mysql php error undefine index

Question

Queos_1 0 Newbie Poster

11 Years Ago

Can anyone please help I'm having an index error with my php code.
When I run the code I get the errors

Notice: Undefined index: name in C:\Program Files\EasyPHP-5.3.9\www\Authentication1\update1_ac.php on line 9

Notice: Undefined index: surname in C:\Program Files\EasyPHP-5.3.9\www\Authentication1\update1_ac.php on line 10

Notice: Undefined index: contact_number in C:\Program Files\EasyPHP-5.3.9\www\Authentication1\update1_ac.php on line 11

Notice: Undefined index: email in C:\Program Files\EasyPHP-5.3.9\www\Authentication1\update1_ac.php on line 12

Notice: Undefined index: position in C:\Program Files\EasyPHP-5.3.9\www\Authentication1\update1_ac.php on line 13

Notice: Undefined index: user_name in C:\Program Files\EasyPHP-5.3.9\www\Authentication1\update1_ac.php on line 14

Notice: Undefined index: password in C:\Program Files\EasyPHP-5.3.9\www\Authentication1\update1_ac.php on line 15
Successful
View result

I can't see what the problem is the problem begin on the las code where $name=$_POS['name'];

//the first code list.php

<font color="green"><h1 align="center">List of player in AB Sports Database</h1></font>

<?php
$host="localhost"; // Host name 
$username="root"; // Mysql username 
$password=""; // Mysql password 
$db_name="administrator"; // Database name 
$tbl_name="players"; // Table name 

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);
?>

<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td>
<table width="400" border="1" cellspacing="0" cellpadding="3">
<tr>
<td colspan="4"><strong>List data from mysql </strong> </td>
</tr>

<tr>
<td align="center"><strong>Name</strong></td>
<td align="center"><strong>Surname</strong></td>
<td align="center"><strong>Contact_Number</strong></td>
<td align="center"><strong>Email</strong></td>
<td align="center"><strong>Position</strong></td>
<td align="center"><strong>User_Name</strong></td>
<td align="center"><strong>Password</strong></td>
<td colspan='2'><strong>Action</strong></td>

</tr>

<?php
while($rows=mysql_fetch_array($result)){
?>

<tr>
<td><?php echo $rows['name']; ?></td>
<td><?php echo $rows['surname']; ?></td>
<td><?php echo $rows['contact_number']; ?></td>
<td><?php echo $rows['email']; ?></td>
<td><?php echo $rows['position']; ?></td>
<td><?php echo $rows['user_name']; ?></td>
<td><?php echo $rows['password']; ?></td>

<td align="center"><a href="update_player2.php?player_id=<?php echo $rows['player_id']; ?>">Edit Player</a></td>
<td align="center"><a href="delete_player_form.php?player_id=<?php echo $row['player_id'];?>">Delete Player</a> </td>";
</tr>

<?php
}
?>

</table>
</td>
</tr>
</table>

<?php
mysql_close();
?>




//the second code update_player2.php

<?php
error_reporting(0);
$host="localhost"; // Host name 
$username="root"; // Mysql username 
$password=""; // Mysql password 
$db_name="administrator"; // Database name 
$tbl_name="players"; // Table name

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

// get value of id that sent from address bar
$player_id=$_GET['player_id'];

// Retrieve data from database 

$sql="SELECT * FROM $tbl_name WHERE player_id='$player_id'";
$result=mysql_query($sql);
$rows=mysql_fetch_array($result);
?>

<table width="500" border="0" cellspacing="1" cellpadding="0">
<tr>
<form name="form1" method="post" action="update1_ac.php">
<td>
<table width="100%" border="0" cellspacing="1" cellpadding="0">
<tr>
<td> </td>
<td colspan="7"><strong>Update data in mysql</strong> </td>
</tr>
<tr>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
<td align="center"> </td>
</tr>
<tr>
<td align="center"> </td>

<td align="center"><strong>Name</strong></td>
<td align="center"><strong>Surname</strong></td>
<td align="center"><strong>Contact_Number</strong></td>
<td align="center"><strong>Email</strong></td>
<td align="center"><strong>Position</strong></td>
<td align="center"><strong>User_Name</strong></td>
<td align="center"><strong>Password</strong></td>
</tr>
<tr>
<td> </td>
<td align="center">
<input name="Name" type="text" id="name" value="<?php echo $rows['name']; ?>" size="15">
</td>
<td align="center">
<input name="Surname" type="text" id="surname" value="<?php echo $rows['surname']; ?>" size="15">
</td>
<td>
<input name="Contact_Number" type="text" id="number" value="<?php echo $rows['contact_number']; ?>" size="15">
</td>
<td>
<input name="Email" type="text" id="email" value="<?php echo $rows['email']; ?>" size="15">
</td>
<td>
<input name="Position" type="text" id="position" value="<?php echo $rows['position']; ?>" size="15">
</td>
<td>
<input name="User_Name" type="text" id="user_name" value="<?php echo $rows['user_name']; ?>" size="15">
</td>
<td>
<input name="Password" type="text" id="password" value="<?php echo $rows['password']; ?>" size="15">
</td>
</tr>
<tr>
<td> </td>
<td>
<input name="player_id" type="hidden" id="player_id" value="<?php echo $rows['player_id']; ?>">
</td>
<td align="center">
<input type="submit" name="Submit" value="Submit">
</td>
<td> </td>
</tr>
</table>
</td>
</form>
</tr>
</table>

<?php
// close connection 
mysql_close();
?>




//the last code update_ac.php

<?php
$host="localhost"; // Host name 
$username="root"; // Mysql username 
$password=""; // Mysql password 
$db_name="administrator"; // Database name 
$tbl_name="players"; // Table name 

$id=$_POST['player_id'];
$Name=$_POST['**name**'];                    //problem here
$Surname=$_POST['**surname**'];              //probem here
$Contact=$_POST['**contact_number**'];       //problem here
$Email=$_POST['**email**'];                  //probel here
$Position=$_POST['**position**'];            //problem here
$User_Name=$_POST['**user_name**'];          //problem here
$Password=$_POST['**password**'];            //problem here

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

// update data in mysql database 
$sql="UPDATE $tbl_name SET name='$Name', surname='$Surname', contact_number='$Contact', email='$Email', position='$Position', user_name='$User_Name', password='$Password' WHERE player_id='$id'";
$result=mysql_query($sql);

// if successfully updated. 
if($result){
echo "Successful";
echo "<BR>";
echo "<a href='list2_player.php'>View result</a>";
}

else {
echo "ERROR can not update data";
}

?>

mysql php

Edited 11 Years Ago by Queos_1

3 Contributors
2 Replies
543 Views
1 Week Discussion Span
Latest Post 11 Years Ago Latest Post by Bukhari1986

whiteyoh 0 Posting Pro in Training

11 Years Ago

for each on try

if (isset($_POST['the name'])){
$the_name = $_POST['the name'];
} else {
$the_name = '';
}

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

Bukhari1986 -4 Newbie Poster · Answer 1 · 2013-10-17T06:56:51+00:00

why not using

$Name=$_POST['Name'];                    //problem here
$Surname=$_POST['Surname'];              //probem here
$Contact=$_POST['Contact_Number'];       //problem here
$Email=$_POST['Email'];                  //probel here
$Position=$_POST['Position'];            //problem here
$User_Name=$_POST['User_Name'];          //problem here
$Password=$_POST['Password'];            //problem here

with the capitals etc. its casesensitive, and names of the form fields are posted as indexes of $_POST[] array. not the id vlaues.

better try

var_dump($_POST);

and it will display all the indexes of the array. then you get it.