1 / 11

My First php Project

My First php Project. A VFP programmer’s experience learning php. What is php ?. Php stands for php hypertext preprocessor. Enjoy the recursive acronym? Originally, it was personal home page, but it has grown to much more than that. It is a language used for developing web pages.

yoko
Download Presentation

My First php Project

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. My First phpProject A VFP programmer’s experience learning php

  2. What is php? • Php stands for php hypertext preprocessor. Enjoy the recursive acronym? Originally, it was personal home page, but it has grown to much more than that. • It is a language used for developing web pages

  3. Introduction to the Project • Interviewing Wounded Warriors over six years to discover Quality of Life. • Participants log on to web site and answer questions every six months. • Data are collected and transferred to SQL Server back end. • My mission is to learn the existing application, take over maintenance, and eventually start enhancing system.

  4. Other tools I started using or may want to learn. • NetBeans – an IDE that gives hints and intellisense while developing • PostgreSQL and mySQL (web side Databases) • Javascript • JQuery • Virtualbox • WampServer (Windows Apache MySQL Php) • Ipswitch WS_FTP

  5. How to proceed? • You eat an elephant one bite at a time. • I’ll choose a piece which coincides best with my experience. • Designed and built a SQL Server database to store relevant data. • Began to modify the process that exports data from PostgreSQL to SQL Server.

  6. Current process • Five separate buttons to generate text files • First button exports answers and takes 25 minutes • Buttons must be done in order for parameters to be kept from previous button. • Requires entering dates and users each time • Open text files in Excel to review • Run SSIS to import into SQL Server

  7. New process • One button • No parameter entry required • Puts all data directly into Excel spreadsheet • Run SSIS to import into SQL Server_

  8. Transition • Can you get there from here? • Show the current code in NetBeans • Building a where clause • Row processing • Filtering by evaluating each row • Show the revised code in NetBeans • Build a view which implements the where clause • Set processing • Filtering prior to evaluating

  9. Lessons learned • Not as daunting as I thought it would be • VFP skills that are applicable to php • Database design (first and foremost) • Test-driven programming technique • Optimizing queries • Not null vs (‘yes’ or ‘no’ • Length($studyno) = 5 • Order of tables (most limited % result sets first) • Looping • Case • While • Foreach

  10. Lessons learned (continued) • Syntactical differences • Brackets • Semi-colons • incrementing • Debugging is more difficult (but may improve with acquiring knowledge) • Xdebug • Xxdebug • Var_dump • echo

  11. Future opportunities • Create tables to mimic SQL database in PostgreSQL • Revise code to populate SQL tables • In parallel ? • Using triggers in PostgreSQL? • Acquire knowledge of debugging tools

More Related