Home » Dynamic programming with MySQL and PHP

Dynamic programming with MySQL and PHP

 
This assignment involves dynamic programming with MySQL and PHP (ch 18 and 19 Internet and world wide web 5th edition). The main activities you need to implement is to create a database connected web application. In this project, you will do listing, deletion, and insertion to a table in a MySQL database. This link http://mycoursework.mywebcommunity.org/p3/ shows a solution for this project using Student table (also a video is attached) In your project, you will use another table of your choice.
Project Description: Choose a data table similar to Student table. You cannot use Student table for this project. The data table could be about anything you want, such as movie, book, business, companies, song, cars, etc. Create this table in your MySQL database. You can use phpMyAdmin or your can use MySQL command. The data table will have at least 10 rows, and 5 columns. Note that my example of Student has 14 rows, and 6 columns.
Second step is implementations of the web applications in five steps:
#1 Implement a html page as index.html. This is main (landing) page listing all four operations (list, list with condition, search, insert).
Requirements about search box (#4): This is a form action without new line. The form action method is POST.
Hint:

#2 This is first link of index.html to list your data in a different .php page. You should list at least three column of the table. The data will be shown in html table. I listed SID, Fname, Lname in Student example in a table (

Don't use plagiarized sources. Get Your Custom Essay on
Dynamic programming with MySQL and PHP
Just from $13/Page
Order Essay

). Also, you should have “Delete” link to delete a row. This delete method should be implemented as “GET” method.
Hint: Delete
After listing all record, give a message saying how many records found in the data table, such as “14 student(s) records found.”
#3 Implement a .php page to demonstrate a conditional listing, such as Student from TX. You may choose any condition on your data, such as customers in Canada, products more expensive than $10, movies produced in 2010, etc.
#4 Implement a search box as a list item as demonstrated in video.
#5 Implement a .html / .php combination to insert new record to data table. The html (data collection) page should mandate at least there fields, as demonstrated in the video
Hint: HTML 5 support required keyword, such as  
All sub-pages should include a link to main / landing page.
Please use the link given above as a sample solution. And give me all project files (html, css, php),

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more
Live Chat+1(978) 822-0999EmailWhatsApp

Order your essay today and save 20% with the discount code BEGOOD