Administrace komentářů

Zdravim

Prosím o radu:

Zkousim si zobrazit přes PHP database a přiložený php script nefunguje.

Spíš to neudělá nic a a začne se stahovat index.php (jako soubor) ve kterém mám ten kod uložený.

<PRE>

 <HTML>   
    <HEAD>
        <TITLE>syslog-ng</TITLE>
        <LINK REL="stylesheet" TYPE="text/css" HREF="syslog.css">
    </HEAD>
    <BODY>
<?php

$sql = mysql_connect("localhost", "syslogng", "mypassword");
mysql_select_db("syslog");

$q = mysql_query("SELECT * FROM logs");

print '<table>';

    print "<tr>
            <td>Host</td>
            <td>Facility</td>
            <td>Priority</td>
            <td>Level</td>
            <td>Tag</td>
            <td>Date</td>
            <td>Time</td>
            <td>Program</td>
            <td>Msg</td>
            <td>Seq</td>
        </tr>
    ";

while ($row = mysql_fetch_assoc($q)) {
    print "<tr>
            <td>" . $row['host'] . "</td>
            <td>" . $row['facility'] . "</td>
            <td>" . $row['priority'] . "</td>
            <td>" . $row['level'] . "</td>
            <td>" . $row['tag'] . "</td>
            <td>" . $row['date'] . "</td>
            <td>" . $row['time'] . "</td>
            <td>" . $row['program'] . "</td>
            <td>" . $row['msg'] . "</td>
            <td>" . $row['seq'] . "</td>
        </tr>

    ";
}

print '</table>';

?>

</BODY>
</HTML>
 

</PRE>

PHP mám nainstalováno a test mi projde OK.

<PRE>

xwks:/var/www# telnet localhost 80
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
HEAD / HTTP/1.0

HTTP/1.1 200 OK
Date: Mon, 11 May 2009 14:12:26 GMT
Server: Apache/2.2.9 (Debian) PHP/5.2.6-1+lenny3 with Suhosin-Patch
Last-Modified: Mon, 11 May 2009 12:51:56 GMT
ETag: "c0bd-2d-469a27175b300"
Accept-Ranges: bytes
Content-Length: 45
Vary: Accept-Encoding
Connection: close
Content-Type: text/html

Connection closed by foreign host.
</PRE>

<PRE>

PHP Test

An Example of PHP in Action
The Current Date and Time is:
4:04 PM Monday, May 11 2009.
PHP Information

PHP Logo
PHP Version 5.2.6-1+lenny3

System     Linux xwks 2.6.26-1-686 #1 SMP Fri Mar 13 18:08:45 UTC 2009 i686
Build Date     Apr 26 2009 21:57:45
Server API     Apache 2.0 Handler
Virtual Directory Support     disabled
Configuration File (php.ini) Path     /etc/php5/apache2
Loaded Configuration File     /etc/php5/apache2/php.ini
Scan this dir for additional .ini files     /etc/php5/apache2/conf.d
additional .ini files parsed     /etc/php5/apache2/conf.d/mysql.ini, /etc/php5/apache2/conf.d/mysqli.ini, /etc/php5/apache2/conf.d/pdo.ini, /etc/php5/apache2/conf.d/pdo_mysql.ini
PHP API     20041225
PHP Extension     20060613
Zend Extension     220060519
Debug Build     no
Thread Safety     disabled
Zend Memory Manager     enabled
IPv6 Support     enabled
Registered PHP Streams     zip, php, file, data, http, ftp, compress.bzip2, compress.zlib, https, ftps
Registered Stream Socket Transports     tcp, udp, unix, udg, ssl, sslv3, sslv2, tls
Registered Stream Filters     string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, convert.iconv.*, bzip2.*, zlib.*

 </PRE>

Tak nevim kde je problém. Nejspíš to bude nějaká drobnost.

Děkuji za radu