Hi list,
I am trying to making online telephone directory search.
I have an input form which has input for name and SELECT option for the
area. Name of this form file is 'searchtel.php'
This form parsing is done by 'searchtelparse.php' file which has query, i.e
$query with 'IF' statement for different areas. When I execute SEARCH on the
form, it only queries from the first 'SELECTED' option's area table i.e the
default option. I have a separate table of telephone numbers for each area.
Even though I select another area, it will give query from the default
SELECT option.
Both the files 'searchtel.php' and 'searchtelparse.php' are pasted below for
you reference.
Could you please have look and suggest me some corrections.
Thanks in advance.
NOBBY
--------
searchtel.php
<FORM method="post" action="searchtelparse.php" name="searchtel">
<input type="text" name="Name" size="20" maxlength="63">
Select location: <select name="location">
<option selected>Gasa</option>
<option>Punakha</option>
<option>Thimphu</option>
<option>Wangdue</option>
</select>
<input type="submit" name="Search">
</FORM>
-----------
searchtelparse.php
<?
error_reporting ( ~E_ALL & ~E_NOTICE );
/* connection information */
$hostname = "localhost";
$username = "root";
$password = "root";
$dbName = "penpal";
/* make connection to database */
MYSQL_CONNECT($hostname, $username, $password) OR DIE( "Unable to connect
to database");
@mysql_select_db("$dbName") or die( "Unable to select database");
if ($idnum == "")
{$idnum = '%';}
if ($Phone == "")
{$Phone = '%';}
if ($Name == "")
{$Name = '%';}
if ($Add1 == "")
{$Add1 = '%';}
if ($Add2 == "")
{$Add2 == '%';}
if ($Add3 == "")
{$Add3 == '%';}
if ($Type == "")
{$Type == '%';}
if ($location ="Gasa") {
$query = ("SELECT * FROM gasa WHERE Name like '%$Name%'");
} elseif ($location ="Punakha") {
$query = ("SELECT * FROM punakha WHERE Name like '%$Name%'");
} elseif ($location ="Thimphu") {
$query = ("SELECT * FROM thimphu WHERE Name like '%$Name%'");
} else {
$query = ("SELECT * FROM wangdue WHERE Name like '%$Name%'");
}
echo "$location";
$result = MYSQL_QUERY($query);
if (!$result) print ("No matches found.\n");
/* Determine the number of records returned */
WHILE ($row=MYSQL_FETCH_ROW($result))
$number = mysql_numrows($result);
if (!$number) print("<font face=\"Verdana, Arial, Helvetica, sans-serif\"
size=\"-2\"><b>There are matches found.</b></font><p>\n");
/* Print the relevant information */
$i = 0;
PRINT "<table cellpadding=5>";
PRINT " <TR bgcolor=#000066>
<td><font face=\"Verdana,
Arial,Helvetica, sans-serif\" size=\"-2\" color=white><b>idnum
</b></font></td>
<td><font face=\"Verdana,
Arial,Helvetica, sans-serif\" size=\"-2\" color=white><b>Phone
</b></font></td> <td><font face=\"Verdana, Arial, Helvetica,
sans-serif\" size=\"-2\" color=white><b>Name
</b></font></td><td><font face=\"Verdana, Arial, Helvetica,
sans-serif\" size=\"-2\" color=white><b>Add1</b></font></td>
<td><font face=\"Verdana, Arial, Helvetica,
sans-serif\" size=\"-2\" color=white><b>Add2</b></font></td>
<td><font face=\"Verdana, Arial, Helvetica,
sans-serif\" size=\"-2\" color=white><b>Add3</b></font></td>
<td><font face=\"Verdana, Arial, Helvetica,
sans-serif\" size=\"-2\" color=white><b>Type</b></font></td>
</tr>";
WHILE ($i < $number):
$idnum = mysql_result($result, $i,"idnum");
$Phone = mysql_result($result, $i,"Phone");
$Name = mysql_result($result,$i,"Name");
$Add1 = mysql_result($result,$i,"Add1");
$Add2 = mysql_result($result,$i,"Add2");
$Add3 = mysql_result($result,$i,"Add3");
$Type = mysql_result($result,$i,"Type");
if ($i%2 == 0) {
PRINT "<tr bgcolor=#E8E8E8>
<td><font face=\"Verdana, Arial, Helvetica,
sans-serif\" size=\"-2\"> $idnum</font></td>
<td><font face=\"Verdana, Arial, Helvetica,
sans-serif\" size=\"-2\"> $Phone</font></td>
<td><font face=\"Verdana, Arial, Helvetica,
sans-serif\" size=\"-2\"> $Name</font></td>
<td><font face=\"Verdana, Arial, Helvetica,
sans-serif\" size=\"-2\"> $Add1</font></td>
<td><font face=\"Verdana, Arial, Helvetica,
sans-serif\" size=\"-2\"> $Add2</font></td>
<td><font face=\"Verdana, Arial, Helvetica,
sans-serif\" size=\"-2\"> $Add3</font></td>
<td><font face=\"Verdana, Arial, Helvetica,
sans-serif\" size=\"-2\"> $Type</font></td>
</tr>";
} else {
PRINT "<tr bgcolor=#cccccc>
<td><font face=\"Verdana, Arial, Helvetica,
sans-serif\" size=\"-2\"> $idnum</font></td>
<td><font face=\"Verdana, Arial, Helvetica,
sans-serif\" size=\"-2\"> $Phone</font></td>
<td><font face=\"Verdana, Arial, Helvetica,
sans-serif\" size=\"-2\"> $Name</font></td>
<td><font face=\"Verdana, Arial, Helvetica,
sans-serif\" size=\"-2\"> $Add1</font></td>
<td><font face=\"Verdana, Arial, Helvetica,
sans-serif\" size=\"-2\"> $Add2</font></td>
<td><font face=\"Verdana, Arial, Helvetica,
sans-serif\" size=\"-2\"> $Add3</font></td>
<td><font face=\"Verdana, Arial, Helvetica,
sans-serif\" size=\"-2\"> $Type</font></td>
</tr>";
}
$i++;
ENDWHILE;
PRINT "</table>";
/* Close the database connection */
MYSQL_CLOSE();
?>
-----------------
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
