Welcome to collectivesolver - Programming & Software Q&A. A website you can trust. I check, compile and run every program. Contact me at: aviboots(AT)netvision.net.il
Hostgator 1 Penny

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


Distribute your Resume to 500+ Job Boards & Recruiters


6,849 questions

9,751 answers

573 users

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

Directory of Wholesale Companies and Dropship Suppliers | SaleHoo

83 views
asked Jul 7, 2015 by avibootz
edited Jul 8, 2015 by avibootz

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
...