已完成

php and sql project

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, 网站设计

查看更多: music project php sql, project php sql, php sql project proposal, free download php projects with mysql, 1000 projects in php free download, php projects with source code and documentation free download, php projects for students, php projects ideas, major projects in php with source code, complete php/mysql project, php projects free download zip, calendar php sql project, develop php sql project, download php sql project chat, management system project php sql, onlineexamination project php sql, organize php project html php sql, php sql free project, php sql hotel reservation demo project, php sql project proposal cost

关于此雇主:
( 3个评论 ) Hamilton, India

项目ID: #17980209

授予:

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 在1天内
(394条评论)
6.6

11 威客就此工作平均出价 $22

florinbacu

_____________________________________________________________________________________________________

$20CAD 在1天里
(28条评论)
6.0
testotorko

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

$30 CAD 在3天内
(54条评论)
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

$20CAD 在1天里
(21条评论)
4.4
Jinxuetian

Dear Hiring Manager, Thank you for reviewing my proposal.I am a web developer and designer having 8 years of experience who can definitely complete this project as per your [login to view URL] schedule a small meeti 更多

$15CAD 在1天里
(9条评论)
3.7
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 更多

$15CAD 在1天里
(2条评论)
2.1
bexono

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

$20CAD 在1天里
(0条评论)
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 更多

$30 CAD 在2天内
(0条评论)
0.0
$25CAD 在1天里
(0条评论)
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 更多

$30 CAD 在3天内
(0条评论)
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

$15CAD 在1天里
(0条评论)
0.0