php pdo LİKE |
6 Mesajlar | 2.479 Okunma | ||
if (isset($_POST['arama'])) {
$aranan=$_POST['aranan'];
$urunsor=$db->prepare("SELECT * FROM urun where urun_ad LIKE ? ");
$urunsor->execute(array("%$aranan%"));
$say=$urunsor->rowCount();
if (isset($_POST['arama'])) {
$aranan=$_POST['aranan'];
$urunsor=$db->prepare("SELECT * FROM urun where urun_ad LIKE or where urun_fiyat LIKE ? ");
$urunsor->execute(array("%$aranan%"));
$say=$urunsor->rowCount();
if(!$aranan){
//Arama yapılmadığı zaman burası çalışır.
}
else {
//Arama yapldığında burası çalışır.
$ara = $db->prepare("select * from urun where urun_ad like '%$aranan%' or urun_fiyat like '%$aranan%'");
$ara->execute();
$sonuc = $ara->rowCount();
if($sonuc){
$row = $ara->fetchAll(PDO::FETCH_ASSOC);?>
Toplam sonuç bulundu
foreach($row as $value){ ?>
if (isset($_POST['arama'])) {
$aranan=$_POST['aranan'];
$urunsor=$db->prepare("SELECT * FROM urun where urun_ad LIKE '%$aranan%' or urun_wunder LIKE '%$aranan%' or urun_fuji LIKE '%$aranan%' or urun_oem LIKE '%$aranan%' or urun_muailref LIKE '%$aranan%' or urun_mann LIKE '%$aranan%' or urun_mahle LIKE '%$aranan%' or urun_hengst LIKE '%$aranan%' or urun_asas LIKE '%$aranan%' or urun_asas LIKE '%$aranan%'");
$urunsor->execute(array("%$aranan%"));
$say=$urunsor->rowCount();