sql_hostname();
$dbname = $config->sql_dbname();
$username = $config->sql_username();
$password = $config->sql_password();
$db = new PDO("mysql:host=$hostname;dbname=$dbname;charset=utf8", $username, $password ); //, array(PDO::ATTR_EMULATE_PREPARES => false, PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));
return $db;
}
public function insertRevision($pdo,$table,$array){
$stmt = $pdo->prepare("INSERT INTO $table (p_cookie,p_sessionid) VALUES (:p_cookie,:p_sessionid)");
if ($stmt->execute($array)){
// echo "Write Picture Success
";
return 1;
} else {
// echo "no successfully writing picture code to sql
";
// print_r($stmt->errorInfo());
return 0;
}
}
public function insertPicture($pdo,$table,$array){
$stmt = $pdo->prepare("INSERT INTO $table(p_title,p_filename,p_shortcode,p_uri,p_hash) VALUES(:p_title,:p_filename,:p_shortcode,:p_uri,:p_hash)");
if ($stmt->execute($array)){
// echo "Write Picture Success
";
return 1;
} else {
// echo "no successfully writing picture code to sql
";
// print_r($stmt->errorInfo());
return 0;
}
}
}
?>