Hi all, I am working on a search script which searches article titles from the table. i have worked out the function, but have not been able to add an error message if the results are zero. my class file has this following function
public function search($table){
$search=$_GET['search'];
if ($this->databaseConnection()) {
$sql="SELECT * FROM $table WHERE title LIKE '%$search%'";
$q = $this->db_connection->query($sql) or die("failed!");
while($r = $q->fetch(PDO::FETCH_ASSOC)){
$data[]=$r;
}
return $data;
}
}
my results page has the following code
<?php
foreach($crud->search("articles") as $value){
extract($value);
echo <<<show
<p>" <a href="view.php?article_id=$article_id">$title</a> "</p>
<br>
show;
}
?>
would be highly obliged if anyone can help me out. apologies if this is a stupid question, but i am pretty much an amateur still.
regards,
Nayan