Php query pdo

<?php
$sql =  'SELECT name, color, calories FROM fruit ORDER BY name';
foreach  ($conn->query($sql) as $row) {
    print $row['name'] . "\t";
    print  $row['color'] . "\t";
    print $row['calories'] . "\n";
}
?>

Source: php.net

Similar codes

15 votes199 views1 answer
Composer install ignore platform requirements
PHP
3 votes173 views2 answers
Seconds to minutes php
PHP
0 vote265 views2 answers
Php codeigniter unit testing
PHP CodeIgniter
6 votes239 views4 answers
Get template directory uri
PHP
0 vote213 views1 answer
A table was not found you might have forgotten to run your migrations. you can run your migrations using php artisan migrate. pressing the button below will try to run your migrations.
PHP
0 vote182 views1 answer
Php send POST request same folder
PHP
2 votes192 views2 answers
Remove every whitespace php
PHP
3 votes202 views2 answers
Round to 2 decimal places php
PHP
13 votes180 views6 answers
Laravel manually authenticate user
PHP
2 votes243 views1 answer
Get name custom post type wordpress
PHP