Build a Website with database and php

Completed Posted 7 years ago Paid on delivery
Completed Paid on delivery

• Develop a website to provide information about short courses at a College.

Must be made to run on my xampp server with mysql, php, etc.

*Write an SQL script to set up a table course in a database college, with fields for a unique id, code, name, subject, instructor, weeks and description.

o code is a typical course code such a LIT101

o name is the name of the course e.g. English Literature in the 18th Century

o subject is the genera subject area e.g. Literature

o instructor is the name of the instructor

o weeks is how long the course runs for e.g. 8 weeks.

o description is a paragraph or so describing the course content

• Also setup a user table in the SQL script (same database) with id, username and password (encrypted with SHA), and add a user (in the script) called admin and password abc123. Do not include any other fields in this table.

*• Each webpage must be 1000px wide, centered in the browser window, using a wrapper div to contain all content.

*It must have a banner across the top 100px high with College title.

*Each page has a horizontal navigation below the top, 30px high, with links to Home, , Courses, Subjects, Instructors, Add, Register and Login.

• Home is the home page ([login to view URL]). This page needs to have some content to fill up some space. Lorem ipsum will do.

• Register ([login to view URL]) needs a form to register new users, with a processing script.

• Login ([login to view URL]) has the login form. Use session management. Once logged in the admin user can access the Add page (described below).

• Add ([login to view URL]) is a form to add a new course. Only the admin user, logged in, can access this page. Include form elements for all fields (code, name, subject, instructor, weeks and description) except the id, which is generated by the database.

*Also write a script to add the data from the add form to the database.

• Courses ([login to view URL]) lists all courses created in the Add form ([login to view URL]) in an HTML table with column headings across the top. Don’t display the id or the description. The name is a hyperlink to a page [login to view URL], which displays all the data for the selected course. Use the id in the query string, not the course name.

• Subjects ([login to view URL]) lists each unique subject from the database as a hyperlink to a page [login to view URL], which uses a query string to display only the courses that belong to that subject.

• Instructors ([login to view URL]) lists each instructor from the database as a hyperlink to a page [login to view URL], which uses a query string to display only the courses taught by that instructor.

• Use separate files for common content and an external stylesheet

NEEDS to be completed within 12 hours please

HTML MySQL PHP Website Design

Project ID: #11606738

About the project

52 proposals Remote project Active 7 years ago

Awarded to:

arcdevsol

Hi, I am a full stack web developer. I can develop this application for you. I've actually written similar applications (education portal) before! I've developed web apps without frameworks as well as with frameworks. More

$100 AUD in 1 day
(145 Reviews)
7.8

52 freelancers are bidding on average $316 for this job

softsolution2000

I am ready to get started right away.... Can we discuss the project details? My distinction, payment after your complete satisfaction with the resulted task.

$377 AUD in 3 days
(384 Reviews)
8.5
mituld

Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks

$237 AUD in 10 days
(480 Reviews)
8.3
gopalvora

Hi I have gone through the details of your project and we find it well within our capabilities. I offer a wide range of services, including Web design, PHP/MySQL web application development, Open sources like Joo More

$185 AUD in 7 days
(557 Reviews)
8.4
eplanetsoftindia

We can create this website with database and php for you at very low cost as we have a team of experienced designers and developers. We want to have long term relations with our clients that's why working at very good More

$200 AUD in 7 days
(638 Reviews)
8.4
StdioRelations

======= EXPERTS HERE READY TO START ======= Hi, can u please discuss in details so that we can let you know the best time frame and cost :) we always work for client satisfaction so please initiate chat as soon as More

$263 AUD in 3 days
(164 Reviews)
7.4
anushriimathur

sir i follow your description. we will provide best solution for client and provide unlimited revision for all things till client satisfy. thanks. hoping for positive reply

$200 AUD in 7 days
(210 Reviews)
7.3
johnflash

Hi, i see you need a simple php site developed where courses can be registered by an admin user and these courses rendered on other pages for public viewing just as you described. I can get this done for you very qu More

$222 AUD in 2 days
(22 Reviews)
6.9
maxtechsl

Hello, I am ready to develop the website using PHP/Mysql in a professional manner as per requirement. I assure you quality work, regular work progress and support. Please open message board for further discussion and p More

$250 AUD in 3 days
(110 Reviews)
6.7
oliviainfotech

Hi greetings of the day I am a Experienced PHP Developer based out in Chennai,India. My experience revolves around development of web and mobile applications,Ecommerce websites. I believe that I am well qualified to un More

$250 AUD in 3 days
(110 Reviews)
5.9
usweblancers

Hi, We have gone through your requirements. We are sure we can fulfill your requirement 100%. Kindly message us for further discussion. Cheers Thanks, Naveen

$155 AUD in 3 days
(15 Reviews)
5.4
kotharigaurav90

Hello, i have checked your project and would like to have your project. I am confident to fulfill your requirements in timely manner, along with quality work. Please check your pmb.

$155 AUD in 3 days
(51 Reviews)
5.8
gracefulwork

hi, php mysql developer interested in doing this project for you. Thanks. _

$155 AUD in 5 days
(63 Reviews)
5.4
lidopih

Hello, I can make this project for you guided by you description. I have experience in creating custom systems from scratch. You can see it in my portfolio. If you are interested contact me on PM. I can make this syst More

$250 AUD in 10 days
(20 Reviews)
4.8
BespokeDMedia

Hello Sir, I have gone through your requirement for you need to develop a website with database and php and I am having 15 year of experience in the field of Web development and Web.I will complete your project wit More

$555 AUD in 10 days
(8 Reviews)
5.0
EmployerParag

hello, I understand your requirement and ready to develop the theme on your proposal. please respond for further communication for better understanding of project and faster working. thank you.

$250 AUD in 10 days
(16 Reviews)
4.2
harrysathe

Hello I am Harry I have 5 year of professional experience in software web application development .. we believe in work quality ,customer satisfaction and timely delivery projects for better and long time relationship More

$150 AUD in 15 days
(8 Reviews)
4.2
Zealous1987

Hello, I am Mangesh Shinde and I have read your requirements thoroughly. I am a experienced web developer with 5 years experience in PHP, MySQL, HTML, CSS, JavaScript. I have understood all the pages you want to creat More

$222 AUD in 8 days
(1 Review)
2.1
RashidAhsen

Hello. I will do this website for you. I have experience in buikding websites. I have command on php sql mysql xammp wammp html css etx. I will do it for you. Also, I will do SEO of your website for free. Waiting for y More

$111 AUD in 3 days
(1 Review)
0.8
gsujoydas123

Hi, I have seen your post. I can develop your collage website. I am a php developer and have experienced in MySQL, It will run in your xampp server. I have understood your whole requirements. Check my previous work More

$300 AUD in 10 days
(1 Review)
3.4
vishalrkcet

Dear Client, we have experience to develop such kind of project for more information see my portfolio. Thanks for providing us opportunity to place bid over the project and communicate with you. I am a serious bi More

$250 AUD in 20 days
(1 Review)
0.5