Welcome to collectivesolver - Programming & Software Q&A. A website you can trust. All programs tested and works. Contact: aviboots(AT)netvision.net.il
Liquid Web Managed Dedicated Server: RAID 1 SSD with 16GB of RAM minimum! 24/7 On-Site Heroic Support! Industry-Leading SLA!

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


Liquid Web Cloud VPS Hosting

8,365 questions

11,625 answers

573 users

How to return next row on MySQL with PHP Data Objects (PDO) for increased security in PHP

1 Answer

0 votes
$db_host = 'localhost';
$db_user = 'user';
$db_password = 'password';
$db_name = 'database_name';
try
{
    $con = new PDO("mysql:host=".$db_host.";dbname=".$db_name, $db_user, $db_password);
    $result = $con->prepare("SELECT DISTINCT query
            FROM search_statistic
            WHERE find = 1
            ORDER BY query ASC");
     $result->execute();
     echo '<table style="padding:20px;" border="0" width="100%">';
     while ($row = $result->fetch(PDO::FETCH_ASSOC))
     {
            echo '<tr>';
            echo '<td width="33%"><font size="2">'.$row['query'].'</font></td>';
            $row = $result->fetch(PDO::FETCH_ASSOC); // Return next row
            echo '<td width="33%"><font size="2">'.$row['query'].'</font></td>';
            $row = $result->fetch(PDO::FETCH_ASSOC); // Return next row
            echo '<td width="33%"><font size="2">'.$row['query'].'</font></td>';
            echo '</tr>';
      }
      echo '</table>';
}
catch (PDOException $e) 
{
       echo "Error: " . $e->getMessage();
}

 




answered Sep 25, 2015 by avibootz
edited Sep 25, 2015 by avibootz
...