Have you tried MySQLTuner yet? It's free and it makes optimizing your MySQL server easier than ever!

« MySQLTuner is the Debian Package of the Day!
Backing up MySQL to Amazon’s S3 »
04 06 2008

Screencast: Write a PHP script to query MySQL

Posted by: major in Database, Development, Screencasts

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.

Share and Enjoy:
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google
  • Reddit
  • Slashdot
  • StumbleUpon
  • Technorati
  • TwitThis

This entry was posted on Wednesday, June 4th, 2008 at 4:15 pm and is filed under Database, Development, Screencasts.You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “Screencast: Write a PHP script to query MySQL”
  1. breun says: June 15th, 2008 at 8:30 am

    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.

Leave a Reply

You must be logged in to post a comment. Login »