Re: postgresql database access failure
| From: | e-letter | Date: | Sun, 01 May 2011 08:24:29 +0000 |
| Subject: | Re: postgresql database access failure | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-312607@lists.php.net to get a copy of this message | ||
On 30/04/2011, Daniel Brown <danbrown@php.net> wrote:
> Readers? Sounds like you spend too much time writing newsletters
> (to the wrong address, since php-general-digest-help@lists.php.net is
> a self-help command list for digest-form subscriptions). ;-P
>
> On Sat, Apr 30, 2011 at 04:41, e-letter <inpost@gmail.com> wrote:
>> <?php
>> $db = pg_connect('dbname=databasename user=username');
>> $query = 'SELECT * FROM databasename';
>> $value=pg_fetch_result($query,1,0);
>> echo 'export of database is ',$value,'';
>> ?>
>> <p>
>> why does this fail?
>
> How is it failing? What error(s) are you seeing on screen or in
> your log files? Noting that $value would contain an array, is that
> the problem? And why are you using ending quotes in your echo? You
> should just place the semicolon immediately after $value.
>
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...
...PHP Parse error: syntax error, unexpected T_VARIABLE, expecting
',' or ';'...
The file was changed as follows which caused the parse error shown above:
<?php
$db = pg_connect('dbname=webcuttings user=httpd');
$query = 'SELECT * FROM articles';
$value=pg_fetch_result($query);
echo 'all files' $value;
?>
The file was copied from the manual page, without understanding that
an array was being used.
>> </p>
>> </body>
>> </html>
>>
>> The following php code produces the user agent:
>>
>> <?php
>> 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'll also cause a parse error, as you reuse
> single quotes in the variable key container.
>
My mistake; with the command:
<?php
echo $_SERVER['HTTP_USER_AGENT'];
?>
the result is:
Opera/9.80 (X11; Linux i686; U; en-GB) Presto/2.6.30 Version/10.61