How can the use of mysql_result in mysqli be adapted in PHP?

The use of `mysql_result` function in `mysqli` is not directly supported as `mysql` and `mysqli` are different extensions in PHP. To adapt the use of `mysql_result` in `mysqli`, you can use `mysqli_data_seek` and `mysqli_fetch_row` functions to achieve similar functionality. 

// Connect to MySQL database using mysqli
$mysqli = new mysqli("localhost", "username", "password", "database");

// Run your query
$result = $mysqli->query("SELECT * FROM your_table");

// Move the result pointer to the desired row
mysqli_data_seek($result, $row_number);

// Fetch the row as an enumerated array
$row = mysqli_fetch_row($result);

// Access the specific column value by index
$column_value = $row[$column_index];

// Free the result set
$mysqli->free_result($result);

Keywords

mysqli mysql_result PHP database adaptation

Related Questions