mysqli_stmt_bind_result
stmt->bind_result()
(No version information available, might be only in CVS)
stmt->bind_result() โ ็ตๆใไฟๅญใใใใใใใชใใขใในใใผใใกใณใใซๅคๆฐใใใคใณใใใ
่ชฌๆ
ๆ็ถใๅ:
ใชใใธใงใฏใๆๅๅ๏ผใกใฝใใ๏ผ:
็ตๆใปใใใฎใซใฉใ ใๅคๆฐใซใใคใณใใใพใใ
ใใผใฟใๅๅพใใใใใซ mysqli_stmt_fetch() ใใณใผใซใใใๅ ดๅใMySQL ใฏใฉใคใขใณใ/ ใตใผใ ใใญใใณใซใฏใใคใณใใใใใซใฉใ ใฎใใผใฟใ var1, ... ใซๆ ผ็ดใใพใใ
ๆณจๆ: ใในใฆใฎใซใฉใ ใใmysqli_stmt_execute() ใใณใผใซใใฆใใ mysqli_stmt_fetch() ใใณใผใซใใใพใงใฎ้ใซ ใใคใณใใใฆใใๅฟ ่ฆใใใใใจใซๆณจๆใใพใใใใใซใฉใ ใฎๅใซ ๅฟใใฆใใใคใณใๅคๆฐใฎๅใๅฏพๅฟใใ PHP ใฎๅใซ่ชๅ็ใซๅคๆใใใพใใ
ใซใฉใ ใฎใใคใณใใๅใใคใณใใฏใใคใงใๅฏ่ฝใงใใใจใ็ตๆใปใใใ้ไธญใพใง ๅๅพใใๅพใงใใฃใฆใๅฏ่ฝใงใใๆฐใใใใคใณใใใๅ ๅฎนใๅนๅใ็บๆฎใใใฎใฏใ ๆฌกใซ mysqli_stmt_fetch() ใใณใผใซใใใใจใใใใงใใ
ใใฉใกใผใฟ
- stmt
-
ๆ็ถใๅใฎใฟ: mysqli_stmt_init() ใ่ฟใในใใผใใกใณใ IDใ
- var1
-
ใใคใณใใใๅคๆฐใ
่ฟใๅค
ๆๅใใๅ ดๅใซ TRUE ใใๅคฑๆใใๅ ดๅใซ FALSE ใ่ฟใใพใใ
ไพ
Example#1 ใชใใธใงใฏใๆๅๅ
<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
/* ในใใผใใกใณใใๆบๅใใพใ */
if ($stmt = $mysqli->prepare("SELECT Code, Name FROM Country ORDER BY Name LIMIT 5")) {
$stmt->execute();
/* ใใชใใขใในใใผใใกใณใใซๅคๆฐใใใคใณใใใพใ */
$stmt->bind_result($col1, $col2);
/* ๅคใๅๅพใใพใ */
while ($stmt->fetch()) {
printf("%s %s\n", $col1, $col2);
}
/* ในใใผใใกใณใใ้ใใพใ */
$stmt->close();
}
/* ๆฅ็ถใ้ใใพใ */
$mysqli->close();
?>
Example#2 ๆ็ถใๅ
<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "world");
/* ๆฅ็ถ็ถๆณใใใงใใฏใใพใ */
if (!$link) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
/* ในใใผใใกใณใใๆบๅใใพใ */
if ($stmt = mysqli_prepare($link, "SELECT Code, Name FROM Country ORDER BY Name LIMIT 5")) {
mysqli_stmt_execute($stmt);
/* ใใชใใขใในใใผใใกใณใใซๅคๆฐใใใคใณใใใพใ */
mysqli_stmt_bind_result($stmt, $col1, $col2);
/* ๅคใๅๅพใใพใ */
while (mysqli_stmt_fetch($stmt)) {
printf("%s %s\n", $col1, $col2);
}
/* ในใใผใใกใณใใ้ใใพใ */
mysqli_stmt_close($stmt);
}
/* ๆฅ็ถใ้ใใพใ */
mysqli_close($link);
?>
ไธใฎไพใฎๅบๅใฏไปฅไธใจใชใใพใใ
AFG Afghanistan ALB Albania DZA Algeria ASM American Samoa AND Andorra