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 Code: SELECT * 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:Code: 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:Code: // ##### 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 <-
Do not allow posting of whitespace
Currently the script below works if the user does not type a name/message, but if i create a whitespace with the spacebar, it will submit. How would I fix this?message page:<?php// Get the
Keep newlines from textarea?..
I'm creating a simple encoding program, and what I want it to do is retain the newlines, as echoing a textarea for example will strip them out (I think). How do I retain the \n's or whatnot and place
Varible in trigger - refering to correct schema
Hello
Developing Ajax-enabled ASP.Net applications for the iPhone
I would like to develop Ajax web applications using Visual Studio that are optimized for the iPhone. There are a few resources on the web showing how this can be done. However, these tend to be
DB2 for z/OS, LUW, iSeries
Hello,
default SAP userid
hi,, I just like to know if it is ok to use the default SAP user id (SAP*)?
Replacing a string on click of a button
Hi! Is there a way to replace a string on a click of a text link?This is what I've come up with. It doesn't work at all ^^;;Code: <head><?php $string = Red;function changeBlue()
Format timestamp from mysql
When I tried this:Code: date("m/d/Y H:i A", $row['timestamp'])I got 12/31/1969 18:33 PM, so I know the time section is working at least. How can I get the mm/dd/yyyy section to work
Extracting Long text from message class with parameters
Hi,
simple php table loop
Hi all,I've the following code <?php // Create category options $query = "SELECT * FROM categories ORDER BY category ASC"; $result = mysql_query
