mysql_fetch_array in PDO

Question

I changed my connection to PDO

$DB = new PDO("mysql:host=".DBHOSTINT.";charset=utf8mb4;dbname=".DBNAMEINT, DBUSERINT, DBPASSINT);

I have the following code in the old "mysql_query"

$result = mysql_query("SELECT * FROM menu ");
while ($row = mysql_fetch_array($result)) {

   echo '<div class="cuisine-detail">'. $row["text"]. '</div>';
   echo '</div>';

}
mysql_free_result($result);

How I can transform this to the PDO way :

score 0 · Answer 1 · answered Mar 09 '18 at 15:10

Check docs: PDO

$sql = 'SELECT * FROM menu';
foreach ($DB->query($sql) as $row) {
    echo '<div class="cuisine-detail">'. $row["text"]. '</div>';
    echo '</div>';
}

For more complex queries better use prepared statements to prevent SQL injections: http://php.net/manual/ru/pdo.prepare.php

mysql_fetch_array in PDO

1 Answers1