Hi,
This is a PHP issue not MySQL.
If anything got inserted at all it will be blanks for no where in your
code were your variables ('$productid', '$itemname', '$description',
'$price', '$information') defined.
Try this in the productsave.php code right at the TOP after your include
:
//(since your form action method is POST use $_POST, use $_GET for get
methods)
$p = & $_POST;
$productid = $p['productid'];
$itemname = $p['itemname'];
$description = $p['description'];
$price = $p['price'];
$information = $p['informatation'];
Once this is done then the variables are defined and you can now call
your insert query and those PHP warnings should go away.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 16, 2003 12:59 PM
To: Prabu Subroto
Cc: [EMAIL PROTECTED]
Subject: Re: first time to use MySQL on MS Platform with PHP.
Those are php notices (not warning or errors) .. change your ini error
reporting settings.. you can either disable those messages or
correctly
initialize all variables before trying to use them.
I'd suggest posting your msg to PHP list..
On Wed, 16 Jul 2003, 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 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]
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
