PHP search multiple input field box help

Posted on 16th Feb 2014 07:03 pm by admin

I am having a problem with my search script. At current it will simply search by a selected date which is a java based calendar that displays when using id='datedisplay' in the input form field below. What I want it to do is have an extra input text field box that can search for text/words within a table field. So my query would be something like Line number On/Off | Expand/ContractSELECT * FROM tbl_comments WHERE comments_date LIKE '%$search%' OR comments_content LIKE '%$textsearch%' ORDER BY comments_date DESC, comments_time DESC But now it gets tricky. I want it to work so if someone types something into the text input box, it will ignore the other input box that searches by date. And if the text input search box is empty, it will ignore the text input box and search only by the date input box.

I am assuming it's going to involve some if statements and posssible !empty and }else{ commands, I am just not 100% sure how to piece what I want together within my search code below.

Here is my form code:
Line number On/Off | Expand/Contract echo "<form method='post' action='handover_index.php'>"; echo "<input type='text' name='search' id='datedisplay' style='width: 60px;' maxlength='10'> "; echo "<input type='hidden' name='cmd' value='search' />"; echo " <input type='Submit' name='submit' value='Go!'>"; echo "</form>";

And here is my php code:
Line number On/Off | Expand/Contract // ##### Search DB ##### Start ->$str = str_replace("n", "<BR />", $str);if (strlen($_POST["search"]) > 1 or strlen($_GET["search"]) > 1){if(isset($_POST["search"])) $search=$_POST["search"];if(isset($_GET["search"])) $search=$_GET["search"]; $result = mysql_query("SELECT * FROM tbl_comments WHERE comments_date LIKE '%$search%' ORDER BY comments_date DESC, comments_time DESC"); echo "<table width='98%' cellspacing='0' cellpadding='3' border='0'>"; $i = 0;while($r=mysql_fetch_array($result)){ $comments_id=$r["comments_id"]; $comments_date=$r["comments_date"]; $comments_time=$r["comments_time"]; $comments_user=$r["comments_user"]; $comments_content=str_replace("rn","
",$r[comments_content]); $comments_updateuser=$r["comments_updateuser"]; $comments_updatedate=$r["comments_updatedate"]; $comments_updatetime=$r["comments_updatetime"]; list($thour, $tmin, $tsec) = explode(':', $comments_time); list($uthour, $utmin, $utsec) = explode(':', $comments_updatetime); if ($_GET[cmd]== "edit" and $_GET[comments_id] == $comments_id) { $comments_content=str_replace("
","rn",$r[comments_content]); echo "<tr>"; echo "<form action='handover_index.php' method='post'>"; echo "<td class='rowtxt' valign='top' width='375'><font class='rowadded'>Added</font> <font class='rowaddeddata'>$comments_date</font> <font class='rowadded'>at</font> <font class='rowaddeddata'>$comments_time</font> <font class='rowadded'>by</font> $comments_user</td>"; echo "<td class='rowtxt' valign='top' width='45'><div class='rowalign'><input type=submit name=submit value=Update><input type=hidden name=comments_id value=$comments_id></div></td>"; echo "<tr></tr>"; echo "<td class='rowtxt' valign='top' colspan='2' width='100%'><textarea name=comments_content cols='10' rows='5'>$comments_content</textarea>

</td>"; echo "</form>"; echo "</tr>"; }else{ if($i%2 == 0){ echo "<tr class='rowresult1'>"; echo "<td class='txt' valign='top' width='375'> <font class='rowadded'>Added</font> <font class='rowaddeddata'>$comments_date $thour:$tmin</font> - $comments_user"; if (!empty($comments_updateuser)) { echo "<font size='2' color='#000000'> / </font> <font class='rowadded'> Updated</font> <font class='rowaddeddata'>$comments_updatedate $uthour:$utmin</font> - " .$comments_updateuser. ""; } echo "</td>"; echo "<td class='rowtxt' valign='top' width='45'><div class='rowalign'><INPUT TYPE='button' name='edit' value='Edit' onClick=self.location='handover_index.php?cmd=edit&comments_id=$comments_id&search=$search'></div></td>"; echo "</tr><tr class='rowresult1'>"; echo "<td class='rowtxt' colspan='2' valign='top' width='100%'>$comments_content

"; echo "</td></tr>"; $i++; }else{ echo "<tr class='rowresult2'>"; echo "<td class='txt' valign='top' width='375'> <font class='rowadded'>Added</font> <font class='rowaddeddata'>$comments_date $thour:$tmin</font> - $comments_user"; if (!empty($comments_updateuser)) { echo "<font size='2' color='#000000'> / </font> <font class='rowadded'> Updated</font> <font class='rowaddeddata'>$comments_updatedate $uthour:$utmin</font> - " .$comments_updateuser. ""; } echo "</td>"; echo "<td class='rowtxt' valign='top' width='45'><div class='rowalign'><INPUT TYPE='button' name='edit' value='Edit' onClick=self.location='handover_index.php?cmd=edit&comments_id=$comments_id&search=$search'></div></td>"; echo "</tr><tr class='rowresult2'>"; echo "<td class='rowtxt' colspan='2' valign='top' width='100%'>$comments_content

"; echo "</td></tr>"; $i++; } } }echo "</table>";echo "
";}else{// ##### Search DB ##### End <-

Your Answer:

Login to answer

Other forums

Using cURL to PUT
Can somebody help with the correct php code to make a cURL PUT request. Here is a sample of code bel

help with insert
Hi there,

I am trying to insert some data into a database, but for some reason, it is not ins

Remove values in array2 from array1
I have two arrays.

Array 1 is where the array key holds various different numbers. For exampl

Inserting 100x and 100y coordinates in mysql table - easy
Is there a way to insert this data into a mysql table named 'map' with the fields: 'x int 3' , 'y in

InternetOpenUrl() Invalid cert
Hi all,

Does anyone know how to prevent calls to InternetOpenUrl() from failing with erro

Displaying image pathname instead of image
Hello

Im trying to upload and then display images from a mysql database - Its only basic and

Disabling SAP menu
How do I disable SAP menu for all the users and just restrict them to User Menu in SAP ECC 6.0?

puting for loop in 1 value
hi ,

how do i put this code in 1 value:
Code: <?php
for ($i=1; $i<=5; $i

array_diff weirdness
I'm using the following bit of code

$diff = array_diff($pids, $pidlist);
$diff = array_va

Backflush
I am looking for a report in SAP that would give me a list of all parts that are populated with a ba