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

4 votes140 views2 answers
What sign is less than or equal to php
PHP
3 votes132 views1 answer
Phone number validation, laravel
PHP
1 vote134 views1 answer
Syntax error or access violation: 1072 Key column 'user_id' doesn't exist in table (SQL: alter table `groups` add constraint `groups_user_id_foreign` foreign key (`user_id`) references `users` (`id`))
PHP
7 votes131 views2 answers
Laravel mail send to multiple recipients
PHP
0 vote112 views1 answer
Error repoerting in php
PHP
1 vote125 views2 answers
Laravel get url parameter value in controller
PHP Laravel
0 vote126 views1 answer
Change column name in phpmyadmin
PHP
0 vote117 views1 answer
The "App\Entity\ entity has a repositoryClass set to but this is not a valid class.
PHP
0 vote116 views1 answer
How can we send attached file with notification in gmail in laravel 8
PHP Laravel
1 vote139 views1 answer
How can get url from $request in laravel
PHP