PHP: Hypertext Preprocessor (original) (raw)

`<?php
$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, SurfaceArea from Country ORDER BY Code LIMIT 5";

if ( result=mysqliquery(result = mysqli_query(result=mysqliq​uery(link, $query)) {/* Get field information for all fields /
while ($finfo = mysqli_fetch_field($result)) {/ get fieldpointer offset / currentfield=mysqlifieldtell(currentfield = mysqli_field_tell(currentfield=mysqlif​ieldt​ell(result);printf("Column %d:\n", $currentfield);
printf("Name: %s\n", $finfo->name);
printf("Table: %s\n", $finfo->table);
printf("max. Len: %d\n", $finfo->max_length);
printf("Flags: %d\n", $finfo->flags);
printf("Type: %d\n\n", $finfo->type);
}
mysqli_free_result($result);
}/ close connection */
mysqli_close($link);
?>`

Column 1: Name: Name Table: Country max. Len: 11 Flags: 1 Type: 254

Column 2: Name: SurfaceArea Table: Country max. Len: 10 Flags: 32769 Type: 4