<?
$dbhost = 'localhost';
$dbname = '******_education';
$dbuser = '******_education';
$dbpass = '******';
mysql_connect($dbhost, $dbuser, $dbpass);
mysql_select_db($dbname);
mysql_query("set names utf-8;");
mysql_query("set collation_connection=utf8_general_ci;");
echo "<pre>\n";
echo str_repeat("-", 133)."\n\n";
echo "user_id\t\tuser_name\t\tuser_phone\t\t\tuser_sex\tuser_age\tuser_login\tuser_password\n\n";
echo str_repeat("-", 133)."\n\n";
$educationResource = mysql_query("select * from education_users;");
while($currentRecord = mysql_fetch_row($educationResource))
{
foreach($currentRecord as $Key => $Value)
{
if($Key == 3)
{
if($Value == 1) echo "М\t\t";
else echo "Ж\t\t";
continue;
}
if($Key != 6) echo $Value."\t\t";
else echo '******';
}
echo "\n";
}
echo "\n".str_repeat("-", 133);
echo "</pre>\n";
mysql_close();
?>
Результат выполнения задания можно посмотреть
здесь.