In Progress

Small Project PHP/Mysql - URGENT


Using PHP and MYSQL, you will create a course application system.

Step 1. Create a database that has 3 tables, Student, Course and Enrolment.

The layout should be –

Student table:

Given varchar 50 characters

Family varchar 50 characters

StudId AutoIncrement Primary Key

Enter Numeric Integer

VTACld Numeric must be 9 digits – probably varchar in the database

PreferredCourse Ingeger (course cose of preferred course – foreign key)


Title varchar 80 characters

Level varchar 15 characters

Duration Number Integer

CourseId AutoIncrement Primary Key

EnterReq Integer

Places Integer

Create a course application system

The first page will allow administrators or applicants to choose the level of access.

Administrators require password protections/authentication. The userid /Password for administrators needs to be admin /admin


Administrators enter a course level, Title Enter requirement and number of places available in the course. Administrators need a way to enter new courses – this must apply some protection such as a password to restrict access to authorized administrators.

The duration is a period in months of full-time study.

The level is Certificate II, III or IV, Diploma, or Bachelor.

Cert II is 6 month duration

CertIII is 12 month duration

CertIV is 18 month duration

Diploma is 24 months duration

Bachelor is 36 months duration

Applicants need to be able to enter their details and An applicant must be able to choose a course.

The applicant must have a sufficient ENETR score.

So if there is a course called Dip IT NET Eng with an Enter of 60 and a student has an Enter of 50, that student must be informed that the student has not met the required Enter score and NO record saved. If the student has a sufficient Enter score, a record should be kept in the student table.

You need to use a tool such as phpMyAdmin to create the tables and populate the course table with data.

I similar examples if you need them.

All code needs comments or documentation and has to be well presented.

Skills: PHP

See more: preferred admin, php create table, mysql data access, create table php, php courses, urgent requirement, urgent mysql, time study, project page, primary, period, numeric, new characters, mysql, mysql admin, met, diploma, dip, courses, cert, c mysql, admin php, php data table, small data table, mysql characters

About the Employer:
( 1 review ) Melbourne, Australia

Project ID: #34874

Awarded to:


Sure can do it. Please contact me soon.

$300 USD in 2 days
(20 Reviews)

3 freelancers are bidding on average $267 for this job


hi there, I will deliver you this on sunday mornng with complete testing and everything! to know more about us plz visit [url removed, login to view] am ready to start now, do you have a IM?

$200 USD in 1 day
(1 Review)

Hi we have a big team in PHP with us and are ready to do your project and finish it in by [url removed, login to view] have a look on PMB

$300 USD in 2 days
(0 Reviews)