RE: [PHP] Re: Pictures and sound in MySQL and access via PHP
The way I always store links in the database is in the format of varchar, but if a file is stored in a mp3 folder to follow your example I would list it in the database as /mp3/sound.mp3. Then list your code like this: echo ""; echo "NederlandsOostendsUitleg"; while ($row=mysql_fetch_array($result)) { echo ""; echo $row[woord_nl]. "" . $row[woord_ost]. "" . $row[betekenis_nl]. "" . "link name"; echo ""; } Hope this hleps and works in your situation, Josh Thomas Administrator RPS Internet Services -Original Message- From: danny [mailto:[EMAIL PROTECTED]] Sent: Sunday, August 11, 2002 3:33 PM To: [EMAIL PROTECTED] Subject: Re: [PHP] Re: Pictures and sound in MySQL and access via PHP thank you for your answer How do you make a link in MySQL? I tried following code were the field "geluid" contains a link to a mp3 format of field geluid = varchar(250). The problem is that i just get plain text instead of a link to the MP3. Even better would be to have a button to clicjk if you want to hear the sound. echo ""; echo "NederlandsOostendsUitleg"; while ($row=mysql_fetch_array($result)) { echo ""; echo $row[woord_nl]. "" . $row[woord_ost]. "" . $row[betekenis_nl]. "" . $row[geluid]; echo ""; } Danny Rodolfo Gonzalez <[EMAIL PROTECTED]> schreef in berichtnieuws [EMAIL PROTECTED] > On Sat, 10 Aug 2002, lallous wrote: > > > I'm making a on-line dictionary. I use PHP and a MySQL Database. > > > Now I want to add audio-streaming (MP3) and pictures (JPG) to the database > > > and retrieve it true PHP. Can sombody help me out with a little > > If the files are not "secret" or "for members only", you should better > store them somewhere under your http document tree, and store *only* their > filenames in the database, then you could provide a link to the file. I > think this would be the faster. Or if you want to "protect" the files, you > could place them outside your document tree, and then use fileread or > something similar to read them. But I'd suggest you to keep only the > filenames on the database, and store the files in the filesystem, it'd > better for the performance and integrity of the files. > > Good luck. > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Re: Pictures and sound in MySQL and access via PHP
> How do you make a link in MySQL? > > I tried following code were the field "geluid" contains a > link to a mp3 > while ($row=mysql_fetch_array($result)) > { > echo ""; > echo $row[woord_nl]. "" > . $row[woord_ost]. "" > . $row[betekenis_nl]. "" > . $row[geluid]; > echo ""; > } I'd do something like this: . "" . $row[geluid] . "" To get you link - basically, just put your link into the appropriate html tags. If you prefer a button or something else then apply the html you'd use and go with it. CYA, Dave -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: Pictures and sound in MySQL and access via PHP
thank you for your answer How do you make a link in MySQL? I tried following code were the field "geluid" contains a link to a mp3 format of field geluid = varchar(250). The problem is that i just get plain text instead of a link to the MP3. Even better would be to have a button to clicjk if you want to hear the sound. echo ""; echo "NederlandsOostendsUitleg"; while ($row=mysql_fetch_array($result)) { echo ""; echo $row[woord_nl]. "" . $row[woord_ost]. "" . $row[betekenis_nl]. "" . $row[geluid]; echo ""; } Danny Rodolfo Gonzalez <[EMAIL PROTECTED]> schreef in berichtnieuws [EMAIL PROTECTED] > On Sat, 10 Aug 2002, lallous wrote: > > > I'm making a on-line dictionary. I use PHP and a MySQL Database. > > > Now I want to add audio-streaming (MP3) and pictures (JPG) to the database > > > and retrieve it true PHP. Can sombody help me out with a little > > If the files are not "secret" or "for members only", you should better > store them somewhere under your http document tree, and store *only* their > filenames in the database, then you could provide a link to the file. I > think this would be the faster. Or if you want to "protect" the files, you > could place them outside your document tree, and then use fileread or > something similar to read them. But I'd suggest you to keep only the > filenames on the database, and store the files in the filesystem, it'd > better for the performance and integrity of the files. > > Good luck. > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: Pictures and sound in MySQL and access via PHP
On Sat, 10 Aug 2002, lallous wrote: > > I'm making a on-line dictionary. I use PHP and a MySQL Database. > > Now I want to add audio-streaming (MP3) and pictures (JPG) to the database > > and retrieve it true PHP. Can sombody help me out with a little If the files are not "secret" or "for members only", you should better store them somewhere under your http document tree, and store *only* their filenames in the database, then you could provide a link to the file. I think this would be the faster. Or if you want to "protect" the files, you could place them outside your document tree, and then use fileread or something similar to read them. But I'd suggest you to keep only the filenames on the database, and store the files in the filesystem, it'd better for the performance and integrity of the files. Good luck. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php