Binds variables to a prepared statement for result storage (original) (raw)

<?php $link = mysqli_connect("localhost", "my_user", "my_password", "world");/* check connection */ if (!$link) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); }/* prepare statement */ if ($stmt = mysqli_prepare($link, "SELECT Code, Name FROM Country ORDER BY Name LIMIT 5")) { mysqli_stmt_execute($stmt);/* bind variables to prepared statement */ mysqli_stmt_bind_result($stmt, <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>c</mi><mi>o</mi><mi>l</mi><mn>1</mn><mo separator="true">,</mo></mrow><annotation encoding="application/x-tex">col1, </annotation></semantics></math>col1,col2);/* fetch values */ while (mysqli_stmt_fetch($stmt)) { printf("%s %s\n", <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>c</mi><mi>o</mi><mi>l</mi><mn>1</mn><mo separator="true">,</mo></mrow><annotation encoding="application/x-tex">col1, </annotation></semantics></math>col1,col2); }/* close statement */ mysqli_stmt_close($stmt); }/* close connection */ mysqli_close($link); ?>

AFG Afghanistan ALB Albania DZA Algeria ASM American Samoa AND Andorra