Multiple paged search results…

@ShrineDesignsMay 24.2004 — #here is a simple example:

&lt;?php
 function pg()
 {
 return (isset($_GET['pg']) &amp;&amp; !empty($_GET['pg'])) ? $_GET['pg'] : 1;
 }
 function ppg()
 {
 return (isset($_GET['ppg']) &amp;&amp; !empty($_GET['ppg'])) ? $_GET['ppg'] : 10;
 }
 
 if($_GET['search'])
 {
 $keywords = explode(' ', $_GET['search']);
 $where = "";
 
 <i>	</i>foreach($keywords as $key)
 <i>	</i>{
 <i>	</i>	$where .= "<span><code>field_name</code></span> LIKE '%{$key}%'";
 <i>	</i>	$where .= ($key != end($keywords)) ? " OR " : '';
 <i>	</i>}
 <i>	</i>$link_id = mysql_pconnect('localhost', $username, $password);
 <i>	</i>mysql_select_db($database, $link_id);
 <i>	</i>$result = mysql_query("SELECT * FROM <span><code>table_name</code></span> WHERE $where LIMIT ".(pg() - 1) * ppg().",".ppg(), $link_id);
 
 <i>	</i>while($row = mysql_fetch_array($result, MYSQL_NUM))
 <i>	</i>{
 <i>	</i>	// output results
 <i>	</i>}
 <i>	</i>mysql_free_result($result);
 <i>	</i>$count = mysql_query("SELECT COUNT(*) FROM <span><code>table_name</code></span> WHERE $where", $link_id);
 <i>	</i>$rows = mysql_result($count, 0, 0);
 <i>	</i>$term = str_replace(' ', '+', $_GET['search']);
 
 <i>	</i>if($rows &gt; ppg())
 <i>	</i>{
 <i>	</i>	echo "[";
 
 <i>	</i>	for($i = 1; $i &lt;= ceil($rows / ppg()); $i++)
 <i>	</i>	{
 <i>	</i>		echo ($i == pg()) ? " $i " : " &lt;a href="{$_SERVER['PHP_SELF']}?search={$search}&amp;amp;pg=".pg()."&amp;amp;ppg=".ppg().""&gt;$i&lt;/a&gt; ";
 <i>	</i>		echo ($i &lt; ceil($rows / ppg())) ? "|" : "]";
 <i>	</i>	}
 <i>	</i>}
 }
 ?&gt;

Multiple paged search results…

1 Comments(s) _↴

Also in #PHP _↴

Success!

Social

Version

Multiple paged search results…

1 Comments(s) ↴

Also in #PHP ↴

Success!

The web is an endless sea of information. Don't miss the boat... Subscribe!

Social

Version

1 Comments(s) _↴

Also in #PHP _↴