Closed

mysql database form and email

This project was awarded to techbongo for $12 USD.

Get free quotes for a project like this
Employer working
Project Budget
$30 - $50 USD
Total Bids
20
Project Description

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;

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