Programming Forums > Web Development and Design > PHP

guess · Feb 21st, 2006, 6:04 AM

in search.php,I have 5 fields and I am passing those variables by get method to the search2.php. I want search2.php to perform a database search according to the information entered by the user and print the result to the search2.php. Everything is ok.Queries,tables.However,I need to be guided about how am I going to search the database with only one key.If I had known which fields are empty and which fields are not,I would write the query according to this.I tried to use isset function for that,however it is always returning true because Im getting them by the post method just like this ;
$ilk = @$_POST["ilktarih"];

So I think it is always returning true because it is initialized at the beginning of the search2.php although I user doesnt enter anything to the fields.

One more thing,Even if I could use the isset function efficiently, there are 5 fields and there are lots of combinations of filling those fields(ex:filling just one,filling the one at the top and the bottom,filling them all).It takes lots of time to write if checks and write the query again and again according to the if checks.Im asking this because I dont know how these kind of searches are coded.

If anybody helps me how to run a query with only one button and make the database bring me the information,I would be grateful.

SEARCH.PHP

<body>
<form name="send" method="post" action="search2.php">
<a style="size:auto ">Baslangi� tarihi : </a>   <input type="text" name="ilktarih" size="30" ><br><br>
<a style="size:auto ">Bitis tarihi : </a>           <input type="text" name="sontarih" size="30" ><br><br>
<a style="size:auto ">From : </a>                <input type="text" name="from" size="30" ><br><br>
<a style="size:auto ">To : </a>                   
<input type="text" name="to" size="30" ><br><br>
<a style="size:auto ">From : </a>               
<select name="spamlist">
<option value="UNSAFE">UNSAFE
<option value="SAFE">SAFE
<option value="BODY">BODY
<option value="ATTACH">ATTACH
<option value="VIRUS">VIRUS
<option value="EMPTY">EMPTY
<option value="ERROR">ERROR
</select><br><br>
                                       
<input type="submit" value="SEARCH">
</form>

SEARCH2.PHP

<body>
<?
$ilk = @$_POST["ilktarih"];
$son = @$_POST["sontarih"];
$from = @$_POST["from"];
$to = @$_POST["to"];
$spam = @$_POST["spamlist"];

/*$a=array($ilk,$son,$from,$to);
for($i=0;$i<5;$i++)
{
if(isset($a[$i])){
$set[$i]=true;
echo $set[$i];
}
}*/
$dbhost = '127.0.0.1';
$dbuser = 'root';
$dbpass = '05364304334';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');

$dbname = 'kutay';
mysql_select_db($dbname);

$query ="select * from t1";
if(empty($ilk) && empty($son) && empty($from) && empty($to)){
$query = $query . " where stats=' $spam'";
}
$result=mysql_query($query,$conn) or die('Error: '.mysql_error().' -- Query: '.$query);

echo "<table border=1>\n";

echo "<tr><td>Rowcount</td><td>Date</td><td>Time</td><td>Status</td><td>Queue</td><td>Recvfrom</td><td>From</td><td>To</td><td>Subject</td><td>Spam</td><td>Rule</td></tr>\n";

$count=1;
while ($myrow = mysql_fetch_row($result)) {

printf("<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>",
$count, $myrow[1], $myrow[2], $myrow[3], $myrow[4], $myrow[5], $myrow[6], $myrow[7], $myrow[8], $myrow[9], $myrow[10]);
$count++;
}
echo "</table>\n";
?>

Feb 21st, 2006, 6:04 AM	#1
guess Programmer Join Date: Feb 2006 Posts: 40 Rep Power: 0	A complicated php,form,mysql in search.php,I have 5 fields and I am passing those variables by get method to the search2.php. I want search2.php to perform a database search according to the information entered by the user and print the result to the search2.php. Everything is ok.Queries,tables.However,I need to be guided about how am I going to search the database with only one key.If I had known which fields are empty and which fields are not,I would write the query according to this.I tried to use isset function for that,however it is always returning true because Im getting them by the post method just like this ; $ilk = @$_POST["ilktarih"]; So I think it is always returning true because it is initialized at the beginning of the search2.php although I user doesnt enter anything to the fields. One more thing,Even if I could use the isset function efficiently, there are 5 fields and there are lots of combinations of filling those fields(ex:filling just one,filling the one at the top and the bottom,filling them all).It takes lots of time to write if checks and write the query again and again according to the if checks.Im asking this because I dont know how these kind of searches are coded. If anybody helps me how to run a query with only one button and make the database bring me the information,I would be grateful. SEARCH.PHP <body> <form name="send" method="post" action="search2.php"> <a style="size:auto ">Baslangi� tarihi : </a>   <input type="text" name="ilktarih" size="30" ><br><br> <a style="size:auto ">Bitis tarihi : </a>           <input type="text" name="sontarih" size="30" ><br><br> <a style="size:auto ">From : </a>                <input type="text" name="from" size="30" ><br><br> <a style="size:auto ">To : </a>                    <input type="text" name="to" size="30" ><br><br> <a style="size:auto ">From : </a>                <select name="spamlist"> <option value="UNSAFE">UNSAFE <option value="SAFE">SAFE <option value="BODY">BODY <option value="ATTACH">ATTACH <option value="VIRUS">VIRUS <option value="EMPTY">EMPTY <option value="ERROR">ERROR </select><br><br>                                         <input type="submit" value="SEARCH"> </form> SEARCH2.PHP <body> <? $ilk = @$_POST["ilktarih"]; $son = @$_POST["sontarih"]; $from = @$_POST["from"]; $to = @$_POST["to"]; $spam = @$_POST["spamlist"]; /$a=array($ilk,$son,$from,$to); for($i=0;$i<5;$i++) { if(isset($a[$i])){ $set[$i]=true; echo $set[$i]; } }/ $dbhost = '127.0.0.1'; $dbuser = 'root'; $dbpass = '05364304334'; $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql'); $dbname = 'kutay'; mysql_select_db($dbname); $query ="select * from t1"; if(empty($ilk) && empty($son) && empty($from) && empty($to)){ $query = $query . " where stats=' $spam'"; } $result=mysql_query($query,$conn) or die('Error: '.mysql_error().' -- Query: '.$query); echo "<table border=1>\n"; echo "<tr><td>Rowcount</td><td>Date</td><td>Time</td><td>Status</td><td>Queue</td><td>Recvfrom</td><td>From</td><td>To</td><td>Subject</td><td>Spam</td><td>Rule</td></tr>\n"; $count=1; while ($myrow = mysql_fetch_row($result)) { printf("<tr><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr>", $count, $myrow[1], $myrow[2], $myrow[3], $myrow[4], $myrow[5], $myrow[6], $myrow[7], $myrow[8], $myrow[9], $myrow[10]); $count++; } echo "</table>\n"; ?>

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Programming Forums > Web Development and Design > PHP

A complicated php,form,mysql