A Wired.com user account lets you create, edit and comment on Webmonkey articles. You will also be able to contribute to the Wired How-To Wiki and comment on news stories at Wired.com.
It's fast and free.
processing...Retrieve Sign In
Please enter your e-mail address or username below. Your username and password will be sent to the e-mail address you provided us.
processing...Welcome to Webmonkey
- edit articles
- add to the code library
- design and write a tutorial
- comment on any Webmonkey article
Sign In Information Sent
PHP and MySQL Tutorial - Lesson 1
/skill level/
/viewed/
Open source has brought a lot more than Linux to the computing world. It has also given us PHP and MySQL.
In the first installment of this three-lesson tutorial, we cover everything you need to know to begin developing database hubs. You'll get instructions for installation on both Unix and Windows, and then you'll learn some simple scripts that will insert information into a database and display that data on a web page.
Lesson 2 covers more PHP/MySQL goodies than you could probably imagine:while loops, the ever-useful if-else statement. But this information alone means little if you don't continue and see how PHP can be used with HTML forms. By the time you've polished off this lesson, you'll be able to add, edit, and remove information from your database.
In Lesson 3, you'll learn some of the secrets that will turn your simple data-driven site into a useful application. We'll cover validation and show how to prevent users from leaving key form fields blank and how to make sure numeric files don't contain letters. You'll also learn how PHP handles includes and functions. Plus you'll see how these two features, when deployed together, can make the coder's life much easier. Everything winds up with some tearful parting words and a bit of advice for the aspiring PHP/MySQL coder.
- PHP and MySQL Tutorial
- PHP and MySQL Tutorial - Lesson 1
- PHP and MySQL Tutorial - Lesson 2
- PHP and MySQL Tutorial - Lesson 3
- This page was last modified 10:16, 4 November 2009.
Special Offer For Webmonkey Users
WIRED magazine:
The first word on how technology is changing our world.
Registration on or use of this site constitutes acceptance of our User Agreement (Revised 4/2/2009) and Privacy Policy (Revised 4/2/2009).
Wired.com © 2009 Condé Nast Digital. All rights reserved.
The material on this site may not be reproduced, distributed, transmitted, cached or otherwise used, except with the prior written permission of Condé Nast Digital.