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 <-
Select Rows as Columns..
is there a way to select COLUMN_NAME from user_tab_columns where table_name='TABLENAME';
=> and <=
So I was digging through some code when I came across the <= operator. This is the first time I've ever seen it. I felt the same way I did when I first saw a ternary statement. What is
Am I setting up my sites oldschool?
Ok,When I create a site I open a basic template that I have created that consists of a css file an index page and a few php inserts for the header, nav and footer.It works fine and I am happy with it
reading partial code from external site
Hi,I am trying to write a script for my website to get an article from an external website. The external website has the article in a set of tags <roottag> &
Multiple Do / While Statements?
I'm still very new to PHP, and running in to a problem when trying to execute a do/while loop inside another one.What I'm trying to achieve is that I want to display all of the records in one table
why aint this working?
i have this code:Code: $num = 250; $count = ($num - $rcount); echo $rcount; echo ""; echo $count;when i echo $rcount it gives me 153...so my calculations is 250-153 = 97.but
Best way to cross matching large datasets
Hi,Im running a script where am I cross matching about 200 000 data sets with each other. Each data set consists of 8 parameters and I want to count all datasets which have similar or the same
problem with array - multilingual page
this is my test page :Code: <?php if(isset($_GET['lang'])) { if($_GET['lang'] == "en") { require_once("languages/lang-en.php"); }
mysql timestamp manipulation
How could I use a timestamp (e.g 2009-10-30 13:20:35 ), and with php find out if it is:from todayfrom this weekfrom this monthfrom the last 3 monthsfrom the last 6 monthsfrom this yearfrom 1 year
Not sure why this script is not working?
Hi I am new to php programing and I was trying to make up a simple script like a captcha but I cannot get the validation part of it working. I think it should work but it is not. Anyone know what is
