Flash and PHP

[Ryan_Padyachie]

Hi There

I was wondering if somebody could help me out.
I am a designer, and I have recently designed
my website entirely in flash.
I have downloaded a tutorial in which
I followed all instrutions to create a form in flash
which connects to a php script.
Now I have uploaded this php file to the server
with all my other files,
however, i know there is some other step like adding a mysql database.
I know that me free server which is lolhosting does support the use of php,
Now I dont know how to link my php file to this mysql,
Can somebody please explain to me how this can be done, or even I have
my straight.

Thanks

Ryan

South Africa

[Newsgroup_User]

If you have MySQL you will have to set up a database and user, either your
host can do that, or you will have a control panel where you can do it
yourself. Just depends on the host. Once you have that, you can make a
connection to your db using PHP with something like this:

$connection = mysql_connect("localhost", "user", "password");
mysql_select_db("databaseName", $connection);

And then you can query the db with:

$result = mysql_query("SELECT * FROM table", $connection);



--
Dave -

[rezun8]

Ryan , what kind of information are you passing betwen Flash & PHP? if its a simple contact form you may not need a MySQL DB at all. If your wanting to store info then yes you prob will need a DB.