Advertisement
Guest User

Untitled

a guest
Sep 22nd, 2016
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.91 KB | None | 0 0
  1. <?
  2. //Create db connection
  3. $hostname = "MYIBMI";
  4. $user = "MYPROFILE";
  5. $password = "";
  6. $dbconn = new PDO("odbc:" . $hostname, $user, $password);
  7.  
  8. //SQL to run stored proc
  9. $sql = "call #LALLAN.getCusInfo(?, ?, ?, ?)";
  10.  
  11. //Prepare SQL for execution
  12. $stmt = $dbconn->prepare($sql);
  13.  
  14. //Create a test object for demo purposes
  15. $Customer = new stdClass();
  16. $Customer->ID = 1;
  17. $Customer->Data1 = "";
  18. $Customer->Data2 = "";
  19. $Customer->Data3 = 1;
  20.  
  21. //Bind object properties to our object
  22. $stmt->bindParam(1, $Customer->ID, PDO::PARAM_INT);
  23. $stmt->bindParam(2, $Customer->Data1, PDO::PARAM_INPUT_OUTPUT);
  24. $stmt->bindParam(3, $Customer->Data2, PDO::PARAM_INPUT_OUTPUT);
  25. $stmt->bindParam(4, $Customer->Data3, PDO::PARAM_INPUT_OUTPUT);
  26.  
  27. //Run it
  28. $stmt->execute();
  29.  
  30. //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
  31. var_dump($Customer);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement