Page 1 of 1

Search Function

Posted: Sun May 01, 2005 9:16 am
by Arsenal Rule
hey I having a problem wth search it is not allowing me to search what I want it is just coming up with errors

this the code I have done so far

search.php

Code: Select all

<? 

$conn = mysql_connect("localhost","root","") or die("Could Not Connect To The Database"); 
		mysql_select_db("aziz",$conn) or die("Could Not Select The Database"); 

if ($_POST['submitForm']) {
$sql = "INSERT INTO search (text) VALUES '".$_POST['text']."'";
mysql_query($sql) or die("Couldn't update information.");
}

if ($title == "") 
{$title = 'Nothing!';} 

if ($text == "") 
{$text = 'nothing';} 

$result = mysql_query ("SELECT * FROM azizpassword WHERE text LIKE '%$text%'"); 

if ($row = mysql_fetch_array($result)) { 

  PRINT "<font face=tahoma size=2>Your search for <b>$text</b> returned the following results:<br><br>"; 

do { 
  $record_text = $row[3]; 
  $text_limit = substr($record_text, 0, 300); 
  PRINT "<font face=tahoma size=2><b>"; 
  print "<a href=\"solution.php?id=$row[id]\">$row[title]</a>"; 
  print ("</b> "); 
  print ("<br>"); 
  print $text_limit; 
  print ("...<p>"); 
} while($row = mysql_fetch_array($result)); 
} else { 

PRINT "<font face=tahoma size=2>Your search for <b>$text</b> returned 0 results:<br><br>"; 
} 

?> 
search: 
<input type=password name=pass>
<br>
<br>
<input type=submit value=Search></form></body></html>
basically, its not functioning properly. What i want it to do, is return a view of what i search. This is a table that i already have working:

tableview.php

Code: Select all

<?php 
        $conn = mysql_connect("localhost","root","") or die("Could Not Connect To The Database"); 
        mysql_select_db("aziz",$conn) or die("Could Not Select The Database"); 
          
if(isset($_GET['action'])) { 
if($action == "delete") { 
$user_id = $_GET['user_id']; 
$delete = mysql_query("delete from azizpassword where user_id = '$user_id'") or die(mysql_error()); 
# you can then put a header("Location: ..."); to go somewhere else 
    } 
} 
    $result=mysql_query("SELECT user_id,az_firstname,az_surname,username FROM azizpassword ORDER BY user_id;"); 
      
    $i=0; 
    while( $row=mysql_fetch_array($result) ) 
    { 
        if($i>0) 
        { 
            echo "<tr valign=top>"; 
            echo "<td bgcolor=#93B0B4 colspan=4><img src=img/blank.gif wuser_idth=1 height=1></td>"; 
            echo "</tr>"; 
        } 
        echo "<tr valign=center>"; 
        echo "<td width=100 class=table><b>".$row['user_id']."</b></td>"; 
        echo "<td width=100 class=table><a href=\"edituser.php?id=".$row['user_id']."\">".$row['az_surname']."</a></td>"; 
        echo "<td width=100 class=table>".$row['az_firstname']." </td>"; 
        echo "<td width=100 class=table><i>".$row['username']."</i> </td>"; 
        //echo "<td width=100 class=table><i><a href=\"?action=delete&user_id=".$row['user_id']."\"> delete: ".$row['username']."</a></i> </td>"; 
        echo "<td width=100 class=table><i><a href=\"?action=delete&user_id=".$row['user_id']."\" onclick=\"if(confirm('Are you sure you want to delete the entry?')) return true; else alert('Delete canceled.');return false;\"> delete: ".$row['username']."</a></i> </td>"; 


		echo "<td class=table></td>"; 
        echo "</tr>"; 
        $i++; 

    } 

    echo "<tr valign=bottom>"; 
        echo "<td bgcolor=#93B0B4 colspan=6 height=8></td>"; 
        echo "</tr>"; 
echo"<h4>To Edit a User please click on the users Surname.</h4>";
      
?>


any suggestions as to why my search isn't working properly???? is there a way to include the search in the tableview.php i posted using code from the search.php file? linking the two with an if-else statement?? that would be a better option

Inevitably i would like the results to come out the same way as they do in the tableview.php file i pasted above.

If someone can help me out with this i'd be very greatful, thanks a lot in advance.

Posted: Sun May 01, 2005 3:02 pm
by ol4pr0
Haven't tested it..

Code: Select all

<?
$result = mysql_query ("SELECT * FROM azizpassword WHERE text LIKE '%".$text."%'") or die (mysql_error()); 
?>
<font face=tahoma size=2>Your search for <b>$text</b> returned the following results:<br /><br /> 
<?
while ($row = mysql_fetch_array($result)) { 
if ($row > 1) {
  $record_text = $row[3]; 
  $text_limit = substr($record_text, 0, 300); ?>
  <font face=tahoma size=2><b>
  <a href="solution.php?id=<?php echo $row['id'];?>"><?php echo $row['title'];?></a>
  </b>
  <br>
  <?php echo $text_limit;?>
  <p>
<?} 
} else { ?>
<font face=tahoma size=2>Your search for <b>$text</b> returned <?php echo count($result);?> results:<br><br> 
<?} 
?>