fbsql_field_table
<<<
fbsql_field_type fbsql_free_result
>>>

8.34 FrontBase
8 Référence des fonctions
 Manuel PHP

Introduction
Pré-requis
Installation
Configuration à l'exécution
Types de ressources
Constantes pré-définies
fbsql_affected_rows
fbsql_autocommit
fbsql_blob_size
fbsql_change_user
fbsql_clob_size
fbsql_close
fbsql_commit
fbsql_connect
fbsql_create_blob
fbsql_create_clob
fbsql_create_db
fbsql_data_seek
fbsql_database_password
fbsql_database
fbsql_db_query
fbsql_db_status
fbsql_drop_db
fbsql_errno
fbsql_error
fbsql_fetch_array
fbsql_fetch_assoc
fbsql_fetch_field
fbsql_fetch_lengths
fbsql_fetch_object
fbsql_fetch_row
fbsql_field_flags
fbsql_field_len
fbsql_field_name
fbsql_field_seek
fbsql_field_table
->fbsql_field_type
fbsql_free_result
fbsql_get_autostart_info
fbsql_hostname
fbsql_insert_id
fbsql_list_dbs
fbsql_list_fields
fbsql_list_tables
fbsql_next_result
fbsql_num_fields
fbsql_num_rows
fbsql_password
fbsql_pconnect
fbsql_query
fbsql_read_blob
fbsql_read_clob
fbsql_result
fbsql_rollback
fbsql_select_db
fbsql_set_lob_mode
fbsql_set_password
fbsql_set_transaction
fbsql_start_db
fbsql_stop_db
fbsql_tablename
fbsql_username
fbsql_warnings

8.34.37 fbsql_field_type() Lit le type d'une colonne

[ Exemples avec fbsql_field_type ]   PHP 4 >= 4.0.6, PHP 5

string  fbsql_field_type ( resource   result , int   field_offset )

fbsql_field_type est similaire à la fonction fbsql_field_name . Les arguments sont identiques, mais le type du champ est retourné. Il peut valoir "int", "real", "string", "blob" ou d'autres valeurs, comme décrit dans la documentation FrontBase .
Exemple avec fbsql_field_type

<?php
fbsql_connect
("localhost:3306");
fbsql_connect("localhost", "_SYSTEM", "");
$result = fbsql_query("SELECT * FROM onek;");
$fields = fbsql_num_fields($result);
$rows   = fbsql_num_rows($result);
$i = 0;
$table = fbsql_field_table($result, $i);
echo
"Votre table '" . $table . "' a " . $fields . " colonnes et " . $rows . " lignes <br />";
echo
'La table dispose des champs suivants <br />';
while (
$i < $fields) {
  
$type  = fbsql_field_type ($result, $i);
  
$name  = fbsql_field_name ($result, $i);
  
$len   = fbsql_field_len  ($result, $i);
  
$flags = fbsql_field_flags($result, $i);
  echo
$type . ' ' . $name . ' ' . $len . ' ' . $flags . '<br />';
  
$i++;
}
fbsql_close();
?>

<< fbsql_field_type >>
fbsql_field_table FrontBase fbsql_free_result