Re: [PHP] Need help on MySQL query

Rahat Bashir wrote: I need your help on writing a MySQL query. I see nothing php related in your question, try a mysql list. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] Dates and Mysql

This one time, at band camp, VamVan <[EMAIL PROTECTED]> wrote: > I was wondering how is it possible for me to query the table to retrieve all > the records that are one week less than the time stamp? SELECT DATE_SUB(date_time_column, INTERVAL 1 WEEK) FROM your_table; http://www.phpro.org/tutoria

[PHP] Re: Need help on MySQL query

Rahat Bashir schrieb: Hi Experts, EID Mubarak to all. I need your help on writing a MySQL query. Scenario: CREATE TABLE transaction ( `id` int NOT NULL ATUTO INCREMENT, `date` datetime NOT NULL, `withdrawn` double (12,2) NULL, `deposit` double (12,2) NULL ); SELECT * FROM transaction; id

Re: [PHP] Need help on MySQL query

On Wed, Dec 10, 2008 at 10:52 PM, Rahat Bashir <[EMAIL PROTECTED]> wrote: > Hi Experts, > > EID Mubarak to all. > > I need your help on writing a MySQL query. > > Scenario: > > CREATE TABLE transaction > ( > `id` int NOT NULL ATUTO INCREMENT, > `date` datetime NOT NULL, > `withdrawn` double (12,2)

Re: [PHP] Need help on MySQL query

On Thu, Dec 11, 2008 at 4:52 PM, Rahat Bashir <[EMAIL PROTECTED]>wrote: > Hi Experts, > > EID Mubarak to all. > > I need your help on writing a MySQL query. > > Scenario: > > CREATE TABLE transaction > ( > `id` int NOT NULL ATUTO INCREMENT, > `date` datetime NOT NULL, > `withdrawn` double (12,2)

[PHP] Need help on MySQL query

Hi Experts, EID Mubarak to all. I need your help on writing a MySQL query. Scenario: CREATE TABLE transaction ( `id` int NOT NULL ATUTO INCREMENT, `date` datetime NOT NULL, `withdrawn` double (12,2) NULL, `deposit` double (12,2) NULL ); SELECT * FROM transaction; id date withdra

Re: [PHP] usort for sorting an array of objects

On Thu, 2008-12-11 at 11:44 +1300, German Geek wrote: > On Thu, Dec 11, 2008 at 6:43 AM, Robert Cummings <[EMAIL PROTECTED]>wrote: > > > On Thu, 2008-12-11 at 01:31 +1300, German Geek wrote: > > > On Wed, Dec 10, 2008 at 10:27 PM, Stut <[EMAIL PROTECTED]> wrote: > > > > > > > On 10 Dec 2008, at 04

Re: [PHP] array_intersect question

On Tue, Dec 2, 2008 at 11:06 PM, Andrej Kastrin <[EMAIL PROTECTED]>wrote: > It works like a charm. > > Thanks, Andrej > > Tim | iHostNZ wrote: > >> I know there must be a more elegant way with array_reduce or something, >> but >> I would simply write a function called >> >> function array_intersec

Re: [PHP] Re: converting a vid with ffmpeg - howto do progress bars?

On Thu, Dec 11, 2008 at 2:27 PM, Rene Veerman <[EMAIL PROTECTED]> wrote: > German Geek wrote: > >> On Thu, Dec 11, 2008 at 1:53 PM, Rene Veerman <[EMAIL PROTECTED]> [EMAIL PROTECTED]>> wrote: >> >>Colin Guthrie wrote: >> >>'Twas brillig, and Rene Veerman at 10/12/08 23:03 did gyre and

Re: [PHP] Re: converting a vid with ffmpeg - howto do progress bars?

German Geek wrote: On Thu, Dec 11, 2008 at 1:53 PM, Rene Veerman <[EMAIL PROTECTED] > wrote: Colin Guthrie wrote: 'Twas brillig, and Rene Veerman at 10/12/08 23:03 did gyre and gimble: Well, nowhere can i find the frame count being pri

Re: [PHP] how to not show login info in the url ...what am I looking for?

Please keep the discussion on the list, or offer me a contract. On 10 Dec 2008, at 14:29, Terion Miller wrote: On Tue, Dec 9, 2008 at 4:03 PM, Stut <[EMAIL PROTECTED]> wrote: On 9 Dec 2008, at 21:54, Terion Miller wrote: On Tue, Dec 9, 2008 at 3:49 PM, Stut <[EMAIL PROTECTED]> wrote: On 9 Dec 20

Re: [PHP] Re: converting a vid with ffmpeg - howto do progress bars?

On Thu, Dec 11, 2008 at 1:53 PM, Rene Veerman <[EMAIL PROTECTED]> wrote: > Colin Guthrie wrote: > >> 'Twas brillig, and Rene Veerman at 10/12/08 23:03 did gyre and gimble: >> >>> Well, nowhere can i find the frame count being printed, but there _is_ a >>> duration: hh:mm:ss:ms field outputted, and

Re: [PHP] Can GD make a JPG thumbnail of a PDF?

On Thu, Dec 11, 2008 at 1:59 PM, Stephen Johnson <[EMAIL PROTECTED] > wrote: > I think you want something like this : > exec("convert -density 360x360 -enhance $pdfFile $pdfFile.gif"); > Yes, that's how i did it here. Didn't find a better solution yet. Was looking at the php module for imagemagic

Re: [PHP] Can GD make a JPG thumbnail of a PDF?

On Thu, Dec 11, 2008 at 1:59 PM, Stephen Johnson <[EMAIL PROTECTED] > wrote: > I think you want something like this : > exec("convert -density 360x360 -enhance $pdfFile $pdfFile.gif"); Yes, that's how i did it here. Didn't find a better solution yet. Was looking at the php module for imagemagick

Re: [PHP] Can GD make a JPG thumbnail of a PDF?

I think you want something like this : exec("convert -density 360x360 -enhance $pdfFile $pdfFile.gif"); On 12/10/08 4:48 PM, "Brian Dunning" <[EMAIL PROTECTED]> wrote: > I've spent most of the last week trying to get ImageMagick working on > my Windows PHP installation. I gather that since I'm g

Re: [PHP] Re: converting a vid with ffmpeg - howto do progress bars?

Colin Guthrie wrote: 'Twas brillig, and Rene Veerman at 10/12/08 23:03 did gyre and gimble: Well, nowhere can i find the frame count being printed, but there _is_ a duration: hh:mm:ss:ms field outputted, and the updating line displays a time=seconds.ms (the time in the movie where the encoder

Re: [PHP] Can GD make a JPG thumbnail of a PDF?

I've spent most of the last week trying to get ImageMagick working on my Windows PHP installation. I gather that since I'm going to be converting PDFs to JPEGs, I need Ghostscript. Well, I've got ImageMagick installed: http://printhq2.com/info.php I ran a Ghostscript installer, but it didn't

Re: [PHP] restrict fsockopen spam etc.

Andre Hübner wrote: Hello List, in last times i recognize that some scripts/formmailer of customers get abused by spammers. Some scripts avoid to use smtp-server and do smtp-dialog by its own using fsockopen etc. Problem ist that if mails are sent by fsockopen directy to other servers they no

Re: [PHP] usort for sorting an array of objects

On Thu, Dec 11, 2008 at 12:28 PM, <[EMAIL PROTECTED]> wrote: > > > Inefficiency for me is when it takes longer to code. > > How long can this take? That's why i like PHP. It's very quick to do stuff in, even if arrays are not always the ultimate data structure, they're easy to handle with all the

[PHP] Re: converting a vid with ffmpeg - howto do progress bars?

'Twas brillig, and Rene Veerman at 10/12/08 23:03 did gyre and gimble: Well, nowhere can i find the frame count being printed, but there _is_ a duration: hh:mm:ss:ms field outputted, and the updating line displays a time=seconds.ms (the time in the movie where the encoder is at). The question

Re: [PHP] Dates and Mysql

VamVan wrote: Hello Gang, I have a Mysql table which has timestamp for the date the record was created. I was wondering how is it possible for me to query the table to retrieve all the records that are one week less than the time stamp? http://dev.mysql.com/doc/refman/5.0/en/date-and-time-fun

Re: [PHP] Dates and Mysql

VamVan wrote: > Hello Gang, > > I have a Mysql table which has timestamp for the date the record was > created. > > I was wondering how is it possible for me to query the table to retrieve all > the records that are one week less than the time stamp? > > Thanks, > V > > I'm assuming you meant g

Re: [PHP] usort for sorting an array of objects

> Inefficiency for me is when it takes longer to code. How long can this take? Even if you go full-blown with an Interface and static methods that have to be fleshed out in the implementations, you're still talking about an hour or so. Quit complaining and start typing. :-) > PHP is

[PHP] Dates and Mysql

Hello Gang, I have a Mysql table which has timestamp for the date the record was created. I was wondering how is it possible for me to query the table to retrieve all the records that are one week less than the time stamp? Thanks, V

Re: [PHP] converting a vid with ffmpeg - howto do progress bars?

Boyd, Todd M. wrote: Top posting BAD! Hulk SMASH! Anyway, moving on... I believe "ffmpeg -i " should give you frame count information (along with a bunch of other stuff). It will have to be parsed, of course, but... meh. Also--were you aware that there is an ffmpeg PHP extension? It's even got

Re: [PHP] usort for sorting an array of objects

PHP is a scripting language. Everytime the compiler has to parse the source. You can not except true OOP performance. OOP behavior is okay. If performance is the main factor, an C extension will do that. -- Blog: http://talk.cmyweb.net/ Follow me: http://twitter.com/shiplu -- PHP General Mailing

Re: [PHP] usort for sorting an array of objects

On Thu, Dec 11, 2008 at 6:43 AM, Robert Cummings <[EMAIL PROTECTED]>wrote: > On Thu, 2008-12-11 at 01:31 +1300, German Geek wrote: > > On Wed, Dec 10, 2008 at 10:27 PM, Stut <[EMAIL PROTECTED]> wrote: > > > > > On 10 Dec 2008, at 04:15, German Geek wrote: > > > > > >> I need to sort an array of ob

RE: [PHP] converting a vid with ffmpeg - howto do progress bars?

ec() atm. > > just running the ffmpeg command shows some details and then a sort of > continually updated status report; > > Input #0, avi, from > '/home/rene/web/LIVE_WEBSITES/www/veerman.name/mediaBeez_content/media/ > upload/20081210 > 220610/work/original/xy.avi'

Re: [PHP] converting a vid with ffmpeg - howto do progress bars?

man.name/mediaBeez_content/media/upload/20081210 > > 220610/work/original/xy.avi': > Duration: 00:43:03.3, start: 0.00, bitrate: 1137 kb/s > Stream #0.0: Video: mpeg4, yuv420p, 624x352, 23.98 fps(r) > Stream #0.1: Audio: mp3, 48000 Hz, stereo, 112 kb/s > Output

Re: [PHP] converting a vid with ffmpeg - howto do progress bars?

I call it from php with exec() atm. just running the ffmpeg command shows some details and then a sort of continually updated status report; Input #0, avi, from '/home/rene/web/LIVE_WEBSITES/www/veerman.name/mediaBeez_content/media/upload/20081210 220610/work/original/xy.avi':

Re: [PHP] converting a vid with ffmpeg - howto do progress bars?

On Wed, 2008-12-10 at 22:13 +0100, Rene Veerman wrote: > Hi, i got ffmpeg to convert videos for my CMS to Flash-video. > With debian, it was real easy to set up. > > The only drawback is that if i can't advance the progressbar during the > call to ffmpeg.. > If i encode longer videos, it can take

[PHP] converting a vid with ffmpeg - howto do progress bars?

Hi, i got ffmpeg to convert videos for my CMS to Flash-video. With debian, it was real easy to set up. The only drawback is that if i can't advance the progressbar during the call to ffmpeg.. If i encode longer videos, it can take up to an hour each, and to halt the progressbar for that long is

Re: [PHP] PHP OFX connection

On Wed, Dec 10, 2008 at 15:40, Dan Harrington <[EMAIL PROTECTED]> wrote: [snip!] > > Just wondered if anyone in PHP land had successfully created a PHP-based > system to connect to a bank's server and download OFX data and consume it. > I'm looking to find a way to help reconcile our bank accounts

[PHP] PHP OFX connection

Hello, No doubt some of you have heard of Quicken, Quickbooks, Microsoft Money and other providers. Apparently there is a data format called OFX (Open Financial Exchange) that these software packages use to download transaction data from banks. Just wondered if anyone in PHP land had successf

RE: [PHP] how to not show login info in the url ...what am I looking for?

On Wed, 2008-12-10 at 09:58 -0600, Boyd, Todd M. wrote: > > -Original Message- > > From: APseudoUtopia [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, December 10, 2008 9:12 AM > > To: tedd > > Cc: [EMAIL PROTECTED]; PHP General > > Subject: Re: [PHP] how to not show login info in the url ..

Re: [PHP] foreach and destroying variables for memory saving

PHP does have garbage_collection, and it's crucial in long-running CLI scripts. Per is right, though, in that if your web-page Apache PHP script needs GC, you are doing something terribly wrong. It is not as aggressive/thorough as, say, the Lisp GC, but it's there. ymmv -- PHP Genera

Re: [PHP] usort for sorting an array of objects

You can use a (base) object Comparable with a method compareTo as the callback function for http://php.net/usort That gives you 99% of what you want, for the tiny price of having to pass in the array('Comparable','compareTo') as the callback arg. Given that one frequently calls usort and f

Re: [PHP] usort for sorting an array of objects

may be you can design a class. interface ISortable{ public sort(); public compare($a,$b); } SortableList implements ISortable { } -- Blog: http://talk.cmyweb.net/ Follow me: http://twitter.com/shiplu -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/u

Re: [PHP] usort for sorting an array of objects

On Thu, 2008-12-11 at 01:31 +1300, German Geek wrote: > On Wed, Dec 10, 2008 at 10:27 PM, Stut <[EMAIL PROTECTED]> wrote: > > > On 10 Dec 2008, at 04:15, German Geek wrote: > > > >> I need to sort an array of objects. I found this ( at a url that didnt let > >> me send this msg... ) and I would kn

[PHP] Re: foreach and destroying variables for memory saving

Tim | iHostNZ wrote: > Hi All, > > Just to annoy the hell out of you, another thing that has been on my mind > for a while: > > I love the foreach ($ar as $k => $v) { ... } construct and use it all the > time. However, I read somewhere that foreach actually uses a copy of $ar > instead of the arr

RE: [PHP] how to not show login info in the url ...what am I looking for?

> -Original Message- > From: APseudoUtopia [mailto:[EMAIL PROTECTED] > Sent: Wednesday, December 10, 2008 9:12 AM > To: tedd > Cc: [EMAIL PROTECTED]; PHP General > Subject: Re: [PHP] how to not show login info in the url ...what am I > looking for? > > On Wed, Dec 10, 2008 at 10:03 AM, ted

RE: [PHP] MSSQL_CONNECT problem

It's fixed WOO HOO - I'm going to get teary-eyedDan - special thanks to you for helping me so much... What fixed this? I put the DLL for SQL 2005 PHP Driver in the PHP/EXT directory, and added the extension to the php.ini. Restarted IIS, and BAM! Everything works The only thing I did

Re: [PHP] how to not show login info in the url ...what am I looking for?

On Wed, Dec 10, 2008 at 10:03 AM, tedd <[EMAIL PROTECTED]> wrote: > At 9:52 PM + 12/9/08, Ashley Sheridan wrote: >> >> > >>> >>> Thanks guys and gals! >> >> You shouldn't be passing info like that over the URL; use sessions >> instead. >> >> I saw a shopping cart system once that passed the p

RE: [PHP] MSSQL_CONNECT problem

From: Dan Shirah [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 10, 2008 9:42 AM To: David Stoltz Cc: Daniel Brown; Bastien Koert; php-general@lists.php.net Subject: Re: [PHP] MSSQL_CONNECT problem Is INTRA_SQL your instance name or database name? If it is the instance name

Re: [PHP] how to not show login info in the url ...what am I looking for?

At 9:52 PM + 12/9/08, Ashley Sheridan wrote: > Thanks guys and gals! You shouldn't be passing info like that over the URL; use sessions instead. I saw a shopping cart system once that passed the price of items over the URL, and when I found out and alerted them, we won the contract for a

[PHP] Re: foreach and destroying variables for memory saving

Tim | iHostNZ schrieb: Hi All, Just to annoy the hell out of you, another thing that has been on my mind for a while: I love the foreach ($ar as $k => $v) { ... } construct and use it all the time. However, I read somewhere that foreach actually uses a copy of $ar instead of the array itself by

Re: [PHP] MSSQL_CONNECT problem

> > Is INTRA_SQL your instance name or database name? If it is the instance > name, is that instance setup to use 1433 as the port? I know 1433 is > the > default port for MSSQL, but the majority of people change that. > > > Correct - intra_sql is the instance, yes, it's using default port 1433 >

RE: Re: [PHP] file_exists and wildcard/regex

> -Original Message- > From: Boyd, Todd M. [mailto:[EMAIL PROTECTED] > Sent: Wednesday, December 10, 2008 8:28 AM > To: php-general@lists.php.net > Subject: RE: Re: [PHP] file_exists and wildcard/regex > > FWIW, I would probably do the file search like this (UNTESTED): > > > $filereg =

RE: Re: [PHP] file_exists and wildcard/regex

> -Original Message- > From: Per Jessen [mailto:[EMAIL PROTECTED] > Sent: Wednesday, December 10, 2008 1:43 AM > To: php-general@lists.php.net > Subject: Re: [PHP] file_exists and wildcard/regex > > Ashley Sheridan wrote: > > > If you're on a Linux system, you could look at ls and the reg

RE: [PHP] MSSQL_CONNECT problem

-Original Message- From: Dan Shirah [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 10, 2008 8:46 AM To: David Stoltz Cc: Daniel Brown; Bastien Koert; php-general@lists.php.net Subject: Re: [PHP] MSSQL_CONNECT problem > > Try something like this: > > > > $dbhost=SERVER\\INSTAN

Re: [PHP] foreach and destroying variables for memory saving

Tim | iHostNZ wrote: > Somewhere i also read that one can save a lot of memory by destroying > variables. Is that done with unset, setting it to null or something > similar? unset() > So, i take there is no garbage collection in php? I've never > actually looked at the c source code of php. Ma

Re: [PHP] MSSQL_CONNECT problem

> > Try something like this: > > > > $dbhost=SERVER\\INSTANCE_NAME,PORT; > $dbuser="USERNAME"; > $dbpass="PASSWORD"; > $db_connect=mssql_connect($dbhost,$dbuser,$dbpass) or die ('Server > connection failed'); > > > > $mssql_database = mssql_select_db("DATABASE", $db_connect) or die ('DB > s

RE: [PHP] MSSQL_CONNECT problem

From: Dan Shirah [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 10, 2008 8:10 AM To: David Stoltz Cc: Daniel Brown; Bastien Koert; php-general@lists.php.net Subject: Re: [PHP] MSSQL_CONNECT problem Sorry for "top posting", that's how my email client sets up the reply...

Re: [PHP] MSSQL_CONNECT problem

> > Sorry for "top posting", that's how my email client sets up the reply... > > Anyway, I don't know what CLI is? I see the error on the web. As for > a DSN, I didn't think I need one connecting this way. That is why the > uname, password, database is supplied, no? This should be a "dsn-less"

RE: [PHP] MSSQL_CONNECT problem

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Daniel Brown Sent: Tuesday, December 09, 2008 3:49 PM To: David Stoltz Cc: Bastien Koert; Dan Shirah; php-general@lists.php.net Subject: Re: [PHP] MSSQL_CONNECT problem On Tue, Dec 9, 2008 at 3:41 PM, David S

[PHP] foreach and destroying variables for memory saving

Hi All, Just to annoy the hell out of you, another thing that has been on my mind for a while: I love the foreach ($ar as $k => $v) { ... } construct and use it all the time. However, I read somewhere that foreach actually uses a copy of $ar instead of the array itself by reference. Wouldn't it b

Re: [PHP] usort for sorting an array of objects

On Wed, Dec 10, 2008 at 10:27 PM, Stut <[EMAIL PROTECTED]> wrote: > On 10 Dec 2008, at 04:15, German Geek wrote: > >> I need to sort an array of objects. I found this ( at a url that didnt let >> me send this msg... ) and I would know how to do it, but I believe there >> might be a cleaner, more e

Re: [PHP] Re: restrict fsockopen spam etc.

I think there was a proposed change to allow php to log mail calls. I was disappointed to see it did not get put in to php yet though. Would help to pinpoint scripts being abused, especially in shared environments. On Dec 10, 2008, at 1:43 AM, Carlos Medina <[EMAIL PROTECTED]> wrote: A

[PHP] Re: restrict fsockopen spam etc.

Andre Hübner schrieb: Hello List, in last times i recognize that some scripts/formmailer of customers get abused by spammers. Some scripts avoid to use smtp-server and do smtp-dialog by its own using fsockopen etc. Problem ist that if mails are sent by fsockopen directy to other servers they

Re: [PHP] usort for sorting an array of objects

On 10 Dec 2008, at 04:15, German Geek wrote: I need to sort an array of objects. I found this ( at a url that didnt let me send this msg... ) and I would know how to do it, but I believe there might be a cleaner, more elegant way to do it. In Java, you just need to implement the interface Co

Re: [PHP] Include directive..

Am having this error in the apache log files WHat does it imply really. I have no idea. Am trying to run Zf but my pages are all blank so i was wondering if this has anything to do with it. Thanks will appreciate any help: [Wed Dec 10 11:15:03 2008] [warn] [client 190.30.20.221] mod_include: Opti

[PHP] restrict fsockopen spam etc.

Hello List, in last times i recognize that some scripts/formmailer of customers get abused by spammers. Some scripts avoid to use smtp-server and do smtp-dialog by its own using fsockopen etc. Problem ist that if mails are sent by fsockopen directy to other servers they not occur in server-mail