Undefined Variable...

[nawal]

Help me Plz.. my problem is.. when click the button submit, this will be out

Notice: Undefined variable: first in D:\LITRAS\emot\insert.php on line 20

Notice: Undefined variable: last in D:\LITRAS\emot\insert.php on line 20

Notice: Undefined variable: phone in D:\LITRAS\emot\insert.php on line 20

Notice: Undefined variable: mobile in D:\LITRAS\emot\insert.php on line 20

Notice: Undefined variable: fax in D:\LITRAS\emot\insert.php on line 20

Notice: Undefined variable: email in D:\LITRAS\emot\insert.php on line 20

Notice: Undefined variable: web in D:\LITRAS\emot\insert.php on line 20

New MySQL info added -->the data is added? but the data cannot appear in MySQL. just blank screean with id, 1, 2, 3 but no data inside. Here the code:

<?php
//if(isset($_POST['add']))
//{

include("dbinfo.inc.php");

mysql_connect($dbhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$query = "INSERT INTO contacts VALUES ('','$first','$last','$phone','$mobile','$fax','$email','$web')";
mysql_query($query) or die('Error, insert query failed');

$query = "FLUSH PRIVILEGES";
mysql_query($query) or die('Error, insert query failed');

//include 'library/closedb.php';
mysql_close();
echo "New MySQL info added";

?>

<form action="insert.php"method="post">

First Name: <input type="text" name="first"><br>
Last Name: <input type="text" name="last"><br>
Phone: <input type="text" name="phone"><br>
Mobile: <input type="text" name="mobile"><br>
Fax: <input type="text" name="fax"><br>
E-mail: <input type="text" name="email"><br>
Web: <input type="text" name="web"><br>
<input type="Submit" id="add" Value="Submit">

</form>

HelpMe Plzzz

[planetsim]

try using $POST
so $first is $POST['first'] etc

[nawal]

<?php
if(isset($_POST['add']))
{

include("dbinfo.inc.php");

<!-- below is new typing from me -->
$POST['first'];
$POST['last'];
$POST['phone'];
$POST['mobile'];
$POST['fax'];
$POST['email'];
$_POST['web'];

<!-- Until here -->

mysql_connect($dbhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$query = "INSERT INTO contacts VALUES ('','$first','$last','$phone','$mobile','$fax','$e
mail','$web')";
mysql_query($query) or die('Error, insert query failed');

$query = "FLUSH PRIVILEGES";
mysql_query($query) or die('Error, insert query failed');

//include 'library/closedb.php';
mysql_close();
echo "New MySQL info added";

?>

<form action="insert.php"method="post">

First Name: <input type="text" name="first"><br>
Last Name: <input type="text" name="last"><br>
Phone: <input type="text" name="phone"><br>
Mobile: <input type="text" name="mobile"><br>
Fax: <input type="text" name="fax"><br>
E-mail: <input type="text" name="email"><br>
Web: <input type="text" name="web"><br>
<input type="Submit" id="add" Value="Submit">

</form>
$_POST['first'];

[Matt_Kindig]

The easiest way to solve this is just insert

extract($_POST);

into your code above the $query line. This will create variables $first, $last, etc. from your POSTed data.

You can then delete all of the $_POST['xx'] variables, since right now you don't have them actually doing anything.

[nawal]

This is my insert.php file, actually i'm trying to using combo box, list, menu or etc in add form field. but it can't. All data has been sent to mysql and it appear while the first filed that i use cannot appear. Below this file, i also attach add.html. You help need.. plss

(insert.php)

<?php

include("dbinfo.inc.php");

mysql_connect($dbhost,$username,$password);
mysql_select_db($database) or die( "Unable to select database");

$first = $POST['first']; //This column use combo box, list, menu.
$last = $POST['last'];
$phone = $POST['phone'];
$mobile = $POST['mobile'];
$fax = $POST['fax'];
$email = $POST['email'];
$web = $_POST['web'];

$query = "INSERT INTO contacts VALUES ('','$_POST[first]','$last','$phone','$mobile','$fax','$email','$web')";
mysql_query($query) or die('Error, insert query failed');

mysql_close();
echo "Your new information of $first added";

?>
//This column use combo box, list, menu. //This column use combo box, list, menu.

add.html:

<form action="insert.php" method="post">

First Name : <select name="first">

<option value="PPAK">PPAK</option>
<option value="UOL">University of London</option>
<option value="UCLA">UCLA</option>
<option value="UM">UM</option>
</select>
<br />
Last Name: <input type="text" name="last"><br>
Phone: <input type="text" name="phone"><br>
Mobile: <input type="text" name="mobile"><br>
Fax: <input type="text" name="fax"><br>
E-mail: <input type="text" name="email"><br>
Web: <input type="text" name="web"><br>
<input type="Submit">

</form>

Thank You....

[Matt_Kindig]

Change $_POST['first'] in the $query string to just $first, i.e.

$query = "INSERT INTO contacts VALUES ('','$first','$last','$phone','$mobile','$fax','$email','$web')"; 

That should do the trick.