Screencast: Write a PHP script to query MySQL

I've discovered one of the most awesome applications for a Mac called ScreenFlow (#3 on my list after #1 TextMate and #2 Adium and I decided to put it to use for my first screencast.

This screencast will teach you how to write a basic PHP script that will query data in MySQL. It is designed for users who are familiar with Linux but are just getting started with PHP. Here are the basic parts of the screencast:

» Import a MySQL dump file
» Connect to MySQL with PHP
» Select a default database
» Issue a query and retrieve results
» Style the rows retrieved into a table with alternating row colors

Download the screencast in Quicktime format (80.9MB)

NEW: Uploaded the video to Vimeo as well.

As always, your comments are welcome. This is my first screencast, and I'm sure I can make some improvements on future videos. Please let me know what I can change to make these screencasts better for you.

This entry was posted on 04/06/2008 (Wednesday) at 4:15 pm and is filed under Blog Posts. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.
Printed from: http://rackerhacker.com/2008/06/04/screencast-write-a-php-script-to-query-mysql/ .
© Major Hayden 2012.

1 Comment   »

  • breun says:
    15.06.08 at 08:30

    Maybe you could upload the screencast to an online service like vimeo or embed the movie file in your blog post, so people don't have to download a 80 MB file.


Trackbacks/Pingbacks

  1. 43 Must Read PHP Articles and Resources | Hi, I'm Grace Smith
  2. Web Super Star » Blog Archive » PHP Articles and Resources for all levels
  3. 45 Must Read PHP Articles and Resources
  4. Below is a huge list of links to various PHP related articles that should help you out when starting a freelance or personal project. | kamranbhutto

RSS feed for comments on this post

Leave a Reply

 

  • Welcome! I started this blog as a way to give back to all of the other system administrators who have taught me something in the past. Writing these posts brings me a lot of enjoyment and I hope you find the information useful. If you spot something that's incorrect or confusing, please write a comment and let me know. Drop me a line if there's something you want to know more about and I'll do my best to write a post on the topic.
    -- Major Hayden

    Flattr this