group strives to be a valuable resource for anyone interested in PHP regardless of their skill level or background. Through sharing and communication we believe we can foster a creative and successful community of PHP developers. The group meets every second Tuesday.
"Executing MySQL Stored Procedures in PHP Web Applications"
This presentation covers advanced SQL:2003 programming, stored procedures advantages and disadvantages, and it also provides stored procedures examples for SELECT, INSERT, UPDATE and DELETE records. An intranet Human Resource web application was demo to show how to design, code and execute MySQL stored procedures using PHP. Download here the entire presentation including slides, PHP source code and MySQL stored procedure scripts.
The following main topics were covered:
MySQL Database Management Tools
MySQL Database SQL Language
Stored Routines Advantages
Stored Routines Disadvantages
Stored Procedure Definition and Examples
Declaring and Initializing Variables
Passing Parameters to Stored Routines
Stored Procedures Interaction with Database Tables
Stored Procedures for SELECT records
Stored Procedures for INSERT, UPDATE and DELETE records
Creating and using Cursors
Using Stored Procedures in PHP/MySQL Web Applications
Dr. Ernest Bonat, Ph.D. will start teaching a new course for Windows Applications Developers “Database Windows Applications Development Using MySQL and VB.NET”. This course starts on Feb/23/2009 and it’ll be hosting by Portland Community College (PCC), Southeast Center in Portland. This course provides students with the knowledge and skills need to develop real production database Windows applications using the MySQL 5.0 Open Source server and Microsoft VB.NET 2008 Express Edition. To learn more about this course look at the brochure sheet and register as soon as possible. If you have any questions feel free to contact Dr. Bonat at any time you need.
Please, if you are interested in Open Source technology LAMP, you can’t just miss this course!
Visual WWW was hired by Voter
Power to develop and host their website. Voter
Power's website is pure Open Source Technology LAMP,
as a Content Management System (CMS).
Stored Scheduling Department from Kroger
- Fred Meyer (Portland Offices) hired Visual
WWW to develop a "Labor Management Criteria Maintenance
System" and teach his employees with the latest Windows
programming technologies using Microsoft VB.NET 2005 / IBM