The query was:
$query = 'SELECT * FROM databasetablename';
So, database access seems to be the problem. Using the superuser
account 'postgres', a user 'httpd' was created and all privileges were
granted to the target database using the postgresql 'grant' command.
However the user 'httpd' is not t
e-letter wrote:
> The file was changed:
>
> ... $value=pg_fetch_result($query,1,1);
> echo 'all files' . var_dump($value);
> ...
>
> The resultant web page produces:
>
> bool(false) all files
>
> The php file was changed again:
>
> ... $value=pg_fetch_result($query);
> ech
The file was changed:
... $value=pg_fetch_result($query,1,1);
echo 'all files' . var_dump($value);
...
The resultant web page produces:
bool(false) all files
The php file was changed again:
... $value=pg_fetch_result($query);
echo 'all fi
On Sun, 2011-05-01 at 09:24 +0100, e-letter wrote:
> I looked at the error file located at '/var/log/httpd/error_log',
> which identifies an error:
>
> ...Apache/2.2.6 (Mandriva Linux/PREFORK-8.2mdv2008.0) PHP/5.2.4 with
> Suhosin-Patch mod_put/2.0.8 configured -- resuming normal
> operations...
On 30/04/2011, Daniel Brown wrote:
> Readers? Sounds like you spend too much time writing newsletters
> (to the wrong address, since php-general-digest-h...@lists.php.net is
> a self-help command list for digest-form subscriptions). ;-P
>
> On Sat, Apr 30, 2011 at 04:41, e-letter wrote:
>>
On Sat, Apr 30, 2011 at 12:23, Daniel Brown wrote:
>>
>> > echo '$_SERVER['HTTP_USER_AGENT']';
>> ?>
>
> First of all, no it doesn't. Placed inside single quotes, it'll
> not only try to return it verbatim (i.e. - the variable would be
> printed to screen), but it'
Readers? Sounds like you spend too much time writing newsletters
(to the wrong address, since php-general-digest-h...@lists.php.net is
a self-help command list for digest-form subscriptions). ;-P
On Sat, Apr 30, 2011 at 04:41, e-letter wrote:
> $db = pg_connect('dbnam
Richard Lynch wrote:
On Sun, August 12, 2007 2:35 am, Alain Roger wrote:
I'm getting an error message when i run the following SQL request :
$sql = "INSERT INTO tmp_importedxls (rec_id, publisher) VALUES (SELECT
nextval('tmp_importedxls_rec_id_seq'),'$pb')";
Error in SQL query: ERROR: syntax er
Alain Roger wrote:
Hi,
I'm getting an error message when i run the following SQL request :
$sql = "INSERT INTO tmp_importedxls (rec_id, publisher) VALUES (SELECT
nextval('tmp_importedxls_rec_id_seq'),'$pb')";
Error in SQL query: ERROR: syntax error at or near "SELECT" LINE 2: VALUES
(SELECT nex
On Sun, August 12, 2007 2:35 am, Alain Roger wrote:
> I'm getting an error message when i run the following SQL request :
> $sql = "INSERT INTO tmp_importedxls (rec_id, publisher) VALUES (SELECT
> nextval('tmp_importedxls_rec_id_seq'),'$pb')";
>
> Error in SQL query: ERROR: syntax error at or near
Alain Roger wrote:
Hi,
I'm getting an error message when i run the following SQL request :
$sql = "INSERT INTO tmp_importedxls (rec_id, publisher) VALUES (SELECT
nextval('tmp_importedxls_rec_id_seq'),'$pb')";
Error in SQL query: ERROR: syntax error at or near "SELECT" LINE 2: VALUES
(SELECT nex
On Mon, November 6, 2006 5:17 pm, Børge Holen wrote:
> aaight... I get yer point there,
> BUT
>
> you see, what do you do when an artists changes it name... forget it,
> that was
> a bad choice...
Oh no, it's a GREAT choice.
First of all, if they really really changed their name, then I create
a
aaight... I get yer point there,
BUT
you see, what do you do when an artists changes it name... forget it, that was
a bad choice...
anyway...
you see, in one of my fields of interests, you got dogs... see, dogs can
change name, not just the calling name, but I mean completely change it all.
seco
On Sat, November 4, 2006 5:38 pm, Børge Holen wrote:
> either you end up with a had as method of grouping them together,
> moreover you can have thousands of small files inside one dir with an
> id name
> to it, and yes the last one, thousands of directories with one file
> inside...
Speaking as a
On Sat, November 4, 2006 11:26 am, Alain Roger wrote:
> I create a table with some large object (ref: OID) to store some
> images.
> When my PHP will display some data, it will also display the images
> stored
> as OID.
>
> However, i've read that before i must restore the image by exporting
> them
On Saturday 04 November 2006 18:26, Alain Roger wrote:
> Hi,
>
> I create a table with some large object (ref: OID) to store some images.
> When my PHP will display some data, it will also display the images stored
> as OID.
>
> However, i've read that before i must restore the image by exporting t
Hello Danny,
Tuesday, March 22, 2005, 6:07:55 PM, you wrote:
DB> Any recommendations on books for postgresql & PHP usage.
Just get a good book on Postgres, the PHP side of it can be easily
picked-up from the PHP manual itself.
Best regards,
Richard Davey
--
http://www.launchcode.co.uk - PHP
You could try leaving off the ";"...
Try $sql = "BEGIN"
Try $sql = "COMMIT"
That should work...
On Thu, 2003-01-09 at 22:23, Jean-Christian Imbeault wrote:
> Jason Sheets wrote:
> >
> > Manual Excerpt: " If a second call is made to pg_connect() with the same
> > connection_string, no new con
Jean-Christian
If you are only doing an insert then you do not need the transactions
"BEGIN" and "COMMIT" because that is already done for you on a single
insert. PGSQL is transaction based so if it does not go then it will not
work.
-Ray
On Thu, 2003-01-09 at 22:23, Jean-Christian Imbeault wrot
Jason Sheets wrote:
Manual Excerpt: " If a second call is made to pg_connect() with the same
connection_string, no new connection will be established, but instead,
the connection resource of the already opened connection will be
returned. You can have multiple connections to the same database if
Not exactly sure why your transactions aren't working but if your script
already has an open connection to the database and you issue another
call to pg_connect with the same connect string PHP will return the
existing connection and should not create another connection to the
database, that is pro
[EMAIL PROTECTED] wrote:
> PHP is compiled with PostgreSQL support but I can not connect. I get
> this error message What does it mean and what do I need to do to fix
> it
>
> Warning: pg_connect() unable to connect to PostgreSQL server: connectDB()
> -- connect() failed: Connection refused Is t
On Thursday 30 May 2002 11:30, Steve G wrote:
Please do not reply to an existing post. Start a new one!
> I do not understand why PHP is trying to pull row 2!! I want to create an
> array of data and construct a table from a query. The echo of $rows shows
> 2 rows, so if I'm setting my variabl
use EXPLAIN to get more information about how postgres executes this query.
I'm not sure about this, but there are some issues with fields of type int8.
It may help to cast explicitly the fields involved in join like:
WHERE bible.book::int4 = books.id::int4
Ask it the postgres mai
Hi,
You dont have the book field in the asv_bible table indexed. Use this to
index it
CREATE INDEX myindexname ON asv_bible(book);
(the primary key fields are ok because PostgreSQL creates a unique index to
implement the PRIMARY KEY constraint).
Hope that helps :)
--
Shane
> I have a
You need to configure you database in the pg_hba.conf. The pg_hba.conf is in
your postgres directory. Put one line like this in your pg_hba.conf
host yourdatabase yourhost 255.255.255.255 trust
- Original Message -
From: "Alberto" <[EMAIL PROTECTED]>
To: <[EMAIL
Hi
> Please discuss as to your point of view the advantage of PostgreSQL over
> Interbase and/or vise versa. I'm considering three (3) important points
>
I'm just evaluating Interbase and there is an important point that did not
come out in the thread.
It seems that Borland went back on key com
"Altunergil, Oktay"wrote:
> The link that goes to interbase's web site in freshmeat.com redirects to
> http://www.borland.com/interbase/
> which does not list the product as free or open source?
>
> Is there another version?
>
> oktay
My understanding is that the current open source version is a
ay 07, 2001 3:17 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP] PostgreSQL vs. Interbase
Arnold Gamboa wrote:
> I'm currently in serious research on what database to use for a B2B site
> which is expected to hold millions of records. I have in so far considered
> two open source databa
Arnold Gamboa wrote:
> I'm currently in serious research on what database to use for a B2B site
> which is expected to hold millions of records. I have in so far considered
> two open source databases - Interbase and PostgreSQL. With this in mind,
I'm
> sending this email to both the PostgreSQL an
On Friday 02 March 2001 00:23, Shaun Thomas wrote:
> On Thu, 1 Mar 2001, Meir kriheli wrote:
> > I use both of the databases (Interbase 6.01 and PostgreSQL 7.1beta4).
> >
> > PostgreSQL has more features comapared to Interbase (the procedureal
> > language is very robust and there are many datatyp
From: "Shaun Thomas" <[EMAIL PROTECTED]>
> The point about Oracle is that it *lets* you do all of those
> optimizations, and if you're good at it, it will outperform almost any
> other database you throw at it. Trust me on this one.
I'm sorry, I can't trust you very much on this. Having worked a
On Thu, 1 Mar 2001, Meir kriheli wrote:
> I use both of the databases (Interbase 6.01 and PostgreSQL 7.1beta4).
>
> PostgreSQL has more features comapared to Interbase (the procedureal language
> is very robust and there are many datatyps to choose from. Also you can have
> some kind of object su
On Wednesday 28 February 2001 06:19, [EMAIL PROTECTED] wrote:
> Arnold Gamboa wrote:
> > I hve heard a great deal about InterBase. Please comment on which is
> > better:
> >
> > 1. Speed
> > 2. Data Reliability
> > 3. Compatibility with PHP
> >
> > Thanks for your comments.
> >
> > --
>
> 1. I
Arnold Gamboa wrote:
>
> I hve heard a great deal about InterBase. Please comment on which is
> better:
>
> 1. Speed
> 2. Data Reliability
> 3. Compatibility with PHP
>
> Thanks for your comments.
>
> --
1. I think Postgresql
2 and 3 I can't say which is better. Both seem to work ok - you
Mensaje citado por: Ron Wills <[EMAIL PROTECTED]>:
> I know this isn't one of the databases that you;re inquiring about, but
> we've been using MySQL (www.mysql.com) and it has been working
> beautifully.
> We have an email server with a MySQL db that's about 4 Gigs now a it's
> still running str
I know this isn't one of the databases that you;re inquiring about, but
we've been using MySQL (www.mysql.com) and it has been working beautifully.
We have an email server with a MySQL db that's about 4 Gigs now a it's
still running strong. MySQL is free and might be worth looking into :-)
Arnold
Hi
We have been using Interbase for all our php development and have not
experienced problems. The oprational database is 4gigs and if we execute
large queries on it we recieve sub-second responses so speed is definetly
not a problem
Interbase is a good way to go if you have need for a relationa
I <[EMAIL PROTECTED]> wrote:
> Can someone give me a simple example script that uses postgres session
> handling, that works with register_globals "off"?
As a followup again, it seems what I've been running into is a bug
in PHP:
http://bugs.php.net/bugs.php?id=8772
http://bugs.
I <[EMAIL PROTECTED]> wrote:
> It seems the pgsql_session_write() function is not even being invoked.
> Here it is:
As a followup, it seems that turning register_globals "on" allows the
pgsql_session_write() function to be called, and my test script works
if I replace $HTTP_SESSION_VARS["count"]
>"Richard Lynch" <[EMAIL PROTECTED]> wrote:
> > The writing of the session data occurs *after* the server-browser HTTP
> > connection is cut.
>
> > If you have any error-reporting happening in your session_write
>function,
> > you won't see it.
>
> > Alter that function to log errors to a file or
"Richard Lynch" <[EMAIL PROTECTED]> wrote:
> The writing of the session data occurs *after* the server-browser HTTP
> connection is cut.
> If you have any error-reporting happening in your session_write function,
> you won't see it.
> Alter that function to log errors to a file or something.
It
The writing of the session data occurs *after* the server-browser HTTP
connection is cut.
If you have any error-reporting happening in your session_write function,
you won't see it.
Alter that function to log errors to a file or something.
--
Visit the Zend Store at http://www.zend.com/store/
W
El Jue 25 Ene 2001 16:36, Evelio Martinez escribió:
> Hi!
>
> Is there any way to get the equivalent sqlca.sqlcode value of informix
> in PostgreSQL from php ?
>
> I would like to use the sqlcode to print the messages in Spanish.
The problem is that informix puts in an array (sort of) all the inf
44 matches
Mail list logo
