Re: [PHP-DB] flash/php problem

2006-03-11 Thread Micah Stevens
On Friday 10 March 2006 6:24 pm, Anthony Lee wrote: Actually, I don't see why either method would work: The SWF is in a static HTML page. It requests an mp3, and loads it without having to refresh. So it needs an mp3 returned, not another SWF. Updating the DB from the SWF call sounds cool,

Re: [PHP-DB] flash/php problem

2006-03-11 Thread Hoz
- From: Micah Stevens [EMAIL PROTECTED] To: php-db@lists.php.net Sent: Saturday, March 11, 2006 6:19 PM Subject: Re: [PHP-DB] flash/php problem On Friday 10 March 2006 6:24 pm, Anthony Lee wrote: Actually, I don't see why either method would work: The SWF is in a static HTML page. It requests

Re: [PHP-DB] flash/php problem

2006-03-10 Thread Anthony Lee
Actually, I don't see why either method would work: The SWF is in a static HTML page. It requests an mp3, and loads it without having to refresh. So it needs an mp3 returned, not another SWF. Updating the DB from the SWF call sounds cool, but serverside wise requires the .htaccess updated to

Re: [PHP-DB] flash/php problem

2006-03-09 Thread Micah Stevens
Actually, I don't see why either method would work: 1) Call php, which updates, then calls swf. or 2) Call swf, which calls php to make update. No difference, both ways the job gets done.. What's the AMFPHP deal? I'll have to take a look at that.. -Micah On Wednesday 08 March 2006 11:23

Re: [PHP-DB] flash/php problem

2006-03-09 Thread Micah Stevens
Or rather, 'wouldn't work'.. my negatives are always screwey before 8.. On Thursday 09 March 2006 7:07 am, Micah Stevens wrote: Actually, I don't see why either method would work: 1) Call php, which updates, then calls swf. or 2) Call swf, which calls php to make update. No difference,

Re: [PHP-DB] flash/php problem

2006-03-08 Thread Hoz
send the ID var of the selected song to Flash, it could be suitable. (and the mp3 url won't be displayed in the html source) - Original Message - From: Micah Stevens [EMAIL PROTECTED] To: php-db@lists.php.net Sent: Wednesday, March 08, 2006 4:18 PM Subject: Re: [PHP-DB] flash/php

Re: [PHP-DB] flash/php problem

2006-03-08 Thread Anthony Lee
This question isn't really a PHP-DB thang is it? Anyway, it sounds like you have a lot of swfs on the page. One for each song, is that right? In that case your best bet would be something like what you already have: embed src='play.swf?ID=74...' i.e. push the variable into flash from the

Re: [PHP-DB] flash/php problem

2006-03-08 Thread Micah Stevens
Just an update to the DB on each swf load is what it seems he wants. On Wednesday 08 March 2006 7:13 pm, Anthony Lee wrote: This question isn't really a PHP-DB thang is it? Anyway, it sounds like you have a lot of swfs on the page. One for each song, is that right? In that case your best

Re: [PHP-DB] flash/php problem

2006-03-08 Thread Hoz
Sent: Thursday, March 09, 2006 6:12 AM Subject: Re: [PHP-DB] flash/php problem Just an update to the DB on each swf load is what it seems he wants. On Wednesday 08 March 2006 7:13 pm, Anthony Lee wrote: This question isn't really a PHP-DB thang is it? Anyway, it sounds like you have a lot

Re: [PHP-DB] flash/php problem

2006-03-08 Thread Anthony Lee
how can i update my DB through Flash, using PHP. The easy way... Flash: var info:String = YoMama; var id:Number = 12; getURL(http://myserver.com/my_db_update_page.php;, _self, GET); PHP [my_db_update_page.php]: ?php include_once('db_connection_script.php'); if ($_GET['info'] $_GET['id']){

Re: [PHP-DB] flash/php problem

2006-03-08 Thread Anthony Lee
On second thoughts you probably better off with load variables. Flash: var info:String = YoMama; var id:Number = 12; loadVariables(http://myserver.com/my_db_update_page.php?id=+id+info=+info+;, this); PHP [my_db_update_page.php]: ?php include_once('db_connection_script.php'); if ($_GET['info']

Re: [PHP-DB] flash/php problem

2006-03-08 Thread Anthony Lee
query(update hitcounter set plays = plays+1 where file = {$_GET['file']}); header(Location: play.swf?file={$_GET['file']}); Sorry I didn't read this thread thoroughly enough. This looks like a good solution to me. You just need to have the swf make the request and return the mp3 to the swf