Mysql Host information not showing using PHP

Question

I'm following php/mysql tutorial book. The sample script connects me to my mysql database doesn't show what it should.

The line in question is

("Host information: %\n", mysqli_get_host_info($mysqli));

There rest of the code

 <?php
$mysqli=new mysqli("localhost", "root", "Im not pasting this", "or this");

if (mysqli_connect_errno()){
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
    } else {
        printf("Host information: %\n", mysqli_get_host_info());
}
?>

I just i get "Hostname: " on the screen.

TN888 · Accepted Answer · 2015-02-10 20:10:53Z

2

You need to specify your mysqli object in mysqli_get_host_info() function - http://php.net/manual/en/mysqli.get-host-info.php. Try this code:

     <?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");

/* check connection */
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}

/* print host information */
printf("Host info: %s\n", $mysqli->host_info);

/* close connection */
$mysqli->close();
?>

edited Feb 10, 2015 at 20:10

answered Feb 10, 2015 at 19:35

TN888

7,7499 gold badges52 silver badges85 bronze badges

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

Collectives™ on Stack Overflow

Mysql Host information not showing using PHP

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related