Weekly Recap | March 10, 2011

Lecture Notes

  • Review of Quiz 2
  • Re-Review of MySQL Database fundamentals
  • Dreamweaver Server Behaviors with PHP & MySQL

This week we reviewed many of the topics we covered in previous weeks.    We pretty much covered all the server behaviors in Lesson 6.


  • Lesson 6 in Training From the Source
  • Project 4 is due Sunday March 20 at midnight – create a website with two  password-protected (internal) pages  that are password-protected using the server behavior techniques on pages 170-192 Lesson 6.   On one page  list  the users table rows (using the recordset behavior explained on pages 192-197.)   On the other page, write a few paragraphs on your experience in doing the exercise.   Did you have any problems?     What did you learn?    What other related techniques are you curious about learning?   Start with the /start/ files from the book and go through Lesson 6 step by step until page 192.   Don’t use the /completed/ files except maybe to copy the encryption code.

12 comments for “Weekly Recap | March 10, 2011

  1. March 11, 2011 at 11:59 am

    On my add_user_encrypt.php page there is user account information (name and password) already filled in each time I go to the page. This is also the case with this page: http://student.santarosa.edu/~lmcbee/lesson06/login_encrypt.php?
    Any ideas as to how to make them go away?

    • March 12, 2011 at 8:08 am

      Linda – What you are seeing is the AutoComplete feature that is standard behavior for most browsers. You can turn it off on a form element or across the entire form using the attribute autocomplete=”off”, but the autocomplete attribute is not W3C valid and it may not be polite to users who expect the browser to provide this convenience. Turning autocomplete off is convenient for development purposes.

  2. March 15, 2011 at 11:49 am

    I’ve put the html code for the ‘login/password’ in the right-hand column of my home page. The problem I’m having, is where to add the ‘php code’ to the ‘home’ page code, so the links work correctly. I’ve tried adding it above the DOCTYPE in the home page code and it disables the rest of the home page. Where is the correct place to place the php code?
    home page example

  3. March 15, 2011 at 5:19 pm

    Deb – Why not use Server Behaviors to add the code?

  4. March 16, 2011 at 11:17 am

    I did use the server behaviors and completed all the pages in Ch.6 and had them working ok. The problem happened when I tried to cut and paste the login code into the index.php (home page). I made sure to change the links from ‘login.php’ to ‘index.php’ in the code and nothing worked. Then I tried coding the login server behaviors directly into the index page and still no luck. It seems there is a conflict somewhere in the code.

    I really don’t want to dedicate a whole web page to a login/password box – it doesn’t seem very practical.

    • March 16, 2011 at 2:19 pm

      What problem did you have when trying to add the login server behavior on index.php?

  5. Mitch
    March 17, 2011 at 5:36 pm

    So, for some reason, if i have both the register and the login on the same page, after registering the redirect fires to the protected page. What gives?

    • March 17, 2011 at 10:16 pm

      Mitch — can you send me the page as an attachment? I looked on your site and couldn’t find a page like that.

  6. Mark Alarie
    March 19, 2011 at 9:22 pm

    Does anyone have an idea how I get a page added in my local site named this:


    it should be:


    • March 20, 2011 at 5:06 pm

      Mark – I haven’t seen that before.

  7. Julie Arden
    March 20, 2011 at 1:09 pm

    Hi Jay,
    I have been trying to get my HW 4 up on the web but I have not been able to make it work.
    I have tried putting the files up several times, looked through the code…..
    Finally I have come to this error in the database connection. I think that this is the problem. There is a error code 404 it says that there is no testing server running and/or the testing server does not map to the srjc site.
    I have checked my connection with the srjc server in both DW and MySQL Workbench and they are working today.
    I don’t seem to understand the problem and how to correct it.

    Do you have any ideas?
    Can I email my files to you for grading today if I can’t get them up on the web?

    Thanks Jay!

    Julie Arden

  8. Mark Alarie
    March 20, 2011 at 6:36 pm

    The extra pages appeared in my files panel earlier, but haven’t since.
    I won’t worry about it.

Comments are closed.