hHq7f2pu

1$db = new SQLite3('databases/logs.sqlite');
2$db->exec("
3	CREATE TABLE IF NOT EXISTS bank_logs (
4		id integer constraint bank_logs_pk primary key autoincrement, 
5		sender_id integer, 
6		receiver_id integer, 
7		amount integer, 
8		type text, 
9		text text
10	)
11");
12$logLine = $db->prepare("INSERT INTO bank_logs (sender_id, receiver_id, amount, type, text) VALUES (?, ?, ?, ?, ?)");
13$logLine->bindParam(1, $senderId, SQLITE3_INTEGER);
14$logLine->bindParam(2, $receiverId, SQLITE3_INTEGER);
15$logLine->bindParam(3, $amount, SQLITE3_INTEGER);
16$logLine->bindParam(4, $operationType, SQLITE3_TEXT);
17$logLine->bindParam(5, $text, SQLITE3_TEXT);
18$logLine->execute();
19$logLine->close();