mysql database form and email

Closed

Need:

1 Form with 14 fields to enter data to 14 mysql database fields and then say data successfully uploaded, with a button that says edit data, and a separate button that says email data.

2. then when edit button is pushed data shows up and can be edited

3. then when email button is pushed the form sends a formatted nice email with Data1, Data2, and Data3 in the formatted email to the email address that was input into the form.

this is the schema:

database: Bdatabase

user: mickey

host: localhost

password: turtle

table is: aa_Businesses

--

-- Table structure for table `aa_Businesses`

--

DROP TABLE IF EXISTS `aa_Businesses`;

SET @saved_cs_client = @@character_set_client;

SET character_set_client = utf8;

CREATE TABLE `aa_Businesses` (

`aa_UserID` mediumint(8) unsigned NOT NULL auto_increment,

`aa_Username` varchar(100) default NULL,

`aa_Email` varchar(255) default NULL,

`aa_Password` varchar(200) default NULL,

`aa_Name` varchar(100) default NULL,

`aa_SignupDate` datetime default NULL,

`aa_AccountBalance` decimal(8,2) default '[url removed, login to view]',

`aa_Points` mediumint(8) unsigned default '0',

`aa_Feedback` mediumint(8) default '0',

`aa_Street` varchar(100) default NULL,

`aa_City` varchar(100) default NULL,

`aa_State` varchar(100) default NULL,

`aa_Zip` varchar(100) default NULL,

`aa_Ranking` tinyint(4) default NULL,

`aa_Data1` varchar(250) default NULL,

`aa_Data2` varchar(250) default NULL,

`aa_Data3` varchar(250) default NULL,

PRIMARY KEY (`aa_UserID`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

SET character_set_client = @saved_cs_client;

## Deliverables

Need:

1 Form with 14 fields to enter data to 14 mysql database fields and then say data successfully uploaded, with a button that says edit data, and a separate button that says email data.

2. then when edit button is pushed data shows up and can be edited

3. then when email button is pushed the form sends a formatted nice email with Data1, Data2, and Data3 in the formatted email to the email address that was input into the form.

this is the schema:

database: Bdatabase

user: mickey

host: localhost

password: turtle

table is: aa_Businesses

--

-- Table structure for table `aa_Businesses`

--

DROP TABLE IF EXISTS `aa_Businesses`;

SET @saved_cs_client = @@character_set_client;

SET character_set_client = utf8;

CREATE TABLE `aa_Businesses` (

`aa_UserID` mediumint(8) unsigned NOT NULL auto_increment,

`aa_Username` varchar(100) default NULL,

`aa_Email` varchar(255) default NULL,

`aa_Password` varchar(200) default NULL,

`aa_Name` varchar(100) default NULL,

`aa_SignupDate` datetime default NULL,

`aa_AccountBalance` decimal(8,2) default '[url removed, login to view]',

`aa_Points` mediumint(8) unsigned default '0',

`aa_Feedback` mediumint(8) default '0',

`aa_Street` varchar(100) default NULL,

`aa_City` varchar(100) default NULL,

`aa_State` varchar(100) default NULL,

`aa_Zip` varchar(100) default NULL,

`aa_Ranking` tinyint(4) default NULL,

`aa_Data1` varchar(250) default NULL,

`aa_Data2` varchar(250) default NULL,

`aa_Data3` varchar(250) default NULL,

PRIMARY KEY (`aa_UserID`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

SET character_set_client = @saved_cs_client;

Skills: Engineering, MySQL, PHP, Project Management, Software Architecture, Software Testing, Web Hosting, Website Management, Website Testing

See more: schema form, key data structure, email address management, data3, email database management, mysql database , form 2 email --2, mysql create database engine, enter data database, mysql structure, php localhost, create schema mysql, mysql create schema, mysql create table data, mysql create table fields, datetime, project management mysql php, schema database mysql, mysql create table, php edit data form, create form enter data mysql, mysql database engine, mysql schema, form drop database, edit email

Project ID: #2858168

Awarded to:

techbongo

See private message.

$12 USD in 1 day
(31 Reviews)
4.6

20 freelancers are bidding on average $30 for this job

puneetjaini

See private message.

$42.5 USD in 1 day
(1495 Reviews)
8.0
MTS

See private message.

$34 USD in 1 day
(375 Reviews)
6.8
stevebryant

See private message.

$29.75 USD in 1 day
(498 Reviews)
6.7
RavFromSpain

See private message.

$29.75 USD in 1 day
(483 Reviews)
6.6
webstorm4net

See private message.

$42.5 USD in 1 day
(156 Reviews)
5.8
umnuscom

See private message.

$29.75 USD in 1 day
(113 Reviews)
5.8
ksoftwares

See private message.

$29.75 USD in 1 day
(190 Reviews)
5.6
rkgroups

See private message.

$21.25 USD in 1 day
(92 Reviews)
5.4
asntech

See private message.

$34 USD in 1 day
(93 Reviews)
5.2
code2success

See private message.

$38.25 USD in 1 day
(19 Reviews)
4.4
Strelac021

See private message.

$34 USD in 1 day
(8 Reviews)
3.9
alphasoftuk

See private message.

$8.5 USD in 1 day
(23 Reviews)
3.9
etco

See private message.

$42.5 USD in 1 day
(5 Reviews)
3.2
vw7111611vw

See private message.

$25.5 USD in 1 day
(2 Reviews)
3.0
codecamp

See private message.

$29.75 USD in 1 day
(23 Reviews)
2.8
saurabvw

See private message.

$29.75 USD in 1 day
(4 Reviews)
1.4
dotof

See private message.

$25.5 USD in 1 day
(4 Reviews)
0.8
alisoft

See private message.

$25.5 USD in 1 day
(2 Reviews)
0.0
samuveland

See private message.

$29.75 USD in 1 day
(0 Reviews)
0.0