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.
Assignments
- 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.
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?
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.
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
Deb – Why not use Server Behaviors to add the code?
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.
What problem did you have when trying to add the login server behavior on index.php?
Hmmm,
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?
Mitch — can you send me the page as an attachment? I looked on your site and couldn’t find a page like that.
Does anyone have an idea how I get a page added in my local site named this:
delete_user_jhcy4ic7ma.php
it should be:
delete_user.php
Mark
Mark – I haven’t seen that before.
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
The extra pages appeared in my files panel earlier, but haven’t since.
I won’t worry about it.