How can I retrieve a database name with PHP?

Question

This is long-winded, but my current setup is a WordPress multisite that is distributed over 256 databases (performance reasons). When sites are generated, a script auto-populated the WP tables needed onto a randomly selected database. The science is beyond my understanding completely.

Anyways, I have a need to alter data on a table for one of my sites. I need to find out which database its table reside. A long while ago, I had success with this:

<?php
    $query="select database() AS <code>db</code>";
    $result=mysql_query($query);
    $row = mysql_fetch_assoc($result);
        echo 'database: '.$row['db'].'<p>';
?>

That no longer seems to function and looks like it has deprecated functions. Any help would be greatly appreciated. Thanks!

Please, don't use mysql_* functions. They are no longer maintained and are officially deprecated. Learn about prepared statements instead, and use PDO or MySQLi. This article will help you decide. — Jay Blanchard
– Jay Blanchard, Commented Oct 6, 2014 at 19:11
Thanks @JayBlanchard...I came to that conclusion and mentioned it already "That no longer seems to function and looks like it has deprecated functions." — NW Tech
– NW Tech, Commented Oct 6, 2014 at 19:14

Jay Blanchard · Accepted Answer · 2014-10-06 19:21:40Z

1

If you're using mysqli_ you can do this -

if ($result = $mysqli->query("SELECT DATABASE()")) {
    $row = $result->fetch_row();
    printf("Default database is %s.\n", $row[0]);
    $result->close();
}

That returns the name of the default database for this connection.

answered Oct 6, 2014 at 19:21

Jay Blanchard

34.5k17 gold badges82 silver badges130 bronze badges

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

Collectives™ on Stack Overflow

How can I retrieve a database name with PHP?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related