require_once('Database.php'); $db = new Database($db_info); echo '<pre>'; $db->query(" SELECT * FROM md_languages"); print_r($db->assoc()); $db->free_result(); $db->query(" SELECT * FROM md_languages"); print_r($db->row()); $db->free_result(); $db->query(" SELECT * FROM md_languages"); print_r($db->row()); $db->free_result(); $db->query(" SELECT * FROM md_languages"); print_r($db->row()); $db->free_result(); $db->query("
$path = realpath(dirname()); require $path . "/database.class.php"; // Creates the instance $db = new Database(); // 3 ways to bind parameters : // 1. Read friendly method //$db->bind("firstname","John"); //$db->bind("age","19"); // 2. Bind more parameters //$db->bindMore(array("firstname"=>"John","age"=>"19")); // 3. Or just give the parameters to the method //$db->query("SELECT * FROM Persons WHERE firstname = :firstname AND age = :age", array("firstname"=>"John","age"=>"19")); // Fetching data //$person = $db->query("SELECT * FROM users"); $single = $db->row("SELECT firstname FROM users WHERE Id = :id ", array('id' => '2')); /* // If you want another fetchmode just give it as parameter $persons_num = $db->query("SELECT * FROM Persons", null, PDO::FETCH_NUM); // Fetching single value $firstname = $db->single("SELECT firstname FROM Persons WHERE Id = :id ", array('id' => '3' ) ); // Single Row $id_age = $db->row("SELECT Id, Age FROM Persons WHERE firstname = :f", array("f"=>"Zoe")); // Single Row with numeric index $id_age_num = $db->row("SELECT Id, Age FROM Persons WHERE firstname = :f", array("f"=>"Zoe"),PDO::FETCH_NUM); // Column, numeric index $ages = $db->column("SELECT age FROM Persons"); // The following statemens will return the affected rows // Update statement
} } } } $dir = dirname(__FILE__) . '/..'; require_once '../server/database/database.php'; require_once '../server/config.php'; $db = new Database($db_path); $id = $db->escape($_GET['id']); // If more than one id was passed, parse them out $shift_ids = array(); if (preg_match("/,/", $id)) { $shift_ids = split(',', $id); $id = $shift_ids[0]; } $shift = $db->row("\n SELECT *\n FROM shift\n WHERE url_slug = '{$id}'\n"); $myurl = $shift->href; $curl = curl_init(); curl_setopt($curl, CURLOPT_URL, $myurl); curl_setopt($curl, CURLOPT_FOLLOWLOCATION, 1); curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1); curl_setopt($curl, CURLOPT_COOKIE, 1); $useragent = "Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.0.1) Gecko/2008070206 Firefox/3.0.1"; curl_setopt($curl, CURLOPT_USERAGENT, $useragent); $result = curl_exec($curl); curl_close($curl); if (!$result) { $result = "Page not found."; echo "<p style=\"color:#DD6666;font-size:1em;font-family:Verdana,Helvetica,sans-serif;\">" . $result . "</p>"; exit; }
$db_filename = ''; if (preg_match('#sqlite://(.+)#', $db_path, $matches)) { list(, $db_filename) = $matches; } $db = new Database($db_path); if ($db->tables() == array()) { // Setup the initial database configuration $db->setup("{$dir}/server/init.sql"); $db->query("\n INSERT INTO user\n (username, status)\n VALUES ('shiftspace', 1)\n "); } // Set up the user session session_register('user'); $user = $_SESSION['user']; if (empty($user) && !empty($_COOKIE['auth'])) { list($username, $password) = explode(':', $_COOKIE['auth']); $user = $db->row("\n SELECT *\n FROM user\n WHERE username = '******'\n AND password = '******'\n "); if (!empty($user)) { $_SESSION['user'] = $user; } } if (!empty($_GET['v'])) { $client_version = $_GET['v']; } $server = 'http://' . $_SERVER['SERVER_NAME'] . dirname($_SERVER['PHP_SELF']) . '/'; if (get_magic_quotes_gpc()) { function strip_quotes(&$var) { if (is_array($var)) { array_walk($var, 'strip_quotes'); } else { $var = stripslashes($var);