MySQL and PHP delete row from dropdown

Question

I wish to use dropdown to list all rows from database. When I select one option, delete that selected row with button. Here what I have by now, this only shows dropdown:

$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Nije se moguće konektovati: ' . mysql_error());
}

 mysql_select_db("videoteka", $con);

$result = mysql_query("select ime,id from filmovi");

$options=""; 

echo "Odaberite film:";

 while ($row=mysql_fetch_array($result)) { 

$id=$row["id"]; 
$ime=$row["ime"]; 
$options.="<OPTION VALUE=\"$id\">".$ime.'</option>';
}

mysql_close($con);

And in body:

<select name=thing> 
<option value=0><?=$options?></option>
</select>

Sorry, but we can't (shouldn't) do your homework for you. Did you try something for the delete part already? Can you use JavaScript/jQuery? — Aioros
– Aioros, Commented Dec 23, 2012 at 16:53
I can only use PHP. I can't relly figure out how to use <option> with button. — Emir Dupovac
– Emir Dupovac, Commented Dec 23, 2012 at 17:01
that's the point of homework. StackOverflow is nice for learning but for this you should start reading it... :-) — Sebas
– Sebas, Commented Dec 23, 2012 at 17:14

Aioros · Accepted Answer · 2012-12-23 17:14:24Z

2

Ok, so two things, just to try and put you in the right direction: first, in the body you can remove the <option> tag, since your php variable already contains those.

<select name=thing> 
<?=$options?>
</select>

Second, the delete part. There are different ways to do this, but one thing you will certainly need is an HTML form. Your select (and the button) will need to be in this form, which will be submitted to this very same PHP page. In the beginning of your PHP code you will check the $_POST variable to determine what row to delete. I hope you know what $_POST is, otherwise this is going to be a pretty useless explanation.

answered Dec 23, 2012 at 17:14

Aioros

4,3931 gold badge20 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Emir Dupovac Over a year ago

Ok. Now I made form with action delete.php and in it I have: $delete = mysql_query("DELETE * FROM filmovi WHERE $_POST[thing]"). But I don't think this is right.

Aioros Over a year ago

Well, it also depends on the result you want. Is delete.php a different page from the one with the form? Anyway, in the post variable you will find the selected id (as $_POST['thing'], yes), so the query will be something like $delete = mysql_query("DELETE FROM filmovi WHERE id = '".$_POST['thing']."';"); I know this is not very detailed, but I hope you understand that this is not the right place for a basic PHP lesson.

Emir Dupovac Over a year ago

Wow. It worked just the way I wanted. Thanks very much! Sorry for amateurism.

Collectives™ on Stack Overflow

MySQL and PHP delete row from dropdown

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related