Help for this page

Select Code to Download


  1. or download this
    $sql_stmnt = "SELECT emp_id, CONCAT(emp_first, ' ', emp_last)
                     FROM sys_main.humans
                     WHERE emp_first LIKE '%$search_text%'
                     OR emp_last LIKE '%$search_text%'";
    $sth = $dbh->prepare($sql_stmnt);
    $sth->execute();
    
  2. or download this
    $sql_stmnt = "SELECT emp_id, CONCAT(emp_first, ' ', emp_last)
                     FROM sys_main.humans
                     WHERE emp_first LIKE ?
                     OR emp_last LIKE ?";
    $sth = $dbh->prepare($sql_stmnt);
    $sth->execute("%$search_text%", "%$search_text%");