insert data not working (code provided)

multispex

Hi I'm trying to insert data to mysql table
and i'm not successful at it through a php
page but very successful through a shell
command. I even compiled php with mysql with
this command: --with-mysql.

here's my code:



<body>



<?php



if ($submit) {

  // process form

  $db = mysql_connect("shantadam", "root");

  mysql_select_db("quadriscan",$db);

  $sql = "INSERT INTO employees (firstname,lastname,id,username,password) VALUES ('$firstname','$lastname','03','$username','$password')";

  $result = mysql_query($sql);

  echo "Thank you! Information entered.\n";

} else{



  // display form



  ?>


  <form method="post" action="<?php echo $PHP_SELF?>">

  First name:<input type="Text" name="firstname"><br>

  Last name:<input type="Text" name="lastname"><br>

  User Name:<input type="Text" name="username"><br>

  Password:<input type="Text" name="password"><br>

  <input type="Submit" name="submit" value="Enter information">

  </form>

  <?php



} // end if



?>



</body>

by the way it's on localhost.

Anon

print mysql_error() to see what error it was. Generally, the 'root' user requires a password...but it might be another error. Or are you getting a PHP error? We need to know what is not working...

Diego

Anon

I think you might want to use php_errormsg() instead of mysql_error() in this case. If there was not a link identifier returned with the mysql_connect() function, then mysql_error() will do no good.

I noticed that you are not specifying a password in your mysql_connect() function. This means that the password is empty. Is this how your user is setup ?

Anon

It's a global variable, not a function. And it's only available if track_errors is "on" in php.ini...

Diego

Anon

I think that you will add connect var in the query function:

$result = mysql_query($sql,$db);

try it...

multispex

Alright here's the problem guys;

I did it with mysql_error() function
and guess what? no database selected
it's telling me for some reason.

Here's the tweeked version of my code:



<body>



<?php



if ($submit) {

  // process form 

  $db = mysql_connect("shantadam");

  mysql_select_db("quadriscan",$db);

  $sql = "INSERT INTO employees (firstname,lastname,id,username,password) VALUES ('$firstname','$lastname','','$username','$password')";

  $result = mysql_query($sql,$db)or die("Bad query: ".mysql_error());;

  echo "Thank you! Information entered.\n";


} else{

// display form

  ?>


  <form method="post" action="<?php echo $PHP_SELF?>">

  First name:<input type="Text" name="firstname"><br>

  Last name:<input type="Text" name="lastname"><br>

  User Name:<input type="Text" name="username"><br>

  Password:<input type="Text" name="password"><br>

  <input type="Submit" name="submit" value="Enter information">

  </form>




  <?php



} // end if



?>



</body>

and here's the error message i get:

"Bad query: No Database Selected"

what about that!

multispex

I have to thank you all for mentioning the
use of the error checker. And quiet honostly
it's a big savier.

Besides all I used mysql_error() function.
And I added back the "root" in the connection
which made me realize with the error that
I was pointing to a non existing table !
can you beleive it guys! I was sleeping all
this time.

Here's my final code:



<body>



<?php



if ($submit) {

  // process form 

  $db = mysql_connect("shantadam","root");

  mysql_select_db("quadriscan",$db);

  $sql = "INSERT INTO members (firstname,lastname,id,username,password) VALUES ('$firstname','$lastname','','$username','$password')";

  $result = mysql_query($sql,$db)or die("Bad query: ".mysql_error());;

  echo "Thank you! Information entered.\n";


} else{

// display form

  ?>


  <form method="post" action="<?php echo $PHP_SELF?>">

  First name:<input type="Text" name="firstname"><br>

  Last name:<input type="Text" name="lastname"><br>

  User Name:<input type="Text" name="username"><br>

  Password:<input type="Text" name="password"><br>

  <input type="Submit" name="submit" value="Enter information">

  </form>




  <?php



} // end if



?>



</body>