public function getList($id = "", $pg) { $purl = array(); if (isset($_GET['url'])) { $purl = $_GET['url']; $purl = rtrim($purl); $purl = explode('/', $_GET['url']); } else { $purl = null; } if (!isset($purl['2'])) { $pn = 1; } else { $pn = $purl['2']; } global $database; $resultUser = $database->db_query("SELECT * FROM client_product WHERE client_id='" . $_SESSION['client_ident'] . "'"); /*$pagin = new Pagination(); $pagin->nr = $database->dbNumRows($resultUser); $pagin->itemsPerPage = 20;*/ $myservices = Cproduct::find_by_sql("SELECT * FROM client_product WHERE client_id='" . $_SESSION['client_ident'] . "'"); $index_array = array("myservices" => $myservices, "mypagin" => ""); return $index_array; }
public function cProdID_AutoComplete($id = "") { return Cproduct::find_by_sql("SELECT * FROM client_product WHERE prod_name LIKE '%" . $_POST['input'] . "%'"); }
public function cprodID_AutoComplete($id = "") { return Cproduct::find_by_sql("SELECT * FROM client_product WHERE client_id='" . $_POST['clientid'] . "' AND ( prod_name LIKE '%" . $_POST['input'] . "%' OR install_city LIKE '%" . $_POST['input'] . "%' OR install_address LIKE '%" . $_POST['input'] . "%' )"); }