[RESOLVED] can't store data to database...help me

duelist

hi,i have problem that the data i insert from form cannot be store to database. here the coding for the function. is ther any wrong/missing at the coding.TQ

<?
$db = mysql_connect ("localhost", "", "");
mysql_select_db("tresco", $db);

if($Submit)
{
$sql = "INSERT INTO petty_cash (payee, payment_of, pv, petty_month, petty_day, petty_year, cheque, doc, inv, amount, total_amount) VALUES ('$payee', '$payment_of', '$pv', '$petty_month', '$petty_day', '$petty_year', '$cheque', '$doc', '$inv', '$amount', '$total_amount')";
$dbResult = mysql_query ($sql, $db);
}
?>

AIS4U

duelist:

I'm not sure, but I have never seen an INSERT function that has back ticks (`) around the column names. Also, I don't think the function should be enclosed in quotation marks (").

I checked three different PHP/MYSQL books I have and could not find the back tick (`) used in any of the INSERT examples.

You might also try running it with just a couple of INSERT items like payee, payment_of and see what happens. If that works then add a couple more items, etc, ect..

Good Luck

You might try making these changes and see what your results are.

duelist

thanks for your idea,i forget to state early that my friend have use that code,but it work.....or maybe u have another idea how can i store data to database.for your information i'm using dreamweaver 8 as a tool.TQ

laserlight

i have problem that the data i insert from form cannot be store to database.

Check the database server connection, database selection and query with the use mysql_error(), e.g.

mysql_query($sql) OR die(mysql_error());

Of course, in production code you would handle the error more gracefully.

I checked three different PHP/MYSQL books I have and could not find the back tick (`) used in any of the INSERT examples.

MySQL allows for the use of backticks to delimit column and table names (e.g. when using keywords for such names). I believe other relational database engines accept brackets and/or double quotes instead.

duelist

mysql_query($sql) OR die(mysql_error());

which line i suppose put this code.do u have some example for it

laserlight

You already have it in your code, you just need to add the OR die(mysql_error())

duelist

TQ for the idea.....but it still not work,because when i check my database at localhost/phpMyAdmin, i can't click browse,so far i know,when the database is no data,we can't click browse.that mean the data is not stored to database.do u have any solution there? i know there must be something wrong there. should i show u the full code.TQ.

Houdini

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

Try

$dbResult = mysql_query ($sql)
  or die("Could not execute query)";

Why do you have a source identifier that has already been used? MySQL assumes the last mysql_connect. It might help you to place some die statements into your code, because what you have right now will not let you know what in the world is happening or where.

duelist

thanks a lot guys,and also thanks to my supervisor to show me the solution.now it works......here i'll share with u the way.

first create a new file for insert to database function.let say we name it insert.php.the code suppose to be like this(example for my system but not yet finish since i just test for 1 variable first).

$payee = $_POST[payee];

$db = mysql_connect ("localhost", "", "");
mysql_select_db("tresco", $db);

$sql = "INSERT INTO petty_cash (payee, payment_of, pv, petty_month, petty_day, petty_year, cheque, doc, inv, amount, total_amount) VALUES ('$payee', '$payment_of', '$pv', '$petty_month', '$petty_day', '$petty_year', '$cheque', '$doc', '$inv', '$amount', '$total_amount')";
$dbResult = mysql_query ($sql, $db);
?>

then in the interface or form file,for this line

file insert.php (bold) is the file that we have created earlier.

that its,it should work now.

i'll glad to hear any comment and idea from you guys.TQ