PHP, Flash, and Client usability

[Syous]

Ok, I'm not asking for a tutorial (though one would be great) or for a ton of answers, just a general way of how things work and what tools are needed to get this specific task done.

I have a flash file with a dynamic text field. The text comes from my file homeSchedule.php and works wonderfully with my movie. My question is, how do I build a backend to a site so the client can login, go to "Edit Schedule", send the information to the database via the backend, and have the PHP file read it.

This is rather lengthy and I understand that I sort of answered my own question. I understand how mySQL works and how PHP works to an extent, just need a lot more clarification or a step in the right direction.

Thanks again!

[kdd]

I still don't get your problem, since your know the solution to your problem. :P

Anyways, what do you want to know? How to build login? And what's Edit Schedule? Do you want to know how to send variables back to PHP? Use POST.

Sorry if that was no help...

[calreks]

I sort of understand what you were trying to accomplish. My solution might now be the best but you just need a client to update a db table right.

Client logs in -> Client edits data as a form then Post -> Php uses mysql_query to post updates in Client's DB user table-> Php then uses $query to get clients updated data. Then variables and echo for view.

You gets?

[kdd]

^ :thumb: Seems right!

[calreks]

KDD his main issue is probably creating tables in mysql db.


My question is, how do I build a backend to a site so the client can login, go to "Edit Schedule",

[Syous]

You guys are correct! I'm not that great with mySQL. I know what it is just don't understand how to use it.

[simplistik]

if you have phpmyadmin installed it's as easy as adding a name into the database field to create a new database and table(s)