http://php.he.net/manual/en/function.pcntl-fork.php says 'The reason for the
MySQL Lost Connection during query...' like what you concluded, although
they grab a new $db connection in the first for loop
} else if ( $pid ) { I bet a child closes the one you create after the for
loop while the
Actually I suppose you need to loop with foreach to wait on all children
before attempting any $db-execute, then after your foreach loop, get your
$db and execute.
Regards,
Dwight
-Original Message-
From: Dwight Altman [mailto:[EMAIL PROTECTED]
Sent: Monday, April 23, 2007 10:09 AM
Hey Dwight,
Thanks for the replies! When the first child thread closes, all of the DB
connections seem to close. That is, the $db-execute() statements will fail
in the child threads after the first child thread closes. It's almost as
though separate connections are not being made, but they are
Hi,
I'm trying to get some data form a MySQL db using PDO and prepared
statement, but I noticed that sometimes it fetches an empty result set,
but sometimes does what it's supposed to do - returns the whole result set.
The environment is WinXP SP2 Home, Apache 2.2.4, PHP 5.2.1 and MySQL
Good point. Anything (children or parent) sharing the connection will get
it closed on them. I was looking up persistent connections, then I thought
you could just address the way you used the pcntl_* functions.
I use mysql_* directly (where mysql_connect Opens or reuses a connection to
a MySQL
I have a mysql database and would like to be able to copy the data from that
to my access database. If there something that is freeware to do this? Or
maybe someone has some code that might do this for me?
Thanks in advanced.
Steve
--
PHP Database Mailing List (http://www.php.net/)
To
To use a PEAR::DB persistent connection, try
$db = DB::connect($dsn, TRUE);
or
$db = DB::connect($dsn, true);
Googled for pear::db persistent connection and got
http://vulcanonet.com/soft/?pack=pear_tut
Regards,
Dwight
-Original Message-
From: Dwight Altman [mailto:[EMAIL PROTECTED]
Hey Dwight,
After getting your first e-mail, I started adding the PEAR::DB persistent
connection code. Unfortunately, it yielded the same results that I was
getting before.
At a hunch, I created a second proof-of-concept script that uses the mysql_*
functions in the PHP base. For each of
For anyone interested in following the progress of this forking/PEAR::DB
issue, see http://pear.php.net/bugs/bug.php?id=10813.
Thanks,
Chris
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Glad to help.
I was actually interested in your post because of forking versus threading.
I still haven't found anything except for PHP-GTK but it may help your
database related performance if it is added/exists in PHP.
Regards,
Dwight
-Original Message-
From: Chris Verges
There is a tool in Access that can connect an access database to any
type of database [via ODBC].
It can be used as a table, so you can make all query rigth the way as
other table.
i'm sorry but i don't remember the tool name.
Hope this will help.
2007/4/23, Steve Smith [EMAIL PROTECTED]:
I
I am looking for help to write a SELECT syntax to help me process a
directory searching query tool I am developing.
If you start at
http://www.actsministrieschristianevangelism.org/ministrydirectory/ and
under 'Step 1:' click Business a form is displayed.
My question is how would you
cmiiw.. since i don't the visual what u said bellow
- Original Message -
From: Ron Piggott [EMAIL PROTECTED]
To: PHP DB php-db@lists.php.net
Sent: Tuesday, April 24, 2007 11:31 AM
Subject: [PHP-DB] SELECT string
I am looking for help to write a SELECT syntax to help me process a
13 matches
Mail list logo
