Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $CreatedOn = strval(date("Y-m-d H:i:s"));
- $dbh = new PDO('odbc:DRIVER=FreeTDS;SERVERNAME=myMssql;DATABASE=' .
- $database.';charset=UTF-8', $user, $password);
- $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- $query='SET TEXTSIZE 9999999';
- $stmt=$dbh->prepare($query);
- $stmt->execute();
- $stmt=null;
- $ins = "insert into tbl_Files(ItemTypeID, Link, FileData, CreatedOn)
- values (
- '{39A5B367-4A7A-473E-8F74-26977CB6DB67}', 'filename.txt', :content, '{$CreatedOn}'
- )";
- $stmt = $dbh->prepare($ins);
- $filename = "test.txt";
- $handle = fopen($filename, "rb");
- $contents = fread($handle, filesize($filename));
- fclose($handle);
- $stmt->bindParam(':content', $contents, PDO::PARAM_LOB);
- $stmt->execute();
Add Comment
Please, Sign In to add comment