Re: [PHP-DB] Pictures+MySQL+PHP
Ck Raju wrote: that I changed my mind. Gurhan OzenStoring images in the database is not a good idea , just store the path of Gurhan Ozenthe images in the database and keep your images in your hard disk... Gurhan Ozen Since everything is on hard-disk, I personally feel, the image can be stored anywhere. BLOB should be easier when doing a mysqldump, or when replication is needed. Anywhere else go in for storing images separately. Raju I prefer storing images out of the dbserver to save on server load. You can serve those images with a http server like thttpd, boa etc which will serve images quicker and with a lighter load. If you need replication just use rsync to move your images around. But if server load isn't an issue a database is as good as any place. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] counting with CURDATE() - please help!
Hello, I want to add a variable numer of months to the current date CURDATE(). I thought it should be something like this: select (MONTH(CURRENT_DATE)+MONTH(2)) but i get NULL as a result. The purpose of this it to check which records with a experation date is earlier or later than today+2 months later. Can somebody please tell me how to do this? Thanks in advance -- Met vriendelijke groet / With Greetings, Sander Peters site: http://www.visionnet.nl/ email: mailto:[EMAIL PROTECTED] webmail: mailto:[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Someone using the tool DeZign
Hi, does someone using DeZing as Tool for modelling databases? I have some trouble with the ImportER Access. Regards, Ruprecht -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] counting with CURDATE() - please help!
Hello Sander, I want to add a variable numer of months to the current date CURDATE(). I thought it should be something like this: select (MONTH(CURRENT_DATE)+MONTH(2)) but i get NULL as a result. The purpose of this it to check which records with a experation date is earlier or later than today+2 months later. Can somebody please tell me how to do this? Would MySQL's ADD_DATE() suit? =dn -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] counting with CURDATE() - please help!
if you have a date column 'birthdate' SELECT (birthdate + INTERVAL 7 MONTH) as birthdate FROM yourtable WHERE ... Look at the date and time functions in the MySQL manual. -Jason Garber IonZoft.com At 02:28 PM 1/27/2002 +, DL Neil wrote: Hello Sander, I want to add a variable numer of months to the current date CURDATE(). I thought it should be something like this: select (MONTH(CURRENT_DATE)+MONTH(2)) but i get NULL as a result. The purpose of this it to check which records with a experation date is earlier or later than today+2 months later. Can somebody please tell me how to do this? Would MySQL's ADD_DATE() suit? =dn -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] PHP + Postgresql + Linux = Frustration
Hello, I am rather new to Linux but an old timer at software development. I am investigating alternate platforms for future development for my company. Linux is at the top of the list. I am trying to get a server setup with a db (PostgreSQL), web server (Apache), and some sort of web scripting language (PHP). I can not make everything work together. PHP4 won't work out-of-the-box with PostgreSQL because PHP doesn't have support for PosgreSQL built in at compile time (why not just build everything into when it was initially built?). So I get the sources to PHP and try to build. However, it wants the sources (header files) for Apache. At this point I don't want to go any further. Eventually, I'll probably need the sources for everything. Is there an easy way to do this sort of stuff on Linux or is it better to just buy off the shelf products that work? Thanks, Mike -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Pictures+MySQL+PHP
I think that saving images outside the database is better but sometimes you need it. here is something i wrote a while back : Sometimes, it's more convenient to save images in a database than as files. MySQL and PHP make it very easy to do this . In this article, I will describe how to save images in a MySQL database and display them later on. http://www.weberdev.com/index.php3?GoTo=ViewArticle.php3?ArticleID=3 Sincerely berber Visit http://www.weberdev.com Today!!! To see where PHP might take you tomorrow. -Original Message- From: K [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 4:54 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Pictures+MySQL+PHP Hello, last time I asked about inserting pictures into MySQL, but how can I do it (inserting into BLOB column, picutures) using PHP? After inserting it into table I would also like to select and display the picutre (I inserted before) using my Internet browser. Any suggestion how to do it using PHP+MySQL? Best regards Kamil PS. I'll be pleased for all info on my private e-mail :) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Odp: [PHP-DB] Someone using the tool DeZign
Od: Ruprecht Helms [EMAIL PROTECTED] Temat: [PHP-DB] Someone using the tool DeZign does someone using DeZing as Tool for modelling databases? I have some trouble with the ImportER Access. I use this tool and I found it usable and comfortable in my work. AFAIK, ImportER Access is not as mature as other tools from Heraut, but what problem exactly do you have? Cheers Jarek Zgoda -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
