PHP

一、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> [,]]){

}