insert doesnt want to work

squimmy

i am driving myself crazy over this and i have no idea why this doesnt work.

I'm learning sql anbd this is my 2nd ever script involving sql so can somebody PLZ tell me what the hell is wrong with this.I dont get any error message, but nothing happens to the database.Nothing is inserted what so ever.

<?php
$auser = $POST["user"];
$apass = $POST["pass"];
$user = "root";
$password = "*******";
$database = "phptest";
mysql_connect(localhost,$user,$password);
mysql_select_db($database) or die( "Unable to select database");
$query ="insert into work values (0,$auser,$apass,4)";
mysql_query($query);
?>

Surely that should insert into table work what the user typed in in the page before. But nothing happens. absolutely nothing. help would be appreciated a LOT. Thank you .

devinemke

<?php
mysql_connect('localhost', 'root', '*******') or exit(mysql_error());
mysql_select_db('phptest') or exit(mysql_error());
$query = "INSERT INTO work VALUES('0', '" . $_POST['user'] . "', '" . $_POST['pass'] . "', '4')";
mysql_query($query) or exit(mysql_error());
?>

squimmy

Thank you very much.I appreciate it.

Can you please tell me what i did wrong so i can learn from my mistakes.

i dont understand this line, what is with all the "' after and before $_POST.

$query = "INSERT INTO work VALUES('0', '" . $POST['user'] . "', '" . $POST['pass'] . "',
'4')";

Thank you.

liquorvicar

first, i wouldn't use $POST data directly in an SQL query, could be dangerous.
second, are you getting an error when you run this? post it here so we can help you:

<?php
$user = mysql_escape_string($_POST['user']);
$pass = mysql_escape_string($_POST['pass']);
mysql_connect('localhost', 'root', '*******') or exit(mysql_error());
mysql_select_db('phptest') or exit(mysql_error());
$query = "INSERT INTO work VALUES('0', '$user', '$pass', '4')";
mysql_query($query) or exit(mysql_error());
?>

squimmy

no error, just nothing is inserted. I also know it is dangerous, but i figured i might as well get it working before i make it more secure.

liquorvicar

odd. have you tried echo-ing the INSERT statement and running it against the DB directly?

squimmy

this not working seems to be the last problem i need to worry about with mysql.

mysql seemed to want to uninstall some of itself from my machine and i had to do yet-another-reinstall (i think that makes it 5 in two day's).I'll see if the reinstall fixed the odd query problem as well.

edit: your script works.

Thanks

squimmy

I finally figured out why my script didn't work! my variable need to be in ''.

Thanks alot to all who helped.