Prabu,
This is kind of off-topic, as it is a PHP problem. ;) Those error
messages are telling you that the variables you are trying to use were never
initialized. This suggests to me that your PHP installation is set up with
the register_globals option turned off. This means all of your form data is
being stored in the $_POST superglobal array. Just change the query to pull
from the array, so your entries would go from $productid to
${_POST['product_id']} (Please take note of the curly braces {} and the use
of single quotes '' in my revision--they are important.)
Hope that helps.
-Rob
-----Original Message-----
From: Prabu Subroto [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 16, 2003 5:14 AM
To: [EMAIL PROTECTED]
Subject: first time to use MySQL on MS Platform with PHP.
Dear my friends...
I am trying to develop a database application with PHP
Version 4.3.2, MS Window 2000, MySQL 4.0.13-nt and
Apache 2.
I tried to insert a record onto my MySQL but I got
this error messages. What do I have to defined to
overcome this problem?
"
Notice: Undefined variable: productid in
C:\Programme\Apache
Group\Apache2\htdocs\amt\cgi\productsave.php on line
15
Notice: Undefined variable: itemname in
C:\Programme\Apache
Group\Apache2\htdocs\amt\cgi\productsave.php on line
15
Notice: Undefined variable: description in
C:\Programme\Apache
Group\Apache2\htdocs\amt\cgi\productsave.php on line
15
Notice: Undefined variable: price in
C:\Programme\Apache
Group\Apache2\htdocs\amt\cgi\productsave.php on line
15
Notice: Undefined variable: information in
C:\Programme\Apache
Group\Apache2\htdocs\amt\cgi\productsave.php on line
16
Saved successfully
"
Here is the code of productsave.php :
"
<?php
include("functions.php");
$sql="
insert into product ( productid, itemname,
description, price, information )
values ('$productid', '$itemname', '$description',
'$price', '$information')
";
$conn=connection();
choosedb();
if (mysql_query($sql,$conn)){
echo "Saved successfully<br>";
}
else echo mysql_error();
mysql_close($conn);
?>
"
Here is the code of the form which calls
productsave.php (it's cgi program):
"
<form action="cgi/productsave.php" method="POST">
<center><b><u>Data Entry - Product
List</u></b></center>
<br>
<table align="center" border="0">
<tr><td align="left">1.</td><td align="left">Product
ID</td><td align="left" >:</td>
<td align="left" ><input type="text" name="productid"
readonly="yes"></td></tr>
<tr><td align="left">2.</td><td align="left">Item
Name</td><td align="left">:</td>
<td align="left"><input type="text"
name="itemname"></td></tr>
<tr><td align="left">3.</td><td
align="left">Description</td><td align="left">:</td>
<td align="left"><input type="text"
name="description"></td></tr>
<tr><td align="left" >4.</td><td
align="left">Price</td><td align="left">:</td>
<td align="left"><input type="text"
name="price"></td></tr>
<tr><td align="left">5.</td><td
align="left">Information</td><td align="left">:</td>
<td align="left"><input type="text"
name="information"></td></tr>
<tr><td colspan="4" align="center"><input
type="submit" value="Save" src="img/ok.png">
<input type="reset" value="Clear"
src="img/no.png"></td></tr>
</table>
</form>
"
Please tell me. Thank you very much in advance.
__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
