<?php
    $link = mysql_connect('localhost', 'root', 'abc123');
    if(!$link){
        die('数据库链接失败：'.mysql_error());
    }
    mysql_select_db('test');
    
    $select = "SELECT * FROM book;";
    $result = mysql_query($select);
    
    echo "<table align='center' width='60%' border='1'>";
    echo '<caption><h2>图书信息表</h2></caption>';
    echo '<th>图书编号</th><th>图书名称</th><th>作者</th>';
    while($row = mysql_fetch_row($result)){
        echo "<tr>";
        foreach($row as $data){
            echo '<td>'.$data.'</td>';
        }
        echo '</tr>';
    }
    echo "</table>";
    mysql_free_result($result);        //释放查询的结果集资源
    mysql_close($link);
?>