require 'scraperwiki.php'; scraperwiki::sqliteexecute("CREATE TABLE mytable (id INTEGER PRIMARY KEY, name TEXT)");
require 'scraperwiki.php'; $name = "John"; scraperwiki::sqliteexecute("INSERT INTO mytable (name) VALUES (?)", array($name));
require 'scraperwiki.php'; $id = 1; $newName = "Jane"; scraperwiki::sqliteexecute("UPDATE mytable SET name = ? WHERE id = ?", array($newName, $id));This code updates the "name" column of the row with id=1 in the "mytable" table to "Jane". The package library for PHP Scraperwiki SQLiteExecute is Scraperwiki, which can be installed using Composer or downloaded from the Scraperwiki website.