PHP beginner Pls. Help?

joelxez · Jul 2, 2002

Dear Experts,

I'm having an error, what's wrong with my code.

Notice: Undefined variable: ID in C:\Inetpub\

on line 15

Notice: Undefined variable: Name in C:\Inetpub\

on line 15

Notice: Undefined variable: Address in C:\Inetpub\

on line 15
could not complete your query

Heres my add.php below
------------------------------------------------------------
<?php

$host = "localhost";
$user = "joel";
$pass = "";
$database = "personal";
$table = "tblpersonal";

echo "<B>This is a list of items I have in my table named $table</B> <hr>";

// Connecting to the Database
$connection = @mysql_connect($host, $user, $pass) or die("could not connect to server&quot

;

@mysql_select_db($database, $connection);

$query = "INSERT INTO $table('ID','Name','Address')VALUES('$ID','$Name','$Address')";

// Query the Database
$result = @mysql_query($query) or die("could not complete your query&quot

;

?>

------------------------------------------------------------
and here's my add.htm

<html>

<head>

<title>Add</title>
</head>

<body>

<form method="POST" action ="add.php">
<input type="text" name="ID" size="20"></p>
<p><input type="text" name="Name" size="20"></p>
<p><input type="text" name="Address" size="20"></p>
<p><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
</form>

</body>

</html>

------------------------------------------------------------

JavaSprout · Jul 5, 2002

Hi Joelexz!

I'm not an expert, but flattery gets you a long way.

I can't see exactly what's going wrong in your code. However, a few suggestions:

a) Get rid of the '@' signs in front of everything. You are hiding perhaps useful information. There are better ways to hide error messages.

b) Do a print of the $query string to see what is ACTUALLY being passed to the query. In fact do a print of any and every line you suspect is causing the problem. I'd like to see a "print $_POST" to be sure things are arriving OK.

c) Tell us exactly what is 'line 15' since I can't work it out from your post.

My suspicion is the single quotes around the fields.

Hope something here helps.

Hugh Prior
Author of

http://www.localpin.com

the world's best

and most local search engine.

KarveR · Jul 5, 2002

At a guess this is line 15
$query = "INSERT INTO $table('ID','Name','Address')VALUES('$ID','$Name','$Address')";

Which needs some spaces:
$query = "INSERT INTO $table ('ID','Name','Address') VALUES('$ID','$Name','$Address')";

and possibly change $table to '$table' - this largely depends on your version of PHP if its greater than 4.1.0 you may need to use $_POST

instead. If this is the case you will also need to change ('$ID','$Name','$Address')"; to ('$_POST[ID]','$_POST[Name]','$_POST[Address]')"; ______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

AnakinPt · Jul 5, 2002

Well, want my advise, go to php.ini, and in the error_reporting, just put there E_ALL & ~E_NOTICE
otherwise you will get a lot of notices ...

Anikin
Hugo Alexandre Dias
Web-Programmer
anikin_jedi@hotmail.com

joelxez · Jul 5, 2002

Hi KarVer

I used this code

$query = "INSERT INTO $_POST

('ID','Name','Address')VALUES('$_POST[ID]','$_POST[Name]','$_POST[Address]')";

I got an error again...

Notice: Undefined index: table in C:\Inetpub\

http://wwwroot\php\view\add.php

on line 15
could not complete your query

Joel

danielhozac · Jul 5, 2002

You define $table in your script, not via the query string. Change the $_POST

back to $table. //Daniel

KarveR · Jul 6, 2002

well spotted dan. ______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

BB101 · Jul 8, 2002

$_POST, lets give you a clue:

<form method="POST" action ="add.php">
<input type="text" name="ID" size="20"></p>
<p><input type="text" name="Name" size="20"></p>
<p><input type="text" name="Address" size="20"></p>
<p><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
</form>

if you submit that form to a php page (add.php) to get at the variables you have sent in the form you used $_POST['ID'] or $_POST['Name'] etc.

Local variables in PHP don't need to be called with a $_POST prefix because, simply, they aren't. --BB

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

PHP beginner Pls. Help?

joelxez

Programmer

JavaSprout

Programmer

KarveR

MIS

AnakinPt

Programmer

joelxez

Programmer

danielhozac

Programmer

KarveR

MIS

BB101

Programmer

Similar threads

Part and Inventory Search

Sponsor