<?php

require_once ("Config.inc.php");

class Connection {
	
	public function prepareQuery() {
		
		$config 		= new Config();
		
		$hostname		= $config->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::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8") ); //, 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<br>";
			return 1;
		} else {
		//	echo "no successfully writing picture code to sql<br>";
		//	print_r($stmt->errorInfo());
			return 0;
		}		
	}
	
	public function insertArticle($pdo,$table,$array){
		
		$stmt = $pdo->prepare("INSERT INTO $table(p_headline,p_category,p_tags,p_articletext,p_sourcelink,p_picture1,p_picture2,p_picture3,p_hashtag,p_videolink,p_twitterlink,p_backlink,p_paypallink,p_authorname,p_shortcode,p_picture_1_description,p_language) VALUES(:headline,:category,:tags,:articletext,:sourcelink,:picture1,:picture2,:picture3,:hashtag,:videolink,:twitterlink,:backlink,:paypallink,:authorname,:shortcode,:picture_1_description,:language)");
		if ($stmt->execute($array)){
			//echo "Write Article Success<br>";
			return 1;
		} else {
			echo "Artikel wurde nicht gespeichert: Folgende Fehlermeldung passierte: <br>";
			$stmt->debugDumpParams();
			var_dump($stmt->errorInfo());
			var_dump($stmt->errorCode());
			return 0; //($stmt->errorInfo());
		}
		//print_r($stmt->errorInfo());
		
	}
	
	public function insertAdvArticle($pdo,$table,$array){
		
		$stmt = $pdo->prepare("INSERT INTO $table(p_headline,p_category,p_tags,p_articletext,p_sourcelink,p_picture1,p_picture2,p_picture3,p_hashtag,p_videolink,p_twitterlink,p_backlink,p_paypallink,p_authorname,p_shortcode,p_picture_1_description,p_language,p_picture1_copyrightholder,p_picture1_copyrightlicense,p_picture1_copyrightoriginal) VALUES(:headline,:category,:tags,:articletext,:sourcelink,:picture1,:picture2,:picture3,:hashtag,:videolink,:twitterlink,:backlink,:paypallink,:authorname,:shortcode,:picture_1_description,:language,:picture1_copyrightholder,:picture1_copyrightlicense,:picture1_copyrightoriginal)");
		if ($stmt->execute($array)){
			//echo "Write Article Success<br>";
			return 1;
		} else {
			echo "Artikel wurde nicht gespeichert: Folgende Fehlermeldung passierte: <br>";
			$stmt->debugDumpParams();
			var_dump($stmt->errorInfo());
			var_dump($stmt->errorCode());
			return 0; //($stmt->errorInfo());
		}
		//print_r($stmt->errorInfo());
		
	}
	
	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<br>";
			return 1;
		} else {
		//	echo "no successfully writing picture code to sql<br>";
		//	print_r($stmt->errorInfo());
			return 0;
		}		
	}
	
}
?>