Closed

Quick PHP and MySQL update pages

This project was awarded to stephhw01 for $50 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Project Budget
$30 - $100 USD
Total Bids
4
Project Description

Hello there,

I have a very small project which I would like to be completed as soon as possible. Here are the details.
---------------------------------------------------------------------
PHP & MYSQL update screen

The structure of the MySQL database is included in this post '[url removed, login to view]'.
The structure of the second page that contains 2 frames is also included in [url removed, login to view], it would be beneficial to have this template open when reading the requirements below.

There are 2 main pages to be developed.

---------------------------------------------------------------------
PAGE1

#1 - Simple secure login page - Connects to the ~USERS~ table, verifys the USER_LOGIN and USER_PASS.

#2 - Starts a PHP Session with USER_ID being passed as a variable to page 2.

---------------------------------------------------------------------
PAGE2 ( [url removed, login to view] )

#1 - This page contains 2 frames side by side. As the page loads it connects to the ~PRODUCTS~ table and selects the first record with ATT_ID = 0.

#2 - The left hand frame then loads the url stored in PROD_URL.

#3 - The right hand frame loads the following details in text boxes.

~PRODUCTS~
prod_id
prod_sdesc
prod_ldesc
prod_type
prod_thumburl

using the SITE_ID value the following details are also listed in the text box from the ~SITES~ table

~SITES~
site_name
manu_id
site_sdesc
site_ldecs
site_bannerurl

#4 - Underneath all of these text boxes 6 sets of radio buttons will reside. Each one of these radio buttons will have values 1 or 0.

#5 - UPDATE button. This update button will update the MySQL database with the *ALL* new values in the text boxes - and it will also create a NEW record in table ~ATTRIBUTES~

~ATTRIBUTES~
cat1
cat2
cat3
cat4
cat5
cat6

With either 1 or 0 depending on the radio button selections,

~ATTRIBUTES~
user_id

with the user_id of the person logged on and

~PRODUCTS~
att_id

the new record att_id associated with the product.

#6 - And finally their will be a button called NEXT which will search for the next record in ~PRODUCTS~ with ATT_ID = 0.

---------------------------------------------------------------------

Well hopefully this isn't too complicated, I can be contacted by email with any questions and queries. I could do this myself but at the moment don't have the time and would like a CHEAP AND QUICK JOB.

No formatting of any kind is required and the HTML template attached as a zip file can be used for the final thing.

PHP and MySql must be used.

Thanks,

Nick.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online