# How to insert data from flash into Mysql database

**URL:** https://forum.kirupa.com/t/how-to-insert-data-from-flash-into-mysql-database/279672
**Category:** programming
**Created:** [January 17, 2009, 9:55am UTC](https://forum.kirupa.com/t/how-to-insert-data-from-flash-into-mysql-database/279672 "2009-01-17T09:55:41Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![elango2009](https://avatars.discourse-cdn.com/v4/letter/e/b9e5f3/32.png) [@elango2009](https://forum.kirupa.com/u/elango2009)
#### Post date: [January 17, 2009, 9:55am UTC](https://forum.kirupa.com/t/how-to-insert-data-from-flash-into-mysql-database/279672/1 "2009-01-17T09:55:41Z")

</div>

Hi everybody,  
I am novice and new born and interested in learning flash script, php and mysql. Here is my problem. I tried to store data from flash to mysql. First i got the data from flash to a php file and from there i mailed, it worked fine; now i want instead of sending the data to an email id to store the data in mysql database. Here is my code:

\<?php

$mess="Dear Sir,

```
	 Action : " . $_POST['action'].",

	 Song : " . $_POST['song'];

```

mail("victorelango@yahoo.com",“I want solution”,$mess,“From:bennycreatives.com”);

?\> This worked fine - I got the dynamic data from the flash file -

([www.bennycreatives.com/pro/oliver/index.html](http://www.bennycreatives.com/pro/oliver/index.html))

But…,

\<?php  
$action= $\_POST[‘action’] ;  
$song = $\_POST[‘song’] ;  
?\>

\<body\>  
\<table width=“400” border=“1” cellspacing=“0” cellpadding=“0” align=“center”\>

\<tr\>  
\<td width=“100”\>\<?php echo("$action");?\>\</td\>  
\<td\>&nbsp;\</td\>  
\<td width=“250”\>\<?php echo("$song");?\>\</td\>

\</table\>  
\</body\>

CREATE TABLE IF NOT EXISTS `user` (  
`ID` int(11) NOT NULL auto\_increment,  
`name` text NOT NULL,  
`action` text NOT NULL,  
PRIMARY KEY (`ID`)  
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO\_INCREMENT=1 ;

Pls guide me?