mysql - Issue with PHP select/search -


so i'm building search site there php/ mysql search , javascript "show number of results per page" html select submitted number per page user desires , refreshes search page. unfortunately, when loaded page got 3 errors. if (isset($_post['select'])){ $total_pages == $_post['select'];} set $total_pages = 12 works fine?

  • notice: have error in sql syntax; check manual corresponds mysql server version right syntax use near '' @ line 1 in /users/me/sites/mysite/search.php on line 36
  • warning: mysql_num_rows() expects parameter 1 resource, boolean given in /users/me/sites/mysite/search.php on line 37
  • warning: division 0 in /users/me/sites/mysite/search.php on line 104

here code:

<?php      $q = mysql_real_escape_string(ucfirst(trim($_request['searchquery'])));          if (isset($q)){         if (isset($_get['page'])) $page = $_get['page']; else $page = 1;         if (isset($_post['select'])){ $total_pages == $_post['select'];} //here edit amount per page          $record_start = ($page * $total_pages) - $total_pages;             require('config.php');              $result = mysql_query("select * companies company_name '%$q%' or company_description '%$q%' or cat1 '%$q' or cat2 '%$q' or cat3 '%$q' or company_phone '%$q' order company_name limit $record_start,$total_pages") or trigger_error(mysql_error());             $rows = mysql_num_rows($result);              $total_results = mysql_result(mysql_query("select count(*) num companies"),0);              echo "             <h4>search &quot;$q&quot;</h4>              <div class='right'>                 <div class='textad1'>                     <center>                          <form name='form1' method='post'>                             results per page:                             <select name='select' onchange='document.form1.submit()'>                                 <option value='10'";if($_request['select'] == 12) {echo "selected='selected'";} echo">12</option>                                 <option value='15'";if($_request['select'] == 18) {echo "selected='selected'";} echo">18</option>                                 <option value='25'";if($_request['select'] == 32) {echo "selected='selected'";} echo">32</option>                             </select>                         </form>                     </center>                 </div>                 <div class='divider'></div>             </div>             <div class='left'>              <ul>";         while($row = mysql_fetch_array($result))

if need more code, that. appreciated!

i think code should this,

require('config.php'); $q = mysql_real_escape_string(ucfirst(trim($_request['searchquery'])));      if (isset($q)){     if (isset($_get['page'])) $page = $_get['page']; else $page = 1;     if (isset($_post['select'])){ $total_pages = $_post['select'];} //here edit amount per page      $record_start = ($page * $total_pages) - $total_pages;          $result = mysql_query("select * companies company_name '%$q%' or company_description '%$q%' or cat1 '%$q' or cat2 '%$q' or cat3 '%$q' or company_phone '%$q' order company_name limit $record_start,$total_pages") or trigger_error(mysql_error());         $rows = mysql_num_rows($result);          $total_results = mysql_result(mysql_query("select count(*) num companies"),0);   //code continuation

Comments

Post a Comment

Popular posts from this blog

java - Play! framework 2.0: How to display multiple image? -

i need display gallery of photos. here template: @(photos: list[photo]) @title = { <bold>gallery</bold> } @main(title,"photo"){ <ul class="thumbnails"> @for(photo <- photos) { <li class="span3"> <a href="#" class="thumbnail"> <img src="@photo.path" alt=""> </a> </li> } </ul> } and here controller method: public static result getphotos() { return ok(views.html.photo.gallery.render(photo.get())); } and here photo bean : @entity public class photo extends model { @id public long id; @required public string label; public string path; public photo(string path, string label) { this.path = path; this.label = label; } private static finder<long, photo> find = new finder<long, photo>( long.class, photo.class); public static list<phot...
Read more

gmail - Is there any documentation for read-only access to the Google Contacts API? -

i want read-only access user's google contacts. there stackoverflow member wanted this, , received following answer : yes, there is, use https://www.googleapis.com/auth/contacts.readonly scope , "view contacts". this exchange reference read-only access google contacts can find using google. simply using access token obtained attempt read usual google contacts api (i.e. https://www.google.com/m8/feeds ) fails insufficient permissions. similarly, using google contacts api on new target fails 404 errors (for example https://www.googleapis.com/auth/contacts.readonly/default/full ). is there documentation anywhere on how use api, or permissible way access google contacts api full read-write access?
Read more

php - Controller/JToolBar not working in Joomla 2.5 -

relevant code: jtoolbarhelper::custom('savecategories', 'save', '', 'save', false, false); ... <input type="hidden" name="controller" value="easyblogcontroller"> according can dig docs , own previous questions, should call savecategories() function in easyblogcontroller . i've tried setting value easyblog , easyblog.php (file name) current easyblogcontroller (class name). clicking on save button refreshes page. not redirect, echo or var_dump test code put in savecategories() function. var_dump ing jrequest::getvar('controller') , 'task' return correct values. creating controller object , using $controller->execute('task'); works. the values going depend on location of controller trying call, , have couple options here. typically there controller in base folder of component (likely components/com_easyblog) in file called controller.php , class name inside ...
Read more