Advertisement
Guest User

Untitled

a guest
Mar 15th, 2017
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.68 KB | None | 0 0
  1. //connection string
  2. $hostname = 'hostname';
  3. $dbname = 'dbname';
  4. $username = 'username';
  5. $password = 'password';
  6. $dbh = new PDO("dblib:host=$hostname;dbname=$dbname","$username","$password");
  7.  
  8. //Parsing the passed in data
  9. $passedparams = implode(',',$_REQUEST['passedparams']);
  10.  
  11. //Capturing the dates from passed in data
  12. $d1 = $_REQUEST['d1'];
  13. $d2 = $_REQUEST['d2'];
  14.  
  15. //Run Stored Procedure To Create Table
  16. $proc = mssql_init('HoldingPattern',$conn);
  17. mssql_bind($proc,'@d1',$d1,SQLVARCHAR);
  18. mssql_bind($proc,'@d2',$d2,SQLVARCHAR);
  19.  
  20. //Create Query String to query newly created table
  21. $sql = "SELECT ".$passedparams." FROM tablecreatedfromproc";
  22. $stmt = $dbh->prepare($sql);
  23. $stmt->execute();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement