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 en

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. > >> > > > > Ra

[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?

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 d

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 (databas

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 > >> doe

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 thes

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 Ge

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 syntax:

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 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:

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 Ge

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:

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 w

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: > >

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: if I set a to 15 and b to 2 in the URL like so: test.php?a=15&b=2 it outputs zero as the answer. When I run the hard-coded '&' operation (the commented out echo), it returns

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

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. W

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: > $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=15&b=2 >

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? R

[PHP] Bitwise operation giving wrong results

2008-10-29 Thread sean greenslade
I have the following code as a test: if I set a to 15 and b to 2 in the URL like so: test.php?a=15&b=2 it outputs zero as the answer. When I run the hard-coded '&' operation (the commented out echo), it returns 2. I'm stumped. -- --Zootboy

[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] 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 * f

[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 mysq

[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

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

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 calls

[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] 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 fi

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 ther

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 a

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. -- http://www.parasane.n

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 ha

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 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 negativ

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 the

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 unsubscr

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 ha

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 profi

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 r

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: > http://www.nabble.com/Newbie%3A-can-I-store-flash-file-into-Mysql-

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

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 א-ב-ג-ד-ה-ו-ז-ח-ט-י-ך-כ-ל-

[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 (http://www.p

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. >>>

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 file

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 st

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

[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 Nab

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"; print"color='#99'>"; include($filename); print""; John Taylor-Johnston wrote: I have http://www.flash-here.com/down

[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 i

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 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 databas

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"; > > print" color='#99'>"; >include($filename); > print""; > > John Taylor-Johnston wrote: > > I have http://www.flash-here.com/downlo

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 fr

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