Re: postgresql database access failure

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 30/04/2011, Daniel Brown <danbrown@xxxxxxx> wrote:
>     Readers?  Sounds like you spend too much time writing newsletters
> (to the wrong address, since php-general-digest-help@xxxxxxxxxxxxx is
> a self-help command list for digest-form subscriptions).  ;-P
>
> On Sat, Apr 30, 2011 at 04:41, e-letter <inpost@xxxxxxxxx> 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

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux