[PHP-DB] Re: test

2006-03-08 Thread João Cândido de Souza Neto
Be welcome. song wrote: new comer from China test -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] flash/php problem

2006-03-08 Thread Hoz
Here is a light but usefull Flash mp3 player : http://jeroenwijering.com/?item=Flash_Single_MP3_Player (thanks to the author ;)) i wanted it to be dynamic : in list.php, i list some mp3 songs from a Mysql database. i want each song to be played in the flash player. looks like : Artist #1 -

Re: [PHP-DB] flash/php problem

2006-03-08 Thread Hoz
i have to display the whole songs list in the same page. the flash embed player is a customized button next to each song of the page. header function has to be placed before any print/echo, or i'll get the traditional warning Cannot modify header information - headers already sent by ... if i

[PHP-DB] Renaming a table once it has been created

2006-03-08 Thread Ron Piggott (PHP)
Is there a way to re-name a table once you have created it? Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Renaming a table once it has been created

2006-03-08 Thread JupiterHost.Net
Ron Piggott (PHP) wrote: Is there a way to re-name a table once you have created it? Ron Depending on the type of DB some sort of ALTER TABLE statement I imagine, not sure what this has to do with PHP though... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] Renaming a table once it has been created

2006-03-08 Thread Jeffrey
Ron Piggott (PHP) wrote: Is there a way to re-name a table once you have created it? Ron ALTER TABLE `old_name` RENAME `new_name` Jeffrey -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Passwords

2006-03-08 Thread Benjamin Stambaugh
Hi, I have created a user login/registration page. As of now I am using a MySQL database to store the info of the user. To validate the user I also have the password stored in the same DB. I was wondering if there is a way that I can store the password in the DB so that it is encrypted or

Re: [PHP-DB] Passwords

2006-03-08 Thread Larry E. Ullman
I have created a user login/registration page. As of now I am using a MySQL database to store the info of the user. To validate the user I also have the password stored in the same DB. I was wondering if there is a way that I can store the password in the DB so that it is encrypted or

RE: [PHP-DB] Passwords

2006-03-08 Thread Bastien Koert
I tend to use a hash value (like MD5) to one way encrypt it... If you combine it with a salt value (some random string that is consistent in the app) then is reasonably secure from being hacked...ex. $salt = '1234567890'; $pass = md5($salt.$_POST['password']); bastien

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
yep, and the exact question is : how can i update my DB through Flash, using PHP. Thanks Tony, amfphp looks interesting. i'll take a look. but, Micah, each song has to be played on its own flash player is the current list.php page. quote -- list.php - this lists the mp3's, and each mp3 links

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