PHP/MySQL Tutorial

By Graeme Merral : Open source has brought a lot more than Linux to the computing world. It has also given us PHP and MySQL. According to Graeme, PHP and MySQL are the world’s best combination for creating data-driven sites. In the first installment of this three-lesson tutorial, our Kiwi guide covers everything you need to know to begin developing database hubs. He gives instructions for installation on both Unix and Windows, and then goes on to show 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. Graeme starts by showing while loops, then talks about 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, Graeme shows some of the secrets that will turn your simple data-driven site into a useful application. As he covers validation, he’ll show how to prevent users from leaving key form fields blank and how to make sure numeric files don’t contain letters. He’ll also teach you 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. Graeme winds it all up with some tearful parting words and a bit of advice for the aspiring PHP/MySQL coder.

Lesson 1

Installation, basic scripts

Lesson 2

PHP and HTML forms

Lesson 3

Advanced tips

Facebook Comments

More Stuff

Top 5 Best Security-Centric Linux Distributions Of 2016 Staying anonymous on the Internet might not necessarily mean the same as surfing the web safely but rather keeping yourself safe from prying eyes that...
Moog’s new analog synth is more than just a growling bass machine... Iconic synth maker Moog is technically showing at this year’s NAMM show, but in true Moog style, there’s no actual booth. Instead, the North Carolina-...
How to Find Out List of All Open Ports in Linux In this article, we will briefly talk about ports in computer networking and move to how you can list all open ports in Linux. In computer networking,...
How to Install Apache, MySQL/MariaDB and PHP on RHEL 8 In this tutorial, you are going to learn how to install LAMP stack – Linux, Apache, MySQL/MariaDB, PHP on RHEL 8 system. This tutorial presumes that y...
Spread the love

Posted by News Monkey