Dynamic Websites using PHP and MySQL

These sites were all built using the LAMP software stack. All these sites use a PHP processor module, which generates the web page document achieving complete separation between design and the content presented. The data is all stored in a MySQL relational database management system (RDBMS). Website versioning through subversion ( tortoise svn). All graphics were designed using Photoshop.

*Some of these sites are being being rebuilt using a responsive design for Mobile use – they will also have all social connection to Facebook and Twitter

www.yorkbia.com

Site built using the LAMP stack of Linux, Apache, MySQL and PHP – with JQuery Libraries and AJAX, Flash, CSS, DHTML and JavaScript. Other technologies used: PHP CAPTCHA, Google Map integrations, two WordPress blogs and Picasa Integration.

Development

Performed full life-cycle development including;  (1) Full Analysis: Working with all Stakeholders in the association (over 300 businesses) using all viewpoints and perspectives.  (2) Specification Building: Building modules of the site including general layout, site navigation and dynamic parts of the site included in the spec sheet.  (3) Design and development: Layouts and navigation were designed along with the MySQL database with all the data structures and sample data.  (4) Coding: Added code without disturbing the design prototype. (4) Full Beta testing on the test server before going live.

Design

  • All images, icons were created using Abode Photoshop and Adobe Illustrator CS.
  • Normalized MySQL database on a Linux/Apache platform created, updated and maintained using the MySQL’s ER modelling tool MySQL Workbench.
  • PHP hand coded using NetBeans and Dreamweaver (for folder syncing).
  • Social Networking Integration with Facebook, Twitter, Foursquare, Gowalla, Yelp and MySpace.

The Cloud

Fully Integrating Google Apps for the yorkbia.com domain using Google’s servers as their company mail servers including POP access to allow for full e-mail backup into Outlook.  Setup of all mail forwarding and Auto Responses etc. Created HTML E-mail Templates to increased interactivity with their customers.

All business and store database and work-flow is updated and stored in Google Docs.

Web Analytics

Incorporated full Google web analytics integration and created basic training manual for all Admins, businesses and staff. The admin have access to three dashboards – a mobile dashboard, AdWords dashboard including Keyword analysis, a  Business Profile dashboard tracking all the businesses in the BIA and which are performing well with which keywords and which are not and lastly a basic Pageview, Bounce etc Dashboard.

www.accommodationsinbc.com

Site built using the LAMP stack of Linux, Apache, MySQL and PHP – with Open Source JQuery Libraries and AJAX, CSS, DHTML and JavaScript. Other technologies used: PHP CAPTCHA, Google Map integrations and Picasa Web Integration.

Development

  • Performed full life-cycle development (As above).
  • Created all PHP pages, Web Forms, Paypal integration, Javascript and jQuery library, full social network integrations using “AddThis”

Design

  • All images and icons were created using Abode Photoshop and Adobe Illustrator CS.
  • Normalized MySQL database on a Linux/Apache platform created, updated and maintained using the MySQL’s ER modelling tool MySQL Workbench.
  • PHP hand coded using Notepad++ and Dreamweaver (for folder syncing).

E-Mail

Fully Integrating Google Apps for the accommodationsinbc.com domain using Google’s servers as their company mail servers including POP access to allow for full e-mail backup into Outlook.  Setup of all mail forwarding, Auto Responses and created HTML email Templates to increased interactivity with their customers.

Web Analytics

Incorporated full Google web analytics integration and created basic training manual for all Admins, businesses and staff.

www.bettenhauscanada.com

Site built using the LAMP stack of Linux, Apache, MySQL and PHP – with Open Source JQuery Libraries and AJAX, CSS, DHTML and JavaScript.

Development

Performed full life-cycle development including;  (1) Full Analysis: Working with business owners  using all viewpoints and perspectives.  (2) Specification Building: Building modules of the site including general layout, site navigation and dynamic parts of the site included in the spec sheet.  (3) Design and development: layouts and navigation were designed along with the MySQL database with all the data structures and sample data.  (4) Coding: added code without disturbing the design prototype. (4) Full Beta testing on the test server before going live.

Design

  • All images and icons were created using Abode Photoshop and Adobe Illustrator CS.
  • Normalized MySQL database on a Linux/Apache platform created, updated and maintained using the MySQL’s ER modelling tool MySQL Workbench.
  • PHP hand coded using Notepad++ and Dreamweaver.

E-Mail

Fully Integrating Google Apps for the bettenhauscanada.com domain using Google’s servers as their company mail servers including POP access to allow for full e-mail backup into Outlook.  Setup of all mail forwarding, Auto Responses and created HTML email Templates to increased interactivity with their customers.

Web Analytics

Incorporated full Google web analytics integration and created basic training manual for all Admins, businesses and staff.

www.dbrs.com

Worked in collaboration with a team of five to create this PHP site. Worked on creating the XML output for the RSS feeds and the basic version of the site for Mobile use.

Development

Site built using the LAMP stack of Linux, Apache, PHP. The database used is a Normalized Oracle database. The team used Subversion (Tortoise SVN) with Symfony Open-Source PHP Web Framework.

www.rapidremittance.com

Site built using the LAMP stack of Linux, Apache, MySQL and a CMS, web-based interfaces was developer using MySQL to allow administrators to manage daily currency exchange rate and update store Location content on the web site. The site also uses security access with an SSL order form to register new members

Development

Performed full life-cycle development including;  (1) Full Analysis: Working with Business Owners  using all viewpoints and perspectives.  (2) Specification Building: Building modules of the site including general layout, site navigation and dynamic parts of the site included in the spec sheet.  (3) Design and development: layouts and navigation were designed along with the MySQL database with all the data structures and sample data.  (4) Coding: added code without disturbing the design prototype. (4) Full Beta testing on the test server before going live.

Design

  • All images, icons were created using Abode Photoshop and Adobe Illustrator CS.
  • Normalized MySQL database on a Linux/Apache platform created, updated and maintained using the MySQL’s ER modelling tool MySQL Workbench.
  • PHP hand coded using Notepad++ and Dreamweaver.

E-Mail

Fully Integrating Google Apps for the rapidremittance.com domain using Google’s servers as their company mail servers including POP access to allow for full e-mail backup into Outlook.  Setup of all mail forwarding, Auto Responses and created HTML email Templates to increased interactivity with their customers.

Web Analytics

Incorporated full Google web analytics integration and created basic training manual for all Admins, businesses and staff.