Inserting values into database with php, ajax and jQuery

[Joemeister]

I'm struggling very hard to get this to work and I don't know what I'm doing wrong. I have a register page that I want to take the data inserted into the form and INSERT it to the database with jQuery and AJAX. I'm not very experienced with AJAX AND jQuery so be gentle! :P I will show you the files that I have...

sign_up.php

<?php
    include 'connect.php';
    include 'header.php';

    echo '<h2>Register</h2>';

    if($_SERVER['REQUEST_METHOD'] != 'POST')
    {
        echo '<br/>';
        echo '
        <div class="container">  
        <form id="submit" method="post" action="">  
        <fieldset>  
        <legend> Enter Information </legend>  
        <br/>
        <label for="user_name">Your username: </label>
        <br/>
        <input id="user_name" class="text" name="user_name" size="20" type="text">
        <br/>
        <br/>
        <label for="user_pass">Your password: </label>
        <br/>
        <input id="user_pass" class="text" name="user_pass" size="20" type="password">  
        <br/>
        <br/>
        <label for="user_pass_check">Confirm password: </label>
        <br/>
        <input id="user_pass_check" class="text" name="user_pass_check" size="20" type="password">
        <br/>
        <br/>
        <label for="user_email">Email: </label>
        <br/>
        <input id="user_email" class="text" name="user_email" size="20" type="email">
        <br/>
        <br/>
        <button class="button positive" type="submit"> <img src="like.png" alt=""> Register </button>  
        </fieldset>  
        </form>  
        <div class="success" style="display: none;"> You are now a registered user!</div>  
        </div>';
    }
    else {
        $errors = array();
        //Checks the errors
        if(isset($_POST['user_name']) == NULL)
        {
                $errors[] = 'Please enter your username.';
        }   

        //Checks the password
        if(isset($_POST['user_pass']) == NULL)
        {
                $errors[] = 'Please enter your password.';
        }
        else
        {
                if($_POST['user_pass'] != $_POST['user_pass_check'])
                {
                    $errors[] = 'The two passwords did not match.';
                }
        }

        if(!empty($errors)) //Checks for empty fields
        {
                echo 'Please check that all the fields are filled in.<br /><br />';
                echo '<ul>';
                foreach($errors as $key => $value) //walk through the array so all the errors get displayed
                {
                        echo '<li>' . $value . '</li>'; //this generates a list with errors
                }
                echo '</ul>';
        }
 }
?>

in my header.php (which I include in every page) I included addMembers.js

$(document).ready(function(){  
        $("form#submit").submit(function() {

        // we want to store the values from the form input box, then send via ajax below  
        var user_name = $('#user_name').val();  
        var user_email = $('#user_email').val();
        var user_pass= $('#user_pass').val();

        //$user_name = $('#user_name').val();
        //$user_email = $('#user_email').val();
        //$password = $('#password').val();

        alert(user_name);

            $.ajax({  
                type: "POST",  
                url: "ajax.php",  
                data: "user_name="+ user_name +"&user_email="+ user_email +"$user_pass=" + user_pass,  
                success: function(){  
                    $('form#submit').hide(function(){$('div.success').fadeIn();});  
                }  
            });

            //alert("ji");

        return false;  
        });  
});

and then my ajax.php that gets the data and must insert it into the database but it doesn't! :(

<?php
        include 'connect.php';
        include 'header.php';

        // CLIENT INFORMATION  
        $user_name  = $_POST['user_name'];  
        $user_email   = $_POST['user_email'];  
        $user_pass   = $_POST['user_pass'];  

        mysql_query("INSERT INTO
                      users(`user_name`, `user_pass`, `user_email` , `user_date` , `user_level`)
                VALUES('$user_name', '$user_pass', '$user_email', NOW() , 0)" OR trigger_error(mysql_error())); 
?>

The PROBLEM here is that it does not INSERT the values into my users table

[diafol]

success: function(data){
   alert(data);

If you use that you'll catch any error from the ajax.php file if it outputs an error to the screen. *I think*.

[ajbest]

check the order of the final statement in your ajax file. It should read

mysql_query("INSERT INTO
                      users (`user_name`, `user_pass`, `user_email` , `user_date` , `user_level`)
                VALUES('$user_name', '$user_pass', '$user_email', NOW() , 0)") or trigger_error(mysql_error());

Or my personal preference is as follows for query structure.

mysql_query("INSERT INTO users SET 
`user_name`='$user_name', 
`user_pass`='$user_pass', 
`user_email`='$user_email', 
`user_date`=NOW(), 
`user_level`=0") or trigger_error(mysql_error());

ON your actual ajax call I am not familiar with this format. I personally use Javascript to run my ajax calls.

[stanley87]

your original code(ajax code):

        $.ajax({  
            type: "POST",  
            url: "ajax.php",  
            data: "user_name="+ user_name +"&user_email="+ user_email +"$user_pass=" + user_pass,  
            success: function(){  
                $('form#submit').hide(function(){$('div.success').fadeIn();});  
            }  
        });

changing to :

$.ajax({
type: "POST",
url: "ajax.php",
data: "user_name="+ user_name+ "&user_email="+ user_email +"&user_pass=" +user_pass,
success: function(data){
    //alert(data);
$('form#submit').hide(function(){$('div.success').fadeIn();});

}
});

your query code:

mysql_query("INSERT INTO
users(`user_name`, `user_pass`, `user_email` , `user_date` , `user_level`)
VALUES('$user_name', '$user_pass', '$user_email', NOW() , 0)" OR trigger_error(mysql_error())); 

channging to :

mysql_query("INSERT INTO users(`user_name`, `user_pass`, `user_email`, `user_date`, `user_level`) VALUES('{$user_name}', '{$user_pass}', '{$user_email}', NOW() , 0)"); 

Note:
-YOu already use wrong data passing $user_pass= , should use &user_pass , that's y cant pass the value to the ajax.php.

-Please include the bracket with the variable passing into the query also.