php-general Digest 29 Oct 2008 07:47:06 -0000 Issue 5761

2008-10-29 Thread php-general-digest-help
php-general Digest 29 Oct 2008 07:47:06 - Issue 5761 Topics (messages 282533 through 282557): Re: clear a mysql table 282533 by: Jim Lucas 282550 by: Lupus Michaelis Waste of storage space? 282534 by: Frank Arensmeier 282542 by: Chris 282543 by:

php-general Digest 29 Oct 2008 21:11:48 -0000 Issue 5762

2008-10-29 Thread php-general-digest-help
php-general Digest 29 Oct 2008 21:11:48 - Issue 5762 Topics (messages 282558 through 282585): Re: Waste of storage space? 282558 by: Frank Arensmeier 282560 by: Frank Arensmeier 282561 by: Frank Arensmeier 282562 by: Maciek Sokolewicz 282573 by:

Fwd: [PHP] Waste of storage space?

2008-10-29 Thread Frank Arensmeier
Från: Yeti [EMAIL PROTECTED] Datum: ti 28 okt 2008 23.07.11 GMT+01:00 Till: Frank Arensmeier [EMAIL PROTECTED] Ämne: Re: [PHP] Waste of storage space? Hej, why not do a simple strlen() before comparison? Like if strlen (or mb_strlen()) is less than 50 do not serialize/ compare. Or Like

Re: [PHP] Waste of storage space?

2008-10-29 Thread Frank Arensmeier
28 okt 2008 kl. 23.56 skrev Chris: 1) Store the delta (=the actual change) of a text change. This could be done by utilizing the Pear package TextDiff. My idea was to compare the old with the new text with help of the TextDiff class. I would then grab the array containing the changes

Re: [PHP] Re: FImage $aSubDir

2008-10-29 Thread Ashley Sheridan
On Tue, 2008-10-28 at 23:52 -0400, John Taylor-Johnston wrote: Could it be this easy? $chopped= strlen($aFn) - 4; $filename = $chopped..txt; printbrfont face='Arial, Helvetica, sans-serif' size=2 color='#99'; include($filename); print/font; John Taylor-Johnston wrote: I

[PHP] Re: Waste of storage space?

2008-10-29 Thread Frank Arensmeier
29 okt 2008 kl. 00.00 skrev Maciek Sokolewicz: Frank Arensmeier wrote: Hi all. In short, I am working on a system that allows me to keep track of changes to a large amount of short texts (a couple of thousand text snippets, two or three sentences per text). All text is stored in a

Re: [PHP] Waste of storage space?

2008-10-29 Thread Frank Arensmeier
29 okt 2008 kl. 01.08 skrev Bastien Koert: On Tue, Oct 28, 2008 at 4:24 PM, Frank Arensmeier [EMAIL PROTECTED] wrote: Hi all. In short, I am working on a system that allows me to keep track of changes to a large amount of short texts (a couple of thousand text snippets, two or three

[PHP] Re: Waste of storage space?

2008-10-29 Thread Maciek Sokolewicz
Frank Arensmeier wrote: 29 okt 2008 kl. 00.00 skrev Maciek Sokolewicz: Frank Arensmeier wrote: Hi all. In short, I am working on a system that allows me to keep track of changes to a large amount of short texts (a couple of thousand text snippets, two or three sentences per text). All text

Re: [PHP] Re: FImage $aSubDir

2008-10-29 Thread Maciek Sokolewicz
Ashley Sheridan wrote: On Tue, 2008-10-28 at 23:52 -0400, John Taylor-Johnston wrote: Could it be this easy? $chopped= strlen($aFn) - 4; $filename = $chopped..txt; printbrfont face='Arial, Helvetica, sans-serif' size=2 color='#99'; include($filename); print/font; John

[PHP] Newbie: can I store flash file into Mysql DB

2008-10-29 Thread vuthecuong
technically can I store flash file into Mysql DB using PHP? what point should I pay attention for that? Thank you -- View this message in context: http://www.nabble.com/Newbie%3A-can-I-store-flash-file-into-Mysql-DB-tp20224150p20224150.html Sent from the PHP - General mailing list archive at

Re: [PHP] Newbie: can I store flash file into Mysql DB

2008-10-29 Thread Stut
On 29 Oct 2008, at 10:20, vuthecuong wrote: technically can I store flash file into Mysql DB using PHP? Yes. what point should I pay attention for that? The blob field type. But I would recommend against it. Why not store the files on disk and only store the filenames in the DB? -Stut

Re: [PHP] Newbie: can I store flash file into Mysql DB

2008-10-29 Thread vuthecuong
Stut wrote: On 29 Oct 2008, at 10:20, vuthecuong wrote: technically can I store flash file into Mysql DB using PHP? Yes. what point should I pay attention for that? The blob field type. But I would recommend against it. Why not store the files on disk and only store the

Re: [PHP] Newbie: can I store flash file into Mysql DB

2008-10-29 Thread Stut
On 29 Oct 2008, at 10:32, vuthecuong wrote: Stut wrote: On 29 Oct 2008, at 10:20, vuthecuong wrote: technically can I store flash file into Mysql DB using PHP? Yes. what point should I pay attention for that? The blob field type. But I would recommend against it. Why not store the

Re: [PHP] Newbie: can I store flash file into Mysql DB

2008-10-29 Thread vuthecuong
Stut wrote: On 29 Oct 2008, at 10:32, vuthecuong wrote: Stut wrote: On 29 Oct 2008, at 10:20, vuthecuong wrote: technically can I store flash file into Mysql DB using PHP? Yes. what point should I pay attention for that? The blob field type. But I would recommend against it.

[PHP] Mailing lists

2008-10-29 Thread Richard Heyes
Hi, Anyone know of a good (as opposed to a bad) mailing list manager, other than freelists.org (which I can't seem to get working). Thanks. -- Richard Heyes HTML5 Graphing for FF, Chrome, Opera and Safari: http://www.rgraph.org (Updated October 25th) -- PHP General Mailing List

Re: [PHP] Mailing lists

2008-10-29 Thread Dotan Cohen
2008/10/29 Richard Heyes [EMAIL PROTECTED]: Hi, Anyone know of a good (as opposed to a bad) mailing list manager, other than freelists.org (which I can't seem to get working). Thanks. Gmail! -- Dotan Cohen http://what-is-what.com http://gibberish.co.il

Re: [PHP] Mailing lists

2008-10-29 Thread Bjoern Bartels
Dotan Cohen wrote .. 2008/10/29 Richard Heyes [EMAIL PROTECTED]: Hi, Anyone know of a good (as opposed to a bad) mailing list manager, other than freelists.org (which I can't seem to get working). Thanks. Gmail! ?!? that's ajoke, right? i pledge loyalty for gnus mailman

Re: [PHP] Newbie: can I store flash file into Mysql DB

2008-10-29 Thread Bastien Koert
On Wed, Oct 29, 2008 at 6:20 AM, vuthecuong [EMAIL PROTECTED] wrote: technically can I store flash file into Mysql DB using PHP? what point should I pay attention for that? Thank you -- View this message in context:

Re: [PHP] Waste of storage space?

2008-10-29 Thread Bastien Koert
Thank you for your respons. I have thought of such a sorting mechanism too. But on the other hand, the biggest drawback would be that even minor changes that might be really important could get lost. And my goal is to really keep track on everything my users do. And, in the long run, the

Re: [PHP] Regex validation

2008-10-29 Thread Bastien Koert
On Tue, Oct 28, 2008 at 8:57 PM, VamVan [EMAIL PROTECTED] wrote: SSO process: $_POST the Email Address and password Get Authenticated, Get the COOKIE ( Through Oracle IDM suite SOAP call) Decrypt the COOKIE ( Through Oracle Enterprise business suite SOAP call) and get the profile Info

Re: [PHP] Mailing lists

2008-10-29 Thread Michael Kubler
I agree. Mailman has everything you need from a mailing list and is the defacto standard. Besides, with it you only need to press 'reply' not 'Reply all' when trying to send to the list... unlike this one. Usually you would setup it up on a subdomain (e.g _lists.__domain.com_) and can then

Re: [PHP] Mailing lists

2008-10-29 Thread Wolf
Richard Heyes [EMAIL PROTECTED] wrote: Hi, Anyone know of a good (as opposed to a bad) mailing list manager, other than freelists.org (which I can't seem to get working). Thanks. What's wrong with Mailman? Wolf -- PHP General Mailing List (http://www.php.net/) To unsubscribe,

Re: [PHP] Waste of storage space?

2008-10-29 Thread Aschwin Wesselius
Bastien Koert wrote: Thank you for your respons. I have thought of such a sorting mechanism too. But on the other hand, the biggest drawback would be that even minor changes that might be really important could get lost. And my goal is to really keep track on everything my users do. And, in

Re: [PHP] Regex validation

2008-10-29 Thread ceo
When it comes to email validation, I would recommend using the IMAP function which will be both fast and correct: http://us.php.net/manual/en/function.imap-rfc822-parse-adrlist.php Otherwise, it's guaranteed that you are having at least some false positives, and probably some false

Re: [PHP] Waste of storage space?

2008-10-29 Thread Bastien Koert
Hi, Ok, disk space is cheap, but you can't avoid the access/seek time penalty on this. - Unomi - Properly indexed, its not that bad...after all its what Dbs do best -- Bastien Cat, the other other white meat

Re: [PHP] Regex validation

2008-10-29 Thread Yeti
On Wed, Oct 29, 2008 at 5:36 AM, [EMAIL PROTECTED] wrote: When it comes to email validation, I would recommend using the IMAP function which will be both fast and correct: http://us.php.net/manual/en/function.imap-rfc822-parse-adrlist.php Otherwise, it's guaranteed that you are having at

Re: [PHP] Mailing lists

2008-10-29 Thread Daniel P. Brown
On Wed, Oct 29, 2008 at 9:26 AM, Wolf [EMAIL PROTECTED] wrote: What's wrong with Mailman? That's what I'd recommend, too. It's not PHP, but it's tried and true, tested over years and years, and probably in the millions or tens of millions of messages handled. -- /Daniel P. Brown

Re: [PHP] Waste of storage space?

2008-10-29 Thread Aschwin Wesselius
Bastien Koert wrote: Hi, Ok, disk space is cheap, but you can't avoid the access/seek time penalty on this. - Unomi - Properly indexed, its not that bad...after all its what Dbs do best I only mention this, that while disk space seems a unlimited resource these days the fact that

Re: [PHP] create/write to psd file

2008-10-29 Thread David Lidstone
Ashley Sheridan wrote: On Mon, 2008-10-27 at 07:55 +0100, Martin Zvarík wrote: What I know is that you can control GIMP over the command line = you can use PHP to do this. Though I guess GIMP doesn't support PSD files, I had to express myself anyways. vuthecuong napsal(a): Hi all Is

Re: [PHP] create/write to psd file

2008-10-29 Thread Ashley Sheridan
On Wed, 2008-10-29 at 15:22 +, David Lidstone wrote: Ashley Sheridan wrote: On Mon, 2008-10-27 at 07:55 +0100, Martin Zvarík wrote: What I know is that you can control GIMP over the command line = you can use PHP to do this. Though I guess GIMP doesn't support PSD files, I had to

[PHP] General Mysql Connect

2008-10-29 Thread Waynn Lue
I sent an email to the mysql list, but it reminded me of a question I had for people structuring their PHP code. What's the general way that people structure their connections? Right now, I spawn off two mysql_connect calls at the top of the file that includes my database calls, using true for

Re: [PHP] General Mysql Connect

2008-10-29 Thread Chris
Waynn Lue wrote: I sent an email to the mysql list, but it reminded me of a question I had for people structuring their PHP code. What's the general way that people structure their connections? Right now, I spawn off two mysql_connect calls at the top of the file that includes my database

Re: [PHP] General Mysql Connect

2008-10-29 Thread Ashley Sheridan
On Thu, 2008-10-30 at 08:55 +1100, Chris wrote: Waynn Lue wrote: I sent an email to the mysql list, but it reminded me of a question I had for people structuring their PHP code. What's the general way that people structure their connections? Right now, I spawn off two mysql_connect calls

[PHP] Re: General Mysql Connect

2008-10-29 Thread Waynn Lue
Yeah, it's the same user, same everything (for now). But I wonder why we're seeing these lost connection errors and I'm trying to fix it--this was one of the things I was investigating. On 10/29/08, Chris [EMAIL PROTECTED] wrote: Waynn Lue wrote: I sent an email to the mysql list, but it

[PHP] Re: General Mysql Connect

2008-10-29 Thread Waynn Lue
It's actually a deliberate design decision to have two dbs, because one's a shared database, and one's application specific. Thanks, Waynn On 10/29/08, Ashley Sheridan [EMAIL PROTECTED] wrote: On Thu, 2008-10-30 at 08:55 +1100, Chris wrote: Waynn Lue wrote: I sent an email to the mysql list,

[PHP] Re: General Mysql Connect

2008-10-29 Thread Chris
Waynn Lue wrote: Yeah, it's the same user, same everything (for now). But I wonder why we're seeing these lost connection errors and I'm trying to fix it--this was one of the things I was investigating. Random guess :) You're overwriting a result or connection variable? $query = select *

[PHP] Re[2]: Problem changing file encoding

2008-10-29 Thread ANR Daemon
Greetings, Nathan Rixham. In reply to Your message dated Wednesday, October 22, 2008, 20:54:22, made this a while back.. might help :) http://programphp.com/iconv.phps Sorta... would be wise to have results of this detector cached in some way to reduce startup times. But it's nice, very nice

[PHP] Bitwise operation giving wrong results

2008-10-29 Thread sean greenslade
I have the following code as a test: ?php $a = $_GET['a']; $b = $_GET['b']; echo $a .. $b . = ; $out = $a $b; echo $out; //echo 15 2; ? if I set a to 15 and b to 2 in the URL like so: test.php?a=15b=2 it outputs zero as the answer. When I run the hard-coded '' operation (the commented

Re: [PHP] General Mysql Connect

2008-10-29 Thread Micah Gersten
Ashley Sheridan wrote: On Thu, 2008-10-30 at 08:55 +1100, Chris wrote: Waynn Lue wrote: I sent an email to the mysql list, but it reminded me of a question I had for people structuring their PHP code. What's the general way that people structure their connections? Right now, I

Re: [PHP] Bitwise operation giving wrong results

2008-10-29 Thread Ashley Sheridan
On Wed, 2008-10-29 at 20:01 -0400, sean greenslade wrote: I have the following code as a test: ?php $a = $_GET['a']; $b = $_GET['b']; echo $a .. $b . = ; $out = $a $b; echo $out; //echo 15 2; ? if I set a to 15 and b to 2 in the URL like so: test.php?a=15b=2 it outputs

Re: [PHP] General Mysql Connect

2008-10-29 Thread Ashley Sheridan
On Wed, 2008-10-29 at 19:25 -0500, Micah Gersten wrote: Ashley Sheridan wrote: On Thu, 2008-10-30 at 08:55 +1100, Chris wrote: Waynn Lue wrote: I sent an email to the mysql list, but it reminded me of a question I had for people structuring their PHP code. What's the general

Re: [PHP] General Mysql Connect

2008-10-29 Thread Micah Gersten
Ashley Sheridan wrote: On Wed, 2008-10-29 at 19:25 -0500, Micah Gersten wrote: Ashley Sheridan wrote: On Thu, 2008-10-30 at 08:55 +1100, Chris wrote: Waynn Lue wrote: I sent an email to the mysql list, but it reminded me of a question I had for people

Re: [PHP] Bitwise operation giving wrong results

2008-10-29 Thread Chris
Ashley Sheridan wrote: On Wed, 2008-10-29 at 20:01 -0400, sean greenslade wrote: I have the following code as a test: ?php $a = $_GET['a']; $b = $_GET['b']; echo $a .. $b . = ; $out = $a $b; echo $out; //echo 15 2; ? if I set a to 15 and b to 2 in the URL like so: test.php?a=15b=2 it

Re: [PHP] General Mysql Connect

2008-10-29 Thread Ashley Sheridan
On Wed, 2008-10-29 at 19:43 -0500, Micah Gersten wrote: Ashley Sheridan wrote: On Wed, 2008-10-29 at 19:25 -0500, Micah Gersten wrote: Ashley Sheridan wrote: On Thu, 2008-10-30 at 08:55 +1100, Chris wrote: Waynn Lue wrote: I sent an email to

Re: [PHP] General Mysql Connect

2008-10-29 Thread Micah Gersten
Ashley Sheridan wrote: On Wed, 2008-10-29 at 19:43 -0500, Micah Gersten wrote: Ashley Sheridan wrote: On Wed, 2008-10-29 at 19:25 -0500, Micah Gersten wrote: Ashley Sheridan wrote: On Thu, 2008-10-30 at 08:55 +1100, Chris wrote:

Re: [PHP] General Mysql Connect

2008-10-29 Thread Ashley Sheridan
On Wed, 2008-10-29 at 19:49 -0500, Micah Gersten wrote: Ashley Sheridan wrote: On Wed, 2008-10-29 at 19:43 -0500, Micah Gersten wrote: Ashley Sheridan wrote: On Wed, 2008-10-29 at 19:25 -0500, Micah Gersten wrote: Ashley Sheridan wrote: On

Re: [PHP] General Mysql Connect

2008-10-29 Thread Micah Gersten
Ashley Sheridan wrote: On Wed, 2008-10-29 at 19:49 -0500, Micah Gersten wrote: Ashley Sheridan wrote: On Wed, 2008-10-29 at 19:43 -0500, Micah Gersten wrote: Ashley Sheridan wrote: On Wed, 2008-10-29 at 19:25 -0500, Micah Gersten wrote:

Re: [PHP] General Mysql Connect

2008-10-29 Thread Ashley Sheridan
On Wed, 2008-10-29 at 19:57 -0500, Micah Gersten wrote: Ashley Sheridan wrote: On Wed, 2008-10-29 at 19:49 -0500, Micah Gersten wrote: Ashley Sheridan wrote: On Wed, 2008-10-29 at 19:43 -0500, Micah Gersten wrote: Ashley Sheridan wrote: On

Re: [PHP] General Mysql Connect

2008-10-29 Thread Waynn Lue
With MySQL, you can change the DB from query to query with mysql_select_db. The alternative as I stated in my last post is to use the fully qualified table name (database.table) in your query. MySQL doesn't care which DB you have open if you do that. In both of these cases, the same

Re: [PHP] General Mysql Connect

2008-10-29 Thread Chris
The answer in your case is not to combine the DBs necessarily, but consolidate the connections used. Like I said, you can use 2 MySQL DBs on the same connection in PHP. There's no reason to sacrifice separation of data. Forgot about this one until now.. mysql also supports the extended

Re: [PHP] General Mysql Connect

2008-10-29 Thread Micah Gersten
Ashley Sheridan wrote: On Wed, 2008-10-29 at 19:57 -0500, Micah Gersten wrote: Ashley Sheridan wrote: On Wed, 2008-10-29 at 19:49 -0500, Micah Gersten wrote: Ashley Sheridan wrote: On Wed, 2008-10-29 at 19:43 -0500, Micah Gersten wrote:

Re: [PHP] General Mysql Connect

2008-10-29 Thread Micah Gersten
Waynn Lue wrote: With MySQL, you can change the DB from query to query with mysql_select_db. The alternative as I stated in my last post is to use the fully qualified table name (database.table) in your query. MySQL doesn't care which DB you have open if you do that. In both of these

Re: [PHP] General Mysql Connect

2008-10-29 Thread Ashley Sheridan
On Wed, 2008-10-29 at 20:12 -0500, Micah Gersten wrote: Waynn Lue wrote: With MySQL, you can change the DB from query to query with mysql_select_db. The alternative as I stated in my last post is to use the fully qualified table name (database.table) in your query. MySQL doesn't care

Re: [PHP] General Mysql Connect

2008-10-29 Thread Micah Gersten
Ashley Sheridan wrote: On Wed, 2008-10-29 at 20:12 -0500, Micah Gersten wrote: Waynn Lue wrote: With MySQL, you can change the DB from query to query with mysql_select_db. The alternative as I stated in my last post is to use the fully qualified table name (database.table) in your

Re: [PHP] Newbie: can I store flash file into Mysql DB

2008-10-29 Thread Lupus Michaelis
Bastien Koert a écrit : We used to do that here, and there was significant performance impact after the database got to be about 12Gb, with minor impact showing after only a few Gb. I ended up having to write a script that stripped all the data from the Db into the file system. What engine

[PHP] Re: General Mysql Connect

2008-10-29 Thread Waynn Lue
Waynn Lue wrote: Yeah, it's the same user, same everything (for now). But I wonder why we're seeing these lost connection errors and I'm trying to fix it--this was one of the things I was investigating. Random guess :) You're overwriting a result or connection variable? $query =

Re: [PHP] Re: General Mysql Connect

2008-10-29 Thread Robert Cummings
On Wed, 2008-10-29 at 18:32 -0700, Waynn Lue wrote: Waynn Lue wrote: Yeah, it's the same user, same everything (for now). But I wonder why we're seeing these lost connection errors and I'm trying to fix it--this was one of the things I was investigating. Random guess :)

Re: [PHP] Newbie: can I store flash file into Mysql DB

2008-10-29 Thread Bastien Koert
On Wed, Oct 29, 2008 at 9:29 PM, Lupus Michaelis [EMAIL PROTECTED][EMAIL PROTECTED] wrote: Bastien Koert a écrit : We used to do that here, and there was significant performance impact after the database got to be about 12Gb, with minor impact showing after only a few Gb. I ended up