Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //connection string
- $hostname = 'hostname';
- $dbname = 'dbname';
- $username = 'username';
- $password = 'password';
- $dbh = new PDO("dblib:host=$hostname;dbname=$dbname","$username","$password");
- //Parsing the passed in data
- $passedparams = implode(',',$_REQUEST['passedparams']);
- //Capturing the dates from passed in data
- $d1 = $_REQUEST['d1'];
- $d2 = $_REQUEST['d2'];
- //Run Stored Procedure To Create Table
- $proc = mssql_init('HoldingPattern',$conn);
- mssql_bind($proc,'@d1',$d1,SQLVARCHAR);
- mssql_bind($proc,'@d2',$d2,SQLVARCHAR);
- //Create Query String to query newly created table
- $sql = "SELECT ".$passedparams." FROM tablecreatedfromproc";
- $stmt = $dbh->prepare($sql);
- $stmt->execute();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement