PHP + Mysql Search

DigitalExpl0it

Im trying to make a mysql search with php. I get to search the database then display the text.

The only thing is, if it finds somthing it will just place everything from the database out on the page, if it doesnt find anything, nothing shows (which is what is supposed to do)

heres my code... kinda long:

<?
include('header.php');
include('cfg.php');

$query2 = explode(" ",searchtxt);
  for($i=0;$i<count($searchtxt);$i++){
    if (strstr($str,$searchtxt[$i]) && $searchtxt[$i]!="")
       print $query2[$i]." is into the string!";

$limit=20; // rows to return

// next determine if offset has been passed to script, if not use 0
if (empty($offset)) {
    $offset=1;
}

$goconnect5 = mysql_connect($db_connetion, $db_username, $db_password) or die ("<span class='titel'>Couldnt connect</span>");
$godb5 = mysql_select_db($db_databse, $goconnect5) or die ("<span class='titel'>Couldnt open Database</span>");

$gosql5 = "SELECT * from code WHERE Cpname LIKE '%$query2[i]%' and Cpdec LIKE '%$query2[i]%' order by Cid";
$gosql_result5 = mysql_query($gosql5, $goconnect5) or die ("<span class='titel'>Couldnt connect!</span>");
$result = mysql_query($gosql5, $goconnect5) or die("Could not execute query."); 

}

##################################
## Array from database
##################################
while ($row2 = mysql_fetch_array($result)){
$title = $row2["Cpname"];
$doc = $row2["Cpdec"];
$id = $row2["Cid"];
$user_name = $row2["Cuser_name"];
$date = $row2["Cdate"];
$selected = $row2["Cselect2"];
$text = wordwrap( $doc, 20 );
$rest = substr($text, 0, 500); 
$rest2 = "$rest..."; 
?> <br> 
<table width="640" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr> 
    <td width="84%"> 
      <table width="100%" border="0" align="center" cellpadding="0" cellspacing="3">
        <tr> 
          <td> 
            <table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr> 
                <td bgcolor="#000000"> 
                  <table width="100%" border="0" cellspacing="1" cellpadding="0">
                    <tr> 
                      <td bgcolor="#FFFFFF"> 
                        <table width="100%" border="0" cellspacing="3" cellpadding="0">
                          <tr> 
                            <td width="58%" align="left" valign="top" class="news"> 
                              <table width="100%" border="0" cellspacing="3" cellpadding="0">
                                <tr> 
                                  <td class="news"> 
                                    <table width="100%" border="0" cellspacing="3" cellpadding="0">
                                      <tr> 
                                        <td align="left" valign="middle"><img src="small.gif" width="26" height="27"><a href="read.php?id=<? echo "$id"; ?>" class="newsheader2"> 
                                          <? echo "$title"; ?>
                                          </a></td>
                                      </tr>
                                      <tr> 
                                        <td bgcolor="<? echo "$row_color"; ?>" class="signup"><span class="newsheader">&nbsp;By:</span> 
                                          <a href="profile.php?name=<? echo "$user_name"; ?>"> 
                                          <? echo "$user_name"; ?>
                                          </a><span class="newsheader">&nbsp;&nbsp;Date:</span> 
                                          <font color="red"> 
                                          <? echo "$date"; ?>
                                          </font> <br>
                                          <span class="newsheader"> </span><br>
                                          &nbsp; 
                                          <? echo "$rest2"; ?>
                                        </td>
                                      </tr>
                                      <tr> 
                                        <td bgcolor="#000000" class="signup"> 
                                          <table width="100%" border="0" cellspacing="1" cellpadding="0">
                                            <tr> 
                                              <td width="80%" bgcolor="#CCCCCC" class="signup"><span class="newsheader">&nbsp;Category:</span> 
                                                <a href="cat.php?cat=<? echo "$selected"; ?>"> 
                                                <? echo "$selected"; ?>
                                                </a></td>
                                              <td width="20%" align="left" valign="middle" bgcolor="#CCCCCC"> 
                                                <div align="center">&nbsp;&nbsp;<span class="newsheader">[Read 
                                                  More] </span></div>
                                              </td>
                                            </tr>
                                          </table>
                                        </td>
                                      </tr>
                                    </table>
                                  </td>
                                </tr>
                              </table>
                            </td>
                          </tr>
                        </table>
                      </td>
                    </tr>
                  </table>
                </td>
              </tr>
            </table>
          </td>
        </tr>
      </table>
    </td>
  </tr>
</table>
<br>
<?
}
?>

to see it in action go here
http://rbcode.com/category.php?d=1

Mega

why on earth would you ever need that many tables?!?!?!

megamanXplosion

lol good question. I think that you're just making this more complicated that it has to be.

DigitalExpl0it

Originally posted by Mega
why on earth would you ever need that many tables?!?!?!

did it for a good looking table.. anywho its not the point.

I have one table with bgcolor = black, then another inside of it bgcolor = white with cellspacing="1", this will get that thin line, then I have other tables in there to do the samthing inside of those two tables plus.... go here and you will see them

www.rbcode.com

little_tris

Hum

Is a bit of long code....

If it is outputting EVERY thing in the table then it sounds like a problem with your SQL command although it does look fine.

First try running the SQL command without all the bells (fancy tables etc) to see what the command actually outputs. (if you have phpmyadmin use that).

Try printing the SQL command to the screen to see if what you are trying to get is actually what you are getting.

Try adding the mysql_error() command to you error messages. This adds a line of text that in an error might help you to track down what is going on.

Also (I did not look) see if you are not getting the results from some earlier search and outputting them by accident.

Might be one, non or all of the above. Might be worth starting with these though.

DigitalExpl0it

I think I found a fix... I redid the array


$split_search = explode(" ",$searchtxt);

for($i = 0; $i < count($split_search); $i++)
{
$match_word = str_replace('*', '%', $split_search[$i]);
$goconnect5 = mysql_connect($db_connetion, $db_username, $db_password) or die ("<span class='titel'>Couldnt connect</span>");
$godb5 = mysql_select_db($db_databse, $goconnect5) or die ("<span class='titel'>Couldnt open Database</span>");
$gosql5 = "SELECT * FROM code WHERE Cpname LIKE '%$split_search[$i]%' ORDER BY Cid";
$gosql_result5 = mysql_query($gosql5, $goconnect5) or die ("<span class='titel'>Couldnt connect!</span>");
$result = mysql_query($gosql5, $goconnect5) or die("Could not execute query.<br>"); 

}