Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?
- //Create db connection
- $hostname = "MYIBMI";
- $user = "MYPROFILE";
- $password = "";
- $dbconn = new PDO("odbc:" . $hostname, $user, $password);
- //SQL to run stored proc
- $sql = "call #LALLAN.getCusInfo(?, ?, ?, ?)";
- //Prepare SQL for execution
- $stmt = $dbconn->prepare($sql);
- //Create a test object for demo purposes
- $Customer = new stdClass();
- $Customer->ID = 1;
- $Customer->Data1 = "";
- $Customer->Data2 = "";
- $Customer->Data3 = 1;
- //Bind object properties to our object
- $stmt->bindParam(1, $Customer->ID, PDO::PARAM_INT);
- $stmt->bindParam(2, $Customer->Data1, PDO::PARAM_INPUT_OUTPUT);
- $stmt->bindParam(3, $Customer->Data2, PDO::PARAM_INPUT_OUTPUT);
- $stmt->bindParam(4, $Customer->Data3, PDO::PARAM_INPUT_OUTPUT);
- //Run it
- $stmt->execute();
- //Dump our object to the screen to see what everything got set to. Or alternatively run xdebug or another debugger to view the $Customer object after execution
- var_dump($Customer);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement