Transcript PPTX

Useful Project Instructions
CSE
4701

Download XAMPP



XAMPP includes: Apache, PHP, MySQL, and other goodies.
No need to download and install them separately, XAMPP
does it all.
Download: https://www.apachefriends.org/download.html
FAQs (Includes instructions on how to install it and set it
up):
 Windows FAQs:
https://www.apachefriends.org/faq_windows.html
 OSX FAQs: https://www.apachefriends.org/faq_osx.html
 Linux FAQs: https://www.apachefriends.org/faq_linux.html
Project-1
Useful Project Instructions
CSE
4701

Download Aptana Studio



Aptana Studio is a web development IDE rooted on Eclipse.
You can use your preferred IDE for the project, it does not
need to be Aptana.
Download:
http://www.aptana.com/products/studio3/download.html
You can download Aptana Studio 2, 3 or either as an Eclipse
plugin. For the instructions on this guide, we will use the
standalone (not the Eclipse plugin) version of Aptana Studio
3.
Project-2
Useful Project Instructions
CSE
4701

Sample API (Slim Framework)




Slim is a PHP micro framework that helps you quickly write
simple yet powerful web applications and APIs.
Slim Framework documentation:
http://docs.slimframework.com/
See : TBD
Sample GUI Web-App (for CRUD operations)


A sample CRUD (Create, Read, Update, Delete) web-app
that interfaces with the MySQL database to use.
See : TBD
Project-3
Setting up a Sample DB
CSE
4701

XAMPP bundles in PhpMyAdmin
(http://www.phpmyadmin.net/home_page/index.php)
Project-4
Set PhpMyAdmin web-app
CSE
4701


Go to: http://localhost/phpmyadmin
If you don’t use Port 80 – Use
http://localhost:{yourport}/phpmyadmin; where
{yourport} is the custom port.
Project-5
Setting up the Sample API
CSE
4701


Add sample_api, to you XAMPP’s htdocs folder
With sample_api in place:







Open Aptana Studio (or your IDE)
Click File -> Import
Select Existing Folder as New Project
Select a folder. Navigate to your
C:/xampp/htdocs/sample_api folder
Give the project a name
Select PHP and Web - Primary as the project types
Click on Finish
Project-6
Sample_gui – customers.php
CSE
4701
Project-7
Sample_gui – employees.php
CSE
4701
Project-8
Sample_api – index.php
CSE
4701
Project-9
Sample_api – index.php
CSE
4701
Project-10
Sample_api – index.php
CSE
4701
Project-11
New sample_gui_v02.zip
CSE
4701




sample_gui.zip. now contacts the sample_api via
(/customers; /employees) and grabs the result, decodes
JSON into a PHP variable, and then loops
The important code there is this:
$jsonResponseAllEmployees =
http_get("http://localhost/sample_api/employees",
array("timeout"=>1), $info); // Need PCL for this
$array = json_decode($jsonResponseAllEmployees);
The function http_get creates a GET request to the
URL specified in the first parameter and grabs
whatever the response is and stores it into the
$jsonResponseAllEmployees

$info variable contains info on the request itself (not
the response) in case debugging is necessary
Project-12
Sample_gui_v02 – customers.php
CSE
4701
Project-13
Sample_gui_v02 – employees.php
CSE
4701
Project-14
Sample_gui_v02 – employees.php
CSE
4701
Project-15