Undefined index: errors

[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/ *

re: Undefined index: errors

John Oliver ha scritto:[color=blue]
> [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();
> ?>
>[/color]
hallo,
try to declare your variables by double quoting
$name=$_POST["name"]; instead of $name=$_POST['name'];
Hope this can help you.
Bye.
Enrico

re: Undefined index: errors

*** John Oliver escribió/wrote (01 Dec 2005 21:05:38 GMT):[color=blue]
> [client 127.0.0.1] PHP Notice: Undefined index: name in
> /home/www/reformcagunlaws.com/new.php on line 6[/color]
[color=blue]
> $name=$_POST['name'];[/color]

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;


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

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
--

re: Undefined index: errors

On Thu, 1 Dec 2005 22:44:09 +0100, Alvaro G. Vicario wrote:[color=blue][color=green]
>> $query = "INSERT INTO petitions VALUES
>> ('','$name','$address','city','county','zip','$pho ne','$email','$volunteer','contacted','deliverd')" ;
>> mysql_query($query);[/color]
>
> Read some documentation about SQL-Injection.[/color]

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/ *

re: Undefined index: errors

EmC said the following on 01/12/2005 21:27:[color=blue]
> John Oliver ha scritto:[/color]
<SNIP>[color=blue][color=green]
>>[/color]
> hallo,
> try to declare your variables by double quoting
> $name=$_POST["name"]; instead of $name=$_POST['name'];[/color]

This will make precisely zero difference.

--
Oli