Guest User

Untitled

a guest
May 28th, 2018
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.75 KB | None | 0 0
  1. $CreatedOn = strval(date("Y-m-d H:i:s"));
  2.  
  3. $dbh = new PDO('odbc:DRIVER=FreeTDS;SERVERNAME=myMssql;DATABASE=' .
  4. $database.';charset=UTF-8', $user, $password);
  5. $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  6.  
  7. $query='SET TEXTSIZE 9999999';
  8. $stmt=$dbh->prepare($query);
  9. $stmt->execute();
  10. $stmt=null;
  11.  
  12. $ins = "insert into tbl_Files(ItemTypeID, Link, FileData, CreatedOn)
  13. values (
  14.  
  15. '{39A5B367-4A7A-473E-8F74-26977CB6DB67}', 'filename.txt', :content, '{$CreatedOn}'
  16.  
  17. )";
  18.  
  19. $stmt = $dbh->prepare($ins);
  20. $filename = "test.txt";
  21. $handle = fopen($filename, "rb");
  22. $contents = fread($handle, filesize($filename));
  23. fclose($handle);
  24.  
  25. $stmt->bindParam(':content', $contents, PDO::PARAM_LOB);
  26. $stmt->execute();
Add Comment
Please, Sign In to add comment