PHP - Execute an insert using a parameter

From Ingres Community Wiki

<?php
$database='dbname';
$user='user';
$password='password';


$conn = ingres_connect($database,$user,$password);

if ($conn) {
    echo "Connection succeeded.";
    $rc_delete=ingres_query($conn,"delete from param_tests");
    if (is_resource($rc_delete)) {
        $param = array(1,1.1,"Row 1");
        $rc_insert=ingres_query($conn,"insert into param_tests values (?,?,?)",$param);
        if (is_resource($rc_insert)) {
            echo "Insert succeeded.";
            $param = array(1);
            $rc_select=ingres_query($conn,"select * from param_tests where col1 = ?",$param);
            if (is_resource($rc_select)) {
                while ( $object = ingres_fetch_object($rc_select)) {
                echo $object->col1 . " " . $object->col2 . " " . $object->col3;
                }
            } else {
                echo "Select failed. " . ingres_error() ;
            }
        } else {
            echo "Insert failed.";
        }
    } else {
        echo "Delete failed.";
    }
    ingres_close($conn);
} else {
    echo "Connection failed.";
}

?>

Back to PHP Driver Examples