[PHP-DB] How to store an image into a db?
Hi there, I recently heard about storing images in a blob column in MySQl. Now I am wondering how to do that. I mean isn't there a potential security problem because of buffer over flow? How would I do that with php anyway? Thank you guys for any hint. Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] How to store an image into a db?
Here's just one of many articles on this subject: http://www.phpbuilder.com/columns/florian19991014. php3 You can also do a search and read the debates about whether this is a good idea or not. -Original Message- From: andy [mailto:[EMAIL PROTECTED]] Sent: May 25, 2002 4:38 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] How to store an image into a db? Hi there, I recently heard about storing images in a blob column in MySQl. Now I am wondering how to do that. I mean isn't there a potential security problem because of buffer over flow? How would I do that with php anyway? Thank you guys for any hint. Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Fames Included?
Hi all, I have a problem in a site I am developing, which is generated by the use of too many tables inside tables. I can avoid using that many tables by using frames instead and I would like to make every page of the site, using the following schema: include(framed_header.php); include(framed_left_menu.php); //main body of every page; include(framed_footer.php); Is it posible to make a site or page by including framed-pages within PHP? Thanx a lot. Cesar Aracena [EMAIL PROTECTED] Neuquen, Argentina
RE: [PHP-DB] How to store an image into a db?
I don't recommend it but if you insist : Saving Images in MySQL http://www.weberdev.com/index.php3?GoTo=ViewArticle.php3?ArticleID=3 berber -Original Message- From: andy [mailto:[EMAIL PROTECTED]] Sent: Saturday, May 25, 2002 10:38 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] How to store an image into a db? Hi there, I recently heard about storing images in a blob column in MySQl. Now I am wondering how to do that. I mean isn't there a potential security problem because of buffer over flow? How would I do that with php anyway? Thank you guys for any hint. Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Fames Included?
Hi just use a frameset with php pages in FRAMESET ROWS=210,* FRAMESPACING=0 FRAMEBORDER=0 border=0 FRAME SRC=top.php3 NORESIZE=NORESIZE NAME=top scrolling=no FRAMESET COLS=130,* FRAMESPACING=0 FRAMEBORDER=0 BORDER=0 FRAME SRC=left.php3 NORESIZE=NORESIZE NAME=s_main FRAME SRC=main.php3 NORESIZE=NORESIZE NAME=order /FRAMESET NOFRAMES if I understood what you were trying to achieve :) hth Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- -Original Message- From: César L. Aracena [mailto:[EMAIL PROTECTED]] Sent: 25 May 2002 17:34 To: PHP DB List Subject: [PHP-DB] Fames Included? Hi all, I have a problem in a site I am developing, which is generated by the use of too many tables inside tables. I can avoid using that many tables by using frames instead and I would like to make every page of the site, using the following schema: include(framed_header.php); include(framed_left_menu.php); //main body of every page; include(framed_footer.php); Is it posible to make a site or page by including framed-pages within PHP? Thanx a lot. Cesar Aracena [EMAIL PROTECTED] Neuquen, Argentina -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Fames Included?
Thanx a lot. It works just fine. - Original Message - From: Peter Lovatt [EMAIL PROTECTED] To: César L. Aracena [EMAIL PROTECTED]; PHP DB List [EMAIL PROTECTED] Sent: Saturday, May 25, 2002 6:01 PM Subject: RE: [PHP-DB] Fames Included? Hi just use a frameset with php pages in FRAMESET ROWS=210,* FRAMESPACING=0 FRAMEBORDER=0 border=0 FRAME SRC=top.php3 NORESIZE=NORESIZE NAME=top scrolling=no FRAMESET COLS=130,* FRAMESPACING=0 FRAMEBORDER=0 BORDER=0 FRAME SRC=left.php3 NORESIZE=NORESIZE NAME=s_main FRAME SRC=main.php3 NORESIZE=NORESIZE NAME=order /FRAMESET NOFRAMES if I understood what you were trying to achieve :) hth Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- -Original Message- From: César L. Aracena [mailto:[EMAIL PROTECTED]] Sent: 25 May 2002 17:34 To: PHP DB List Subject: [PHP-DB] Fames Included? Hi all, I have a problem in a site I am developing, which is generated by the use of too many tables inside tables. I can avoid using that many tables by using frames instead and I would like to make every page of the site, using the following schema: include(framed_header.php); include(framed_left_menu.php); //main body of every page; include(framed_footer.php); Is it posible to make a site or page by including framed-pages within PHP? Thanx a lot. Cesar Aracena [EMAIL PROTECTED] Neuquen, Argentina -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] limiting the amount of data to be show on one page.
If I want to use the bellow liste senario. How would i go about setting up the 1 2 3 4 5 6 7 8 page #'s how would I know when to stop counting? You should also add an ORDER BY clause in there, as the SQL standard doesn't guarantee the order that rows are retrieved in. There's a chance that you'll get, say, 20 rows on the first page, go to the second page and get some of the rows you've already seen on the first page. If you use an ORDER BY, you'll at least guarantee that you'll get them in the same order each time. J Kevin Stone wrote: $query = SELECT * FROM mytable LIMIT $i, 20; Where 20 is the number of rows to retrieve and $i is the starting row. By incrementing $i + 20 you can do next, prev buttons, or parse the total number of rows into page links (prev - 1, 2, 3, 4, 5, 6.. 10.. 20 - next). Search www.mysql.com for more information about using LIMIT in your queries. -Kevin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
