Php > Informix

Query

Query

Show all rows of the "orders" table as a html table 
<?php 
ifx_textasvarchar(1);      // use "text mode" for blobs 
$res_id = ifx_query("select * from orders", $conn_id); 
if (! $res_id) { 
    printf("Can't select orders : %s\n<br>%s<br>\n", ifx_error()); 
    ifx_errormsg(); 
    die; 
} 
ifx_htmltbl_result($res_id, "border=\"1\""); 
ifx_free_result($res_id); 
?> 

Insert some values into the "catalog" table 
<?php 
// 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); 
?>