mysqli_stmt::execute
(PHP 5, PHP 7)
mysqli_stmt :: execute - mysqli_stmt_execute - 执行准备好的查询
描述
面向对象的风格
bool mysqli_stmt::execute ( void )程序风格
bool mysqli_stmt_execute ( mysqli_stmt $stmt )执行先前使用mysqli_prepare（）函数准备的查询。执行时，任何存在的参数标记都将自动替换为适当的数据。
如果语句是UPDATE，DELETE或INSERT，则可以使用mysqli_stmt_affected_rows（）函数确定受影响的行的总数。同样，如果查询产生结果集，则使用mysqli_stmt_fetch（）函数。
注意：使用mysqli_stmt_execute（）时，必须使用mysqli_stmt_fetch（）函数在执行任何其他查询之前获取数据。
参数
`stmt` 仅过程风格：由mysqli_stmt_init（）返回的语句标识符。
返回值
返回TRUE成功或返回FALSE失败时返回。
例子
Example #1 Object oriented style
<?php
$mysqli?=?new?mysqli("localhost",?"my_user",?"my_password",?"world");
/*?check?connection?*/
if?(mysqli_connect_errno())?{
????printf("Connect?failed:?%s\n",?mysqli_connect_error());
????exit();
}
$mysqli->query("CREATE?TABLE?myCity?LIKE?City");
/*?Prepare?an?insert?statement?*/
$query?=?"INSERT?INTO?myCity?(Name,?CountryCode,?District)?VALUES?(?,?,?)";
$stmt?=?$mysqli->prepare($query);
$stmt->bind_param("sss",?$val1,?$val2,?$val3);
$val1?=?'Stuttgart';
$val2?=?'DEU';
$val3?=?'Baden-Wuerttemberg';
/*?Execute?the?statement?*/
$stmt->execute();
$val1?=?'Bordeaux';
$val2?=?'FRA';
$val3?=?'Aquitaine';
/*?Execute?the?statement?*/
$stmt->execute();
/*?close?statement?*/
$stmt->close();
/*?retrieve?all?rows?from?myCity?*/
$query?=?"SELECT?Name,?CountryCode,?District?FROM?myCity";
if?($result?=?$mysqli->query($query))?{
????while?($row?=?$result->fetch_row())?{
????????printf("%s?(%s,%s)\n",?$row[0],?$row[1],?$row[2]);
????}
????/*?free?result?set?*/
????$result->close();
}
/*?remove?table?*/
$mysqli->query("DROP?TABLE?myCity");
/*?close?connection?*/
$mysqli->close();
?>Example #2 Procedural style
<?php
$link?=?mysqli_connect("localhost",?"my_user",?"my_password",?"world");
/*?check?connection?*/
if?(mysqli_connect_errno())?{
????printf("Connect?failed:?%s\n",?mysqli_connect_error());
????exit();
}
mysqli_query($link,?"CREATE?TABLE?myCity?LIKE?City");
/*?Prepare?an?insert?statement?*/
$query?=?"INSERT?INTO?myCity?(Name,?CountryCode,?District)?VALUES?(?,?,?)";
$stmt?=?mysqli_prepare($link,?$query);
mysqli_stmt_bind_param($stmt,?"sss",?$val1,?$val2,?$val3);
$val1?=?'Stuttgart';
$val2?=?'DEU';
$val3?=?'Baden-Wuerttemberg';
/*?Execute?the?statement?*/
mysqli_stmt_execute($stmt);
$val1?=?'Bordeaux';
$val2?=?'FRA';
$val3?=?'Aquitaine';
/*?Execute?the?statement?*/
mysqli_stmt_execute($stmt);
/*?close?statement?*/
mysqli_stmt_close($stmt);
/*?retrieve?all?rows?from?myCity?*/
$query?=?"SELECT?Name,?CountryCode,?District?FROM?myCity";
if?($result?=?mysqli_query($link,?$query))?{
????while?($row?=?mysqli_fetch_row($result))?{
????????printf("%s?(%s,%s)\n",?$row[0],?$row[1],?$row[2]);
????}
????/*?free?result?set?*/
????mysqli_free_result($result);
}
/*?remove?table?*/
mysqli_query($link,?"DROP?TABLE?myCity");
/*?close?connection?*/
mysqli_close($link);
?>上面的例子会输出：
Stuttgart (DEU,Baden-Wuerttemberg)
Bordeaux (FRA,Aquitaine)本文档系腾讯云开发者社区成员共同维护，如有问题请联系 cloudcommunity@tencent.com
