Seeks to an arbitrary row in statement result set (original) (raw)

<?php /* Open a connection */ $link = mysqli_connect("localhost", "my_user", "my_password", "world");/* check connection */ if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); }$query = "SELECT Name, CountryCode FROM City ORDER BY Name"; if ($stmt = mysqli_prepare($link, $query)) {/* execute query */ mysqli_stmt_execute($stmt);/* bind result variables */ mysqli_stmt_bind_result($stmt, <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>n</mi><mi>a</mi><mi>m</mi><mi>e</mi><mo separator="true">,</mo></mrow><annotation encoding="application/x-tex">name, </annotation></semantics></math>name,code);/* store result */ mysqli_stmt_store_result($stmt);/* seek to row no. 400 */ mysqli_stmt_data_seek($stmt, 399);/* fetch values */ mysqli_stmt_fetch($stmt);printf ("City: %s Countrycode: %s\n", <math xmlns="http://www.w3.org/1998/Math/MathML"><semantics><mrow><mi>n</mi><mi>a</mi><mi>m</mi><mi>e</mi><mo separator="true">,</mo></mrow><annotation encoding="application/x-tex">name, </annotation></semantics></math>name,code);/* close statement */ mysqli_stmt_close($stmt); }/* close connection */ mysqli_close($link); ?>

City: Benin City Countrycode: NGA