data not posting to db?

toddmarx

Having a problem. I cannot seem to get data to enter into my database. When you enter information, and then click submit, it process like it takes the data and sends it to the data base, but you dont get the message at the end letting you know that the data was submitted successfully. Getting really frustrated!!!!

below is the code:

<html>

<body>



<?php



if ($submit) {

  // process form

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

  $dbsel = mysql_select_db("mydb",$db);
  mysql_select_db("mydb",$db);

  $sql = "INSERT INTO employees (first,last,address,position) VALUES ('$first','$last','$address','$position')";

  $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="first"><br>

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

  Address:<input type="Text" name="address"><br>

  Position:<input type="Text" name="position"><br>

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

  </form>



  <?php



} // end if


?><BR>



</body>



</html>

Please take a looksie and see what all you guys/gals can figure out. I dont see what is wrong!

thanks,
Todd

Sxooter

Well, other than an extra select db statement, I don't see a lot wrong. you might wanna add some error checking or turn on error reporting in php.ini.

Try printing out the SQL query right before you insert it and see what it looks like.

mwichmann4

Your script has no way to know that those variables in your insert statment are local. You have to got like this for each variable that u want to make local.

$name = $_POST['name'];

Then your insert should work. The reason no message is coming up is because the statment was not true therefor no message.

mwichmann4

Your script has no way to know that those variables in your insert statment are local. You have to got like this for each variable that u want to make local.

$name = $_POST['name'];

Then your insert should work. The reason no message is coming up is because the statment was not true therefor no message.

toddmarx

still not working.....

Here is what I did. I did not quite fully understand your answer, so I tried the way that I think you are implying:

$first = $_POST['first'];
$last = $_POST['last'];
$address = $_POST['address'];
$position = $_POST['position'];

  $sql = "INSERT INTO employees (first,last,address,position) VALUES ('$first','$last','$address','$position')";

Is that right? If so, it is still not working!!!! Pleaese bear with me, I am still new to all this.

On my php.ini file I have:

error_reporting=E_ALL & ~E_NOTICE
register_globals=Off (should this one be on?)

thanks again! 🙂

uniflare

Your settings are fine....

And you shouldn't REALLY have to redefine the $_POST variable array to another variable name...

Try this debug code:

<?php
Global $_POST;
$i = "0";
if($_POST['first'] == null){
      $errmsg = "First Name variable is empty<br>"; $i++; }
elseif($_post['last'] == null){
      $errmsg .= "Last name variable is empty<br>"; $i++; }
elseif($_POST['address'] == null){
      $errmsg .= "Address variable is empty<br>"; $i++; }
elseif($_POST['position'] == null){
      $errmsg .= "Position variable is empty<br>"; $i++; }
if($i > "0"){
      exit($i." Errors has occured: <br>".$errmsg); }
$sql = "INSERT INTO `employees` (first,last,address,position) VALUES ('".$_POST['first']."','".$_POST['last']."','".$_POST['address']."','".$_POST['position']."')";
$conn = @mysql_connect("localhost", "root", "root") or die("Could not Connect to MySQL:<br><b>".mysql_errno().":</b> ".mysql_error());
$the query = @mysql_query($sql) or die("Could not Execute MySQL Query:<br>".$sql."<br><br><b>".mysql_errno().":</b> ".mysql_error());
if(mysql_error() == null){
      echo("MySQL Reports there were no errors with this query:<br>".$sql); }else{
      echo("<br><br>Errors have occured"); }
?>

toddmarx

I tried that and I get an error message:

parse error in c:\phpdev\www\computerzonehq\test2.php on line 106

line 106 is:

$the query = @mysql_query($sql) or die("Could not Execute MySQL Query:<br>".$sql."<br><br><b>".mysql_errno().":</b> ".mysql_error());

uniflare

I Personally dont see anything wrong with that code, could you give me these answers:

PHP Version?
is safe_mode on?
is sql.safe_mode on?

and does the error tell you that it was "Expecting" something or it found an "Unexpected" string?

btw, 106 is my mistake...

try this...

<?php
Global $_POST;
$i = "0";
if($_POST['first'] == null){
      $errmsg = "First Name variable is empty<br>"; $i++; }
elseif($_post['last'] == null){
      $errmsg .= "Last name variable is empty<br>"; $i++; }
elseif($_POST['address'] == null){
      $errmsg .= "Address variable is empty<br>"; $i++; }
elseif($_POST['position'] == null){
      $errmsg .= "Position variable is empty<br>"; $i++; }
if($i > "0"){
      exit($i." Errors has occured: <br>".$errmsg); }
$sql = "INSERT INTO `employees` (first,last,address,position) VALUES ('".$_POST['first']."','".$_POST['last']."','".$_POST['address']."','".$_POST['position']."')";
$conn = @mysql_connect("localhost", "root", "root") or die("Could not Connect to MySQL:<br><b>".mysql_errno().":</b> ".mysql_error());
$the query = @mysql_query($sql) or die("Could not Execute MySQL Query:<br>".$sql."<br><br><b>".mysql_errno().":</b> ".mysql_error());
if(mysql_error() == null){
      echo("MySQL Reports there were no errors with this query:<br>".$sql); }else{
      echo("<br><br>Errors have occured"); }
?>

toddmarx

Also,

would it be easier if I were to have the "action" on the form go to another page instead of using the "php_self"? If so, this is no biggie, now that I think about it, I would rather have it go to another page, but if this would be easier, then I can leave it like this and try to fix it. 🙂

toddmarx

still same error message:

Parse error: parse error in c:\phpdev\www\computerzonehq\test2.php on line 106

PHP Version? = 4.0.6 running on apache 1.3.20
is safe_mode on? = safe_mode=Off
is sql.safe_mode on? = sql.safe_mode=Off

uniflare

i shall write a plain page, 1 file, that will display the form AND update MySQL...

<?php 
if($_POST['submit'] == null){ 
echo'
<html>
<head>
<title>Update</title>
</head>
<body>
<form method="post" action="'.$PHP_SELF.'">
First Name: <input type="text" name="first"><br>
Last Name: <input type="text" name="last"><br>
Address: <input type="text" name="address"><br>
Position: <input type="text" name="position"><br>
<input type="submit" value="submit" name="submit">
</form>
</body>
</html>'; }
else{
Global $_POST;
$i = "0";
if($_POST['first'] == null){
      $errmsg = "First Name variable is empty<br>"; $i++; }
elseif($_post['last'] == null){
      $errmsg .= "Last name variable is empty<br>"; $i++; }

elseif($_POST['address'] == null){
      $errmsg .= "Address variable is empty<br>"; $i++; }
elseif($_POST['position'] == null){
      $errmsg .= "Position variable is empty<br>"; $i++; }
if($i > "0"){
      exit($i." Errors has occured: <br>".$errmsg); }
$sql = "INSERT INTO `employees` (first,last,address,position) VALUES ('".$_POST['first']."','".$_POST['last']."','".$_POST['address']."','".$_POST['position']."')";
$conn = @mysql_connect("localhost", "root", "root") or die("Could not Connect to MySQL:<br><b>".mysql_errno().":</b> ".mysql_error());
$the_query = @mysql_query($sql) or die("Could not Execute MySQL Query:<br>".$sql."<br><br><b>".mysql_errno().":</b> ".mysql_error());
if(mysql_error() == null){
      echo("MySQL Reports there were no errors with this query:<br>".$sql); }else{
      echo("<br><br>Errors have occured"); }
?>

toddmarx

Uniflare, I just want to take a second and say thank you for all that you have done in helping me with my problem thus far.....

Ok,

I created new doc, used code that you have on last post. Got error message:

Parse error: parse error in c:\phpdev\www\computerzonehq\test3.php on line 38

line 38 is the closing tag for php ( ?>) that is all that is on there.

uniflare

ok... sorry, i have been quite tired lately, in my last few posts i have made several dumb mistakes, but i shall give you the code that should work.....

but first i need your Database name

toddmarx

No problem! I understand. I too am having a long day.

Ok, dbase info:

Connection: localhost, root, root
dbase info: db=mydb, table=employees

toddmarx

In looking over your code, I noticed something that may be of use.

On my code I have the

<?php echo $PHP_SELF?>

you have it as

action="'.$PHP_SELF.'"

should I be using that instead on my action line in the form?

uniflare

You are very kind 🙂 ... i have tested this script on my own server just this second, with the same settings as yours etc... so there is no reason why it shouldn't work... here goes...

<?php 
$host = "localhost";
$user = "root";
$pass = "root";
$database = "mydb";
$tablename = "employees";
if($_POST['submit'] == null)
{ 
	echo'
	<html>
	<head>
	<title>Update</title>
	</head>
	<body>
	<form method="post" action="'.$PHP_SELF.'">
	First Name: <input type="text" name="first"><br>
	Last Name: <input type="text" name="last"><br>
	Address: <input type="text" name="address"><br>
	Position: <input type="text" name="position"><br>	
	<input type="submit" value="submit" name="submit">
	</form>
	</body>
	</html>'; 
}else{

Global $_POST;
$i = "0";
if($_POST['first'] == null)
{
	$errmsg = "First Name variable is empty<br>"; $i++; 
}
if($_POST['last'] == null)
{
	$errmsg .= "Last name variable is empty<br>"; $i++; 
}
if($_POST['address'] == null)
{
	$errmsg .= "Address variable is empty<br>"; $i++; 
}
if($_POST['position'] == null)
{
	$errmsg .= "Position variable is empty<br>"; $i++; 
}
if($i > "0")
{
	exit($i." Errors has occured: <br>".$errmsg); 
}
$sql = "INSERT INTO `".$tablename."` 
(first,last,address,position) 
VALUES (
'".$_POST['first']."',
'".$_POST['last']."',
'".$_POST['address']."',
'".$_POST['position']."'
)";
$conn = @mysql_connect($host, $user, $pass) 
or die("Could not Connect to MySQL:<br><b>".mysql_errno().":</b> ".mysql_error());
$db = mysql_select_db($database);
$the_query = @mysql_query($sql) 
or die("Could not Execute MySQL Query:<br>".$sql."<br><br><b>".mysql_errno().":</b> ".mysql_error());
if(mysql_error() == null)
{
	echo("MySQL Reports there were no errors with this query:<br>".$sql); }else{
	echo("<br><br>Errors have occured"); 
}
mysql_close($conn);
}
?>

toddmarx

Ok, did not get any error messages, but no data was sent to the database. I even tried triggering some of the error message off on purpose (leaving fields blank and submitting) and got nothing. It goes throught the motions like it is processing, just not sending to database. Could this be a php.ini problem? Or a setting in mysql?

uniflare

Did you compile or download a binary of Apache and php?

or did u get it in a package?

if you did not get it in a package, and you are willing to try a maybe more suitable and stable result, try going for:

http://www.easyphp.org/ - Very nice binary for windows with php/mysql/apache

its what i use, it may be a bug in your mysql version, php, apache, nearly anything.... and no it wouldn't b a setting in php.ini...

toddmarx

yea, I got it in a bundle. phpdev4.???

I will try the link that you have posted. I do appreciate all of your efforts and time. Thank you once again. 🙂

uniflare

Your welcome, if you have any further questions or problems you can always try emailing me (or adding me to your Hotmail contacts list) using this email address: uni_fl4r3@hotmail.com