Forum Moderators: coopster
I'm not to familiar to php and sql. I have this assignment to read from database in a table and I HAVE TO be able to push a button causing one costumer to vanish. something to do with id = $id... can anyone help me... and help me fast! thanx a bunch :)
this is my code:
<center>
<table border="1" cellspacing="0" cellpadding="3" width="400">
<tr bgcolor="#003399">
<td colspan=2 width="100%" bgcolor="#003399">
<b><font color=white size="-1" face="arial, helvetica">Upplýsingar viðskiptamanna</font></b></td></tr><tr><td>
<?
$conn = mysql_connect("localhost", "", "");
mysql_select_db("orderdb",$conn);
$sql = "SELECT * FROM orderdb";
$result = mysql_query($sql, $conn);
while ($newArray = mysql_fetch_array($result))
{
$o_id = $newArray['o_id'];
$o_gender = $newArray['o_gender'];
$o_firstname = $newArray['o_firstname'];
$o_lastname = $newArray['o_lastname'];
$o_b_day = $newArray['o_b_day'];
$o_b_month = $newArray['o_b_month'];
$o_b_year = $newArray['o_b_year'];
$o_address = $newArray['o_address'];
$o_email = $newArray['o_email'];
$o_a_day = $newArray['o_a_day'];
$o_a_month = $newArray['o_a_month'];
$o_a_year = $newArray['o_a_year'];
$o_d_day = $newArray['o_d_day'];
$o_d_month = $newArray['o_d_month'];
$o_d_year = $newArray['o_d_year'];
$o_accomodation = $newArray['o_accomodation'];
$o_tour = $newArray['o_tour'];
$o_t_day = $newArray['o_t_day'];
$o_t_month = $newArray['o_t_month'];
$o_t_year = $newArray['o_t_year'];
$o_info = $newArray['o_info'];
echo "<FORM ACTION=skra.php METHOD=Post>";
echo "<tr><td>Pöntunarnúmer:</td><td><b>$o_id</b></td></tr>";
echo "<tr><td>Nafn:</td><td><i>$o_gender $o_firstname $o_lastname</i></td></tr>";
echo "<tr><td>Fæðingardagur:</td><td>$o_b_day.$o_b_month.$o_b_year</td></tr>";
echo "<tr><td>Heimilisfang:</td><td>$o_address</td></tr>";
echo "<tr><td>Póstfang:</td><td>$o_email</td></tr>";
echo "<tr><td>Komutími:</td><td>$o_a_day.$o_a_month.$o_a_year</td></tr>";
echo "<tr><td>Brottfarartími:</td><td>$o_d_day.$o_d_month.$o_d_year</td></tr>";
echo "<tr><td>Gisting:</td><td>$o_accomodation</td></tr>";
echo "<tr><td>Ferð:</td><td>$o_tour</td></tr>";
echo "<tr><td>Dagsetning ferðar:</td><td>$o_t_day.$o_t_month.$o_t_year</td></tr>";
echo "<tr><td>Annað:</td><td>$o_info</td></tr>";
echo "<tr><td colspan=2 align=center bgcolor=#C0C0C0>";
echo "<INPUT TYPE=Submit VALUE=! ONCLICK= DELETE FROM orderdb WHERE o_id = $o_id;?>";
echo "<font face=arial, helvetica size=-2>PUSH BUTTON TO DELETE COSTUMER viðskiptamanni</font></td></tr>";
?>
</center><p>
Here's what I do.
You'll need a delete button like this which will be posted.
<input type="submit" name="action" value="Delete">
Then in the page being posted to I have something like this...
//Delete the record
if ($_POST['action'] == "Delete") {
$sqldelete = "delete from orderdb where o_id=" . $_POST['o_id'];
mysql_query($sqldelete);
//more code here.
}
Look at the mysql manual for more on DELETE [mysql.com]. Just remember with php a sql statement must be run with mysql_query().
The Page, skra.php
_______________________________________________
<center>
<table border="1" cellspacing="0" cellpadding="3" width="400">
<tr bgcolor="#003399">
<td colspan=2 width="100%" bgcolor="#003399">
<b><font color=white size="-1" face="arial, helvetica">Upplýsingar viðskiptamanna</font></b></td></tr><tr><td>
<?
$conn = mysql_connect("localhost", "", "");
mysql_select_db("orderdb",$conn);
$sql = "SELECT * FROM orderdb";
$result = mysql_query($sql, $conn);
while ($newArray = mysql_fetch_array($result))
{
$o_id = $newArray['o_id'];
$o_gender = $newArray['o_gender'];
$o_firstname = $newArray['o_firstname'];
$o_lastname = $newArray['o_lastname'];
$o_b_day = $newArray['o_b_day'];
$o_b_month = $newArray['o_b_month'];
$o_b_year = $newArray['o_b_year'];
$o_address = $newArray['o_address'];
$o_email = $newArray['o_email'];
$o_a_day = $newArray['o_a_day'];
$o_a_month = $newArray['o_a_month'];
$o_a_year = $newArray['o_a_year'];
$o_d_day = $newArray['o_d_day'];
$o_d_month = $newArray['o_d_month'];
$o_d_year = $newArray['o_d_year'];
$o_accomodation = $newArray['o_accomodation'];
$o_tour = $newArray['o_tour'];
$o_t_day = $newArray['o_t_day'];
$o_t_month = $newArray['o_t_month'];
$o_t_year = $newArray['o_t_year'];
$o_info = $newArray['o_info'];
echo "<FORM ACTION=delete.php METHOD=Post>";
echo "<tr><td>Pöntunarnúmer:</td><td><b>$o_id</b></td></tr>";
echo "<tr><td>Nafn:</td><td><i>$o_gender $o_firstname $o_lastname</i></td></tr>";
echo "<tr><td>Fæðingardagur:</td><td>$o_b_day.$o_b_month.$o_b_year</td></tr>";
echo "<tr><td>Heimilisfang:</td><td>$o_address</td></tr>";
echo "<tr><td>Póstfang:</td><td>$o_email</td></tr>";
echo "<tr><td>Komutími:</td><td>$o_a_day.$o_a_month.$o_a_year</td></tr>";
echo "<tr><td>Brottfarartími:</td><td>$o_d_day.$o_d_month.$o_d_year</td></tr>";
echo "<tr><td>Gisting:</td><td>$o_accomodation</td></tr>";
echo "<tr><td>Ferð:</td><td>$o_tour</td></tr>";
echo "<tr><td>Dagsetning ferðar:</td><td>$o_t_day.$o_t_month.$o_t_year</td></tr>";
echo "<tr><td>Annað:</td><td>$o_info</td></tr>";
echo "<tr><td colspan=2 align=center bgcolor=#C0C0C0>";
echo "<input type=submit name=action value=!>";
echo "<font face=arial, helvetica size=-2>Click to delete costumer from database</font></td></tr>";
}
?>
</center><p>
__________________________
And the delete.php page:
__________________________
<?
//Delete the record
if ($_POST['action'] == "!") {
$sqldelete = "delete from orderdb where o_id=" . $_POST['o_id'];
mysql_query($sqldelete);
//more code here.
}
?>
<a href=skra.php> BACK
_______________________
it doesn't work. Thank you so much for your help man, if you could take a quick look at this I would be verry happy. again thanks for your comment :)
Regards -Einar Oskar
Maybe I'm missing something but I can't see how your delete.php is getting the o_id variable. Something like this between your form tags will do the trick.
echo "<input type=hidden name=o_id value=$i_od>"
echo "<FORM ACTION=delete.php METHOD=Post>";
echo "<tr><td>Pöntunarnúmer:</td><td><b>$o_id</b></td></tr>";
echo "<tr><td>Nafn:</td><td><i>$o_gender $o_firstname $o_lastname</i></td></tr>";
echo "<tr><td>Fæðingardagur:</td><td>$o_b_day.$o_b_month.$o_b_year</td></tr>";
echo "<tr><td>Heimilisfang:</td><td>$o_address</td></tr>";
echo "<tr><td>Póstfang:</td><td>$o_email</td></tr>";
echo "<tr><td>Komutími:</td><td>$o_a_day.$o_a_month.$o_a_year</td></tr>";
echo "<tr><td>Brottfarartími:</td><td>$o_d_day.$o_d_month.$o_d_year</td></tr>";
echo "<tr><td>Gisting:</td><td>$o_accomodation</td></tr>";
echo "<tr><td>Ferð:</td><td>$o_tour</td></tr>";
echo "<tr><td>Dagsetning ferðar:</td><td>$o_t_day.$o_t_month.$o_t_year</td></tr>";
echo "<tr><td>Annað:</td><td>$o_info</td></tr>";
echo "<tr><td colspan=2 align=center bgcolor=#C0C0C0>";
echo "<input type=submit name=action value=!><input type=hidden name=o_id value=$i_od>";
echo "<font face=arial, helvetica size=-2>Smelltu hér til að eyða viðskiptamanni</font></td></tr>";
__________________
now it looks like this and it didn't work so i tried to put a connection to the database in the delete page... it looks like so:
__________________
<?
$conn = mysql_connect("localhost", "", "");
mysql_select_db("orderdb",$conn);
//Delete the record
if ($_POST['action'] == "!") {
$sqldelete = "delete from orderdb where o_id=" . $_POST['o_id'];
mysql_query($sqldelete);
//more code here.
}
?>
<a href=skra.php> BACK
_____________________
Don't get it!
regards -Einar Óskar
cracking little tutorial showing exactly what you want to do - shows you how to display results of an sql database, add entries, delete entries, update entries and different filters!
maybe you can learn from this tutorial to achieve things on your own!
