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…
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…
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…
Introduction to the Zend Framework
by jayperetz • • 16 Comments
“Extending the art & spirit of PHP, Zend Framework is based on simplicity and object-oriented best practices and … is focused on building more secure, reliable, and modern Web 2.0 applications & web services.” – framework.zend.com In this…
Server / Network Problems with SRJC MySQL databases
by jayperetz • • 34 Comments
Advanced Dreamweaver students: If you are having problems connecting to your MySQL database – either with Dreamweaver’s Database Connection/Databases Panel or with MySQL Workbench, please post a comment below with your username and the specific error number or problem you…
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. …