Ezra^3 - let's make things happen. » Dynamic Web Development

BangBang

ezraezra — Wed, 25 May 2011 04:06:35 +0000

BangBang: Telepresence shoot-em-up game
Name: BangBang
Platform: Web
Author: Ezra Velazquez
Release: May 3rd, 2011
Technology: AJAX, CSS, CSS3, HTML, HTML5, JavaScript, JSON, jQuery, PHP, OpenTok
Version: 1.0

About BangBang: Click to read about my Personal Statement

Dynamic Web Apps

ezraezra — Sat, 09 Apr 2011 21:41:58 +0000

9bit: play with you friends

Name: 9bit: play with your friends
Platform: Web
Author: Ezra Velazquez
Release: March 25th, 2011
Technology: AJAX, CSS, CSS3, HTML, JavaScript, JSON, jQuery, PHP
Version: 1.0

Web App: “CLICK HERE” to launch 9bit.

For more details, read the article I wrote for the TokBox Developer’s Blog.

PHP Talks to MySQL

ezraezra — Mon, 28 Feb 2011 03:38:39 +0000

Assignment 5: Create a web page that accepts user input and stores it in a table (or tables) in your database. This page should also be able to display the contents of your table(s) in some interesting way. As always, try to choose your data and functionality in some coherent fashion, paying particular attention to user interface design. Why would someone want to use this little application you’ve created? Why is it important that whatever activity they have performed be persistent in your database? On a more technical level, this means that PHP will have to perform at least one SELECT query, at least one INSERT query, possibly an UPDATE query, and possibly a DELETE query. However, the functionality of your interface is ultimately more important than the range of SQL operations it needs to perform.

Response: 9Bit Intro (right click to download to view source code)

About Assignment:

At first I developed a simple page where the user saw all options (create session and join session) while displaying the value of tables in the background. After making sure I had the PHP working, I decided to play with the user interface design and make it a little more web 2.0.

Speaking technically, the page is created and populated via a blend of PHP, MySQL, CSS, CSS3, and HTML. The PHP communicates to MySQL to get information on which users are on what session. On the MySQL side, there are three tables: Users, Sessions, and Users_X_Sessions. In theory I could have just created the first two tables, since Users to Sessions is a one-to-many relationship. The Users table can contain the foreign key which will tell it which session it is associated with. I wanted experience creating foreign key tables, hence the Users_X_sessions table.

Well, Hello there MySQL

ezraezra — Sat, 12 Feb 2011 20:49:03 +0000

Week3 of Dynamic Web Development: Database Design, MySQL, and the SQL Language – Part 1

Assignment can be found here.

**To view the php source, please right-click to download file**

Interesting things I learned while doing the assignment and reading:

Contrary to popular belief, in today’s terminology SQL does not stand for “Structured Query Language”, or some other derivative
MySQL is quite picky when it comes to proper formatting.
A good PHP script can be written with just a few lines of actual PHP code.

Week 3: Database Design, MySQL, and the SQL Language – Part 1

PHP and her Forms

ezraezra — Mon, 31 Jan 2011 20:52:08 +0000

Week 2 of Dynamic Web Development: PHP Basics and CGI: Script-Generated Pages

Assignment can be found here.

**To view the php source, please right-click to download file**

Interesting things I learned while doing the assignment and reading:

“Web Database Applications with PHP and MySQL” (O’Reilly ISBN 0-596-00543-1) assumes you know a thing or two about programming. For a more basic approach, try O’Reilly’s other book “Learning PHP, MySQL, and JavaScript” (O’Reilly ISBN 978-0-596-15713-5

Dynamic Websites

ezraezra — Sun, 30 Jan 2011 21:03:05 +0000

Assignment 1: Pick a website you admire and write a paragraph about what you like about it. Also modify hello.php script.

- View Script & Response