Submit A Form - 11submit.fla

This implements a data entry form and submits the entered data to another web page.

1. Start Flash MX
2. Create a new file.
3. Set the canvas size to 400x200
4. Set the colour to some pale pastel shade.
5. Right click on frame 25 and select Insert Frame

6. Click on the Text Tool.
7. Set it to Input Text
8. Set the font name and size if you wish.
9. Set the font colour if you wish.
10. Click the "Show Border" button on.
11. Place four text input boxes onto the canvas.
12. Click the Arrow tool and select the top input box.
13. Set its X and Y properties to 20 and 20.
14. Set its width property to 200.
15. Repeat this procedure for the rest of the input boxes but set their Y properties to 50, 80 and 110 to space them out properly.

16. Use the arrow tool to select the top Input Text.
17. Set the Var (variable name) to title.
18. Repeat the procedure for the other Input Text boxes and set their names to firstName, lastName and dob (date of birth).

19. Right click on Layer 1 and select "Insert Layer".
20. Right click on Layer 2 Frame 2 and select "Convert to Keyframes".
21. Place a Static Text control onto Layer 2 Frame 2. Make sure the correct frame is selected!
22. Place an error message into this text control. "Error : Title is blank."

23. Select Layer 1 Frame 1
24. Click on a blank area of the canvas to ensure no control is selected.
25. Click on Actions Frame.
26. Click to select advanced mode.
27. Enter this code stop();

28. Place a Submit button onto Layer 1 Frame 1.
29. Change the Button label to "Submit.
30. Select the button and click on "Actions-Movie Clip".
31. Enter this code.

32. on (release)
    {
        if (_root.title == Null)
        {
            _root.gotoAndStop(2);
        }
        else
        if (_root.firstName == Null)
        {
            _root.gotoAndStop(3);
        }
        else
        if (_root.lastName == Null)
        {
            _root.gotoAndStop(4);
        }
        else
        if (_root.dob == Null)
        {
            _root.gotoAndStop(5);
        }
        else
        {
            // ALL OK
            url = "foo.php";             // web page url
            url = url + "?";             // start "get" parameters
            url = url + "title=";        // field name equals
            url = url + _root.title;     // some value
            url = url + "&";             // separator
            url = url + "firstName=";    // field name equals
            url = url + _root.firstName; // some value
            url = url + "&";             // separator
            url = url + "lastName=";     // field name equals
            url = url + _root.lastName;  // some value
            url = url + "&";             // separator
            url = url + "dob=";          // field name equals
            url = url + _root.dob;       // another value
    
            getUrl (url);                // navigate to url		
        }
    }
    

33. Add the rest of the error messages ...
34. Right click on Layer 2 Frame 3 and select "Convert to Blank Keyframes".
35. Select Layer 2 Frame 3 and place a Static Text control onto the canvas.
36. Set the text to "Error : First Name must not be Blank."
37. Right click on Layer 2 Frame 4 and select "Convert to Blank Keyframes".
38. Select Layer 2 Frame 4 and place a Static Text control onto the canvas.
39. Set the text to "Error : Last Name must not be Blank."
40. Right click on Layer 2 Frame 5 and select "Convert to Blank Keyframes".
41. Select Layer 2 Frame 5 and place a Static Text control onto the canvas.
42. Set the text to "Error : Date of Birth must not be Blank."

43. Right Click on Layer 1 Frame 2 and select "Convert to Blank Keyframe."
44. Click on Layer 1 Frame 2 and place a button onto the canvas.
45. Set the button label to "Reset".
46. Open up "Actions - Movie Clip" and attach this code to the Reset Button.

47. on (release)
    {
        _root.gotoAndStop(1);
    }
    

48. Add static text labels to make the UI more friendly.
49. Add graphics for the error messages to make the UI more friendly/interesting/ammusing.

You need a web page to recieve the data submitted by your Flash application.

This assumes you have a database called "foo" and a table named "customer".

Here is an example ...

<?php
  $title     = $_GET['title'];
  $firstName = $_GET['firstName'];
  $lastName  = $_GET['lastName'];
  $dob       = $_GET['dob'];
  
  $link = mysql_connect("localhost",    // Host name
                        "root",         // User name     (never use root in real life - Too insecure!)  
                        "")             // User password (never have a blank password in real life - Insecure!)
  or die("<h5>Could not connect: </h5>" . mysql_error());
  
  if (mysql_select_db ("foo")) // Use your own database and table name
  {
    $sql = "INSERT INTO customer        
    (title, last_name, first_name, date_of_birth) 
    VALUES 
    (\"$title\", \"$lastName\", \"$firstName\", \"$dob\")";
	  
    mysql_query($sql, $link);

    mysql_close($link);
  }   
?>

<html>
<head>
<title>Example Page</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<h4><strong>Execute :</strong> <?php echo $sql; ?></h4>
</body>
</html>