mirror on
github, I don't 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
Oid limit {l1}, {l2}
Here is the query. I didn't know that it needed to have an ORDER clause in
it for the limit to work properly. I'll probably order by h.listdate
-- Rob
"Stut" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Chris wrote:
Stut 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 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
dec
12
.
2
22
23
25
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
$stmt->bind_param($paramTypes, $params[0]);
But it seems you cannot pass the array itself using the '&' operator.
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
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:
Sent: Tuesday, March 14, 2006 9:02 PM
Subject: Re: [PHP-DB] Text file (rw) questi
It's all fixed and works. If anybody is wondering how this turned out, here's
the begining of the results.
index.php
";
if ($variable == "MaxUser") {
echo "Max Users: ";
}
if ($variable == "Password") {
echo "Password: ";
}
// echo "$variable $data";
}
fclose($f);
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:
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 PROTE
halt after it updates that line of code.
- Original Message -
From: "Chris" <[EMAIL PROTECTED]>
To: "Rob W." <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, March 14, 2006 6:23 PM
Subject: Re: [PHP-DB] Text file (rw) question...
Rob W. wrote:
That works,
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:
Sent: Tuesday, March 14, 2006 5:54 PM
Subject: Re: [PHP-DB] Tex
t;Dwight Altman" <[EMAIL PROTECTED]>
To: "'Rob W.'" <[EMAIL PROTECTED]>;
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 Mess
Nevermind. I figured it out.
- Original Message -
From: "Rob W." <[EMAIL PROTECTED]>
To:
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 writ
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.
= @fopen("/tmp/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 wro
t = $rows_array[0];
if (!is_null($limit) && $count > $limit) {
$count = $limit;
}
}
} catch (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&#
$rows_array = $rows->fetch(PDO::FETCH_NUM);
$rows->closeCursor();
$count = $rows_array[0];
if (!is_null($limit) && $count > $limit) {
$count = $limt;
}
}
return $stmt;
}
Where am I going wrong here?
Rob
Micah Stevens wrote
l limitation that I'm 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.ne
t until it
hits YZ. feck knows why :-/
hth (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: http://www.php.ne
this
You'll get this:
Notice: Use of undefined constant something_not_defined - assumed
'something_not_defined'
but if you change something_not_defined to a reserved word like private,
you'll get a parse error as you found.
> any
> idea where I
> could find a lis
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 unsu
o your lof files the rest
should be a peice of cake
Good luck
Rob
==
Dear group, I am trying to query my db and print the results.
when i execute my script, i am not getting any result
except a blank page. can any one please help me what
is going wro
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
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=1&variable=2
Thanks,
Robert Gillen
http://www.GifArt.com
- Original Message -
From: Rob
To: Shiloh Madsen ; [E
I believe what you want to do is just add the variable onto the URL, like this...
script.php?variable
or
script.php?variable&variable
Does that help?
Thanks,
Robert Gillen
http://www.GifArt.com
- Original Message -
From: Shiloh Madsen
To: [EMAIL PROTECTED]
Sent: Thursday, O
> -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 bef
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-
only if id is all integers.
$in_list = implode(", ", $_POST["del"]);
$query = "delete from table where id in ($in_list)";
} else
$query = "delete from table where id = {$_POST['del']}";
That should work, no javascript necessary.
-- Rob
&q
in libinfo, 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
>
> You have an error in your SQL syntax near '"group"' at line 1
>
Have you tried 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
line." 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
other 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
Number of books purchased wit
in function.
rather 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 fun
point. 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 neede
for me 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
--
PH
Stephanie,
Take a look at this:
Option 1
Option 2
Option 3
Look at the names of the checkboxes. If they are all the same and end with
[] as above, PHP will toss 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
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 Data
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] Reco
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 cli
also can't use
server 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
was $close");
=
I run IIS4, NT4 (SP6a) and SQL 7 on the same machine as its my
development one, out of date maybe but you should 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
date("Y-m-d", strtotime("+2 years"))
or
$date_var=date("Y-m-d H:i", strtotime("+2 years"))
if you wanted hours/minutes
either example formats in a way that MySQL wants to see a date 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
t;no
359Answer "yes" if you want all postings to the list to be
sent to
360 a moderator for approval before distribution to the
list.
Any help would be greatly appreciated. Thanks!
Rob Day
Web Team Leader
Texas State
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 unsubsc
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 f
Good point, but if you are prefixing you should really use a separator that
you can later remove with a string function (or regexp if complex).
1_1family.jpg
11_family.jpg
You can use a string function to remove everything up to the _ and call that
your ID. If you do not use a separator, extr
> 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:
RTFM (or a tutorial rather)...hate when people answer their own questions,
but here goes:
> $db = DB::connect("pgsql://username:password@localhost/audio
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 (DB::isError($db
help 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
wha
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
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 P
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, e-mail:
55 matches
Mail list logo
