<?php $link = mysqli_connect("localhost", "my_user", "my_password", "test");
mysqli_query($link, "DROP TABLE IF EXISTS friends"); mysqli_query($link, "CREATE TABLE friends (id int, name varchar(20))"); mysqli_query($link, "INSERT INTO friends VALUES (1,'Hartmut'), (2, 'Ulf')");
$stmt = mysqli_prepare($link, "SELECT id, name FROM friends"); mysqli_stmt_execute($stmt);
/* get resultset for metadata */ $result = mysqli_stmt_result_metadata($stmt);
/* retrieve field information from metadata result set */ $field = mysqli_fetch_field($result);
printf("Fieldname: %s\n", $field->name);
/* close resultset */ mysqli_free_result($result);
/* close connection */ mysqli_close($link); ?>
|