Web development with PHP

A PHP tutorial. I advice the visualization of all videos because along the playlist I make some “mistakes” on purpose, that later they become “problems” and need to be fixed. This way I can show why we should do it this or that way. Until now I’ve only created series nbr 7, explaining how to use PHP to connect to a database using PDO and how to structure an application using the MVC design pattern.

You can download the source code here.

  • Web Dev: 01 – PHP
    • Creating the database
    • Creating the SVN repository and the project in Eclipse
    • Connecting to the database
    • Using SELECT
    • Using INSERT
    • What is the MVC design pattern and how to use it
    • Using UPDATE
    • Using DELETE
    • Using prepared statements
    • Using transactions
    • Wraping up the project with CSS and DIVs

Web development environment

Here I teach how to set up a web development environment for PHP, using UBUNTU + XAMPP + Eclipse + XDebug + Phing + PHPDoc + SVN. It’s still missing PHPUnit, but some day I will do it.

You can download the used files from here (httpd.conf, php.ini, build.xml …).

  • Web Dev: 00 – Ambiente de desenvolvimento
    • XAMPP – install, configure and testing xampp in Ubuntu, with Xdebug
    • Eclipse – install and configure with Xdebug
    • Phing – Install, configure and create a build.xml file
    • PHPDocumentor – Install, configure, test and encoding correction
    • SVN (Subversion) – install, configure and usability

Linux basics screen-casts

I’ve prepared a playlist about Linux basics covering:

  • Linux: 00 – Instalação, Configuração e Software
    • Virtual Box configuration
    • Installing Ubuntu
    • Virtual Box snapshots
    • First login
    • System set up
    • Installing software using shell
    • Installing software using Ubuntu Software Center
    • Installing software using Synaptic
    • Installing software using a DEB file
    • Installing software using apt-get
    • Installing software using make (compiling from source)
    • Installing, seting up and using WINE (Windows emulator)
    • Installing and using Compiz
    • Installing and using Emerald
    • How to reinstall Ubuntu

How to make screen-casts

In some of my classes I asked my students to author some screen-casts and upload them to Youtube, so they could show me that they could install and work with Linux. So I ended up creating some screen-casts teaching how to create screen-casts!  I teach how to do it in Linux with the following open source software:

  • Virtual box – to have an isolated sandbox
  • recordmydesktop – to record my desktop and my explanations
  • Pitivi – to edit the video files

I teach how to set up recordmydesktop options, use pitivi to edit the videos, set pitivi options to get an HD video ready for Youtube upload.

I use a desktop do create the screen-casts, and I always get that background sound (BZZZZZZZZ) that seems like a refrigerator, so I also have a second video teaching how to clean up the sound using:

  • Audacity – to clean the sound
  • Pitivi – to remaster the video