帮忙debug一下,谢谢!
function create_connection()
{
$link=mysqli_connect("localhost",'root','')or die('无法建立连接:'.mysqli_connect_error());
return $link;
}
function execute_sql($link,$database,$sql)
{
mysqli_select_db($link,$database) or die('无法打开'.$database.'数据库:'.mysqli_error($link));
mysqli_query($link,"SET NAMES gb2312");
$res=mysqli_query($link,$sql);
return $res;
}
require_once("mysqli_connect.php");
$link=create_connection();
$sql="SELECT * FROM tdb_goods";
$res=mysqli_execute($link,"test",$sql);
echo '<table width="700" border="1"><tr align="center">';
echo '<td>字段名</td><td>数据类型</td><td>最大长度</td></tr>';
while($object=mysqli_fetch_field($res))
{
echo '<tr>';
echo '<td>'.$object->name.'</td>';
echo '<td>'.$object->type.'</td>';
echo '<td>'.$object->max_length.'</td>';
echo '</tr>';
}
echo '</table>';
mysqli_close($link);
以下是错误提示:
Warning: mysqli_execute() expects exactly 1 parameter, 3 given inD:\AppServ\www\testsite\bookcode\charpter\13AccessMysqlDatabase\mysqli_fetch_field.php on line 13
Warning: mysqli_fetch_field() expects parameter 1 to be mysqli_result, null given inD:\AppServ\www\testsite\bookcode\charpter\13AccessMysqlDatabase\mysqli_fetch_field.php on line 16