Originally Posted by network18

First of what you gave got nothing to do with PHP, its a HTML select element. and what do you mean by declare.

Originally Posted by levsha

Yes, I know.
What I mean is I need to write an IF... ELSE statement in PHP using data from the select menu that comes from my HTML form.
Can't figure out how this should be done.

Originally Posted by violarisgeorge

Simply, if I understand what you want to do, you should have a value for each option in your HTML select element of your form. Then, in php, you should have variables which grab those option values (with $_POST or $_GET depending on your form), and then feed them into a switch statement (better than IF statement for this purpose I believe) and put inside each case of your switch what you want it to do for each option.

i.e. each case represents one of the options.

Originally Posted by levsha

Let's say I have this in my HTML form:

Help with Code Tags

PHP Syntax (Toggle Plain Text)

      <select name="search" title="Search Criteria">
      <option value="id">ID Status</option>
      <option value="ip">IP Status</option>
      <option value="pd">PD Status</option>
      </select>

<select name="search" title="Search Criteria"> <option value="id">ID Status</option> <option value="ip">IP Status</option> <option value="pd">PD Status</option> </select>

Here is my PHP:

Help with Code Tags

PHP Syntax (Toggle Plain Text)

<?php
 
$search = @$_POST['search'];
$id = @$_POST['id'];
$ip = @$_POST['ip'];
$pd = @$_POST['pd'];
 
?>

<?php $search = @$_POST['search']; $id = @$_POST['id']; $ip = @$_POST['ip']; $pd = @$_POST['pd']; ?>

Is that correct?
What if I need to grab a value from my HTML select element (one of the options) and send it to a database?
What do I write in my INSERT statement?

Help with Code Tags

(Toggle Plain Text)

$sql = "insert into mytable (status) values ('$_POST[???]')";

$sql = "insert into mytable (status) values ('$_POST[???]')";

Originally Posted by violarisgeorge

No this is not correct. You only need $search = @$_POST['search']; in order to capture the selection. Then in your switch statement you should say that if the $search is equal to id, then do this, and so on.

Then, in your db query you should command something like

Help with Code Tags

PHP Syntax (Toggle Plain Text)

$sql = "INSERT INTO `mytable` (status) VALUES ($search);"

$sql = "INSERT INTO `mytable` (status) VALUES ($search);"

IMPORTANT NOTE: The SQL query should go into EVERY single on of your case statements of the switch. I hope you get what I mean... Try it out and report back any problems.

Originally Posted by levsha

Thank you so, so, so much!
It works perfectly well!