mysql database form and email
$30-50 USD
Paid on delivery
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 '0.00',
`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 '0.00',
`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;
Project ID: #2858168