see this patch applied:
https://github.com/php/php-src/blob/master/ext/pdo_odbc/odbc_driver.c#L339-L352
Does anyone have any experience or advice with how I could implement a
database connection timeout without this patch? Thanks!
--Rob
probably order by h.listdate
-- Rob
Stut [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Chris wrote:
Stut wrote:
Chris wrote:
Rob Adams wrote:
I have a query that I run using mysql that returns about 60,000 plus
rows. It's been so large that I've just been testing it with a limit
I have a query that I run using mysql that returns about 60,000 plus rows.
It's been so large that I've just been testing it with a limit 0, 1 (ten
thousand) on the query. That used to take about 10 minutes to run,
including processing time in PHP which spits out xml from the query. I
3
4
5
6
7
Is there a way with my mysql query so that I can list the numbers in correct
order?
Any help is appricated.
- Rob
.
Cheers
Rob Hamilton
--
___
Play 100s of games for FREE! http://games.mail.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Heres what i'm trying to do.
$proc=exec('ps aux | grep proc');
if ($proc != ) {
echo True;
}
if ($proc == ) {
echo False;
}
but some time's it show's the ps aux so I dont get a true reading. Anybody have
a way that I might be able to extract this out of there to get a true reading
to find
Nevermind. I figured it out.
- Original Message -
From: Rob W. [EMAIL PROTECTED]
To: php-db@lists.php.net
Sent: Tuesday, March 14, 2006 1:45 AM
Subject: [PHP-DB] Text file (rw) question...
I'm trying to figure out how to read specific data from a text file that
is already written
[EMAIL PROTECTED]
To: 'Rob W.' [EMAIL PROTECTED]; php-db@lists.php.net
Sent: Tuesday, March 14, 2006 9:13 AM
Subject: RE: [PHP-DB] Text file (rw) question...
How about posting your solution as well? Maybe someone will find it
useful.
-Original Message-
From: Rob W. [mailto:[EMAIL
That works, but it just throws it in to a big loop and fills up the file,
any suggestions?
- Original Message -
From: Chris [EMAIL PROTECTED]
To: Rob W. [EMAIL PROTECTED]
Cc: php-db@lists.php.net
Sent: Tuesday, March 14, 2006 5:54 PM
Subject: Re: [PHP-DB] Text file (rw) question
it updates that line of code.
- Original Message -
From: Chris [EMAIL PROTECTED]
To: Rob W. [EMAIL PROTECTED]
Cc: php-db@lists.php.net
Sent: Tuesday, March 14, 2006 6:23 PM
Subject: Re: [PHP-DB] Text file (rw) question...
Rob W. wrote:
That works, but it just throws it in to a big
Yeah, but will that just replace the data that is present already there? I
dont wanna have duplicate entries in there or i'm affraid it wont read it.
The origional code you gave worked but it just ran in a big loop.
- Original Message -
From: Chris [EMAIL PROTECTED]
To: Rob W
So how do I make it so it just set's the variable's that are sent in the
$_POST because i wanna write it so that if the value isnt changed, it wont
send the $_POST and wont update the config file..
- Original Message -
From: Chris [EMAIL PROTECTED]
To: Rob W. [EMAIL PROTECTED]
Cc
It's all fixed and works. If anybody is wondering how this turned out, here's
the begining of the results.
index.php
?php
if (!($f=fopen(sc_serv.conf,r)))
exit(Unable to open file.);
while (!feof($f))
{
$x=fgets($f, 100);
list($variable, $data) = explode(=, $x);
echo form
Ah yes, that's true. I didnt realize that. Thanks for pointing that out.
- Original Message -
From: Chris [EMAIL PROTECTED]
To: Rob W. [EMAIL PROTECTED]
Cc: php-db@lists.php.net
Sent: Tuesday, March 14, 2006 9:02 PM
Subject: Re: [PHP-DB] Text file (rw) question...
Rob W. wrote
I'm trying to figure out how to read specific data from a text file that
is already written. Example
MaxUser=3D32
PortBase=3D8000
I want to be able to have php read them specific pieces of info so I can
put them in to forms and update them via php.
Any help would be appreciated.
/inputfile.txt, r);
if ($handle) {
while (!feof($handle)) {
$lineArray[] = fgets($handle, 4096);
}
fclose($handle);
}
That will get up to 4096 characters per line, and I'm sure increasing
this isn't too complex :)
Rob
Ron Piggott wrote:
This is a sample of code which takes
= $rows_array[0];
if (!is_null($limit) $count $limit) {
$count = $limt;
}
}
return $stmt;
}
Where am I going wrong here?
Rob
Micah Stevens wrote:
There's a function called 'found_rows()' function, so you could try issuing a
query, then issuing a second one 'SELECT
(PDOException $e) {
# todo
}
return $stmt;
}
Rob
Rob C wrote:
So would it be possible to write a select() function to handle the
wierdness? I'm attempting to write one but I'm getting buffered query
errors. This function is part of a Database Manager class and is
supposed to return a PDO
not appreciating, if anyone can shed
some light on this, I'd like to know.
I'm new to both PDO and this mailing list, so please be gentle with me.
I'm using PDO 1.0RC2, PHP 5.0.5 and MySQL 4.1.15.
Rob
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net
(a bit)
Rob
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Anyone got any good websites or resources on how to connect to an access
database and perform sql querrys etc, in Linux running apache?
or if anyone has the connection strings required
thanks in advance !!
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
as such, but http://www.php.net/manual/en/
will help.
Rob
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hello,
I'm a newbie. I made a persistent connection, but I have to prove it's
persistent for a class I'm in. So far I haven't found anything in the
MySQL manual about it. Does anyone know what I can do?
Thanks
Rob
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http
How can I run php from the command line?
Thanks,
Rob Gillen
Clipart Downloads
http://www.GifArt.com
- Original Message -
From: Tyler Lane
To: Gabriel Peugnet
Cc: [EMAIL PROTECTED]
Sent: Tuesday, October 14, 2003 5:31 PM
Subject: Re: [PHP-DB] Can't conect
I believe what you want to do is just add the variable onto the URL, like this...
script.php?variable
or
script.php?variablevariable
Does that help?
Thanks,
Robert Gillen
http://www.GifArt.com
- Original Message -
From: Shiloh Madsen
To: [EMAIL PROTECTED]
Sent: Thursday,
Sorry I made a little mistake in my reply. Here is the correct syntax for what I think
will work for you...
script.php?variable=1
or
script.php?variable=1variable=2
Thanks,
Robert Gillen
http://www.GifArt.com
- Original Message -
From: Rob
To: Shiloh Madsen ; [EMAIL
-Original Message-
From: Robbie Staufer [mailto:[EMAIL PROTECTED]
Sent: Friday, April 04, 2003 3:59 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] variable within regular expression
I have a php query form in which the user input must be converted to a
regular expression before
Dan,
It is more of a HTML-related question:
Need to change the table width in percentage (%) rather than just numbers.
HTH,
-rob
Dan Liu [EMAIL PROTECTED]
03/31/2003 01:17 PM
To: [EMAIL PROTECTED]
cc:
Subject:[PHP-DB] print table truncated
Hi,
I
necessary.
-- Rob
John Dillon [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
m...
I want to create a page where the user will have a list of its favorites and
by ticking a box opposite the item will be able to delete it by clicking the
submit button. I want to make this dynamic so
, where
libinfo.lib_id = reportinfo.lib_id, that do not have an entry in reportinfo
where reportinfo.quarter = 0. I don't care if there is an entry in
reportinfo where quarter = 2. Can someone please help me construct this
query? Thanks.
-Rob
P.S. I realize that this question has nothing to do with PHP
using backticks in your query? E.g.,
$query_groups = SELECT name FROM `group`;
--
rob
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
. That
means no tabs, right? So is that just the way it is? Do I just need to not
worry about my tabs for heredoc? Is there some way to maintain consistency
without breaking my code?
-Rob
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
script works just fine. Both of these scripts
are in the same directory and the lsladmin_connection.inc file is there. The
#! path is correct. I just can't seem to see it. Sorry to burden the list
with another parse error. Thanks.
-Rob
#!/usr/bin/php
?php
require_once('lsladmin_connection.inc
you should return the results.
hope that helps.
-rob
-Original Message-
From: Dave Carrera [mailto:dave;davecarrera.com]
Sent: Friday, October 18, 2002 10:52 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySql Statement inside a function?
Hi All
I have created a function and insde
. Another
option if your application is somehow linear would be to make sure that the
referring page is what you wanted it to be.
-Rob
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 23, 2002 10:14 AM
To: PHP_DB
Subject: [PHP-DB] advise needed
to update some of the records in my table.
But whenever I send an UPDATE, the timestamp changes. I would like for the
timestamp value to remain unchanged. Is there a way to do this without
reading the old value of the timestamp and reinserting with my UPDATE query?
Thanks.
-Rob
--
PHP Database
them into an array. So in the script that
processes the form you will have access to an array named $option_val. Hope
that helps.
-Rob
-Original Message-
From: Stephanie [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 15, 2002 2:18 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Checkbox/mySQL
Dear All,
I am probably doing something silly but I don't know what (story of my
life). I have just upgraded to 4.2.1 and now all the variables I post in
forms or in query strings are now coming up undefined errors and are in
absent. I'm running PHP under IIS 4.
What am I doing wrong?
--
PHP
why not just use a mailing list manager (i.e. majordomo, ezmlm, etc.)?
writing a web interface for users to subscribe/unsubscribe would be no big
deal.
-Original Message-
From: Al [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 29, 2002 11:37 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB]
see my clothes but PHP
was test downloaded a month ago - any ideas from a white knight?
best regards
Rob
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
side includes. An upgrade to PHP4 is in the works, but I can't wait
that long. How can I get a client's IP address with PHP3.014 and/or
JavaScript? Thanks in advance.
-Rob
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Thanks, Craig. That was exactly what I was looking for!
-Rob
-Original Message-
From: Craig Vincent [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 19, 2002 2:35 PM
To: Rob Day; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] IP Address?
How can I find out the IP address of the client
or datetime
field (respectively)
hope it helps,
~ Rob Small
c0demonkey
Fresno, CA
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
-DB] Re: parse error
you haven't shut your script with the ? before starting your HTML, near as
I
can figure it
Rob Day wrote:
I've written a small script that processes a form from a webpage and sends
the submitted data as an HTML e-mail that has the form all filled out
already. I've gotten
I am just starting out on a project that has to be multi-lingual. i.e.
every word/sentence I output has to be translated.
The user logs in, and I read the language they use, by looking at the
user record.
I then need to get the language translations from a database.
I just select label, text
I forgot to say, I am using Oracle OCI to access the database:
:
$sSQL = select label, text from language_text where language =
'English';
$stmt = OCIParse($conn,$sSQL);
OCIExecute($stmt);
$nrows = OCIFetchStatement($stmt,$results);
--
PHP Database Mailing List (http://www.php.net/)
To
i'm having a hell of a time figuring out how to connect to a postgresql
database using the pear db abstraction...here's some code snippets:
with mysql (works fine):
require_once('DB.php');
$db = DB::connect(mysql://username:password@localhost/audio);
if
lp me "back convert" this routine into something PHP3
likes, I'd be greatly appreciative! It runs fine in PHP4, so I know
the code works (even if it's not the most elegant of examples). I'm
not a developer by trade, and I've never used PHP3, so I'm not sure
what could be different that's
Anyone here know of a good php soap tutorial? I have tried the one at
gigatrends, but had no luck
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL
Hello all,
PHP\MySQL shopping cart for sale www.firegarden.com/cart/ still under
development (good price if you buy now). Top notch OO coding garenteed. go
to firegarden.com and click the email link for more info.
Rob
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe
I am trying to implement session support with mysql. I am using
session.set_save_handler but don't really have a great set of functions does
anyone have some good ones?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands,
51 matches
Mail list logo
