Hello there,
I'm quite new on PHP language.I'm trying to make an simple Phone book apps.I added insert & show options in Phone book.Now i want to add "update & delete" option.How can i do that.
This is add code:
<?php
mysql_connect("localhost","admin","");
mysql_select_db("simphp");
//Get Values from form
$name=$_POST['name'];
$email=$_POST['email'];
$number=$_POST['number'];
mysql_query("insert into phonebook(name,email,number) values('$name','$email','$number')");
echo"Saved Sucessfully";
echo "<br/>";
echo '<a href="index.php/">Homepage</a>';
echo "<br/>";
echo '<a href="select.php/">Show Data</a>';
echo "<br/>";
echo '<a href=update.php>Update</a>';
mysql_close();
?>
Show.php=>>
<?php
mysql_connect("localhost","admin","");
mysql_select_db("simphp");
$query="select *from phonebook";
$result=mysql_query($query);
$num=mysql_numrows($result);
echo"Number of records Stored:$num";
$i=0;
while($i<$num)
{
$name=mysql_result($result,$i,"Name");
$email=mysql_result($result,$i,"Email");
$number=mysql_result($result,$i,"number");
echo "<br/>";
echo "Name :<b> $name </b><br/>";
echo "<br/>";
echo "Email : <b>$email</b> <br/>";
echo "<br/>";
echo "Phone :<b>$number</b><br/>";
echo '<a href=update.php>Update</a>';
$i++;
}
?>
How can i update and delete data?? :confused:help me