Em Andamento

Quick PHP and MySQL update pages

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.

Habilidades: Processamento de dados, PHP, Instalação de Script, Segurança na rede, Design de Sites

Ver mais: update email template, session php, quick text, php developed by, php create table, Mysql questions, login page create in php, job values, create table php, create mysql database using php, and mysql, mysql quick update, update record using button php mysql, update radio button result php mysql, php mysql update button, button update mysql, quick update php mysql, update radio button using php mysql, use radiobutton mysql php, mysql update quick, update database radio buttons php, update radiobutton php onclick, update radio button php using mysql, quick updates mysql php, php mysql radio buttons table

Acerca do Empregador:
( 0 comentários ) Moreton, United Kingdom

ID do Projeto: #141371

Premiar a:

stephhw01

A VERY IMPORTANT OFFER IS WAITING FOR YOU IN YOUR PM !

$50 USD em 0 dias
(41 Avaliações)
5.7

4 freelancers are bidding on average $71 for this job

seasonw

Hi, please check PM. Thanks!

$80 USD em 1 dia
(25 Comentários)
5.7
indiratech

We hope to take half day to complete 1st page and 1 day to complete the second page. I looks simple. We have expertise in PHP, MySQL and Flash. We completed one Educational project for a UK client using PHP and MySQ Mais

$75 USD in 2 dias
(0 Comentários)
0.0
vijay2404

I am Vijay Tambad from india. I have been working as a software developer for the last 4+ years. I have good experience in Visual Basic, Oracle, Mysql, PHP and database design. I have developed a similar kind of websit Mais

$80 USD in 3 dias
(0 Comentários)
0.0