Code Help.. If txt input box empty search X instead..

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 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 <-

Your Answer:

Login to answer

Other forums

Help with echo()
I'm having some problems with this code:

Code: echo '
<A HREF="jav

show the direct link into href
I want to display link on the page. i am fetching the data(URL) from database,actually before that i

Query failed issue with php script but works fine in mssql manager!
hi i have the script below which copies data from one table to another but will only insert new data

MySQL Does not UPDATE- SQLString Problem
vb Syntax (Toggle Plain Text) 1. SQL = "UPDATE sampletable SET column1 = 'C1sample1'"

INSERT for date range
Hi all

I have the following table

Code: [Select] `date` date
`day` int(2)
`

PHP using IF to display error
i have a MySQL query and i want to display 1 thing only if the number of affected rows is >=1

DBCA Templates
Hi all,

I'm working on creating a template for DBCA, but can't find any documentation on the

Random Number Generation And Probability
Hello, I am working on a function which has to insert data into a SQL table.

we have to suppl

Quick Question about echo value
Hey guys, I'm trying to get something to show differently in one of my scripts. I'm trying to make

Gantt Chart Tool
Does anyone know of a good free gantt chart creator tool

Thanks