Search Result
} } ?>
require_once 'Mobile_Detect.php'; $pgl = preg_replace( "/[^a-zA-Z0-9_]/", "",$_REQUEST['pgl']); $pagenumber = preg_replace( "/[^a-zA-Z0-9_]/", "",$_REQUEST['pagenumber']); $surname = preg_replace( "/[^a-zA-Z0-9_ ().]/", "",$_REQUEST['surname']); $ship = preg_replace( "/[^a-zA-Z0-9_ ().]/", "",$_REQUEST['ship']); $firstname = preg_replace( "/[^a-zA-Z0-9_ ().]/", "",$_REQUEST['firstname']); $max_results = 20; $nextpage = 0; if ($surname || $ship || $firstname){ if(!isset($_GET['page'])){ $page = 1; } else { $page = urlencode(preg_replace( "/[^a-zA-Z0-9_]/", "",$_GET['page'])); } $from = (($page * $max_results) - $max_results); $SQL = "Select * from shipping where "; if ( $surname){ $SQL.= " Surname LIKE '%$surname%'"; if ($ship){ $SQL.= " and Ship LIKE '%$ship%'"; } if ($firstname){ $SQL.= " and Firstname LIKE '%$firstname%'"; } }else if ($ship){ $SQL.=" Ship LIKE '%$ship%'"; if ($firstname){ $SQL.= " and Firstname LIKE '%$firstname%'"; } if ( $surname){ $SQL.= " and Surname LIKE '%$surname%'"; } } else if ($firstname){ $SQL.=" Firstname LIKE '%$firstname%'"; if ( $surname){ $SQL.= " and Surname LIKE '%$surname%'"; } if ($ship){ $SQL.= " and Ship LIKE '%$ship%'"; } }//else{ //$SQL.=""; // } $SQL.=" order by surname, firstname, ship, id"; $SQL2 = $SQL." LIMIT ".$from." , 20"; //echo $SQL; //$db = mysqli_connect("localhost", "jenwille_jen", "rXCqEl9eEKcw", "jenwille_default"); $db = mysql_connect("localhost", "jenwille_jen", "rXCqEl9eEKcw"); mysql_select_db("jenwille_default",$db); $results = mysql_query($SQL); $numberrec = mysql_num_rows($results); $total_pages = ceil($numberrec / $max_results); $results2 = mysql_query($SQL2) ; $num = 0; $detect = new Mobile_Detect; $device_type = ($detect->isMobile() ? ($detect->isTablet() ? 'tablet' : 'phone') : 'computer'); $script_version = $detect->getScriptVersion(); ?>