代码新手，mysql_fetch_array到PDO

Question

I have been looking to convert some older PHP queries to newer PDO method.

This is where I am at:

$servername = "localhost";
$dbName = XXXXXXXXX
$dbUser = XXXXXXXXX;
$dbPass = XXXXXXXXX;
$conn = new PDO("mysql:host=$servername;dbname=XXXXXXXXX", $dbUser, 
$dbPass);
$delimiter = "**";
$query = "SELECT * FROM `images` WHERE `portfolio_id` = 'X' AND `image_status` = 'X' ORDER BY rand()";
$conn->query($query);
while($row = mysql_fetch_array($query)){
    $sVal = substr($row['image_full'],0); 
    $nString = $nString.$delimiter.$sVal;
}

Seems like it is going okay till I get to the "mysql_fetch_array" part. Any advice would be greatly appreciated.

Answer 1

You currently pass a string to mysql_fetch_array. Try this:

$result = $conn->query($query);
while($row = mysql_fetch_array($result)){