سلام دوستان من واقعا عاجز شدم دیگه .همه جا دارم میپرسم باید برای دیتا بیسم یه جستجو بر اساس دو فیلد قرار بدم تو صفحه اول اینو گذاستم
<form action="search.php" method="get">
<fieldset>
<table>
<tr>
<td> name:</td>
<td><input name="tag" type="text" id="tag" size="15"/></td>
</tr>
<tr>
<td> sys_name: </td>
<td><input sys_name="tag" type="text" id="tag" size="15"/></td>
</tr>
<tr>
<td>month:</td>
<td><input month="tag" type="int" id="tag" size="15"/></td>
</tr>
<tr>
<td>day:</td>
<td><input day="tag" type="int" id="tag" size="15"/></td>
</tr>
<tr><td> </td>
<td><input type="submit" value="search" /></td>
</tr>
</table>
</fieldset>
</form>
</form>
و تو صفحه search.php هم اینو <fieldset>
<table>
<tr>
<td> name:</td>
<td><input name="tag" type="text" id="tag" size="15"/></td>
</tr>
<tr>
<td> sys_name: </td>
<td><input sys_name="tag" type="text" id="tag" size="15"/></td>
</tr>
<tr>
<td>month:</td>
<td><input month="tag" type="int" id="tag" size="15"/></td>
</tr>
<tr>
<td>day:</td>
<td><input day="tag" type="int" id="tag" size="15"/></td>
</tr>
<tr><td> </td>
<td><input type="submit" value="search" /></td>
</tr>
</table>
</fieldset>
</form>
</form>
<?php
if(!isset($_GET["q"]))
die("The Search key word is not set!");
$key = $_GET["q"];
if($key == "")
die("The Search key word must be entered!");
$DbConn = mysql_connect("localhost", "root", "emami" ) or die(mysql_error());
mysql_select_db("technical_unit",$DbConn) or die("Can Not Select DataBase Because: ". mysql_error());
$sql = "SELECT * FROM main1 WHERE name LIKE \"+$key+'\' and sys_name LIKE \"+$key+'\' and month \"+$key+'\' and day \"+$key+'\'; "
$SearchResult = mysql_query($sql) or die(mysql_error(). "<br />SQL: ". $sql);
$TotalResults = mysql_num_rows($SearchResult);
if($TotalResults <= 0)
die("Not found any record for your key word!");
for($i = 0; $i != $TotalResults; $i++ )
{
//<!-- Start of Print Results...
$TextTitle = mysql_result($SearchResult, $i, 1);
$TextBody = mysql_result($SearchResult, $i, 2);
print($TextTitle ." ==> ". $TextBody ."<br /><br />");
//End of Print Results. -->
}
?>
ولی عمل نمیکنه .......کمکم کنید لطفاif(!isset($_GET["q"]))
die("The Search key word is not set!");
$key = $_GET["q"];
if($key == "")
die("The Search key word must be entered!");
$DbConn = mysql_connect("localhost", "root", "emami" ) or die(mysql_error());
mysql_select_db("technical_unit",$DbConn) or die("Can Not Select DataBase Because: ". mysql_error());
$sql = "SELECT * FROM main1 WHERE name LIKE \"+$key+'\' and sys_name LIKE \"+$key+'\' and month \"+$key+'\' and day \"+$key+'\'; "
$SearchResult = mysql_query($sql) or die(mysql_error(). "<br />SQL: ". $sql);
$TotalResults = mysql_num_rows($SearchResult);
if($TotalResults <= 0)
die("Not found any record for your key word!");
for($i = 0; $i != $TotalResults; $i++ )
{
//<!-- Start of Print Results...
$TextTitle = mysql_result($SearchResult, $i, 1);
$TextBody = mysql_result($SearchResult, $i, 2);
print($TextTitle ." ==> ". $TextBody ."<br /><br />");
//End of Print Results. -->
}
?>