Re: [PHP] Exporting large data from mysql to html using php

2011-10-27 Thread Lester Caine
Jim Giner wrote: Your boss wants to give access to phone numbers to the public in general? Then what? Glad mine's unlisted. Is it? Does it start 518248 ? I often forget to get a phone number when a parcel has to go by carrier, and paypal does not include that info, but only rarely does one no

Re: [PHP] Exporting large data from mysql to html using php

2011-10-27 Thread David Robley
Jim Giner wrote: > "David Robley" wrote in message > news:49.50.34068.1b567...@pb1.pair.com... >> >> Consider running EXPLAIN on all your queries to see if there is something >> Mysql thinks could be done to improve performance. >> > > Why do so many responders seem to think the problem here is

Re: [PHP] Convert Hours to Decimal

2011-10-27 Thread Richard Quadling
On 17 October 2011 22:57, Don Wieland wrote: > select timediff(cast(out_1 as time), cast(in_1 as time)) tHours FROM > lm_tc_trans WHERE tc_trans_id = '42' Can you try ... SELECT CAST ( TIMEDIFF ( CAST(Out_1 A

Re: [PHP] Friday Distraction

2011-10-27 Thread Richard Quadling
On 21 October 2011 17:27, Daniel Brown wrote: >    I'll get this week's Friday distraction kicked off here with > something shared with me by a Facebook friend.  If you're on Facebook, > try this.  It's pretty sweet (and safe for work and kids). > >        http://www.takethislollipop.com/ Sweet?

[PHP] array_unique by id multi-dimensional array

2011-10-27 Thread Tontonq Tontonq
i have an array like [0] => Array ( [likes] => 113091 [name] => blabla [access_token] => AAABZCTx [id] => 188206217874932 ) [1] => Array ( [likes] => 113091 [name] => blabla [access_token] => AAABZCTz [id] => 188206217874932 ) i want to filter the array by [id] sub value?

[PHP] Re: array_unique by id multi-dimensional array

2011-10-27 Thread Jim Giner
> > i want to filter the array by [id] sub value? > The PHP manual is a source of infinite knowledge. A simple entry of "array" in the "search for" field brings up just what you need. Have at it! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/un

[PHP] What is wrong with this preg_match?

2011-10-27 Thread Paul Halliday
I have the following: if (isset($argc)) { if ($argc == 1 || $argc > 2 || !preg_match("(\d{4}-\d{2}-\d{2})", $argv[1])) { echo "\nUsage: $argv[0] \n\n"; exit; } else { $base_date = $argv[1]; } } else { $base_date = date('Y-m-d'); } When I run it: $ ./proce

Re: [PHP] Exporting large data from mysql to html using php

2011-10-27 Thread Tommy Pham
On Wed, Oct 26, 2011 at 5:47 PM, Jason Pruim wrote: > > Jason Pruim > li...@pruimphotography.com > > The server that's running it is a home computer with a VPS installed... > It's not my dev environment :) > > Home computer used for a production environment? Wow.. I'm speechless. > The informat

RE: [PHP] What is wrong with this preg_match?

2011-10-27 Thread Steve Staples
-Original Message- From: Paul Halliday [mailto:paul.halli...@gmail.com] Sent: Thursday, October 27, 2011 2:43 PM To: PHP-General Subject: [PHP] What is wrong with this preg_match? I have the following: if (isset($argc)) { if ($argc == 1 || $argc > 2 || !preg_match("(\d{4}-\d{2}-\d{2}

Re: [PHP] What is wrong with this preg_match?

2011-10-27 Thread Robert Williams
On 10/27/11 11:43, "Paul Halliday" wrote: >if ($argc == 1 || $argc > 2 || !preg_match("(\d{4}-\d{2}-\d{2})", > >Usage: ./process_patches.php > >patches@innm2 ~/Code/Oculi $ ./process_patches.php 2011-01-011 The problem is that your expression basically defines a 'contains'-type search, so

Re: [PHP] Exporting large data from mysql to html using php

2011-10-27 Thread Nathan Nobbe
On Mon, Oct 24, 2011 at 6:50 PM, Jason Pruim wrote: > Now that I've managed to list 3 separate programming languages and somewhat > tie it back into php here's the question... > > I have about 89 million records in mysql... the initial load of the page > takes 2 to 3 minutes, I am using pagination

Re: [PHP] Exporting large data from mysql to html using php

2011-10-27 Thread Jim Giner
> > Good luck, that's a LOT of reading. I'd estimate that's about 3k+ pages > of > reading. :) > > >> > >> > >> > Regards, >> > Tommy >> >> > nice to see someone else is finally getting the point that I'm been making. -- PHP General Mailing List (http://www.php.net/) To unsu

[PHP] Question reading a file

2011-10-27 Thread Tedd Sperling
Hi gang: I have a few questions -- this is my first one. Please review this link: http://webbytedd.com//perms/ This page simply reads the contents of a file of the user's choice and displays the file's data. My first question is with regard to reading a file ( fread() ): If the user pick

[PHP] Execute permission question

2011-10-27 Thread Tedd Sperling
Hi gang: Another question -- in the context of file permissions (rwx) is the execute permission limited to shell commands -- Or -- is there more? Cheers, tedd _ t...@sperling.com http://sperling.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, vis

Re: [PHP] Execute permission question

2011-10-27 Thread Larry Martell
On Thu, Oct 27, 2011 at 2:26 PM, Tedd Sperling wrote: > Hi gang: > > Another question -- in the context of file permissions (rwx) is the execute > permission limited to shell commands -- Or -- is there more? Not sure I fully understand your question, but to execute anything directly - shell scri

Re: [PHP] Execute permission question

2011-10-27 Thread Ashley Sheridan
On Thu, 2011-10-27 at 14:41 -0600, Larry Martell wrote: > On Thu, Oct 27, 2011 at 2:26 PM, Tedd Sperling > wrote: > > Hi gang: > > > > Another question -- in the context of file permissions (rwx) is the execute > > permission limited to shell commands -- Or -- is there more? > > Not sure I ful

Re: [PHP] Question reading a file

2011-10-27 Thread Ashley Sheridan
On Thu, 2011-10-27 at 15:25 -0400, Tedd Sperling wrote: > Hi gang: > > I have a few questions -- this is my first one. > > Please review this link: > > http://webbytedd.com//perms/ > > This page simply reads the contents of a file of the user's choice and > displays the file's data. > >

[PHP] OpenId Provider

2011-10-27 Thread Roy Kaldung
Hi, Can anybody recommend a good OpenId Provider? I need one with LDAP integration if available. tia, Roy -- Roy Kaldung -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Question reading a file

2011-10-27 Thread Daniel Brown
On Thu, Oct 27, 2011 at 15:25, Tedd Sperling wrote: > Hi gang: > > I have a few questions -- this is my first one. > > Please review this link: > > http://webbytedd.com//perms/ > > This page simply reads the contents of a file of the user's choice and > displays the file's data. > > My first

Re: [PHP] Question reading a file

2011-10-27 Thread Tedd Sperling
On Oct 27, 2011, at 5:14 PM, Daniel Brown wrote: > On Thu, Oct 27, 2011 at 15:25, Tedd Sperling wrote: >> -snip my confusion - > >No need to review the code. The first hunch I had proved correct. > PHP opens with a less-than (left carat, or 'less-than') symbol, as do > HTML tags. As a resul

Re: [PHP] Execute permission question

2011-10-27 Thread Tedd Sperling
On Oct 27, 2011, at 4:51 PM, Ashley Sheridan wrote: > Yes, I just ran a quick test PHP script without any execute permissions set > at all, only rw-rw-r-- and it ran just fine, suggesting it is just an > argument as Larry said. > > I don't think Apache needs execute permissions set on PHP files

Re: [PHP] Execute permission question

2011-10-27 Thread Daniel Brown
On Thu, Oct 27, 2011 at 18:15, Tedd Sperling wrote: > > Ash: > > You answered a question I wasn't prepared to ask, which was "How can php > scripts be executed when their execute permissions aren't set?" > > That question begged the question of "What does execute mean?" It means "execute."

Re: [PHP] Exporting large data from mysql to html using php

2011-10-27 Thread Jason Pruim
Jason Pruim li...@pruimphotography.com On Oct 27, 2011, at 2:44 PM, Tommy Pham wrote: > On Wed, Oct 26, 2011 at 5:47 PM, Jason Pruim > wrote: > > Jason Pruim > li...@pruimphotography.com > > The server that's running it is a home computer with a VPS installed... It's > not my dev environm

Re: [PHP] Exporting large data from mysql to html using php

2011-10-27 Thread Jason Pruim
Jason Pruim li...@pruimphotography.com On Oct 27, 2011, at 4:08 PM, Nathan Nobbe wrote: > On Mon, Oct 24, 2011 at 6:50 PM, Jason Pruim > wrote: > Now that I've managed to list 3 separate programming languages and somewhat > tie it back into php here's the question... > > I have about 89 mi

Re: [PHP] Execute permission question

2011-10-27 Thread Tedd Sperling
On Oct 27, 2011, at 6:27 PM, Daniel Brown wrote: > On Thu, Oct 27, 2011 at 18:15, Tedd Sperling wrote: >> >> Ash: >> >> You answered a question I wasn't prepared to ask, which was "How can php >> scripts be executed when their execute permissions aren't set?" >> >> That question begged the qu

Re: [PHP] Execute permission question

2011-10-27 Thread Tedd Sperling
On Oct 27, 2011, at 6:27 PM, Daniel Brown wrote: > On Thu, Oct 27, 2011 at 18:15, Tedd Sperling wrote: >> That question begged the question of "What does execute mean?" > >It means "execute." Not to be confused with what others are > mentioning here, which is "read and interpret." If you ru

Re: [PHP] Execute permission question

2011-10-27 Thread Daniel Brown
On Thu, Oct 27, 2011 at 19:44, Tedd Sperling wrote: > > One of the things I'm trying to understand is a php script can execute a > shell command, right? Is there a way via permissions to prevent that -- or -- > does that even have anything to do with it? That's where I'm fuzzy. Sure. What

[PHP] Help with redeclare error

2011-10-27 Thread Jack
Hello All, I have some code that just broke with a PHP upgrade, the error says: PHP Fatal error: Cannot redeclare date_diff() the line of the error is the close bracket of the function which is below. Any ideas what's going on, I'm stuck? function date_diff($start_time, $stop_time)

Re: [PHP] Help with redeclare error

2011-10-27 Thread Jason Pruim
Jason Pruim li...@pruimphotography.com On Oct 27, 2011, at 7:55 PM, Jack wrote: > Hello All, > > > > I have some code that just broke with a PHP upgrade, the error says: > > PHP Fatal error: Cannot redeclare date_diff() the line of the error is the > close bracket of the function which is

Re: [PHP] Help with redeclare error

2011-10-27 Thread Daniel Brown
On Thu, Oct 27, 2011 at 20:06, Jason Pruim wrote: > > Most likely you have in included in 2 files... Look into it from that > angle... It only needs to be included in 1 file to work throughout all the > files. Prune is spot-on. That error generally happens when you include a file that has

Re: [PHP] OpenId Provider

2011-10-27 Thread Negin Nickparsa
I don't know about LDAP but Zend openID provider can be a good choice http://framework.zend.com/manual/en/zend.openid.html On 10/28/11, Roy Kaldung wrote: > Hi, > > Can anybody recommend a good OpenId Provider? > I need one with LDAP integration if available. > > tia, > Roy > > -- > Roy Kaldung >

Re: [PHP] Help with redeclare error

2011-10-27 Thread UltraMega Admin
On 10/27/2011 5:33 PM, Daniel Brown wrote: On Thu, Oct 27, 2011 at 20:06, Jason Pruim wrote: Most likely you have in included in 2 files... Look into it from that angle... It only needs to be included in 1 file to work throughout all the files. Prune is spot-on. That error generally hap

Re: [PHP] array_unique by id multi-dimensional array

2011-10-27 Thread tamouse mailing lists
On Thu, Oct 27, 2011 at 10:31 AM, Tontonq Tontonq wrote: > i have an array like > >  [0] => Array > ( > [likes] => 113091 >  [name] => blabla >  [access_token] => AAABZCTx > [id] => 188206217874932 > > ) > >  [1] => Array > ( > [likes] => 113091 > [name] => blabla > [access_token] =>   AAABZCTz >

Re: [PHP] Help with redeclare error

2011-10-27 Thread Ashley Sheridan
On Thu, 2011-10-27 at 17:40 -0700, UltraMega Admin wrote: > On 10/27/2011 5:33 PM, Daniel Brown wrote: > > On Thu, Oct 27, 2011 at 20:06, Jason Pruim > > wrote: > >> Most likely you have in included in 2 files... Look into it from that > >> angle... It only needs to be included in 1 file to wor