public static final function GetInstance() { if (!isset(self::$instance)) { self::$instance = new self(); } return self::$instance; }
/** * @return resource mysql connection */ public static function GetConnection() { if (!self::$conn) { self::$conn = new \PDO("mysql:host=" . self::DBHOST . ";dbname=" . self::DBNAME . ";", self::DBUSER, self::DBPASS); } return self::$conn; }
/** * Create new DB instance. */ public function __construct() { if (!self::$dbh) { parent::__construct(); $db_string = 'dbname=' . $this->dbname; $dsn = 'mysql:host=' . $this->host . ';' . $db_string; try { self::$dbh = new PDO($dsn, $this->user, $this->pass); self::$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch (PDOException $e) { echo 'Connection failed: ' . $e->getMessage(); } } }
<?php header('Content-disposition: attachment; filename=dump.txt'); header('Context-type: text/csv'); class AppDB extends SQLite3 { function __construct() { $this->open('005.db'); } } $db = new AppDB(); if (!$db) { echo "Failed to open DB"; return; } $query = "SELECT * FROM apps"; $results = $db->query($query); $output = fopen('php://output', 'w'); while ($row = $results->fetchArray(SQLITE3_ASSOC)) { fputcsv($output, $row); echo "\n"; }
<?php class AppDB extends SQLite3 { function __construct() { $this->open('005.db'); } } $db = new AppDB(); if (!$db) { echo "Failed to open DB"; return; } function gvar($ar) { if (isset($_POST[$ar]) && $_POST[$ar] !== '') { return "'" . SQLite3::escapeString($_POST[$ar]) . "'"; } else { return 'NULL'; } } $uname = gvar('username'); $mail = gvar('email'); $st = gvar('state'); $cty = gvar('city'); $zp = gvar('zip'); $comment = gvar('comments'); $dt = gvar('date'); $query = "INSERT INTO apps (username,email,city,state,zip,comments,date) VALUES (" . $uname . "," . $mail . "," . $cty . "," . $st . "," . $zp . "," . $comment . "," . $dt . ");"; $results = $db->query($query);
<?php //Connects to the database //Load database config include APPLICATION_CONFDIR . 'db.conf.php'; //Verify database connectivity $DB = AppDB::GetInstance(); if (!$DB->ping()) { //Connection failure die("Database Error"); exit; }