Re: Calling a stored procedure that exists on the As/400 fromPHP

["Dan Hogan" <Dan.Hogan@xxxxxxxxxxxx>]

Tom,

We had a heck of a time finding an example as well.  We managed to get
our PHP script calling a stored procedure to work just yesterday.  Hope
this helps.

Dan...

PHP code Before This

function callpgm($prod)
{
		// Make all global variables available here
	foreach($GLOBALS as $arraykey=>$arrayvalue) 
	{
		if($arraykey[0]!='_' && $arraykey != 'GLOBALS')
			global $$arraykey;
	}
     
    
	$conn = db2_connect("system", "userid", "password");
	 
	if (!$conn)
	{
		die("Database connect failed($conn)");
	}
	
	$pkey='1';
	
	//----------------- Prepare & Call the stored procedure
-----------------
		
	$call='call SHASHI.GENKEY(?,?,?,?,?)';
	$stmt = db2_prepare($conn,$call);
	db2_bind_param($stmt, 1, "srlNo", DB2_PARAM_IN); 
	db2_bind_param($stmt, 2, "seats", DB2_PARAM_IN); 
	db2_bind_param($stmt,3, "expDate", DB2_PARAM_IN); 
	db2_bind_param($stmt,4, "prod", DB2_PARAM_IN); 
	db2_bind_param($stmt,5, "pkey", DB2_PARAM_OUT); 
	
	// call the stored procedure
	$ret=db2_execute($stmt);
		    
    // Check if any errors occurred.
	if (!$ret) 
	{
	    die("i5_program_call_failed ($ret)");
	}
     
 }

More PHP Code

> I have done multiple searches and looked through 2 Redbooks 
> on PHP, and cannot find a simple example of calling a stored 
> procedure from PHP to build on.