Online PHP editor | refs for Iv4og

<?php $PDO = new \PDO("sqlite::memory:"); $PDO->query( "CREATE TABLE FileRecord ( RecordID INT, ReportFile VARCHAR(255) )" ); $PDO->query("INSERT INTO FileRecord (RecordID, ReportFile) VALUES (1, 'Test')"); $path = "Issues\\Reports\\"; $ReportFile = $path . "TestFileName.ext"; $query = $PDO->prepare('UPDATE FileRecord SET ReportFile = ? WHERE RecordID = 1'); $query->bindParam(1,$ReportFile); $result = $query->execute(); var_dump($result); $select = $PDO->query("SELECT * FROM FileRecord"); var_dump($select->fetchAll(\PDO::FETCH_OBJ));