Attachment 931390 Details for Bug 1134339 – Program causing the bug

Program causing the bug

pdobug.php (text/plain), 1.02 KB, created by Patrick Monnerat on 2014-08-27 10:44:15 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Patrick Monnerat

Created: 2014-08-27 10:44:15 UTC

Size: 1.02 KB

patch

obsolete

><?php
>	try {
>		$conn = new PDO("odbc:<yourdatabaseDSN>");
>	}
>	catch (PDOException $e) {
>		print "Error!: " . $e->getMessage() . "\n";
>		die();
>	}
>
>	/* Adjust the SQL statement below to your test environment. */
>	$stmt = $conn->prepare("CALL LIBRARY.GETDB(? , ?)");
>
>	$intvalue = 10;
>	$strvalue = "abc";
>	$stmt->bindParam(1, $intvalue, PDO::PARAM_INT|PDO::PARAM_INPUT_OUTPUT, 4);
>	$stmt->bindParam(2, $strvalue, PDO::PARAM_STR|PDO::PARAM_INPUT_OUTPUT, 100);
>	print "before execute\n";
>	$res = $stmt->execute();
>	print "after execute\n";
>
>	var_dump($intvalue);
>	var_dump($strvalue);
>
>	if ($res) {
>		// Print inout and output parameter data
>		print "Success! \n";
>		print "The inout parameter value is: $intvalue. \n";
>		print "The out parameter value is: $strvalue. \n";
>
>		$stmt = null;
>		// Close connection
>		$conn = null;
>	}
>	else {
>		$arr = $stmt->errorInfo();
>		print "Execute failed with SQLState: " . $arr[0] . "\n";
>		print "Error message text: " . $arr[2] . "\n";
>
>		$stmt = null;
>		// Close connection
>		$conn = null;
>		die();
>	}
>?>

Actions: View

Attachments on bug 1134339: 931390 | 931391