PHP & MySQL for Dummies
This is the book I am going to start with learning PHP. I am using MS SQL server at work, so MySQL part is not a problem. The basic PHP commands and functions will be listed along with my study progress.
Chapter 2: Connect to mysql
The provided mysql_up.php used mysqli_query function, which due to unknown reason does not work. MySQL revision at my website is 5.1.30 verified with mysql_get_server_info. But mysql_up-4.php works, it used mysql_query.
Check MySQL connection
<?php
/* Program: mysql_up.php
* Desc: Connects to MySQL Server and
* outputs settings.
*/
echo "<html>
<head><title>Test MySQL</title></head>
<body>";
$host="fdb2.host-ed.net";
$user="username";
$password="password";
$cxn = mysql_connect($host,$user,$password);
$sql="SHOW STATUS";
$result = mysql_query($sql);
if($result == false)
{
echo "<h4>Error: ".mysql_error($cxn)."</h4>";
}
else
{
/* Table that displays the results */
echo "<table border='1'>
<tr><th>Variable_name</th>
<th>Value</th></tr>";
for($i = 0; $i < mysql_num_rows($result); $i++)
{
echo "<tr>";
$row_array = mysql_fetch_row($result);
for($j = 0;$j < mysql_num_fields($result);$j++)
{
echo "<td>".$row_array[$j]."</td>n";
}
}
echo "</table>";
}?>
</body></html>
Check MySQL revision
<?php
$host="fdb2.host-ed.net";
$user="username";
$password="password";
$link = mysql_connect($host,$user,$password);if (!$link) {
die('Could not connect: ' . mysql_error());
}
printf("MySQL server version: %sn", mysql_get_server_info());
?>