php and sql project

Lengkap Disiarkan 5 tahun lepas Dibayar semasa penghantaran
Lengkap Dibayar semasa penghantaran

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 Reka Bentuk Laman Web

ID Projek: #17980209

Tentang projek

11 cadangan Projek jarak jauh Aktif 5 tahun lepas

Dianugerahkan kepada:

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 dalam sehari
(394 Ulasan)
6.6

11 pekerja bebas membida secara purata $22 untuk pekerjaan ini

florinbacu

_____________________________________________________________________________________________________

$20 CAD dalam sehari
(28 Ulasan)
6.0
testotorko

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

$30 CAD dalam 3 hari
(54 Ulasan)
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 dalam sehari
(21 Ulasan)
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 Lagi

$15 CAD dalam sehari
(2 Ulasan)
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 dalam sehari
(0 Ulasan)
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 Lagi

$30 CAD dalam 2 hari
(0 Ulasan)
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 Lagi

$30 CAD dalam 3 hari
(0 Ulasan)
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 dalam sehari
(0 Ulasan)
0.0