Learn to Create Interactive Drill-Down Dashboards with PHP and FusionCharts via Learn to Create Interactive Drill-Down Dashboards with PHP at Nettuts. This tutorial is so similar to the SQL final project, I am sharing it to provide another approach using…
Tag Archive for MySQL
SQL: A Simple PHP/MySQL Master Detail Report
by jayperetz • • 3 Comments
This tutorial is based on Project 4 of the SQL class. It is of use to students in the Advanced Dreamweaver class as well. In fact, a summary/detail report is a very common technique in using SQL database-driven applications. …
Dreamweaver Cinco de Mayo Project
by jayperetz • • 9 Comments
In class on Thursday May 5 we started building a PHP form for a simple application that allows a user to upload an image and order a custom Cinco de Mayo tshirt with the image on the front. Using the…
Dreamweaver | Lecture Notes 4-21-2011
by jayperetz • • Comments Off
Complex Form Processing download the lesson08 files Examining the POST[] array Setting default Radio Group value with checked=”checked” Set multiselect select name values to arrays Handling mulitselect values to PHP Resetting Passwords examine the process – pg 288 Create a…
Data Models & Forward Engineering with MySQL Workbench
by jayperetz • • Comments Off
Forward Engineering Tutorial I created a short video tutorial on how to forward engineer a database on the SRJC student server. The first few seconds are gray for some reason, but stick with it and you’ll see the step by…
Weekly Update | April 7, 2011
by jayperetz • • 10 Comments
Lecture Notes Data Validation with Zend Framework Creating & using custom server behaviors Selecting & Inserting to MySQL with Zend Framework Zend_Auth database table authentication HTML5 Assignments Lesson 7 – Introducing the Zend Framework – read the blog entry before…
Data Form Validation and MySQL with Zend Framework
by jayperetz • • 6 Comments
Data Validation with Zend Framework You can download the lesson 7 start files here. The definitive reference for Zend Validation can be found here. The text is excellent at providing a step-by-step approach to building a robust web data form…
Relational Databases and SQL Joins
by jayperetz • • Comments Off
A student asks “I don’t really yet understand Joins, just figured it out using the example in the text book. Joins are fascinating and I look forward to better understanding them as I use them at work in a ‘trial…
Part 2: Server Behaviors in Dreamweaver CS5 with PHP / MySQL
by jayperetz • • 1 Comment
In an earlier post focused on the first part of Lesson 6 we explored the server behaviors that create a fully function user login system using webpage forms and a MySQL database with user records stored in a table. …
Part 1: Server Behaviors in Dreamweaver CS5 with PHP / MySQL
by jayperetz • • 8 Comments
Dreamweaver has included server programming and database server programming features for over 10 years. The server behaviors in CS5 are virtually unchanged from CS4. The basic concept is that Dreamweaver inserts code snippets into your webpages that perform basic server-based…