Tags down


mysql pdo select query

By : Yi-Fan Wu
Date : May 05 2020, 10:04 AM

I write this code like :

$id=$_GET['category_id']; echo $id; $products=$db->prepare('SELECT * FROM `products` WHERE category_id=4'); $products->execute(); ?> <?php while ($product=$products->fetch(PDO::FETCH_ASSOC)) { ?> <div id="mehsul"> <div class="altmehsul"> <div onclick="show()" class="card" style="width: 15rem;"> <div class="photo"> <img src="https://i1.rozetka.ua/goods/7373993/53819988_images_7373993442.jpg" class="card-img-top" alt="..."> </div> <div class="card-body"> <h5 class="card-title"><?php echo $product['name']; ?></h5> <p class="card-text"><?php echo $product['price']; ?></p> </div> </div> <?php } ?>

And this divs displayed but I write instead 'id=3' for example id=$id this dinamic divs is hiding. WHY?

any help apprecated

Answer :

PDO support placeholder values that make doing this correctly so easy:


$products=$db->prepare('SELECT * FROM `products` WHERE category_id=:id');
$products->execute([ 'id' => $id ]);

That's all there is to it.

Share : facebook icon twitter icon
Related Posts Related Posts :
  • clear array after form submit
  • pass url variable to javascript
  • access data using api
  • div position fixed css
  • add horizontal line between two div
  • disable toggle button css
  • css fixed line height
  • background image not working
  • table cell border
  • text line break css
  • overlay div on div
  • text direction rtl css
  • javascript convert string to an object
  • bind inner div click to outer div
  • jquery ajax oncomplete
  • how to use promise in for loop
  • jquery get element using variable
  • javascript send textbox value
  • pass div class content to another class or id
  • css new line after element
  • css calc not working properly
  • link disabled jquery
  • sql join table to subquery
  • MS Access SQL Issue with OR AND Operators
  • set textarea value using php
  • php merge two arrays into one
  • php form with google captcha
  • update current row in php
  • php date format mysql
  • php function return an array
  • PHP mysqldump database to sql file
  • display image query
  • php create array using foreach loop
  • associative array php
  • group_concat in mysql laravel
  • php array_push empty
  • mysql on update cascade not working
  • pdo insert prepared statement
  • mysql insert ignore vs on duplicate key
  • mysql insert into existing row
  • mysql multi insert query
  • mysql group by show all rows
  • php change profile image
  • combine multiple arrays into one array php
  • how to sum values in an array
  • how to get sum of the total time
  • How to Create Facebook live stream without notification using API ?
  • on button click make div visible
  • css affect another element on hover
  • insert line after paragraph word
  • shadow
    Privacy Policy - Terms - Contact Us © bighow.org