how can i add update in my php code?

S

samuel101

New member
this code can delete rows., my question is how can i add update here's the code:

<?php

include 'conn.php';

$flag=$_GET["flag"];

if ($flag=="1")
{
$id = $_GET["id"];
$del = "DELETE FROM newdbase WHERE id='$id'";
$nres = mysql_query($del);
if(!$nres) {
echo " Failed to delete: ".mysql_error();
} else {
echo " Deleting successful";
}
}

if ($flag=="2")
{
$store = $_POST["store"];
$sales = $_POST["sales"];
$year = $_POST["year"];
$month = $_POST["month"];
$day = $_POST["day"];

$ans = "INSERT INTO newdbase VALUES ('','$store', '$sales', '$year' ,'$month', '$day')";
$result = mysql_query($ans);

if($result!="")
{
echo "<br>Saving Successful";
}
else
{
echo "<br>Failed". mysql_error();
}
}
?>

<HTML>
<BODY>
<form method="post" action="index2.php?flag=2">
Storename: <input type = "text" name = "store"><br>
Sales: <input type = "text" name = "sales"><br>
Date: <input type = "text" name = "month" size = "3" value = "<?php echo date("m"); ?>">
-<input type = "text" name = "day" size = "3" value = "<?php echo date("d"); ?>">
-<input type = "text" name = "year" size = "3" value = "<?php echo date("Y"); ?>"><br>
<input type = "submit" name = "submit" value = "Save">
<input type = "reset" name = "clear" value = "Cancel">
</form>

<?php

$result2 = mysql_query("SELECT * FROM newdbase");
echo '<table border ="1">';
echo '<th>Action</th><th>Storename</th><th>Sa…
if (count($result2)>0)
{
while ($a=mysql_fetch_array($result2))
{
echo "<tr>";
echo "<td><a href=\"index2.php?id=".$a["id"]."&flag=1… DELETE </a></td>";
echo "<td>".$a["store"]."</td>";
echo "<td>".$a["sales"]."</td>";
echo "<td>".$a["month"]."-".$a["day"]."-".$a[…
echo "</tr>";
}
}
echo "</table>";

?>

</BODY>
</HTML>

like in phpmyadmin, there's delete(the code above provides this) and there's update (no idea) that's not my code but i works properly, thanks! =)
 
Back
Top