loops - php pagination and search -


i have while loop pagination have idea how make search don't know how insert here's code pagination , output commands working don't know how put code search , it's messing head.

//count total number of row in table*/ $count_query   = mysql_query("select count(personid) numrows persons"); $row     = mysql_fetch_array($count_query); $numrows = $row['numrows']; $total_pages = ceil($numrows/$per_page); $reload = 'index.php'; //main query fetch data  $query = mysql_query("select * persons order rand() limit $offset,$per_page"); //loop through fetched data while($result = mysql_fetch_array($query)){ $id = $result['personid']; echo "<div class= content > "; echo"<img height=100 width=100 src='upload/". $result['image'] ."'/>"; echo "<font color='black'>". $result['firstname']. "</font></br>"; echo "</div>";

so trial , error think part got error row here's whole code

> <?php include_once('includes/dbconnect.php'); >  >  > ?> >  > <?php >  > // can display results returned. first display > search form on top of page >  > $searchtext = $_post["q"]; >  >  >  >  >  > $action = (isset($_request['action'])&& $_request['action'] > !=null)?$_request['action']:''; >  > if($action == 'ajax'){ >  >   include 'pagination.php'; //include pagination file >  >  >   //pagination variables  $page = (isset($_request['page']) && > !empty($_request['page']))?$_request['page']:1;   $per_page = 5; //how > records want show     $adjacents  = 5; //gap between pages > after number of adjacents     $offset = ($page - 1) * $per_page; >  >   //count total number of row in table*/     $count_query   = > mysql_query("select count(personid) numrows persons");    $row   > = mysql_fetch_array($count_query);    $numrows = $row['numrows'];     $total_pages = ceil($numrows/$per_page);    $reload = 'index.php'; >  >                   //search >         // basic sql-injection protection >  >         $searchtext = $_request["q"];     //main query fetch data >         // query simple search criteria $query = mysql_query("select * persons firstname '%" >            . $searchtext . "%' order rand() limit $offset,$per_page"); >  >   //loop through fetched data >  >  >         while($result = mysql_fetch_array($query)){ >         $id = $result['personid']; >  >  >                                       echo "<div class= content > "; >  >                                       echo"<img height=100 width=100 src='upload/". $result['image'] ."'/>"; >                                       echo "<font color='black'>". $result['firstname']. "</font></br>"; >  >  >  >                                       echo "</div>"; >  >  > } echo paginate($reload, $page, $total_pages, $adjacents); } else{ ?> >  >  > <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>simple ajax > pagination php , mysql</title> <script type="text/javascript" > src="jquery-1.5.2.min.js"></script> <link media="screen" > href="style.css" type="text/css" rel="stylesheet"> <script > type="text/javascript">   $(document).ready(function(){       load(1);    }); >  >   function load(page){        $("#loader").fadein('slow');        $.ajax({ >           url:'index.php?action=ajax&page='+page,             success:function(data){ >               $(".outer_div").html(data).fadein('slow'); >               $("#loader").fadeout('slow');           }       }) >  >         } >  > </script> >  > </head> <body> >   >  >  > <div id="loader"><img src="loader.gif"></div> >  >  >  > <div class="outer_div"></div> >  >     <div class="content"><form action='' method='post'> <input type='text' name='q' /> <input type="button" onclick="history.go(0)" > value="refresh"/> </p> </form></div> </body> </html> <?php >  > }?>

this output want
1: http://i.stack.imgur.com/l8mma.png
2: http://i.stack.imgur.com/p47ui.png

in case can add where clause pattern condition , receive desired effect quickly.

// basic sql-injection protection $searchtext = htmlspecialchars ($_post['searchtext']);  // query simple search criteria $query = mysql_query("select * persons firstname '%"             . $searchtext . "%' order rand() limit $offset,$per_page");

but approache have several disadvatages:

  1. your request slow (you see more data in db) because use order rand() construction sorts randomly all entries in db table , returns small amount specified in limit clause;
  2. it neseccary reload page every time want search something. if want implement dynamic update of search results list should use ajax queries javascript.

p.s.: try not use deprecated mysql_ functions, use pdo or mysqli indstead (they provide built-in sql-injection protection trough prepared statments).

update:

ok, using ajax.

so don't need form @ all. use 2 elements: text input , button.

html:

<input id="q" type='text' name='q' /> <input type="button" onclick="load(1)" value="refresh"/>

javascript:

function load(page){     $("#loader").fadein('slow');     var searchtext = $('#q').val();     $.ajax({            url:     'index.php?action=ajax&page='+page+'&q='+searchtext,             success:  function(data){                $(".outer_div").html(data).fadein('slow');                $("#loader").fadeout('slow');                       }     }); }

Comments

Post a Comment

Popular posts from this blog

curl - PHP fsockopen help required -

i trying work on cloudflare api , have found in documentation. unfortunately have no idea how can use in fsockopen or through curl. here example of post request. need know how can make request below data post using curl or fsockopen curl https://www.cloudflare.com/api_json.html -d 'a=cache_lvl' \ -d 'tkn=8afbe6dea02407989af4dd4c97bb6e25' \ -d 'email=sample@example.com' \ -d 'z=example.com' \ -d 'v=agg' here link cloudflare https://www.cloudflare.com/docs/client-api.html#s4.2 try one: $ch = curl_init("https://www.cloudflare.com/api_json.html"); curl_setopt($ch, curlopt_returntransfer,1); curl_setopt($ch, curlopt_followlocation, 1); curl_setopt($ch, curlopt_ssl_verifypeer,false); // handling of -d curl parameter here. $param = array( 'a' => 'cache_lvl', 'tkn' => '8afbe6dea02407989af4dd4c97bb6e25', 'email' => 'sample@example.com', 'z' =...
Read more

HTTP/1.0 407 Proxy Authentication Required PHP -

i working in restricted network/limited access internet. since have use proxy make web service call. here php code calling web service , response . $client = new soapclient("http: //www.xyz.com/abc/wsdls/login.wsdl", array("trace" => 1, "exceptions" => 1, 'proxy_host' => $proxy_host, 'proxy_port' => $proxy_port, 'proxy_login' => $proxy_login, 'proxy_password' => $proxy_password)); response is fatal error: uncaught soapfault exception: [wsdl] soap-error: parsing wsdl: couldn't load ' http://www.xyz.com/abc/wsdls/login.wsdl ' : failed load external entity if copy url error message , paste in browser(with same proxy settings) works. 2nd scenario is, if pass values instead of variables giving me diffarant response $client = new soapclient("http: //www.xyz.com/abc/wsdls/login.wsdl", array("trace" => 1, "exceptions" => 1, 'proxy_host' ...
Read more

c# - Resource not found error -

i have problem accessing method on homecontroller. show code of method : [httpget] public actionresult decriptidentifiantetredirige(string login_crypter, string mdp_crypter) { string loginacrypter = _globalmanager.protegemotdepasse(login_crypter); string mdpacrypter = _globalmanager.protegemotdepasse(mdp_crypter); user userapp = new models.user(login_crypter, mdp_crypter); if (userapp.authentificationvalidee(userapp.userlogin, userapp.password)) { session["name"] = userapp.userlogin; return redirecttoaction("accueil", "home"); } else { return redirecttoaction("validerauthentification", "home"); } } then in routeconfig.cs wrote route : routes.maproute( name: "authentificationapresdecryptage", url: "{controller}/{action}/{login_crypter}/{mdp_crypter}", defaults: new...
Read more