<?php class MyDB extends SQLite3 { function __construct() { $this->open('perfdb'); } } $hostname = $_POST['hostname']; if (!empty($hostname)) { $db = new MyDB(); $stmt = $db->prepare("insert into hosts (hostname) values (:hn)"); $stmt->bindParam(':hn', $hostname, SQLITE3_TEXT); $ret = $stmt->execute(); if (!empty($ret)) { $host_id = $db->lastInsertRowID(); print "Inserted row with host_id = " . $host_id; } }
{ function __construct() { $this->open('perfdb'); } } $os = $_POST['os']; $compiler = $_POST['compiler']; $version = $_POST['version']; $flags = $_POST['flags']; $library = $_POST['library']; $library_ver = $_POST['library_ver']; $backend = $_POST['backend']; $backend_ver = $_POST['backend_ver']; if (!empty($os) and !empty($compiler) and !empty($version) and !empty($flags) and !empty($library) and !empty($library_ver) and !empty($backend) and !empty($backend_ver)) { $db = new MyDB(); $stmt = $db->prepare("insert into systems \n\t\t\t\t\t\t(os, compiler, version, flags, library, library_ver, backend, backend_ver) \n\t\t\t\t\t\tvalues (:o, :c, :v, :f, :l, :lv, :b, :bv)"); $stmt->bindParam(':o', $os, SQLITE3_TEXT); $stmt->bindParam(':c', $compiler, SQLITE3_TEXT); $stmt->bindParam(':v', $version, SQLITE3_TEXT); $stmt->bindParam(':f', $flags, SQLITE3_TEXT); $stmt->bindParam(':l', $library, SQLITE3_TEXT); $stmt->bindParam(':lv', $library_ver, SQLITE3_TEXT); $stmt->bindParam(':b', $backend, SQLITE3_TEXT); $stmt->bindParam(':bv', $backend_ver, SQLITE3_TEXT); $ret = $stmt->execute(); if (!empty($ret)) { $system_id = $db->lastInsertRowID(); print "Inserted row with system_id = " . $system_id; } }
<?php class MyDB extends SQLite3 { function __construct() { $this->open('perfdb'); } } $url = $_POST['url']; $hash = $_POST['hash']; if (!empty($url) and !empty($hash)) { $db = new MyDB(); $stmt = $db->prepare("insert into sources (URL, commit_hash) values (:u, :ch)"); $stmt->bindParam(':u', $url, SQLITE3_TEXT); $stmt->bindParam(':ch', $hash, SQLITE3_TEXT); $ret = $stmt->execute(); if (!empty($ret)) { $source_id = $db->lastInsertRowID(); print "Inserted row with source_id = " . $source_id; } }
function insert_item($title, $descr, $photos) { $db = new MyDB(); if (!$db) { echo $db->lastErrorMsg(); } $sql = "INSERT INTO item (title, description) VALUES ('{$title}','{$descr}')"; $ret = $db->exec($sql); $itemID = $db->lastInsertRowID(); foreach ($photos as $photo) { $sql = "INSERT INTO photo (name, item_id) VALUES ('{$photo}','{$itemID}')"; $ret = $db->exec($sql); } if (!$ret) { echo $db->lastErrorMsg(); } }
<?php class MyDB extends SQLite3 { function __construct() { $this->open('perfdb'); } } $type = $_POST['type']; $accl_name = $_POST['accl_name']; $arch = $_POST['arch']; $memory = $_POST['memory']; $cores = $_POST['cores']; $details = $_POST['type']; if (!empty($type) and !empty($accl_name) and !empty($arch) and !empty($memory) and !empty($cores) and !empty($details)) { $db = new MyDB(); $stmt = $db->prepare("insert into accelerators \n\t\t\t\t\t\t(type, accl_name, arch, memory, cores, details) \n\t\t\t\t\t\tvalues (:t, :an, :ar, :m, :c, :d)"); $stmt->bindParam(':t', $type, SQLITE3_TEXT); $stmt->bindParam(':an', $accl_name, SQLITE3_TEXT); $stmt->bindParam(':ar', $arch, SQLITE3_TEXT); $stmt->bindParam(':m', $memory, SQLITE3_INTEGER); $stmt->bindParam(':c', $cores, SQLITE3_INTEGER); $stmt->bindParam(':d', $details, SQLITE3_TEXT); $ret = $stmt->execute(); if (!empty($ret)) { $accl_id = $db->lastInsertRowID(); print "Inserted row with accl_id = " . $accl_id; } }