ÿØÿà JFIF ÿÛ „ ( %"1"%)+...383,7(-.-
![]() Server : Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.4.20 System : Linux st2.domain.com 3.10.0-1127.10.1.el7.x86_64 #1 SMP Wed Jun 3 14:28:03 UTC 2020 x86_64 User : apache ( 48) PHP Version : 7.4.20 Disable Function : NONE Directory : /var/www/html/thietkewebvumi.com/lib/searchSQL/ |
<?php require_once 'class.search.php'; $config = array('localhost','root','gunblade','database_testsearch'); $table = 'bizmain'; $key = 'biz_id'; $fields = array('biz_name','biz_address','biz_cat'); $keyword = $_POST['keyword'].' '.$_POST['location']; $found = new search_engine($config); $found->set_table($table); $found->set_primarykey($key); $found->set_keyword($keyword); $found->set_fields($fields); $result = $found->set_result(); print_r($result); // Display the results $data = join( ",", $result); $sql = "SELECT * FROM bizmain WHERE biz_id IN ($data) "; $process = @mysql_query($sql); echo "<br><pre><table border=1>"; while ($row = mysql_fetch_object($process)) { echo "<tr>"; echo "<td>".$row->biz_id."</td>"; echo "<td>".$row->biz_name."</td>"; echo "</tr>"; } echo "</table>" ?>