1. <?php
//定义打印函数
function dump($dump_row = null) {
echo '<pre>';
var_dump($dump_row);
}
//主要配置
$conf = [
'localhost' => '127.0.0.1', //主机名
'login_name' => 'root', //登录名
'login_pwd' => '', //登录密码
'char_set' => 'utf8', //字符
'db_name' => '', //选择数据库
'table_name' => '',//数据表
'title_one'=>'',//字段1
'title_two'=>'',//字段二
'title_three'=>''//字段三
];
$link = mysql_connect($conf['localhost'], $conf['login_name'], $conf['login_pwd']);
if (!$link) {
echo '数据库连接错误,请检查配置及服务';
exit;
}
mysql_select_db($conf['db_name'], $link);
mysql_query("set names " . $conf['char_set'], $link);
//语句
$sql = "select * from " . $conf['table_name'];
$sql_res = mysql_query($sql, $link);
while ($row[] = mysql_fetch_assoc($sql_res))
unset($row[count($row) - 1]);
?>
<table style="background: #349DFF">
<tr>
<th>姓名</th>
<th>年龄</th>
<th>微信</th>
</tr>
<?php foreach ($row as $v): ?>
<?php echo "<tr>"; ?>
<?php echo"<td>" . $v[$conf['title_one']] . "</td>"; ?>
<?php echo"<td>" . $v[$conf['title_two']] . "</td>"; ?>
<?php echo"<td>" . $v[$conf['title_three']] . "</td>"; ?>
<?php echo "</tr>"; ?>
<?php endforeach; ?>
</table>
3. 请参考
http://php.haowen100.com/read/wenzhang-14698.html<?php
mysql_connect('127.0.0.1','root','root');
mysql_query("utf8");
mysql_select_db('test');
//显示表的结构
$result = mysql_query("desc a");
if (!$result){
var_dump($result);
die();
}
while ($row = mysql_fetch_assoc($result)){
var_dump($row);
}
echo "<hr/>";
//获取表的创建语句
$result = mysql_query("show create table a");
if (!$result){
var_dump($result);
die();
}
while ($row = mysql_fetch_assoc($result)){
var_dump($row);
}