Hi Paul
On 27 Mar,2003 at 12:44 Paul Burney wrote:
snip
Hope that helps. YMMV. TMTOWTDI.
/snip
It did !! I had tried a direct pipe, but had neglected the all important semi-colon
on the insert !!!
Is this reasonably efficient on your production server ? Do you have any problems
with
Hi Jerry
Inline comments
On 28 Mar,2003 at 12:31 JeRRy JeRRy wrote:
How can I update 2 tables at once if a match occours
from information inputed into a PHP form.
How about turning this around and re-organising the data a little?
Why not have a single score table with references to
Hi
When I use FORM ACTION=?php echo $_SERVER['PHP_SELF']; ? METHOD=POST
INPUT TYPE=submit NAME=submitp VALUE=Sendp
INPUT TYPE=submit NAME=submitn VALUE=Sendn
to attempt to control variables in the script the variables are not kept and
are refreshed every post, how can i ensure they are kept
Hi list.
I have no real education in PHP or postgre, so forgive me if I dont
use the correct language or expressions.
I have a small problem that is probably easily solved if you just know
how to do it.
I have a PHP interface over a postgreSQL database, where I can search,
add, delete or
Hi,
I've been facing problem while trying to access remote MySQL database
using PHP. It is working fine with the local database.
I did in the following way:
Created a user on the database with [EMAIL PROTECTED] identified by
'password';
Warning:
Warning: Lost connection to MySQL server
I'm having a problem with a php script when connecting to a postgresql
database. The problem is this: When Apache runs the php script, the
output is missing everything after my first call to pg_connect(). i.e., I
can echo, print whatever I like, but everything is cut off after that
call--it
Hi, I just installed PHP with pgsql support, and it doesn't seem to work
properly, although I don't see why it shouldn't.
I'm running the following script:
?php
error_reporting (E_ALL);
$myconn = pg_connect(dbname=thornvalley);
$res = pg_query('select * from test;', $myconn);
I am having problems putting an html string into a variable to create an array of
strings.
something like this:
$stringarray[] = array();
$i = 0;
while ( $i 6 ){
$stringarray[$i] = table cellspacing=\0\trtd.$this-differentarray[0]
[0]./td/tr/table;
}
When I echo $stringarray[1] it comes
The part where $i is never equal to 1 might be the problem. You might want
to try incrementing your sentinel when using loops.
-Original Message-
From: Info_Best-IT [mailto:[EMAIL PROTECTED]
Sent: Friday, March 28, 2003 11:13 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Putting a string
You might be getting an empty result because you don't have anything in
$stringarray[1]. You set $i = 0 then have a while loop that does something
while $i 6. But you never go through and increment $i at all so it's
always equal to 0. You might get some type of result if you echoed
I found what I remembered reading. If you're curious, go here:
http://www.php.net/manual/en/language.types.array.php
and scroll down to the Array Do's and Don'ts section. Don't know if it
actually does pertain to what you're doing, but it IS what I was thinking
of.
-Original Message-
Hi Tim
Comments inline...
$stringarray[] = array();
$i = 0;
while ( $i 6 ){
$stringarray[$i] = table cellspacing=\0\trtd.$this-differentarray[0]
[0]./td/tr/table;
}
When I echo $stringarray[1] it comes up empty... Is there a special trick to get a
You're not incrementing $i.
I'd suggest building a connection string, explicitly defining the user and
password. Maybe it would give you a more descriptive error that way
(invalid user, etc.).
The other thing I've done is do something like this:
$database = pg_connect ($conn_string)
or die (Help! No connection to
As I said in my first post, I tried the following connection strings as
well:
dbname=thornvalley user=apache password=[passwd]
dbname=thornvalley user=apache password=[passwd] host=localhost port=5432
and had the same results. After messing around with pg_hba.conf (I set local
authentication to
Check the documentation on pg_query.
http://www.php.net/manual/en/function.pg-query.php
It expects the link identifier as the first argument and the query as the
second. Switch your arguments and you might have some luck.
The manual is always a great place to look for answers to things like
Sorry for not fully reading your post. That's what I get 4 spd rdng.
Just another WAG--have you tried using get_resource_type() on $myconn?
That may tell you whether the thing exists after its creation, and if it
does, it should tell you pgsql link as the resource type. I'd suspect
that if it
OOPS! /me hangs head in shame...
That's what it was. Guess that's what I get for always using PHPlib's
abstraction layer... I hardly ever use the actual pg_*() functions anymore.
Thanks for putting up with me. ;)
Nathaniel Price http://www.thornvalley.com
Craig --
...and then Craig Kohtz said...
%
...
% The script I've included works for a table named structure with the
% following fields:
Sounds interesting. Care to actually post the script? ;-)
I'd like to see it.
TIA HAND
:-D
--
David T-G * There is too much animal
on 3/28/03 7:30 AM, Ronan Chilvers at [EMAIL PROTECTED] appended the
following bits to my mbox:
Is this reasonably efficient on your production server ? Do you have any
problems with it ?
It's pretty efficient on my production server. Since I don't index the
initial table, the inserts go
Folks,
I am trying to connect to a sybase server (12.5) using PEAR DB object.
When connecting to the database from Linux, everything goes as expected.
However, when running on HPUX (Apache 1.3.27/PHP 4.3.1 DSO), I get the
following error:
php_code:
$this-$db =
I'm experienced with SQL, but new to MySql and PHP, which I'm using
together to create a dynamic web site. Right now, I'm having minor
difficulties with date formatting. It seems that when I retrieve a date
from MySQL into PHP, it shows up as a string instead of a date data
type, with format
The mysql support list is slow, so I though I would
post here since I know this list is more active. MySQL
shuts down when I start it up...
Starting mysqld daemon with databases
from/home/mysqldb
030328 09:29:32 mysqld ended
__
Do you Yahoo!?
The mysql support list is slow, so I though I would
post here since I know this list is more active. MySQL
shuts down when I start it up...
Starting mysqld daemon with databases
from/home/mysqldb
030328 09:29:32 mysqld ended
Usually means you have an error in your my.cnf file.
---John
Usually means you have an error in your my.cnf file.
Is the my.cnf file a new thing with mysql because I
heard about it for the first time today?
Is there a way to configtest the my.cnf file like
there is with apache?
Thanks,
J
__
Do you
I'm experienced with SQL, but new to MySql and PHP, which I'm using
together to create a dynamic web site. Right now, I'm having minor
difficulties with date formatting. It seems that when I retrieve a
date
from MySQL into PHP, it shows up as a string instead of a date data
type, with
25 matches
Mail list logo
