一、PHP与Html结合 数组以表格显示
<?php while($row=$result->fetch_array()){?>
<tr>
<td><?php echo $row['cn']?></td>
<td><?php echo $row['cn']?></td>
</tr>
<?php}?>
二、update
$stmt->prepare($sql);
$var="123";
$stmt->bind_param("sn",$var1);
$stmt_execute();
echo $stmt->affected_rows;
三、结果集输出
$stmt->prepare($sql);
$var1="男"
$stmt->bind_param("gender",$var1);
$stmt_execute();
$stmt->bind_result($sn,$password,$name,$gender);
while($row=$stmt->fetch()){
echo $sn." ".$password." ".$name." ".$gender.
}
四、函数的声明
function <function_name>([<arg> [,]]){
}