Тема: Скрипт дожен работать?
На одном из англоязычных форумов взял скрипт для удаленной проверки подключения к удаленной MySql.
<?php
// FILL IN BELOW
$conncect = mysql_connect ( "host", "Username", "password" )
// STOP EDIT
or die (" Sorry your server can't connect to your mysql server <BR> Check to see you have put in the Username and password and if this is the 1st time you have got this <BR> And it has worked before That means you need to contact your hoster and tell them my MySql server is down");
echo ("Good job your server has connected to your mysql server");
?>
Должен-ли он работать вообще (у меня не работает, нет ли ошибки в написании $conncect)?
А скрипт оттуда же:
<?php
$phpinfo = $_GET['phpinfo'];
if($phpinfo=="phpinfo") {
phpinfo();
die();
}
$hostname_zip = "localhost";
$database_zip = "enter database name here";
$username_zip = "your account user name";
$password_zip = "your password";
$dbcheck = mysql_pconnect("$hostname_zip", "$username_zip", "$password_zip");
if (!$dbcheck) {
echo "<H1>MySQL Connection Error</H1>";
echo mysql_error();
echo "<br><b>This Test Script was unable to connect to the MySQL server!<br>Your MySQL database is not reachable or the info you supplied to
login with is not accurate.</b><br><br>
The info used to login was:<br><font color=purple><b>\$hostname_zip=\"<i>$hostname_zip</i>\"<br>
\$username_zip=\"<i>$username_zip</i>\"<br> \$password_zip=\"*<i>hidden</i>*\"</b></font><br>";
echo "<br>Your MySQL server did not accept the connection when using the info you supplied. Double check these entries for accuracy and try again. <br>";
echo "Tips:";
echo "Email your web host and ask them what to use for a mysql hostname, username and password.<br>";
echo "View the PHP Manual: <a href=\"http://www.php.net/manual/en/function.mysql-connect.php\" target=\"_blank\">mysql_connect</a><br>";
echo "Perhaps you just need to create a new mysql user instead of using your root user.<br>";
die("<br><a href=\"$_SERVER[PHP_SELF]?phpinfo=phpinfo\">View your php settings</a>");
}else{
echo "<H1>MySQL Connection Success!</H1>";
echo "<a href=\"$_SERVER[PHP_SELF]?phpinfo=phpinfo\">view your phpinfo</a><br><br>";
echo "<p><font color=black><b>If everything looks good, but you still have mysql problems, contact your support team or server admin. ";
echo "<p><b>- Connected to your MySQL server successfully!<br>";
if (mysql_select_db($database_zip)) {
echo "<br>- Connecting to your locator database named \"<font color=purple>$database_zip</font>\" was also successful.<br>";
}else{ echo "- Connected to mysql server, but could not connect to your database named \"<font color=purple>$database_zip</font>\", check your database name
in your /admin/config.php file and refresh this page."; }
}
?>
показывает MySQL Connection Success!
На forum.php-myadmin.ru нашел скрипт:
<?php
$link = mysql_connect("localhost", "mysql_user", "mysql_password")
or print mysql_error();
mysql_close($link);
?>
- не работает