Keep Server Online
If you find the Apache Lounge, the downloads and overall help useful, please express your satisfaction with a donation.
or
A donation makes a contribution towards the costs, the time and effort that's going in this site and building.
Thank You! Steffen
Your donations will help to keep this site alive and well, and continuing building binaries. Apache Lounge is not sponsored.
| |
|
 Topic: MySQL info script |
|
| Author |
|
Steffen
Moderator
Joined: 15 Oct 2005
Posts: 3092
Location: Hilversum, NL, EU
|
 Posted: Sun 27 Aug '06 21:03 Post subject: MySQL info script |
 |
|
With MySQL I missed a script like phpinfo for php.
I made a simple PHP script for testing a MySQL connection and viewing the Mysql settings. Also it shows the MySQL Runtime Information and MySQL Server variables and settings. Also I included phpinfo().
Download at www.apachelounge.com/download/mysqlinfo.zip
I hope you like it and additions are welcome.
Steffen |
|
| Back to top |
|
James Blond
Moderator
Joined: 19 Jan 2006
Posts: 7371
Location: Germany, Next to Hamburg
|
| Posted: Sun 27 Aug '06 21:47 Post subject: |
|
|
For testing MySQLi you can add this
| Code: |
if(extension_loaded("MySQLi")){
$mysqli = new mysqli($host, $user, $password);
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
printf("Host information: %s\n", $mysqli->host_info);
/* close connection */
$mysqli->close();
}
else
{
echo "MySQLi not loaded";
}
|
|
|
| Back to top |
|
Steffen
Moderator
Joined: 15 Oct 2005
Posts: 3092
Location: Hilversum, NL, EU
|
| Posted: Tue 29 Aug '06 18:50 Post subject: |
|
|
Update:
I updated the script with a install check. It gives notice when the mysql extension is not found and gives hints when it cannot connect to a MySQL server.
Steffen |
|
| Back to top |
|
Steffen
Moderator
Joined: 15 Oct 2005
Posts: 3092
Location: Hilversum, NL, EU
|
| Posted: Wed 18 Oct '06 14:52 Post subject: |
|
|
Scott Furry has made a mysqlinfo script for the mysqli extension. I included it in the .zip at the download page.
A big thanks! Scott,
Steffen |
|
| Back to top |
|
|
|
|
|
|
