database query
| From: | Helen Rosseau | Date: | Mon, 15 Oct 2001 12:49:25 +0000 |
| Subject: | database query | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-13324@lists.php.net to get a copy of this message | ||
I've been reading through this newsgroup and have acquired snippets of
code that I thought would work, but I am missing something in passing my
variables from the html portion to the php portion. If I hard code in
some values I get a correct search, but I need to be able to pass the
variables in.
Suggestions please.
<body>
<?
$field=array();
$keyword=array();
$keyword=array();
?>
<html>
<table border="0" cellspacing="5" cellpadding="5">
<tr>
<td valign="top"><b>Search Database on </b></td>
<td>
<form>
<input type="Text" name="keyword.php" size="25"
method=GET></td>
<? $HTTP_GET_VARS["keyword"] ?>
</form>
</tr>
<tr>
<td valign="top"><b>Search</b></td>
<form method=GET>
<td><select name="field.php" size="1">
<? $HTTP_GET_VARS["field"] ?>
<!-- LOOP lines -->
<option name=field value="Chamber">Chamber</option>
<option name=field value="Date" >Date</option>
<option name=field value="Time" >Time</option>
<option name=field value="TermID" >Terminal ID</option>
<option name=field value="FLID" >Forward Link ID</option>
<option name=field value="RLID" >Return Link ID</option>
<option name=field value="HWID" >Hardware ID </option>
<option name=field value="bootVer" >Boot Version </option>
<option name=field value="hwVer" > Hardware Version </option>
<option name=field value="appVer" >Application Version </option>
<option name=field value="txSF" >Transmit SF </option>
<option name=field value="tx_olg">Transmit olg </option>
<!-- END_LOOP lines -->
</select></td>
<form>
<? $HTTP_GET_VARS["field"];
$HTTP_GET_VARS["keyword"];
?>
<td colspan="2" align="center"><input type="Submit"
name="submit"
value="submit"></td> </form>
</tr>
</table>
</body>
</html>
<?php
if (isset($submit)) {
// if there is an field, then it's an update
if (isset($field)) {
reset($HTTP_POST_VARS);
$field = ""; $search_item = "";
while(list($field,$search_item) = each($HTTP_GET_VARS)) {
if (ereg("^$field\.", $keyword)) {
}
if ($set == "")
$HTTP_GET_VARS["keyword"];
$HTTP_GET_VARS["field"];
{ print "Getting Data"; exit; }
}
}
$HTTP_GET_VARS["keyword"];
$HTTP_GET_VARS["field"];
// this part works when hard coded
$dbh = mysql_connect("connect","user","password");
$result = mysql_list_tables("table");
echo "$result<br>\n";
mysql_select_db("database");
$query = "SELECT * FROM F4 WHERE field="$field" AND
keyword="%"keyword"%" limit 0, 30";
echo"$query<br>\n";
$result = mysql_query($query,$dbh);
echo "$result<br>\n";
$field = mysql_num_fields($result);
while ($row=mysql_fetch_array($result))
{
for ($i=0; $i<$field; $i++)
{
$name=mysql_field_name($result, $i);
echo "$name = $row[$name]<br> \n";
}
echo "<br><br>\n";
}
//end of part that works
?>
--
Helen Rosseau
Technologist
Vistar Telecommunications Inc
427 Laurier Ave W
Suite 1410
Ottawa Ontario Canada
K1R 7Y2
613-230-4848 ext 2245
Fax 613-230-4940
email hrosseau@vistar.ca