Undefined index: errors

[John Oliver]

[client 127.0.0.1] PHP Notice: Undefined index: name in
/home/www/reformcagunlaws.com/new.php on line 6
[client 127.0.0.1] PHP Notice: Undefined index: address in
/home/www/reformcagunlaws.com/new.php on line 7
[client 127.0.0.1] PHP Notice: Undefined index: city in
/home/www/reformcagunlaws.com/new.php on line 8
[client 127.0.0.1] PHP Notice: Undefined index: county in
/home/www/reformcagunlaws.com/new.php on line 9
[client 127.0.0.1] PHP Notice: Undefined index: zip in
/home/www/reformcagunlaws.com/new.php on line 10
[client 127.0.0.1] PHP Notice: Undefined index: phone in
/home/www/reformcagunlaws.com/new.php on line 11
[client 127.0.0.1] PHP Notice: Undefined index: email in
/home/www/reformcagunlaws.com/new.php on line 12
[client 127.0.0.1] PHP Notice: Undefined index: volunteer in
/home/www/reformcagunlaws.com/new.php on line 13
[client 127.0.0.1] PHP Notice: Undefined index: contacted in
/home/www/reformcagunlaws.com/new.php on line 14
[client 127.0.0.1] PHP Notice: Undefined index: delivered in
/home/www/reformcagunlaws.com/new.php on line 15

-bash-2.05b$ cat new.php
<?
$user="root";
#$password="password";
$database="rcgl-petitions";

$name=$_POST['name'];
$address=$_POST['address'];
$city=$_POST['city'];
$county=$_POST['county'];
$zip=$_POST['zip'];
$phone=$_POST['phone'];
$email=$_POST['email'];
$volunteer=$_POST['volunteer'];
$contacted=$_POST['contacted'];
$delivered=$_POST['delivered'];

#mysql_connect(localhost,$user,$password);
mysql_connect('localhost',$user);
@mysql_select_db($database) or die( "Unable to select database");

$query = "INSERT INTO petitions VALUES
('','$name','$address','city','county','zip','$pho ne','$email','$volunteer','contacted','deliverd')" ;
mysql_query($query);

mysql_close();
?>

--
* John Oliver http://www.john-oliver.net/ *
* Reform California gun laws - http://www.reformcagunlaws.com/ *
* http://www.gunownersca.com - http://www.crpa.org/ *
* San Diego shooters come to http://shooting.forsandiego.com/ *

[EmC]

John Oliver ha scritto:

[client 127.0.0.1] PHP Notice: Undefined index: name in
/home/www/reformcagunlaws.com/new.php on line 6
[client 127.0.0.1] PHP Notice: Undefined index: address in
/home/www/reformcagunlaws.com/new.php on line 7
[client 127.0.0.1] PHP Notice: Undefined index: city in
/home/www/reformcagunlaws.com/new.php on line 8
[client 127.0.0.1] PHP Notice: Undefined index: county in
/home/www/reformcagunlaws.com/new.php on line 9
[client 127.0.0.1] PHP Notice: Undefined index: zip in
/home/www/reformcagunlaws.com/new.php on line 10
[client 127.0.0.1] PHP Notice: Undefined index: phone in
/home/www/reformcagunlaws.com/new.php on line 11
[client 127.0.0.1] PHP Notice: Undefined index: email in
/home/www/reformcagunlaws.com/new.php on line 12
[client 127.0.0.1] PHP Notice: Undefined index: volunteer in
/home/www/reformcagunlaws.com/new.php on line 13
[client 127.0.0.1] PHP Notice: Undefined index: contacted in
/home/www/reformcagunlaws.com/new.php on line 14
[client 127.0.0.1] PHP Notice: Undefined index: delivered in
/home/www/reformcagunlaws.com/new.php on line 15

-bash-2.05b$ cat new.php
<?
$user="root";
#$password="password";
$database="rcgl-petitions";

$name=$_POST['name'];
$address=$_POST['address'];
$city=$_POST['city'];
$county=$_POST['county'];
$zip=$_POST['zip'];
$phone=$_POST['phone'];
$email=$_POST['email'];
$volunteer=$_POST['volunteer'];
$contacted=$_POST['contacted'];
$delivered=$_POST['delivered'];

#mysql_connect(localhost,$user,$password);
mysql_connect('localhost',$user);
@mysql_select_db($database) or die( "Unable to select database");

$query = "INSERT INTO petitions VALUES
('','$name','$address','city','county','zip','$pho ne','$email','$volunteer','contacted','deliverd')" ;
mysql_query($query);

mysql_close();
?>

hallo,
try to declare your variables by double quoting
$name=$_POST["name"]; instead of $name=$_POST['name'];
Hope this can help you.
Bye.
Enrico

[Alvaro G. Vicario]

*** John Oliver escribió/wrote (01 Dec 2005 21:05:38 GMT):

[client 127.0.0.1] PHP Notice: Undefined index: name in
/home/www/reformcagunlaws.com/new.php on line 6 $name=$_POST['name'];
A notice is not an error. You've just configured PHP to warn you when you
use an non initialized variable. Try:

$name = isset($_POST['name']) ? $_POST['name'] : NULL;
$query = "INSERT INTO petitions VALUES
('','$name','$address','city','county','zip','$pho ne','$email','$volunteer','contacted','deliverd')" ;
mysql_query($query);

Read some documentation about SQL-Injection.
--
-+ Álvaro G. Vicario - Burgos, Spain
++ http://bits.demogracia.com es mi sitio para programadores web
+- http://www.demogracia.com es mi web de humor libre de cloro
--

[John Oliver]

On Thu, 1 Dec 2005 22:44:09 +0100, Alvaro G. Vicario wrote:

$query = "INSERT INTO petitions VALUES
('','$name','$address','city','county','zip','$pho ne','$email','$volunteer','contacted','deliverd')" ;
mysql_query($query);

Read some documentation about SQL-Injection.

I know jack squat about MySQL and PHP. That's right out of some online
tutorial I found. And, since it doesn't seem to work...

I need a tutorial or something I can follow along that isn't going to
lie to me about how to do things ;-)

--
* John Oliver http://www.john-oliver.net/ *
* Reform California gun laws - http://www.reformcagunlaws.com/ *
* http://www.gunownersca.com - http://www.crpa.org/ *
* San Diego shooters come to http://shooting.forsandiego.com/ *

[Oli Filth]

EmC said the following on 01/12/2005 21:27:

John Oliver ha scritto:

<SNIP>

hallo,
try to declare your variables by double quoting
$name=$_POST["name"]; instead of $name=$_POST['name'];

This will make precisely zero difference.

--
Oli