PHP/mySQL
Matt Gioia walks us through learning PHP, which stands for Hypertext Preprocessor, and mySQL (my Structured Query Language). PHP allows a server program (like apache) to execute code BEFORE the html(aka the Hypertext) is sent out over the internet to whoever asked for it. This means a few things
- PHP code is never visible to someone just browsing the internet.
- you can display a totally different web-page depending on variables, or times, or anything you can think of.
mySQL is a way to interact with a database and retrieve or post information. It basically allows your site to have ‘memory’. This means we can do different things for different users, or save comments, ect.
An example of the two in action would be PHP checking the current time when some asks for a web page. if the time is before noon, php makes the header image a sunny day, and if the time is after 6 PM, php can make the header image a cloudy night.
mySQL allows you to have user logins. Used with php, you can print out stuff like ‘welcome back, dan’, where dan was the name stored in the database for the user who just logged in.
Matt’s presentation materials are not available yet, but will be soon.
Please remember these videos have not been edited in any way, and might contain intro scenes and comments not intended for a final release.
Loading ...
Latest Comments