MySQL 5 X + PHP code ISSUE! AUGH!
Posted: Fri Dec 16, 2005 2:11 pm
I have some older code which allowed me (and still allows me) to connect to the older styleMySQL 3x and pre 4.1 series of MySQL. Now I get that annoying : consider upgrading client to be more compatible message when trying to use it under the MySQL 5, and using PHP 4x and 5x. Tried using the old passwords command in MySQL but that doesnt work for whatever reason.
Also, doing this under Windows XP off of IIS 6x.
Here is the basic code:
Any thoughts?
Whats the new structure look like? that was basically copied from the php.net site, and I havent been successful when doing searches for MySQL 5x + PHP specific coding.
Need to convert my old scripts.
Also, doing this under Windows XP off of IIS 6x.
Here is the basic code:
Code: Select all
<?php
// Connecting, selecting database
$link = mysql_connect('127.0.0.1', 'root', 'password')
or die('Could not connect: ' . mysql_error());
echo 'Connected successfully';
mysql_select_db('test') or die('Could not select database');
// Performing SQL query
$query = 'SELECT * FROM news';
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
// Printing results in HTML
echo "<table>\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo "\t<tr>\n";
foreach ($line as $col_value) {
echo "\t\t<td>$col_value</td>\n";
}
echo "\t</tr>\n";
}
echo "</table>\n";
// Free resultset
mysql_free_result($result);
// Closing connection
mysql_close($link);
?>Whats the new structure look like? that was basically copied from the php.net site, and I havent been successful when doing searches for MySQL 5x + PHP specific coding.
Need to convert my old scripts.