first time to use MySQL on MS Platform with PHP.

Prabu Subroto

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/my***********...ie.nctu.edu.tw

Jul 19 '05 #1

Subscribe Post Reply

1835

2metre

Either use
extract ($_POST);
before your query or

use $_POST["productid"] to access the productid variable (and similar
construction for other varaibles POSTed from the form)

For further information:
http://uk.php.net/variables.external

"Prabu Subroto" <pr**********@yahoo.com> wrote in message
news:bf***********@FreeBSD.csie.NCTU.edu.tw...

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/my***********...ie.nctu.edu.tw

Jul 19 '05 #2

2metre

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/my***********...ie.nctu.edu.tw

Jul 19 '05 #3

Similar topics

Setting up my first database

by: John | last post by:

Hello. If I want to set up my first database and start using it in Dreamweaver what do I need to do? The book I'm working on has a CD with the database on. It is telling me to put it in the...

PHP

Transferring web hosts - php/mysql application

by: Abby | last post by:

I have an application that is written in php/mysql on a Linux platform and need to transfer hosts. This is a session based application and I don't know a lot about php/Linux/mysql, but can get by....

PHP

C++ and MySQL

by: Ben | last post by:

Hi I am new to C++ and I want to know if C++ is suitable for making a GUI application with a MySQL database. I also want to know what keywords in books I should look for. Is DATA STRUCTURES a...

C / C++

an old geezer running visual studio for the first time

by: TB | last post by:

Hi all: If you think that the following comments are absolute amateurish, then please bear with me, or simply skip this thread. A couple of months back I made the decision to initiate a...

ASP.NET

Does SSL really work in mysql 4.0.21?

by: Dragonphoenix | last post by:

bash-2.05b# ldd mysql libcurses.so.1 => /usr/lib/libcurses.so.1 libmysqlclient.so.12 => /sandbox/mysql-4.0.21/lib/mysql/libmysqlclient.so.12 libz.so.1 => /usr/lib/libz.so.1 librt.so.1...

MySQL Database

Change field names to first row of table

by: Bob | last post by:

Hi all, I've got a table that I've imported and it has junk at the top of the table, so after import I run a delete query to remove the junk lines then I'm left with the field names I want for...

Microsoft Access / VBA

Help with JDBC and MySQL

by: IvanJ2EE | last post by:

Hello partners. I have an issue using jdbc and a DB in MySQL. The problem is that I want to make a seach using the Last Name of a person stored in a MySQL DB, from a JSP The problem is that I...

MySQL Database

Time to migrate from Access DB to???? ---- Need recommendations

by: Algonquin J. Calhoun | last post by:

I've developed an application that exceeds the Access 2GB limit. This application was developed as a prototype and the users have found it very useful. Approximately 45,000 records are added to...

Visual Basic .NET

php to get date and time separately into MySQL?

by: Geoff Cox | last post by:

Hello, at the moment I can add the combined date and time into MySQL using php $dt1 = date("Y-m-d H:i:s"); is it possible to add the date and time separately? I thought it might be

PHP

Benefits of Blockchain App Development for Enterprise Businesses

by: Kemmylinns12 | last post by:

Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...

General

Hyperconverged All-in-One Streaming Engine, ushering in new age for distributed database

by: antdb | last post by:

Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...

General

How to layout php header location with a variable as the location?

by: Matthew3360 | last post by:

Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. header("Location:".$urlback); Is this the right layout the...

PHP

HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computer

by: AndyPSV | last post by:

HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and...

General

How do I view Redshift db tables in Alteryx

by: Arjunsri | last post by:

I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and credentials and received a successful connection...

General

One of the easiest ways to set the background color of Excel documents in Java

by: Carina712 | last post by:

Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand. Background colors can be used to highlight important...

General

Join our open community on Discord to learn programming, SEO, and marketing

by: BLUEPANDA | last post by:

At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS starter kit that's not only easy to use but also...

General

Mastering Python: A Versatile Programming Language for All

by: Rahul1995seven | last post by:

Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python has gained popularity among beginners and experts...

General

Problems to capture mouse_down event on a control within a form with lots of controls

by: Ricardo de Mila | last post by:

Dear people, good afternoon... I have a form in msAccess with lots of controls and a specific routine must be triggered if the mouse_down event happens in any control. Than I need to discover what...

Microsoft Access / VBA