php and sql project

Completed Posted 5 years ago Paid on delivery
Completed Paid on delivery

For this assignment, you are to create a PHP web app that lets a single user log in and manage (i.e. view, add, remove, and modify) the contents of a table stored in a MySQL database. The default idea is to create a “collection manager” to manage some collection of objects (i.e. coins, vinyl, blog posts, etc.) The Data Table Your table must have at least 6 fields, one of which must be a primary key. You must make use of each of the four main data types: Int, Varchar, Text, and Date. When you hand in, your database should have at least 10 records in it. Tip: Pick a type of object or thing that you care about or are interested in. It will make it easier to motivate yourself to work on this assignment. Logging In and Out The index page of your site should present the user with a login form. This form should redirect to a page that “logs in” the user by checking the id and password against a pair of hard-coded values. If the login is successful, use the $_SESSION object to keep track of the fact that the browser is logged in. If someone tries to load any page other than the login page without logging in first, they should get an error message. It should be possible to log out when the user is finished. Managing the Table It is up to you how to structure the table management part of your site. However, it must be possible to view the records in some sorted order, search (by at least one field), insert a new record, delete a record, and update a record. It might be possible to do all of this on a cleverly-designed single page, or you might prefer to use multiple pages. If you decide to use multiple pages, make sure that it is easy to navigate back and forth. Design a “main view” page with links to each of the other pages, and return the user to this page after each operation. Your app should be as user friendly as possible. They should be able to choose items to update or delete with a click, and when they update, at the very least, they should get a form with the original values from the database already filled in. Security All parameters should be retrieved using the appropriate call to filter_input. All SQL queries should be prepared using parameters to avoid SQL Injection attacks. All exceptions and errors should be caught and handled gracefully. The user should never be exposed to a raw error or warning from the PHP interpreter.

HTML MySQL PHP SQL Website Design

Project ID: #17980209

About the project

11 proposals Remote project Active 5 years ago

Awarded to:

rohitagarberg

hi sir, i will create the table with the six columns and write php script using which user can perform the operations on the table, i will complete in 48 hrs for 25 CAD, ready to start now, thanks

$25 CAD in 1 day
(394 Reviews)
6.6

11 freelancers are bidding on average $22 for this job

florinbacu

_____________________________________________________________________________________________________

$20 CAD in 1 day
(28 Reviews)
6.0
testotorko

Great professional with clarity in specification. Excellent communication skills and payment promptness. For sure will work for him again.

$30 CAD in 3 days
(54 Reviews)
5.4
alphatech786

Hi I have great experience in web development, php and database management and i can handle it according to your requirements Please inbox me for more details. Thanks

$20 CAD in 1 day
(21 Reviews)
4.4
SherifShahawy

Hello sir, I would love to take and complete your job, I like how everything is explained , i understood everything and i am ready to work starting now. I will work in PHP , mySQL and HTML/CSS/Bootstrap I hope you More

$15 CAD in 1 day
(2 Reviews)
2.1
bexono

Please give me this task, I will perform best, honestly, I need a rating as I am new freelancer here.

$20 CAD in 1 day
(0 Reviews)
0.0
avigd

Hi this is easy job. Give me the job will finish in 2 days. Will build using PHP, MySQL and Bootstrap for design. Could build the site using these if you need them:- - PHP PDO - PHP SPL - Standard PHP Libr More

$30 CAD in 2 days
(0 Reviews)
0.0
mrhammadrauf

Hi We are team of web developers with over 3 years of experience. We can make this website in php which will connect with data base. Give me the opportunity to work with you. We can discuss bid and deadline, we wil More

$30 CAD in 3 days
(0 Reviews)
0.0
Abhijeet301192

I can complete this project in a day with minimum cost including your all requirement. Relevant Skills and Experience I am very good with database and asp.net ,php which is required in this project

$15 CAD in 1 day
(0 Reviews)
0.0