Hi,
I need to run this command inside a PHP (web) script, in order to
produce an acl list (url_negados.txt) for squid:
/usr/bin/psql -t knet -c SELECT url_negado from urls_negados
/tmp/urls_negados.txt
I'm using shell_exec to run it.
Well, so far, so good.
The problem is that i must run this
Hi
php runs as the same user as apache. Depending on any other security/system
issues you could set apache to run as postgres.
Otherwise why not connect to postgres using the php functions and write the
text file using php?
You might also be able to su to postgres.
HTH
Peter
-Original
Hi Peter,
Thank you for your answer.
php runs as the same user as apache. Depending on any other security/system
issues you could set apache to run as postgres.
Unfortunately, i can't. There's too much variables involved :(
Otherwise why not connect to postgres using the php functions and write
This is my favourite.
How can i execute this query:
$myresult2 = pg_query($pgsql_conn, SELECT url_negado from urls_negados
/tmp/urls_negados.txt);
from inside a PHP file as user postgres ?
cant you do this...?
select url_negado into outfile '/tmp/urls_negados.txt' from urls_negados
--
PHP
I'm hoping someone can help me with this. I am having
problems with the mysql_fetch_array function in PHP
5.0.1 - the code listed below works fine with PHP
4.3.2.
Here is my setup:
A DB class file that has the following for the
mysql_fetch_array (I know this function is OK because
its working
- Original Message -
From: Joe Smith [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, August 25, 2004 9:16 AM
Subject: [PHP-DB] PHP 5 mysql_fetch_array problems
I'm hoping someone can help me with this. I am having
problems with the mysql_fetch_array function in PHP
5.0.1 - the
Does anyone have any suggestions for the following problem:
I'm running Apache/1.3.31 and PHP Version 4.3.8 connecting to an Oracle
database. Periodically, PHP is unable to connect to the database. When this
problem occurs, I am able to connect to the database from the webserver
without any
Hi All,
I'm using PHP5/mysqli with object style bind_param,
which always reports mysqli_stmt::bind_param() Number
of variables doesn't match number of parameters in
prepared statement - even if they do match! - and
even using the sample code from the zend tutorial.
I have included the (slightly
Hi there everyone,
I set an array using the following in PHP:
$ringb[$i]=$complex_area;
$i++;
It cycles through my DB and stores the info, my question is, how can I
convert it to a value that can be read in Javascript?
I'm stumped.
Chris
On Wed, 25 Aug 2004 20:18:23 -0400, Chris Payne
[EMAIL PROTECTED] wrote:
Hi there everyone,
I set an array using the following in PHP:
$ringb[$i]=$complex_area;
$i++;
It cycles through my DB and stores the info, my question is, how can I
convert it to a value that can be read in
Hi everyone.
In PHP, how do I submit data by e-mail as HTML to a specified address? And where can I
find samples of that in http://www.php.net/ ?
Thanks regards,
Hafidz
Hello,
I have a script that make changes to the database in more than one sql statement, as i
need to update more than one table at the same time, I want to know if there is a
method where all of those changes are committed, or rolled back if some error
occured(lets say in the last sql
look at the PEAR HTML_Javascript class
_
- Original Message -
From: Chris Payne [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 26, 2004 2:18 AM
Subject: [PHP-DB] PHP Array to Javascript?
Hi there everyone,
I set an array using the
On Wed, 25 Aug 2004 22:08:03 -0700 (PDT), Khalid Judeh
[EMAIL PROTECTED] wrote:
Hello,
I have a script that make changes to the database in more than one sql statement, as
i need to update more than one table at the same time, I want to know if there is a
method where all of those changes
Jon Foreman wrote:
Does anyone have any suggestions for the following problem:
I'm running Apache/1.3.31 and PHP Version 4.3.8 connecting to an Oracle
database. Periodically, PHP is unable to connect to the database. When this
problem occurs, I am able to connect to the database from the
Hello,
On 08/26/2004 01:44 AM, Hafidz Abdullah wrote:
In PHP, how do I submit data by e-mail as HTML to a specified
address? And where can I find samples of that in http://www.php.net/
?
You need to compose a multipart/alternative message that includes an
HTML part and a text part for e-mail
16 matches
Mail list logo