headers
PJ | 1 Apr 2009 01:15
Picon

Re: formulate nested select

haliphax wrote:
> On Tue, Mar 31, 2009 at 5:15 PM, PJ <af.gourmet <at> videotron.ca> wrote:
>> kyle.smith wrote:
>>> What about using "IN", something like:
>>>
>>> SELECT * FROM book WHERE id IN (SELECT bookID FROM book_authors WHERE
>>> authID IN (SELECT author.id FROM authors WHERE last_name LIKE
>>> "$Auth%"));
>>>
>>> You could use LEFT instead of LIKE, too.
>> Well, I learned something here... but that also revealed another,
>> hidden, problem which I had not considered - the order by clause which I
>> had stupidly not included in my example:
>>
>> $SQL = "SELECT * FROM book
>> Â  Â  Â  Â WHERE id IN (SELECT bookID
>> Â  Â  Â  Â FROM book_author WHERE authID IN (SELECT author.id
>> Â  Â  Â  Â FROM author WHERE LEFT(last_name, 1 ) = '$Auth'))
>> Â  Â  Â  Â ORDER BY $sort $dir
>> Â  Â  Â  Â LIMIT $offset, $records_per_page ";
>>
>> I now realize that to keep things as simple as possible in the rest of
>> the code, I must join 1 column to the query result and that is last_name
>> from the author table.
>> the spelling, column and table names are spelled correctly. Without the
>> ORDER BY I get the right results. I'll try to JOIN the author table ???
>> But I see that I may be trying to do too much - I thought of showing how
>> many books were listed under each letter of the alphabet but I don't see
>> how it can be done in any simiple way as it would mean that I would have
>> to do the select once with the ORDER BY and a second time without it
(Continue reading)

Permalink | Reply | 1 comment |
headers
Phpster | 1 Apr 2009 01:32
Picon

Re: Re: PHP task manager

Zoho's project tool looks pretty good. Www.zoho.com

Bastien

Sent from my iPod

On Mar 31, 2009, at 18:20, Colin Guthrie <gmane <at> colin.guthr.ie> wrote:

> 'Twas brillig, and George Larson at 31/03/09 20:31 did gyre and  
> gimble:
>> We've got a homebrew ToDo list (task & project) manager / mailer  
>> that we're
>> thinking about replacing with something a little more robust.
>> Any suggestions?  I saw TaskFreak! on Google but I am curious if  
>> there are
>> any personal recommendations out there.
>
> Well Trac is my personal favourite, but it's in Python.
>
> JotBug is a new PHP system based around the same principles as Trac,  
> but written in the Zend Framework.
>
> http://www.jotbug.org/
>
> It's very early days but perhaps it will be something you can get  
> involved with?
>
> Col
>
> --
(Continue reading)

Permalink | Reply | 0 comments |
headers
Michael A. Peters | 1 Apr 2009 06:11
Picon

Re: 5.2.9 changes - phpwiki

Charles Sprickman wrote:
> On Mon, 30 Mar 2009, Michael A. Peters wrote:
> 
>> Charles Sprickman wrote:
>>> Hello all,
>>>
>>> Recently I upgraded a box running phpwiki from php 5.2.8 to 5.2.9.  
>>> After the upgrade, phpwiki (1.3.14) started spitting out the 
>>> following two errors, both of which are basically leaving the wiki 
>>> dead in the water:
>>>
>>> [30-Mar-2009 22:01:23] PHP Parse error:  syntax error, unexpected 
>>> T_CLONE, expecting T_STRING in 
>>> /usr/local/www/data/wikisvn/lib/config.php(500) : eval()'d code on 
>>> line 2
>>> [30-Mar-2009 22:01:23] PHP Fatal error:  Class 
>>> 'WikiDB_backend_PearDB_PearDB' not found in 
>>> /usr/local/www/data/wikisvn/lib/WikiDB/SQL.php on line 25
>>
>>
>>
>>> first error is in this block:
>>>
>>> /**
>>>  * safe php4 definition for clone.
>>>  * php5 copies objects by reference, but we need to clone "deep copy" in
>>>    some places.
>>>  * (BlockParser)
>>>  * We need to eval it as workaround for the php5 parser.
>>>  * See http://www.acko.net/node/54
(Continue reading)

Permalink | Reply | 0 comments |
headers
Toke Herkild | 1 Apr 2009 08:43
Picon

Re: thread question

Virgilio Quilario skrev:
>> Hi all,
>>
>> Another question:
>>
>> If a script starts to perform an operation and the user browses away will
>> that terminate the thread perfoming the operation eg. the operation is
>> aborted ?
>>
>> Mvh
>> Toke
> 
> the script is aborted as soon as server gets no response from the
> browser when it sent output to the browser.
> 
> virgil
> http://www.jampmark.com

Hi virgil,

would that also apply to a script executed from the first script :

example:

if (do_stuff_which_takes_a_long_time){
   exec('php /path_toscript/script.phpsh');
}

would script.phpsh also be aborted if the connection is broken ?
(Continue reading)

Permalink | Reply | 3 comments |
headers
Virgilio Quilario | 1 Apr 2009 13:41
Picon

Re: thread question

>>> Hi all,
>>>
>>> Another question:
>>>
>>> If a script starts to perform an operation and the user browses away will
>>> that terminate the thread perfoming the operation eg. the operation is
>>> aborted ?
>>>
>>> Mvh
>>> Toke
>>
>> the script is aborted as soon as server gets no response from the
>> browser when it sent output to the browser.
>>
>> virgil
>> http://www.jampmark.com
>
> Hi virgil,
>
> would that also apply to a script executed from the first script :
>
> example:
>
> if (do_stuff_which_takes_a_long_time){
>  exec('php /path_toscript/script.phpsh');
> }
>
> would script.phpsh also be aborted if the connection is broken ?
>
> Regards,
(Continue reading)

Permalink | Reply | 2 comments |
headers
Ashley Sheridan | 1 Apr 2009 13:47
Picon

Re: thread question

On Wed, 2009-04-01 at 19:41 +0800, Virgilio Quilario wrote:
> >>> Hi all,
> >>>
> >>> Another question:
> >>>
> >>> If a script starts to perform an operation and the user browses away will
> >>> that terminate the thread perfoming the operation eg. the operation is
> >>> aborted ?
> >>>
> >>> Mvh
> >>> Toke
> >>
> >> the script is aborted as soon as server gets no response from the
> >> browser when it sent output to the browser.
> >>
> >> virgil
> >> http://www.jampmark.com
> >
> > Hi virgil,
> >
> > would that also apply to a script executed from the first script :
> >
> > example:
> >
> > if (do_stuff_which_takes_a_long_time){
> >  exec('php /path_toscript/script.phpsh');
> > }
> >
> > would script.phpsh also be aborted if the connection is broken ?
> >
(Continue reading)

Permalink | Reply | 1 comment |
headers
Toke Herkild | 1 Apr 2009 13:52
Picon

Re: thread question

Ashley Sheridan skrev:
> On Wed, 2009-04-01 at 19:41 +0800, Virgilio Quilario wrote:
>>>>> Hi all,
>>>>>
>>>>> Another question:
>>>>>
>>>>> If a script starts to perform an operation and the user browses away will
>>>>> that terminate the thread perfoming the operation eg. the operation is
>>>>> aborted ?
>>>>>
>>>>> Mvh
>>>>> Toke
>>>> the script is aborted as soon as server gets no response from the
>>>> browser when it sent output to the browser.
>>>>
>>>> virgil
>>>> http://www.jampmark.com
>>> Hi virgil,
>>>
>>> would that also apply to a script executed from the first script :
>>>
>>> example:
>>>
>>> if (do_stuff_which_takes_a_long_time){
>>>  exec('php /path_toscript/script.phpsh');
>>> }
>>>
>>> would script.phpsh also be aborted if the connection is broken ?
>>>
>>> Regards,
(Continue reading)

Permalink | Reply | 0 comments |
headers
haliphax | 1 Apr 2009 14:37
Picon

Re: Workflow app for software

On Tue, Mar 31, 2009 at 4:37 PM, bruce <bedouglas <at> earthlink.net> wrote:
> hey todd...
>
> just toook a look at the polarion svn-web app.... i thought that was closed source... i see that it's open!!!
>
> -----Original Message-----
> From: haliphax [mailto:haliphax <at> gmail.com]
> Sent: Tuesday, March 31, 2009 2:18 PM
> To: bruce; php-general <at> lists.php.net
> Subject: Re: [PHP] Workflow app for software
>
>
> On Tue, Mar 31, 2009 at 1:47 PM, bruce <bedouglas <at> earthlink.net> wrote:
>> Ladies/Gents...
>>
>> Hi. Trying to get some input to a web based app for dealing with managing
>> software apps/scripts.
>>
>> Basically, i'm envisioning a system where people register/signup, and then
>> check in/out apps for development/testing/production... I need a way of
>> dealing with users, assigning/accepting roles for the users, and to manage
>> the flow of the "file" as it moves through the basic
>> "development/testing/production" process. i'd like to have a database
>> backend, combines with some kind of source/file reqpository...
>>
>> I've seen things like knowledgetree, owl, etc... but figured I'd get input
>> from here. So, any thoughts to open source apps that you guys have actual
>> experience using??
>
> This sounds like something Subversion (SVN) is suited for. Three
(Continue reading)

Permalink | Reply | 0 comments |
headers
Laura Longo | 1 Apr 2009 14:22

stream_socket_client with tls: problem in Solaris 8

Hi all,
I've a problem with stream_socket_client function and tls under Solaris
8 (sparc).

The client code follows up:
<?php
$context =
stream_context_create(array('tls'=>array('capture_peer_cert'=>TRUE)));
$fp = stream_socket_client("tls://192.168.14.200:8000", $errno, $errstr,
30, STREAM_CLIENT_CONNECT, $context);
if (!$fp) {
	echo "$errstr ($errno)\n";
	die("error creating socket ({$errno}):{$errstr}\n");
}
echo "Socket is ok, start sending messages!\n";
$i_sleep = 5;
for ($i_counter = 0; $i_counter < 10; $i_counter++) {
	$s_msg = "message sent ".$i_counter;
	fwrite($fp,$s_msg);
	sleep($i_sleep);
}
fclose($fp);
?> 

This code works fine on CentOS 5 (x86_64) and Solars 10 (x86) [the
client connects to the server and sends messages], but on Solars 8
(sparc, core installation) it gives a warning and does not create any
connection, the connection error is 0 (unknown error).

Warning: stream_socket_client(): SSL: Error 0 in test.php on line 2
(Continue reading)

Permalink | Reply | 0 comments |
headers
Igor Escobar | 1 Apr 2009 16:39
Picon
Gravatar

Error on .htaccess

In all the servers i had tested my system i dont have any problem, but in
this server the apache are displaying to me the error 500 "Internal Server
Error".

Someone can say tome what is wront with my .htaccess?

RewriteEngine On
<IfModule mod_rewrite.c>
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond $1 !-d
RewriteRule ^(.*)$ load.php?$1 [QSA,L]
</IfModule>

This server are running PHP 5.2.9 and Apache 1.3.41 (Unix).

Regards,
Igor Escobar
systems analyst & interface designer
www . igorescobar . com
Permalink | Reply | 2 comments |

Gmane