Terminé

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.

Compétences : HTML, MySQL, PHP, SQL, Design de site internet

en voir plus : 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

Concernant l'employeur :
( 3 commentaires ) Hamilton, India

Nº du projet : #17980209

Décerné à:

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

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% CAD en 1 jour
(394 Commentaires)
6.6

11 freelance font une offre moyenne de $22 pour ce travail

florinbacu

_____________________________________________________________________________________________________

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% CAD en 1 jour
(28 Commentaires)
6.0
testotorko

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 3 jours
(54 Commentaires)
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% CAD en 1 jour
(21 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% CAD en 1 jour
(9 Commentaires)
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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% CAD en 1 jour
(2 Commentaires)
2.1
bexono

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% CAD en 1 jour
(0 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 2 jours
(0 Commentaires)
0.0
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% CAD en 1 jour
(0 Commentaires)
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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% CAD en 3 jours
(0 Commentaires)
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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% CAD en 1 jour
(0 Commentaires)
0.0