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

Hit counter updating once per IP - IP HIT COUNTER
I have a hit counter, for the amount of views on a tutorial.
It'll do the query and then do..

Require select-option functionality in Module Pool Programming
Hi Gurus,

I am doing a development by Module Pool on Warehouse Management. For that devel

Warning: mysql_num_rows() expects parameter 1
When i add quote at the end of this link
example:http://localhost/articlemania/category.php?cid=3

FILTER_CALLBACK -- Files?
Hi All,

I'm using the php filter functions to validate my form data. For custom filters, I'm

How to extract/download content from HTTPS page?
Hello to all the Members of this forum, Im Shoiab, A novice programmer in php.. for my first job I h

Auto install
Hi I have a directory lets say "apps" that I then have more folders ie "email",

How do i use vars in an array
Hiya peeps!

How do I use a var in an array. You will see $id but it isnt working.

Simple Question
I know this is a simple question, that if I knew what it was technically called i could probably loo

PHP hyperlinks generator - HELP plz
Hi

I need some help to get this done using php:


1 - I have few hyperlinks say 500

i have no idea why this isn't working
Code: <?php
session_start();
include("connect.php");

error_reporting(E