I gang

Database Editing Web Page for Two Table Database

Web page which allows a user to view and edit a simple database consisting of 2 tables with a one-to-many relationship.

Using: PHP/HTML and MySQL and AJAX protocols

The database consists of only 2 tables. The Accounts table is the master and contains a user's email address as the unique key, and several other attributes.

The Purchased table is the detail and uses the [url removed, login to view] as the foreign key. There can be many rows in the Purchased table for each row in the Accounts table.

The web page will include these features:

- the page shall be LIVE using an Ajax/Web 2.0 style (ie. selecting a new record, or editing a record, should never refresh the web page)

- the code shall be written using a combination of the following: HTML/PHP/Javascript/MySQL - no other tools or pre-built frameworks shall be used without prior approval

- a Logo at top left (the size is 128x128)

- a title, centered, at the top "Panna Giveaway Database"

- a table showing the contents of the Accounts table will take up most of the page

- the table will include the following columns:

- emailAddress

- secretCode *4 digit number - column header "PIN"

- originalCredit *no formatting - column header "Original Credit"

- creditAmount *no formatting - column header "Remaining Credit"

- oneTimeOnly *Column should display "Yes" or "No"

- when the page opens, the first row in the table should be "selected"

- the table should be sorted by emailAddress

- the bottom third of the page should show the related data from the Purchased table for the row selected in the Accounts table view

- when the user selects a different row in the table of Accounts (either by clicking or using up/down arrow keys) the Purchased table list should update to show the purchased data for the new selected row

- the Purchased table list should include the following columns:

- storeSKU *column header "Issue SKU"

- timeStamp *column header "Date Purchased"

The user should be able to perform these actions using buttons placed in convenient, logical places.

- for the Account table

- Add button

- Delete button

- Edit button

- clicking this button should allow the user to edit

- secretCode

- originalCredit

- creditAmount

- oneTimeOnly * should be presented as a Dropdown Combobox with the two options "Yes" or "No"

- once the user is in editing mode, two new buttons should be available - "Save" and "Cancel"

- for the Purchased table

- Delete button

- Add button

- if the user clicks the add button, the user should be asked to provide the storeSKU value

- two new buttons should be available - "Save" and "Cancel"

- the row should be added when the user clicks "Save"

- there should be NO EDIT BUTTON, this data is not editable

Attached are SQL scripts to create the tables and add sample data. You are expected to develop and test the page on your own server using this schema and sample data. When the work is completed, the page will be delivered with all required associated files and we will install it on our servers.

The code should be well documented and commented.

At the top of the page there should be a set of variables which define the database, user credentials and server for easy modification. Below is an exmaple - please use these variable names, just like in the example.

Example:

/** MySQL Login Credentials **/

$mysql_host = "localhost";

$mysql_database = "panna_giveaways";

$mysql_user = "panna_user";

$mysql_password = "pannaPassword";

Please see attached file sqlScripts.zip - this contains 2 SQL script files which will create the 2 tables and populate them with sample data.

Færdigheder: AJAX, MySQL, PHP

Se mere: database editing table html, database table edit web page, php mysql table login, web page scripts, web page php develop, web page create in html, web master develop, two sample logo, top ajax frameworks, tools to create logo, sorted data set, scripts web page, scripts for web page, schema update, names style editing, names editing, list of ajax frameworks, javascript ajax frameworks, html code to develop a web page, frameworks ajax, features of a web page, develop a web page, create your own web logo, create your own php style, create web page logo

Om arbejdsgiveren:
( 7 bedømmelser ) Marina del Rey, United States

Projekt-ID: #4042756

Tildelt til:

sapewady

I can deliver the job as required. Please check your private message.

$250 USD in 3 dage
(3 bedømmelser)
3.8

29 freelancers are bidding on average $398 for this job

NetzPro

Dear Sir, We would love to get this opportunity of working with you. We can guarantee that you will not regret your decision if you select us to execute this project. Regards NetzPro

$600 USD in 5 dage
(341 bedømmelser)
8.4
manpreet

We are experts in PHP.

$300 USD in 5 dage
(203 bedømmelser)
8.2
webhawks

Its a nice thought how you explained your Job. It will be nice if you kindly check your PMB. Thanks

$400 USD in 8 dage
(96 bedømmelser)
7.3
rajeshsonisl

Quality work assured. Ready to get started. Thanks.

$1000 USD in 4 dage
(376 bedømmelser)
7.0
netxpertindia

We will develop this system in php and mysql.

$350 USD in 10 dage
(76 bedømmelser)
6.6
shihan033010

Hi please check inbox.

$350 USD in 10 dage
(228 bedømmelser)
6.3
vertexsolutions

I am interested and offer you my services, Thanks.

$400 USD in 5 dage
(112 bedømmelser)
6.2
solution4you

I will be happy to develop this form for you using technologies you specified. Hope to do busisness with you. Thx !

$330 USD in 8 dage
(91 bedømmelser)
5.6
phpxpert89

Hello Dear Employer, I have checked mysql schema files of accounts table and purchased table from [url removed, login to view] I am a Custom PHP/MySQL developer. I have designed and developed, many websites on PHP amd MySQL. I Mere

$500 USD in 8 dage
(23 bedømmelser)
5.6
gkuizinas

I have the technical knowledge and experience needed to undertake your project. Refer to the PMB for technical details.

$1000 USD in 10 dage
(25 bedømmelser)
5.3
khalidamin

Hi, I have 16+ years of experience in database programming, along with extensive experience in web 2.0 programming. A professional quality product is what you get in the end. I look forward to creating the user interfa Mere

$500 USD in 14 dage
(42 bedømmelser)
5.1
coolrankit

------ 2YEARS EXPERIENCED PHP, WORDPRESS, CSS & WEB DEVELOPING EXPERT ------

$300 USD in 5 dage
(19 bedømmelser)
5.1
lokjaiswal12

Hello, Please check PMB.

$335 USD in 5 dage
(38 bedømmelser)
4.7
webangel1

i am ready to start work, Please check pmb, Thank You

$380 USD in 7 dage
(22 bedømmelser)
4.5
abupabuya

hi sir im an expert web developer

$250 USD in 7 dage
(15 bedømmelser)
4.5
logomafia4u

Don't really want to bore you with our profile. If you are interested to see our competitive advantages, please check here : [url removed, login to view] Just a quick note Mere

$500 USD in 10 dage
(7 bedømmelser)
4.4
Rafflesitpark

Please check PM

$300 USD in 7 dage
(16 bedømmelser)
4.4
javakapil

Hi Sir, Your Requirements are crystal clear. We are please to tell you that we have team of professional website designer and developers. we would be happy to get your project done with full satisfaction and per Mere

$550 USD in 10 dage
(8 bedømmelser)
3.8
devstefan

Hi please see PMB

$250 USD in 10 dage
(5 bedømmelser)
2.5
karttechnologies

Hello sir, I can do it for serious budget $270 and ready to start . waiting for your message . Kind regards.

$270 USD in 15 dage
(1 bedømmelse)
2.2