postgresql.php
来自「视频监控网络部分的协议ddns,的模块的实现代码,请大家大胆指正.」· PHP 代码 · 共 46 行
PHP
46 行
<html><head><title>PHP und PostgreSQL</title></head><body><h1>PHP und PostgreSQL</h1><table border="1"><tr> <th>Interpret</th> <th>Titel</th> <th>Jahr</th></tr><?php $conn_string = "host=localhost port=5432 dbname=cdcol user=oswald password=geheim"; $db_handle = pg_connect($conn_string); if(!$db_handle) die("Kann Datenbank nicht erreichen!"); $query = "SELECT * FROM cds"; $result = pg_exec($db_handle, $query); if (!$result) { echo pg_errormessage($db_handle); } else { for ($row = 0; $row < pg_numrows($result); $row++) { $values = pg_fetch_array($result, $row, PGSQL_ASSOC); echo "<tr>"; echo "<td>".$values['interpret']."</td>"; echo "<td>".$values['titel']."</td>"; echo "<td>".$values['jahr']."</td>"; echo "</tr>"; } }?></table></body></html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?