php won't insert into ... - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

pepe_lepew1962 · 02-01-2009, 08:32 PM

Hello:

I am trying to get my insert into mysql to work and it just plain does not work. I have copied the insert part into a text file and manually executed the code via source and it works but for some reason it won't via php. Is there someting I am missing or not getting? I have the loop at the begining to test if the variables are getting thru and they are.

<?php
// Loop to pass the variables from previous script
//
foreach (array_keys($_POST) as $key)
{
$$key = $_POST[$key];
//print "$key is ${$key}<br />";
print "$key ==> ${$key}<br />";
}
//
//
mysql_connect("localhost", "root", "xxxxxxxxx") or die('Could not connect: ');
mysql_select_db("test") or die('Could not connect again: ');
//
$sql = ("INSERT INTO tblnadda (tblNADA_User01,tblNADA_User02) VALUES ('namef','namem')") or die('Could not add records ');

$result = mysql_query("SELECT * FROM tblnadda");

$num_rows = mysql_num_rows($result);

echo "$num_rows Rows\n";
//
?>

KaeVectori · 02-04-2009, 12:43 PM

shouldn't this:

PHP Code:


			
$sql = ("INSERT INTO tblnadda (tblNADA_User01,tblNADA_User02) VALUES ('namef','namem')") or die('Could not add records ');

be

PHP Code:


			
$sql = mysql_query("INSERT INTO tblnadda (tblNADA_User01,tblNADA_User02) VALUES ('namef','namem')") or die('Could not add records ');

?

Ariyes1 · 02-18-2009, 07:55 AM

You should read this article on W3School about SQL - the Insert Into statement.
SQL INSERT INTO Statement

PHP Code:


			
$sql = "INSERT INTO tblnadda (tblNADA_User01,tblNADA_User02) VALUES ('namef','namem')

clinkpc · 02-22-2009, 10:40 AM

Quote:

Originally Posted by KaeVectori

shouldn't this:

PHP Code:


			
$sql = ("INSERT INTO tblnadda (tblNADA_User01,tblNADA_User02) VALUES ('namef','namem')") or die('Could not add records ');

be

PHP Code:


			
$sql = mysql_query("INSERT INTO tblnadda (tblNADA_User01,tblNADA_User02) VALUES ('namef','namem')") or die('Could not add records ');

?

That is exactly correct. This should fix your problem.

AD