RE: first time to use MySQL on MS Platform with PHP.

[Jef S]

Place an echo in the productsave.php page and check the SQL query. If
the query that is getting passed is correct then the problem is on the
productsave page. Otherwise, your values aren't being passed to the
query.


Jef

> -----Original Message-----
> From: Andrew [mailto:andrew@stripped]
> Sent: Wednesday, July 16, 2003 3:25 AM
> To: Prabu Subroto; mysql@stripped
> Subject: RE: first time to use MySQL on MS Platform with PHP.
> 
> I think it is the code in functions you need to look at or the path in
one
> of
> your ini files :)
> 
> Andrew
> 
> >-----Original Message-----
> >From: Prabu Subroto [mailto:prabusubroto@stripped]
> >Sent: 16 July 2003 10:14
> >To: mysql@stripped
> >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/mysql?unsub=1
> >
> >
> >---
> >Incoming mail is certified Virus Free.
> >Checked by AVG anti-virus system (http://www.grisoft.com).
> >Version: 6.0.501 / Virus Database: 299 - Release Date: 14/07/2003
> >
> 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1