Jump to content

Looking for book that deals with a log in procedure.

ralphvarney's Photo Asked by ralphvarney
Posted Oct 24 2011 04:09 PM
1981 Views
O,Reilly seems to have books that cover every aspect of web design.. But ,does any one know if there are any OReilly book(s) that include a web site log in procedure using PHP and a data base in mySQL.? Something used on almost every website yet there seems to be a dearth of instructions on a basic log in procedure.

I have a family website, it is members only using a simple form that checks against a list of members, cobbled together with help from many sources, it works reasonably well. I would like to change it though using a proper data base and add a few features like setting your own password, a forgot password feature, a remember me..

Thanks for your time
Tags:
2 Subscribe


2 Replies

0
  rachel.j's Photo Answered by rachel.j Answers Early Bird Peacock
Posted Oct 25 2011 07:13 AM
There are two books that I think might be helpful to you. Both books teach the basics of PHP and MySQL and then have examples for building a website that you can log in to. Neither of them have all of the features you're looking for, but I think they should give you the knowledge that you need to build those features.

Here are the details:

Learning PHP, MySQL, and Javascript
Learning PHP, MySQL, and Javascript explains each technology separately, shows you how to combine them, and introduces valuable web programming concepts, including objects, XHTML, cookies, and session management. You'll practice what you've learned with review questions in each chapter, and find a sample social networking platform built with the elements introduced in this book.

This book will help you:
  • Understand PHP essentials and the basics of object-oriented programming
  • Master MySQL, from database structure to complex queries
  • Create web pages with PHP and MySQL by integrating forms and other HTML features
  • Learn about Javascript, from functions and event handling to accessing the Document Object Model
  • Use libraries and packages, including the Smarty web template system, PEAR program repository, and the Yahoo! User Interface Library
  • Make Ajax calls and turn your website into a highly dynamic environment
  • Upload and manipulate files and images, validate user input, and secure your applications


Head First PHP & MySQL
If you're ready to create web pages more complex than those you can build with HTML and CSS, Head First PHP & MySQL is the ultimate learning guide to building dynamic, database-driven websites using PHP and MySQL. Packed with real-world examples, this book teaches you all the essentials of server-side programming, from the fundamentals of PHP and MySQL coding to advanced topics such as form validation, session IDs, cookies, database queries and joins, file I/O operations, content management, and more.

Head First PHP & MySQL offers the same visually rich format that's turned every title in the Head First series into a bestseller, with plenty of exercises, quizzes, puzzles, and other interactive features to help you retain what you've learned.
  • Use PHP to transform static HTML pages into dynamic web sites
  • Create and populate your own MySQL database tables, and work with data stored in files
  • Perform sophisticated MySQL queries with joins, and refine your results with LIMIT and ORDER BY
  • Use cookies and sessions to track visitors' login information and personalize the site for users
  • Protect your data from SQL injection attacks
  • Use regular expressions to validate information on forms
  • Dynamically display text based on session info and create images on the fly
  • Pull syndicated data from other sites using PHP and XML

Throughout the book, you'll build sophisticated examples -- including a mailing list, a job board, and an online dating site -- to help you learn how to harness the power of PHP and MySQL in a variety of contexts. If you're ready to build a truly dynamic website, Head First PHP & MySQL is the ideal way to get going.
0
  ralphvarney's Photo Answered by ralphvarney
Posted Oct 25 2011 03:21 PM
Thanks Rachel
I was hoping for a specific.. "here is how you build a log in system" complete with reasons why.. I guess that I am surprised that O'Reilly has not used a log in system as an example considering that more sites have something like that then a dating feature

My family website uses a fair amount of PHP but I have yet to jump to the mySQL level. My fear is that I will build a log in system that works yet is completely unsecured and open to even the mildest attack.

So the search goes on.. but thanks anyway

 
Sign up today to receive special discounts,
product alerts, and news from O'Reilly.
Privacy Policy >
View Sample Newsletter >