htmlspecialchars kısmında da iki tane ( varmış
<?php
/* Veri Tabanını Bağla */
try {
$db = new PDO('mysql:host=localhost;dbname=lpanelen', 'root', '');
}catch(PDOException $e) {
$e->getMessage();
}
/* Sorgu Başlat */
if (isset($_POST['search'])) {
$name = htmlspecialchars($_POST['search']);
$name = "%".$name."%";
$query = $db->query("SELECT * FROM posts WHERE title LIKE $name", PDO::FETCH_ASSOC);
$query->execute();
}
?>
<!-- Yazdır -->
<?php foreach ($query as $result): ?>
<?=$result['title']?>
<?php endforeach; ?
Şu kodda
<?php
/* Veri Tabanını Bağla */
try {
$db = new PDO('mysql:host=localhost;dbname=hh', 'root', '');
}catch(PDOException $e) {
$e->getMessage();
}
/* Sorgu Başlat */
if (isset($_POST['search'])) {
$name = htmlspecialchars($_POST['search']);
$name = "%".$name."%";
$query = $db->query("SELECT * FROM posts WHERE title LIKE $name", PDO::FETCH_ASSOC);
$query->execute();
}
?>
<!-- Yazdır -->
<?php foreach ($query as $result): ?>
<?=$result['title']?>
<?php endforeach; ?>Şu Hatayı almaktayım
Fatal error: Uncaught Error: Call to a member function execute() on bool in C:xampphtdocsaraajax.php:19 Stack trace: #0 {main} thrown in
C:xampphtdocsaraajax.php on line
19