mysql query using PDO Syntax

Question

I have a query where I am getting the list of databases. This is working fine, but I don't know how to execute the queries here in PDO syntax.

$link = mysql_connect('localhost', 'root', '');
$db_list = mysql_list_dbs($link);

$i = 0;
$cnt = mysql_num_rows($db_list);
while ($i < $cnt) {
    echo '<a href='.$i.'>'.mysql_db_name($db_list, $i).$i.' </a><br>';
    $i++;

possible duplicate of How can I get a list of MySQL databases in PHP using PDO? — Marco
– Marco, Commented May 30, 2014 at 16:58
In these links, we have only for PDO connection syntax, I need for mysql_list_dbs, mysql_num_nows and mysql_db_name — ronquiq
– ronquiq, Commented May 30, 2014 at 17:01

Ashouri · Accepted Answer · 2014-05-30 17:01:55Z

0

here sample code with pdo

  $user = 'root';

  $pass = 'root';

  $server = 'localhost';

  $dbh = new PDO( "mysql:host=$server", $user, $pass );

  $dbs = $dbh->query( 'SHOW DATABASES' );

     while( ( $db = $dbs->fetchColumn( 0 ) ) !== false )

      {

        echo $db.'<br>';

      }

answered May 30, 2014 at 17:01

Ashouri

8944 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

ronquiq Over a year ago

Thank You.. could I know where is the $i as I shown in my code

ronquiq Over a year ago

Could you please help me with passing $i in your code as in my question

Ashouri Over a year ago

I could but first get me useful

Collectives™ on Stack Overflow

mysql query using PDO Syntax

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related