/ / create blob id' s for a byte and text column $textid = ifx_create_blob(0, 0, "Text column in memory"); $byteid = ifx_create_blob(1, 0, "Byte column in memory"); / / store blob id's in a blobid array $blobidarray[] = $textid; $blobidarray[] = $byteid; / / launch query $query = "insert into catalog (stock_num, manu_code, ". "cat_descr,cat_picture) values(1 ,'HRO',?, ?)"; $res_id = ifx_query($query, $conn_id, $blobidarray); if (! $res_id) {... error...} / / free result id ifx_free_result($res_id);
?php / / créer un identifiant de BLOB pour une colonne de type BYTE et une de type TEXT $textid = ifx_create_blob( 0, 0, "Colonne Text en mémoire"); $byteid = ifx_create_blob(1, 0, "Colonne Byte en mémoire"); / / Stocke l'identifiant du BLOB dans le tableau BLOBid $BLOBidarray[] = $textid; $BLOBidarray[] = $byteid; / / éxécute la requête $query = "insert into catalog (stock_num, manu_code, ". "cat_descr,cat_picture) values(1 ,'HRO',?, ?)"; $res_id = ifx_query($query, $conn_id, $BLOBidarray); if (! $res_id) {/ /... erreur...} / / libération du résultat ifx_free_result($res_id);?