Welcome to collectivesolver - Programming & Software Q&A. A website you can trust. All programs tested and works. Contact: aviboots(AT)netvision.net.il
Bonsai Trees

Liquid Web Managed Dedicated Server: RAID 1 SSD with 16GB of RAM minimum! 24/7 On-Site Heroic Support! Industry-Leading SLA!

BlueHost Web Hosting

Ecommerce Software - Best Ecommerce Platform Made for You - Free Trial

Ecommerce Software - Best Ecommerce Platform Made for You - Free Trial

getflywheel wordpress hosting


Liquid Web Cloud VPS Hosting

8,954 questions

12,356 answers

573 users

How to print MySQL table with PHP Data Objects (PDO) in PHP

1 Answer

0 votes
 $sql_posts = "SELECT post_id, post
              FROM posts
              WHERE user_id = :userid";

$result = $con->prepare($sql);

$result->bindParam(':userid', $_SESSION['user-id'], PDO::PARAM_INT);

$result->execute();

$posts_array = $result->fetchAll(PDO::FETCH_ASSOC);

print_r($posts_array);


/*
run:

Array ( [0] => Array ( [post_id] => 1 [post] => C is popular programming language ) 
        [1] => Array ( [post_id] => 2 [post] => PHP is popular server-side scripting ) 
        [2] => Array ( [post_id] => 3 [post] => PHP version 7 is available ) 
        [3] => Array ( [post_id] => 4 [post] => PHP new post ) ) 

*/

 




answered Jul 7, 2015 by avibootz
edited Jul 9, 2015 by avibootz
...