new user--please help.

georgine

im new to this php and mysql stuff, im still trying to know them..but as i start in the basics, i encounter a problem.I try to insert new records to a table i named "all_users"..the SELECT function is working but as i try the INSERT and DELETE function they aren't. this is my codes:
<?
$host="localhost";
$username="root";
$password="";
$dbase="all_users";

$conn = mysql_connect($host, $username, $password) or die ("unable to connect");
$select = mysql_select_db($dbase, $conn);
$result = mysql_query("INSERT INTO 'users' VALUES(users_id,'$users_name','$users_password','$users_email')");
?>

only users_id is inserted on the table, (for INSERT function) the rest of the fields is blank. The DELETE function is not totally working and this is the codes:

<?
$host="localhost";
$username="root";
$password="";
$dbase="all_users";

$conn = mysql_connect($host, $username, $password);
$select = mysql_select_db($dbase, $conn);
$result = mysql_query("DELETE FROM users WHERE users_id='$users_id'");
?>
Please help me, i really want to learn..please?🙁 🙁 🙁

[deleted]

If the fields are blank but the rest of the record is inserted, then the variables $user_name and $user_password must have been empty.

Do these variables come from a form? Read the PHP manual about the 'superglobal' called $_POST.

ahundiak

I am a bit dubious that this is working at all.

$result = mysql_query("INSERT INTO 'users' VALUES(users_id,'$users_name','$users_password','$
users_email')");

Should not use quotes around the table name.
And there is no $ in front of user_id.

[deleted]

"Should not use quotes around the table name. "

No there should not.

"And there is no $ in front of user_id."

possibly typo during posting?

georgine

Im very greatful with your great ideas..but i was a bit confuse..
I was trying to insert them using a html this is the code:

<table cellpadding=0 cellspacing=0><form method=post action=add.php>
<tr><td>user name:</td><td><input type=text name=users_name></td><br>
<tr><td>user password:</td><td><input type=text name=users_password></td><br>
<tr><td>user email:</td><td><input type=text name=users_email></td><br>
<input type=submit value="add data"><input type=reset value="clear data">
</form></table>

i was just trying to insert the value from the textbox by transferring it in their variables(e.g., $users_name,$users_password), i thought mysql codes would get the values of the textbox by adding a "$" sign in their name.
Hope i dont confuse u guys, but im very glad with your response..Hope to give me more!

thanks!!🙂

[deleted]

As of PHP 4.1, the values of form-fields will end up in the $_POST array.

So if you have a form with

input type="text" name="user_name"

then after submitting you can access the value through the $_POST array, like so:

echo $_POST['user_name'];