Drop Down list in PHP Code

bob1660 · June 5, 2009

I a a NEWBIE with PHP and MySQL, and would like some help on how to add a drop down selection in a input field.

EG. Code - <td class="hr"><?php echo htmlspecialchars("Hotel")." " ?></td>

Drop Down should only contain "Westin Grand", "Cullinen" and "Holliday Inn"

Any Help will be greatly appreciated.

NEWBIE ???

gevans · June 5, 2009

Are you getting the data for the drop down from the db? If so you should be able to implement the following to do the rest;

<?php
$the_list = array("1" => "Westin Grand", "2" => "Cullinen", "3" => "Holliday Inn");//data you would get from db
$drop_down = '<select>';

foreach($the_list as $k => $v) {
$drop_down .= "<option value=\"$k\">$v</option>";
}

$drop_down .= '</select>';

bob1660 · June 5, 2009

Thank you gevans, but the values are not in the DB, and will have to be hard coded.

gevans · June 5, 2009

well, in the above example i hard coded them for you

bob1660 · June 5, 2009

Tank yoy Gavin,

As I said, VERY new. I attach the rest of the code, can you please indicate where I must insert your suggestion.

<?php

$conn = connect();

$showrecs = 40;

$pagerange = 10;

$a = @$_GET["a"];

$recid = @$_GET["recid"];

$page = @$_GET["page"];

if (!isset($page)) $page = 1;

$sql = @$_POST["sql"];

switch ($sql) {

case "insert":

sql_insert();

break;

case "update":

sql_update();

break;

}

switch ($a) {

case "add":

addrec();

break;

case "edit":

editrec($recid);

break;

default:

select();

break;

}

if (isset($order)) $_SESSION["order"] = $order;

if (isset($ordtype)) $_SESSION["type"] = $ordtype;

if (isset($filter)) $_SESSION["filter"] = $filter;

if (isset($filterfield)) $_SESSION["filter_field"] = $filterfield;

if (isset($wholeonly)) $_SESSION["wholeonly"] = $wholeonly;

mysql_close($conn);

?>

</body>

</html>

<?php function select()

{

global $a;

global $showrecs;

global $page;

global $filter;

global $filterfield;

global $wholeonly;

global $order;

global $ordtype;

if ($a == "reset") {

$filter = "";

$filterfield = "";

$wholeonly = "";

$order = "";

$ordtype = "";

}

$checkstr = "";

if ($wholeonly) $checkstr = " checked";

if ($ordtype == "asc") { $ordtypestr = "desc"; } else { $ordtypestr = "asc"; }

$res = sql_select();

$count = sql_getrecordcount();

if ($count % $showrecs != 0) {

$pagecount = intval($count / $showrecs) + 1;

}

else {

$pagecount = intval($count / $showrecs);

}

$startrec = $showrecs * ($page - 1);

if ($startrec < $count) {mysql_data_seek($res, $startrec);}

$reccount = min($showrecs * $page, $count);

?>

<tr>

<td><b>Search Criteria</b> </td>

<option value="">All Fields</option>

</select></td>

<td><input type="checkbox" name="wholeonly"<?php echo $checkstr ?>>Whole words only</td>

</td></tr>

<tr>

<td><a href="delegate_details.php?a=reset">Reset</a></td>

</tr>

</table>

</form>

<?php showpagenav($page, $pagecount); ?>

<br>

<tr>

</tr>

<?php

for ($i = $startrec; $i < $reccount; $i++)

{

$row = mysql_fetch_assoc($res);

$style = "dr";

if ($i % 2 != 0) {

$style = "sr";

}

?>

<tr>

</tr>

<?php

}

mysql_free_result($res);

?>

</table>

<br>

<?php showpagenav($page, $pagecount); ?>

<?php } ?>

<?php function showroweditor($row, $iseditmode)

{

global $conn;

?>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

</tr>

</table>

<?php } ?>

<?php function showpagenav($page, $pagecount)

{

?>

<tr>

<td><a href="delegate_details.php?a=add">Add Record</a> </td>

<?php if ($page > 1) { ?>

<?php } ?>

<?php

global $pagerange;

if ($pagecount > 1) {

if ($pagecount % $pagerange != 0) {

$rangecount = intval($pagecount / $pagerange) + 1;

}

else {

$rangecount = intval($pagecount / $pagerange);

}

for ($i = 1; $i < $rangecount + 1; $i++) {

$startpage = (($i - 1) * $pagerange) + 1;

$count = min($i * $pagerange, $pagecount);

if ((($page >= $startpage) && ($page <= ($i * $pagerange)))) {

for ($j = $startpage; $j < $count + 1; $j++) {

if ($j == $page) {

?>

<?php } else { ?>

<?php } } } else { ?>

<?php } } } ?>

<?php if ($page < $pagecount) { ?>

<?php } ?>

</tr>

</table>

<?php } ?>

<?php function showrecnav($a, $recid, $count)

{

?>

<tr>

<td><a href="delegate_details.php">Index Page</a></td>

<?php if ($recid > 0) { ?>

<td><a href="delegate_details.php?a=<?php echo $a ?>&recid=<?php echo $recid - 1 ?>">Prior Record</a></td>

<?php } if ($recid < $count - 1) { ?>

<td><a href="delegate_details.php?a=<?php echo $a ?>&recid=<?php echo $recid + 1 ?>">Next Record</a></td>

<?php } ?>

</tr>

</table>

<?php } ?>

<?php function addrec()

{

?>

<tr>

<td><a href="delegate_details.php">Index Page</a></td>

</tr>

</table>

<?php

$row = array(

"Surname" => "",

"First Name" => "",

"Ministry" => "",

"Flight No" => "",

"Arrival Status" => "",

"Baggage Status" => "",

"Baggage No" => "",

"Clothing Req" => "",

"Hotel" => "",

"Room No" => "");

showroweditor($row, false);

?>

</form>

<?php } ?>

<?php function editrec($recid)

{

$res = sql_select();

$count = sql_getrecordcount();

mysql_data_seek($res, $recid);

$row = mysql_fetch_assoc($res);

showrecnav("edit", $recid, $count);

?>

<br>

<?php showroweditor($row, true); ?>

</form>

<?php

mysql_free_result($res);

} ?>

<?php function connect()

{

$conn = mysql_connect("localhost", "root", "");

mysql_select_db("iam2010");

return $conn;

}

function sqlvalue($val, $quote)

{

if ($quote)

$tmp = sqlstr($val);

else

$tmp = $val;

if ($tmp == "")

$tmp = "NULL";

elseif ($quote)

$tmp = "'".$tmp."'";

return $tmp;

}

function sqlstr($val)

{

return str_replace("'", "''", $val);

}

function sql_select()

{

global $conn;

global $order;

global $ordtype;

global $filter;

global $filterfield;

global $wholeonly;

$filterstr = sqlstr($filter);

if (!$wholeonly && isset($wholeonly) && $filterstr!='') $filterstr = "%" .$filterstr ."%";

$sql = "SELECT `Surname`, `First Name`, `Ministry`, `Flight No`, `Arrival Status`, `Baggage Status`, `Baggage No`, `Clothing Req`, `Hotel`, `Room No` FROM `delegate_details`";

if (isset($filterstr) && $filterstr!='' && isset($filterfield) && $filterfield!='') {

$sql .= " where " .sqlstr($filterfield) ." like '" .$filterstr ."'";

} elseif (isset($filterstr) && $filterstr!='') {

$sql .= " where (`Surname` like '" .$filterstr ."') or (`First Name` like '" .$filterstr ."') or (`Ministry` like '" .$filterstr ."') or (`Flight No` like '" .$filterstr ."') or (`Arrival Status` like '" .$filterstr ."') or (`Baggage Status` like '" .$filterstr ."') or (`Baggage No` like '" .$filterstr ."') or (`Clothing Req` like '" .$filterstr ."') or (`Hotel` like '" .$filterstr ."') or (`Room No` like '" .$filterstr ."')";

}

if (isset($order) && $order!='') $sql .= " order by `" .sqlstr($order) ."`";

if (isset($ordtype) && $ordtype!='') $sql .= " " .sqlstr($ordtype);

$res = mysql_query($sql, $conn) or die(mysql_error());

return $res;

}

function sql_getrecordcount()

{

global $conn;

global $order;

global $ordtype;

global $filter;

global $filterfield;

global $wholeonly;

$filterstr = sqlstr($filter);

if (!$wholeonly && isset($wholeonly) && $filterstr!='') $filterstr = "%" .$filterstr ."%";

$sql = "SELECT COUNT(*) FROM `delegate_details`";

if (isset($filterstr) && $filterstr!='' && isset($filterfield) && $filterfield!='') {

$sql .= " where " .sqlstr($filterfield) ." like '" .$filterstr ."'";

} elseif (isset($filterstr) && $filterstr!='') {

$sql .= " where (`Surname` like '" .$filterstr ."') or (`First Name` like '" .$filterstr ."') or (`Ministry` like '" .$filterstr ."') or (`Flight No` like '" .$filterstr ."') or (`Arrival Status` like '" .$filterstr ."') or (`Baggage Status` like '" .$filterstr ."') or (`Baggage No` like '" .$filterstr ."') or (`Clothing Req` like '" .$filterstr ."') or (`Hotel` like '" .$filterstr ."') or (`Room No` like '" .$filterstr ."')";

}

$res = mysql_query($sql, $conn) or die(mysql_error());

$row = mysql_fetch_assoc($res);

reset($row);

return current($row);

}

function sql_insert()

{

global $conn;

global $_POST;

$sql = "insert into `delegate_details` (`Surname`, `First Name`, `Ministry`, `Flight No`, `Arrival Status`, `Baggage Status`, `Baggage No`, `Hotel`, `Room No`, `Clothing Req`) values (" .sqlvalue(@$_POST["Surname"], true).", " .sqlvalue(@$_POST["First_Name"], true).", " .sqlvalue(@$_POST["Ministry"], true).", " .sqlvalue(@$_POST["Flight_No"], true).", " .sqlvalue(@$_POST["Arrival_Status"], true).", " .sqlvalue(@$_POST["Baggage_Status"], true).", " .sqlvalue(@$_POST["Baggage_No"], true).", " .sqlvalue(@$_POST["Hotel"], true).", " .sqlvalue(@$_POST["Room_No"], false).", " .sqlvalue(@$_POST["Clothing_Req"], true).")";

mysql_query($sql, $conn) or die(mysql_error());

}

function sql_update()

{

global $conn;

global $_POST;

$sql = "update `delegate_details` set `Surname`=" .sqlvalue(@$_POST["Surname"], true).", `First Name`=" .sqlvalue(@$_POST["First_Name"], true).", `Ministry`=" .sqlvalue(@$_POST["Ministry"], true).", `Flight No`=" .sqlvalue(@$_POST["Flight_No"], true).", `Arrival Status`=" .sqlvalue(@$_POST["Arrival_Status"], true).", `Baggage Status`=" .sqlvalue(@$_POST["Baggage_Status"], true).", `Baggage No`=" .sqlvalue(@$_POST["Baggage_No"], true).", `Hotel`=" .sqlvalue(@$_POST["Hotel"], true).", `Room No`=" .sqlvalue(@$_POST["Room_No"], false).", `ClothingReq`=" .sqlvalue(@$_POST["Clothing_Req"], true) ." where " .primarykeycondition();

mysql_query($sql, $conn) or die(mysql_error());

}

function primarykeycondition()

{

global $_POST;

$pk = "";

$pk .= "(`Surname`";

if (@$_POST["xSurname"] == "") {

$pk .= " IS NULL";

}else{

$pk .= " = " .sqlvalue(@$_POST["xSurname"], true);

};

$pk .= ")";

return $pk;

}

?>

gevans · June 5, 2009

OK, first you have to learn to use

tags...

...code goes in here

Second, it's up to you. That's all the code will do is assign the html to a variable. Then you can output the variable wherever you want it, I'd advise in your form!

bob1660 · June 5, 2009

Still confused where the code must go

Sign In

Drop Down list in PHP Code

Recommended Posts

bob1660

Link to comment

Share on other sites

gevans

Link to comment

Share on other sites

bob1660

Link to comment

Share on other sites

gevans

Link to comment

Share on other sites

bob1660

Link to comment

Share on other sites

gevans

Link to comment

Share on other sites

bob1660

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information