note 118003 added to reserved.variables.get
| From: | Tolulope | Date: | Thu, 17 Sep 2015 14:53:06 +0000 |
| Subject: | note 118003 added to reserved.variables.get | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-203798@lists.php.net to get a copy of this message | ||
pls i need help on how to make my code work for search engine.
<?php
//connect server and database here
//then below is the set command and query
if(isset($_GET['search'])) {
$search_value= $_GET['value'];
$query = "select * from sites where keywords like '%search_value'";
$my_run = mysql_query($query);
while ($row = mysql_fetch_array($my_run)) {
$title =$row['title'];
$link =$row['link'];
$desc =$row['description'];
echo "<h1>$title</h1><a href=
'$link'>$link</a><p>$desc</p>";
}
}
?>
Error : but it keeps telling me that i can make use of global array $_GET , that i should instead
use filter_input.
Now i set up my filter_input code like this but still did not search my database to return result .
but it gave no error. please i need help.
if(!empty(INPUT_GET ('search'))){
$search_value = filter_input(INPUT_GET, 'value');
$query = "select * from sites where keywords like '%search_value'";
$my_run = mysql_query($query);
while ($row = mysql_fetch_array($my_run)) {
$title =$row['title'];
$link =$row['link'];
$desc =$row['description'];
echo "<h1>$title</h1><a href=
'$link'>$link</a><p>$desc</p>";
}
}
?>
----
Server IP: 72.52.91.14
Probable Submitter: 212.119.150.32
----
Manual Page -- http://php.net/manual/en/reserved.variables.get.php
Edit -- https://master.php.net/note/edit/118003
Del: integrated -- https://master.php.net/note/delete/118003/integrated
Del: useless -- https://master.php.net/note/delete/118003/useless
Del: bad code -- https://master.php.net/note/delete/118003/bad+code
Del: spam -- https://master.php.net/note/delete/118003/spam
Del: non-english -- https://master.php.net/note/delete/118003/non-english
Del: in docs -- https://master.php.net/note/delete/118003/in+docs
Del: other reasons-- https://master.php.net/note/delete/118003
Reject -- https://master.php.net/note/reject/118003
Search -- https://master.php.net/manage/user-notes.php