19/04/23E.R.Edwards 19/04/23 Staffordshire UniversitySchool of Computing

Easy PHP Available from - http://www.easyphp.org/ Local service on your machine Works from a data stick. It provides

– An apache web server (already functioning)– MYSQL server (already functioning)– PHP language development environment

Can be added to by ‘Modules’ eg– Content Management System – wordpress– Prestashop – e-commerce site– PHPMyAdmin – MySQl admin system

19/04/23E.R.Edwards 19/04/23 Staffordshire UniversitySchool of Computing

EsyPHP Admin Menu

19/04/23E.R.Edwards 19/04/23 Staffordshire UniversitySchool of Computing

MySQL Admin System

19/04/23E.R.Edwards 19/04/23 Staffordshire UniversitySchool of Computing

Code to Access MS ACCESS database

<?php$adoCon = new COM("ADODB.Connection");$sHere = dirname(__FILE__);Try{ $adoCon->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data

Source=$sHere/uidb2.mdb");}catch(Exception $e){ die('Sorry - Problem opening the database.<br />');}

Code to do things goes in here

$rsMain->Close();$rsMain = null;

$adoCon->Close();$adoCon = null;

?>

19/04/23E.R.Edwards 19/04/23 Staffordshire UniversitySchool of Computing

Code to access MYSQL file<?PHP

//try to connect to the database$con = mysql_connect("127.0.0.1", "test", "pass") or die("Failed to connect to DB, " . mysql_error() );$tiggerDB = mysql_select_db('modulemanager', $con) or die('Could not find database -die.');//Insert staff details into staff tabletry

{$tiggerDB =mysql_query ("INSERT INTO STAff (Username,Forename,Surname,Password,TelNo,Room) VALUES

('$Username','$Forename','$Surname','$Password','$Telno','$Room')"); }

catch(Exception $e){echo 'Sorry - details not enetered onto database <br />';}

mysql_close($con); header("Location: StaffList.php");

?>

19/04/23E.R.Edwards 19/04/23 Staffordshire UniversitySchool of Computing

Files in ..\www\SES

Class lists used by lectures– ClassListForm.htm fires ClassList.php – StudentTimetable.htm fires

StudentTimetable.php

Possible Improvements (if you are mad!)– Student online registration form?– Web based group list modification system.