Solved

Simple flash/php form to create database

Posted on 2011-03-01
8
647 Views
Last Modified: 2013-11-11
I need to create a simple form in flash that a user will fill out and on submit will create a new database and fill it with the form data using php and mqsql. Does anyone have some sample code to this effect?
0
Comment
Question by:brettacvh
  • 3
  • 3
8 Comments
 
LVL 17

Assisted Solution

by:Dushan911
Dushan911 earned 500 total points
Comment Utility
0
 

Author Comment

by:brettacvh
Comment Utility
To be a bit more detailed I need my flash form to run the following kind of query:

CREATE TABLE  `new`.`users` (
  `test_uid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `test_email` varchar(100) NOT NULL,
  `test_address` varchar(45) DEFAULT NULL,
  `test_message` varchar(45) DEFAULT NULL,
  `ipaddress` varchar(45) DEFAULT NULL,
  `test_pword` char(20) NOT NULL,
  `test_gname` char(80) NOT NULL,
  `test_lname` char(80) NOT NULL,
  `test_active` char(1) DEFAULT 'y',
  `test_lvl` int(10) unsigned NOT NULL DEFAULT '1',
  `test_rdate` datetime DEFAULT NULL,
  `test_username` varchar(45) NOT NULL,
  `test_permission` varchar(45) NOT NULL DEFAULT '1',
  `test_contactno` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`pogu_uid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1

Open in new window


but I'm not sure how to structure the php.

For the flash I guess I'll be using something like this:

submit1.onPress = function(){
	myData.test_uid_txt = test_uid_txt.text
		myData.test_email_txt = test_email_txt.text
		myData.test_address_txt = test_address_txt.text
		myData.sendAndLoad("form.php", myData, "POST")
	}
}

Open in new window

 ... etc
0
 

Author Comment

by:brettacvh
Comment Utility
Apologies. I am incorrect. I don't need to be creating the database but rather updating an existing database with:

insert into users(pogu_username,
pogu_pword, 
pogu_gname, 
pogu_lname, 
pogu_gender, 
pogu_rdate, 
pogu_contactno,
pogu_email,
pogu_dob, 
pogu_address, 
pogu_message,
ipaddress)

Open in new window

0
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 17

Accepted Solution

by:
Dushan911 earned 500 total points
Comment Utility
http://www.kirupa.com/developer/actionscript/flashphpxml_integration.htm

Above SQL statement you should not run from flash in normal practice. You should create database table using phpmyadmin, mysql gui or some other mysql client interface.

Then use php script to insert values to database which captures from the flash form.

BR Dushan.
0
 
LVL 17

Assisted Solution

by:Dushan911
Dushan911 earned 500 total points
Comment Utility
Please find below sample code.
----------------------------------------------flash code ---------------------------------------------
var submitObject:LoadVars = new LoadVars();

submit1.onRelease = function():Void
{

     submitObject.myname = myname.text;
     submitObject.mycontact = mycontact.text;
     submitObject.myabout = myabout.text;
     submitObject.mymessage = mymessage.text;
     submitObject.send("http://WEBSITE.com/contactscript.php", "_self", "POST");
};
-------------------------------------------------------------------------------------------------------


----------------------------------------------php code ------------------------------------------------
<?php
$conn = mysql_connect("local host", "username", "password");
mysql_select_db("blc", $conn);
$myname = $_POST['myname'];
$mycontact = $_POST['mycontact'];
$myabout = $_POST['myabout'];
$mymessage = $_POST['mymessage'];

$query="INSERT INTO contacts values ('', '$myname', '$mycontact', '$myabout', '$mymessage')";
$sql_run = mysql_query($query, $conn) or die(mysql_error());

?>
-------------------------------------------------------------------------------------------------------

Open in new window

0
 

Author Comment

by:brettacvh
Comment Utility
To add to my question: how do I validate the radio buttons in the flash form? I have 2 radio buttons with a group name of my_vars.gender The code I am trying is

if (my_vars.gender.selection == undefined) 
		{
			error_clip.gotoAndStop(44);
		}

Open in new window



but doesn't work
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Envision that you are chipping away at another e-business site with a team of pundit developers and designers. Everything seems, by all accounts, to be going easily.
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
This tutorial demonstrates how to identify and create boundary or building outlines in Google Maps. In this example, I outline the boundaries of an enclosed skatepark within a community park.  Login to your Google Account, then  Google for "Google M…
Any person in technology especially those working for big companies should at least know about the basics of web accessibility. Believe it or not there are even laws in place that require businesses to provide such means for the disabled and aging p…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now