Demo of PHP OCI with parameters

demo_oci_parameters.php

<?php
$ORACLE_HOST = "127.0.0.1";
$ORACLE_PORT = "1521";
$ORACLE_SID = "mysid";
$ORACLE_USER = "myuser";
$ORACLE_PASSWORD = "mypass";

$ORACLE_DSN = "
	(DESCRIPTION =
	(ADDRESS = (PROTOCOL = TCP)(HOST = $ORACLE_HOST)(PORT = $ORACLE_PORT))
(CONNECT_DATA = (SID = $ORACLE_SID)) )";

$conn = oci_connect($ORACLE_USER, $ORACLE_PASSWORD, $ORACLE_DSN, 'utf8');

if ($conn) {
	$param_id = null;
	$param_seq = null;
	
	$st = oci_parse($conn, "UPDATE TEST SET SEQ=:seq WHERE id=:id");
	oci_bind_by_name($st, ':seq', $param_seq);
	oci_bind_by_name($st, ':id', $param_id);

	$param_id = 2; $param_seq = 2; 
	oci_execute($st);
	
	$param_id = 7; $param_seq = 3; 
	oci_execute($st);
}