Build a Website with database and php
$30-250 AUD
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
Project ID: #11606738
About the project
52 freelancers are bidding on average $316 for this job
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.
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
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
======= 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
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
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
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
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.
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
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.
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
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
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
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
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