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!
On Wednesday 16 July 2003 17:18, Prabu Subroto wrote:
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
Since this is a SuSE list you're going to find it hard to get help with a Win2K problem. But, if PHP on Win2K behaves much like it does on SuSE, you're making assumptions about the security level the language is configured to. Try accessing your variables with $_POST['productid'], and so on. -- "This book fills a much needed gap." -- Moses Hadas, in a book review
participants (2)
-
Derek Fountain
-
Prabu Subroto