how i can delete record from database using html forms

preetg 0 414 Views

hi......
i am using window xp.....apache server
m new in php
i inserted record in database through forms .now i m facing problem to delete the records from database in php code..... above code is not working properly...give me solution within 2 days....

[code=php]
<?
//connect to mysql
//change user and password to your mySQL name and password
mysql_connect("localhost","root","root");

//select which database you want to edit
mysql_select_db("mydb");

//If cmd has not been initialized
if(!isset($cmd))
{
   //display all the news
   $result = mysql_query("select * from stuinfo order by FirstName");

   //run the while loop that grabs all the news scripts
   while($r=mysql_fetch_array($result))
   {
      //grab the title and the ID of the news
      //$title=$r["title"];//take out the title
      $FirstName=$r["FirstName"];//take out the id

	 //make the title a link
      echo "<a href='delete.php cmd=delete&FirstName=$FirstName'></a>";
      echo "<br>";
    }
}
?>
[/code]

[code=html]
<HTML>
<HEAD>
 <TITLE>New Document</TITLE>
</HEAD>
<BODY>
<? php

if($_GET["cmd"]=="delete")
{
    $sql = "DELETE FROM stuinfo WHERE FirstName=$FirstName";
    $result = mysql_query($sql);
    echo "Row deleted!";
}
?>
</BODY>
</HTML>[/code]
Member Avatar for CJesusSaves
CJesusSaves 6 Light Poster

Since I personally don't like mixing PHP and HTML you can try the following edited code if you so wish. Compare with yours to see what was changed.

Hope it helps.

<?
//connect to mysql
//change user and password to your mySQL name and password
mysql_connect("localhost","root","root");

//select which database you want to edit
mysql_select_db("mydb");

//If cmd has not been initialized
if(!isset($cmd))
{
   //display all the news
   $result = mysql_query("select * from stuinfo order by FirstName");

   //run the while loop that grabs all the news scripts
   while($r=mysql_fetch_array($result))
   {
      //grab the title and the ID of the news
      $title=$r['title'];//take out the title
      $FirstName=$r['FirstName'];//take out the id
   ?>
	 //make the title a link
      <a href="delete.php?cmd=delete&FirstName=<?php echo $FirstName; ?>" title="<?php echo $title; ?>"><?php echo $title; ?></a>
      <br />
    <?php }
}
?>

<HTML>
<HEAD>
 <TITLE>New Document</TITLE>
</HEAD>
<BODY>
<? php

if($_GET['cmd']== "delete")
{
    $FirstName = $_GET['FirstName'];
    $sql = "DELETE FROM stuinfo WHERE FirstName='$FirstName'";
    $result = mysql_query($sql);
    echo "Row deleted!";
}
?>
</BODY>
</HTML>
Member Avatar for didier_m
didier_m 0 Newbie Poster

Hi,

to preetg => first of all, a please or a thank you can be more friendly

On line 11 you test on $cmd.
Where do you define $cmd? $cmd is at that time not set, you should better test on $_GET.
Hope this help
Didier

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.

Edit Preview