The final lesson...week 6! In this week's lesson, we learned about connecting to a database on another server. For some, it worked just fine. For others (and I am one of the others) it did not work at all. There was much frustration in attempting to connect to the database and constantly being given the message:

Warning: Client does not support authentication protocol requested by server; consider upgrading MySQL client in /home/r/j/rjoannej.com/html/php101/testConnect.php on line 19 Warning: MySQL Connection Failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client in /home/r/j/rjoannej.com/html/php101/testConnect.php on line 19 HELP! Something is wrong here Client does not support authentication protocol requested by server; consider upgrading MySQL client

In order to complete the assignment, I am using a temporary connection to the LVS server. However, once the class is over, the page I complete will no longer be working. I have discontinued my association with Atlantic.net because they were/are running 4.4.9 which translates to PHP 4.1.2 (when I move the version will reflect that of the new server).

By the way, snow was a distraction and at the same time a gift of time...there was no school on Friday, the 19th of December. This allowed me to finish week 6. Here are some photos of the snow. The Snowy Day

<?php 
    /* My variables */
    $myName = "R. Joanne Johnson";
    $pageTitle = "PHP for Web Developers 101";
    $instructors = "Jeramie Risinger and Bean Fairbanks";
    //I experimented with making a link as part of a variable. At first, it didn't work because of the sets of double quotes, so I             tried changing the double quotes inside the link to single. It works!!! 
    $theSchool = "<a href='http://www.lvsonline.com/index.shtml' target='_blank'>LVS</a>";
    
 ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title><?php echo $title ?></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<style type="text/css">
@import url("common/week6a.css");


#current {
    font-family: "Brush Script Std", Papyrus, Arial, sans-serif;
    color: #FFFFFF;
    background-color: #FF6699;
    text-decoration: none;
}
</style>
</head>
<body>
<?php include('includes/header.php'); ?>
<div id="mainContent">
      <div id="navDiv">
        <?php include('includes/nav.php'); ?>
  </div>
  
 
 

      <p>The final lesson...week 6! In this week's lesson, we learned about connecting to a database on another server. For some, it worked just fine. For others (and I am one of the others) it did not work at all. There was much frustration in attempting to connect to the database and constantly being given the message:    </p>
      <blockquote>
        <p>Warning: Client does not support authentication protocol requested by server; consider upgrading MySQL client in /home/r/j/rjoannej.com/html/php101/testConnect.php on line 19
          
          Warning: MySQL Connection Failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client in /home/r/j/rjoannej.com/html/php101/testConnect.php on line 19
          HELP! Something is wrong here Client does not support authentication protocol requested by server; consider upgrading MySQL client </p>
  </blockquote>
      
 <p>In order to complete the assignment, I am using a temporary connection to the LVS server. However, once the class is over, the page I complete will no longer be working. I have discontinued my association with Atlantic.net because they were/are running <?php echo phpversion(); ?> which translates to PHP 4.1.2 (when I move the version will reflect that of the new server).  </p>
 <p>By the way, snow was a distraction and at the same time a gift of time...there was no school on Friday, the 19th of December. This allowed me to finish week 6. Here are some photos of the snow. <a href="http://www.rjoannej.com/php101/snow/index.htm" target="_blank">The Snowy Day</a></p>
 <div id="navDiv2"><?php $currentPage = basename ($_SERVER['PHP_SELF']); ?>
<table width="375" cellspacing="2" cellpadding="2" align="center">
  <tr>
    <td class="menu" <?php if($currentPage=="testConnect.php") {
   echo 'id="current"';      
            }
        ?> ><a href="http://www.student30.lvsphp.com/testConnect.php">Connect</a></td>
        
    <td class="menu" <?php if($currentPage=="2darray.php") {
   echo 'id="current"';      
            }
        ?> ><a href="2darray.php">2D Array</a></td>
    
     <td class="menu" <?php if($currentPage=="sharedData.php") {
   echo 'id="current"';      
            }
        ?> ><a href="http://www.student30.lvsphp.com/sharedData.php">Database</a></td>
     
      <td class="menu" <?php if($currentPage=="genre.php") {
   echo 'id="current"';      
            }
        ?> ><a href="http://www.student30.lvsphp.com/genre.php">Genre</a></td>
    <td class="menu" <?php if($currentPage=="modified.php") {
   echo 'id="current"';      
            }
        ?> ><a href="modified.php">Genre 2</a></td>
   
   
  </tr>
</table>

</div>
        
 <div id="showSource">
  <?php show_source(basename($_SERVER['PHP_SELF']));?>
</div>
      
</div>
</body>
</html>