Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Simple flash/php form to create database

Posted on 2011-03-01
8
Medium Priority
?
655 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
8 Comments
 
LVL 17

Assisted Solution

by:Dushan De Silva
Dushan De Silva earned 2000 total points
ID: 35012808
0
 

Author Comment

by:brettacvh
ID: 35012846
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
ID: 35013239
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
Quick Cloud Training

Looking for some quick training on the cloud in 2 hours or less? Check out these how-to guides in AWS, Linux, OpenStack, Azure, and more!

 
LVL 17

Accepted Solution

by:
Dushan De Silva earned 2000 total points
ID: 35013267
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:Dushan De Silva
Dushan De Silva earned 2000 total points
ID: 35013337
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
ID: 35014038
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

Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
The goal of the tutorial is to teach the user how to how to load their YouTube profile onto Flash Media Live Encoder.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

721 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