rpicms

commit 2b39839d9324d4d3ab289caa4ced31fe233a09ad
parent 947a9887f24402898f97c3faebcb54a0e9d075e4
Author: MTRNord <mtrnord1@gmail.com>
Date:   Sat, 16 May 2015 17:02:38 +0200

reset posts.php and start rebuild of it in posts2.php

Diffstat:
M
core/backend/blog/posts.php
 | 
131
++++++++++++++++++++++++++++++++++++++++++-------------------------------------
A
core/backend/blog/posts2.php
 | 
180
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

2 files changed, 249 insertions(+), 62 deletions(-)
diff --git a/core/backend/blog/posts.php b/core/backend/blog/posts.php
@@ -19,30 +19,32 @@ if ($root_3[1] == 'core') {
 }else{
   $root = $root_1 . '/' . $root_3[1];
 }
+	include($root . '/core/config/connect.db.inc.php');
 	//Check if Database connection established
 	if (mysqli_connect_errno()) {
 		printf("Verbindung fehlgeschlagen: %s\n", mysqli_connect_error());
 		exit();
 	}
-
-  if ($resultat = $connection->query('SELECT id FROM posts')) {
-    while($daten = $resultat->fetch_object() ){
-      $post_id_clean = $daten->id;
-    }
-    $resultat->close();
-  }
-  if ($resultat = $connection->query("SELECT id FROM posts WHERE category LIKE '$category'")) {
-    while($daten = $resultat->fetch_object() ){
-      $category_id_clean = $daten->id;
-    }
-    $resultat->close();
-  }
-  if ($resultat = $connection->query("SELECT id FROM posts WHERE author LIKE '$author'")) {
-    while($daten = $resultat->fetch_object() ){
-      $author_id_clean = $daten->id;
-    }
-    $resultat->close();
-  }
+		if ($resultat = $connection->query('SELECT id FROM posts')) {
+			while($daten = $resultat->fetch_object() ){
+ 				$post_id_clean = $daten->id;
+ 				#var_dump($daten);
+			}
+  			#$resultat->close();
+		}
+		if ($resultat = $connection->query("SELECT id FROM posts WHERE category LIKE '$category'")) {
+			while($daten = $resultat->fetch_object() ){
+ 				$category_id_clean = $daten->id;
+ 				#var_dump($daten);
+			}
+  			#$resultat->close();
+		}
+		if ($resultat = $connection->query("SELECT id FROM posts WHERE author LIKE '$author'")) {
+			while($daten = $resultat->fetch_object() ){
+ 				$author_id_clean = $daten->id;
+ 				#var_dump($daten);
+			}
+		}
 	next_id_only();
 	next_id_category();
 	next_id_author();
@@ -59,8 +61,10 @@ if ($root_3[1] == 'core') {
 		global $id, $connection, $read, $post_id_clean;
 		global $post_id, $post_title, $post_text, $post_author, $post_date, $post_category, $post_text_short;
 		if ($resultat = $connection->query("SELECT id,title,text,author,category,date FROM posts WHERE id LIKE '$id'")) {
+			//echo 'SELECT * FROM posts WHERE id LIKE '.$id;
 			//Put database data in variables
  			while($daten = $resultat->fetch_object() ){
+ 				//var_dump ($daten);
  			 	$post_id = $daten->id;
 				$post_title = $daten->title;
 				$post_text = $daten->text;
@@ -69,21 +73,21 @@ if ($root_3[1] == 'core') {
 				$post_category = $daten->category;
 				$post_text_short = shortText($post_text,300);
 			}
+  			$resultat->close();
 		} else {
 			global $id, $connection, $read, $post_id_clean;
 			global $post_id, $post_title, $post_text, $post_author, $post_date, $post_category;
-      global $error;
-      $error = "1";
-      echo "Nothing to read from Database!";
-      $post_id = "Database error!";
-      $post_title = "Database error!";
-      $post_text = "Database error!";
-      $post_author = "Database error!";
-      $post_date = "Database error!";
-      $post_category = "Database error!";
-      $post_text_short =  "Database error!";
+  					global $error;
+  					$error = "1";
+  					echo "Nothing to read from Database!";
+  					$post_id = "Database error!";
+					$post_title = "Database error!";
+					$post_text = "Database error!";
+					$post_author = "Database error!";
+					$post_date = "Database error!";
+					$post_category = "Database error!";
+					$post_text_short =  "Database error!";
 		}
-
 	}
 
 
@@ -91,8 +95,10 @@ if ($root_3[1] == 'core') {
 		global $id, $category, $connection, $read, $category_id_clean;
 		global $post_id, $post_title, $post_text, $post_author, $post_date, $post_category, $post_text_short;
 		if ($resultat = $connection->query("SELECT id,title,text,author,category,date FROM posts WHERE category LIKE '$category' AND id LIKE '$id'")) {
+			//echo 'SELECT * FROM posts WHERE id LIKE '.$id;
 			//Put database data in variables
  			while($daten = $resultat->fetch_object() ){
+ 				//var_dump ($daten);
  			 	$post_id = $daten->id;
 				$post_title = $daten->title;
 				$post_text = $daten->text;
@@ -101,29 +107,31 @@ if ($root_3[1] == 'core') {
 				$post_category = $daten->category;
 				$post_text_short = shortText($post_text,300);
 			}
+  			$resultat->close();
 		} else {
 			global $id, $category, $connection, $read, $category_id_clean;
 			global $post_id, $post_title, $post_text, $post_author, $post_date, $post_category;
-      global $error;
-      $error = "1";
-      echo "Nothing to read from Database!";
-      $post_id = "Database error!";
-      $post_title = "Database error!";
-      $post_text = "Database error!";
-      $post_author = "Database error!";
-      $post_date = "Database error!";
-      $post_category = "Database error!";
-      $post_text_short =  "Database error!";
+  					global $error;
+  					$error = "1";
+  					echo "Nothing to read from Database!";
+  					$post_id = "Database error!";
+					$post_title = "Database error!";
+					$post_text = "Database error!";
+					$post_author = "Database error!";
+					$post_date = "Database error!";
+					$post_category = "Database error!";
+					$post_text_short =  "Database error!";
 		}
-    $resultat->close();
 	}
 
 function read_author(){
 		global $id, $author, $connection, $read, $author_id_clean;
 		global $post_id, $post_title, $post_text, $post_author, $post_date, $post_category, $post_text_short;
 		if ($resultat = $connection->query("SELECT id,title,text,author,category,date FROM posts WHERE author LIKE '$author' AND id LIKE '$id'")) {
+			//echo 'SELECT * FROM posts WHERE id LIKE '.$id;
 			//Put database data in variables
  			while($daten = $resultat->fetch_object() ){
+ 				//var_dump ($daten);
  			 	$post_id = $daten->id;
 				$post_title = $daten->title;
 				$post_text = $daten->text;
@@ -132,21 +140,21 @@ function read_author(){
 				$post_category = $daten->category;
 				$post_text_short = shortText($post_text,300);
 			}
+  			$resultat->close();
 		} else {
 			global $id, $author, $connection, $read, $author_id_clean;
 			global $post_id, $post_title, $post_text, $post_author, $post_date, $post_category;
-      global $error;
-      $error = "1";
-      echo "Nothing to read from Database!";
-      $post_id = "Database error!";
-      $post_title = "Database error!";
-      $post_text = "Database error!";
-      $post_author = "Database error!";
-      $post_date = "Database error!";
-      $post_category = "Database error!";
-      $post_text_short =  "Database error!";
+  					global $error;
+  					$error = "1";
+  					echo "Nothing to read from Database!";
+  					$post_id = "Database error!";
+					$post_title = "Database error!";
+					$post_text = "Database error!";
+					$post_author = "Database error!";
+					$post_date = "Database error!";
+					$post_category = "Database error!";
+					$post_text_short =  "Database error!";
 		}
-    $resultat->close();
 	}
 
 
@@ -159,15 +167,14 @@ function shortText($string,$lenght) {
     }
     return $string;
 }
-function deletePost($id) {
-  global $connection;
-  echo "ID: $id";
-  $sql = "DELETE FROM posts WHERE id='$id'";
-  if (mysqli_query($connection, $sql)) {
-    echo "Record deleted successfully";
-  } else {
-    echo "Error deleting record: " . mysqli_error($connection);
-  }
-}
+//$longtext = $post_text;
+
+
+
+
+
+
+
+
 // Close database connection
 $connection->close();
diff --git a/core/backend/blog/posts2.php b/core/backend/blog/posts2.php
@@ -0,0 +1,180 @@
+<?php
+/**
+* Get posts from Database
+*
+* This script will the post variables with the database data.
+*
+* @author	Marcel Radzio <info@nordgedanken.de>
+* @version	1.0dev 1/12/2014 17:16
+*/
+###############################
+# include files from root dir #
+###############################
+$root_1 = realpath($_SERVER["DOCUMENT_ROOT"]);
+$currentdir = getcwd();
+$root_2 = str_replace($root_1, '', $currentdir);
+$root_3 = explode("/", $root_2);
+if ($root_3[1] == 'core') {
+  $root = realpath($_SERVER["DOCUMENT_ROOT"]);
+}else{
+  $root = $root_1 . '/' . $root_3[1];
+}
+	include($root . '/core/config/connect.db.inc.php');
+	//Check if Database connection established
+	if (mysqli_connect_errno()) {
+		printf("Verbindung fehlgeschlagen: %s\n", mysqli_connect_error());
+		exit();
+	}
+		if ($resultat = $connection->query('SELECT id FROM posts')) {
+			while($daten = $resultat->fetch_object() ){
+ 				$post_id_clean = $daten->id;
+ 				#var_dump($daten);
+			}
+  			#$resultat->close();
+		}
+		if ($resultat = $connection->query("SELECT id FROM posts WHERE category LIKE '$category'")) {
+			while($daten = $resultat->fetch_object() ){
+ 				$category_id_clean = $daten->id;
+ 				#var_dump($daten);
+			}
+  			#$resultat->close();
+		}
+		if ($resultat = $connection->query("SELECT id FROM posts WHERE author LIKE '$author'")) {
+			while($daten = $resultat->fetch_object() ){
+ 				$author_id_clean = $daten->id;
+ 				#var_dump($daten);
+			}
+		}
+	next_id_only();
+	next_id_category();
+	next_id_author();
+	function next_id_category(){
+		read_category();
+	}
+	function next_id_author(){
+		read_author();
+	}
+	function next_id_only(){
+		read_only();
+	}
+	function read_only(){
+		global $id, $connection, $read, $post_id_clean;
+		global $post_id, $post_title, $post_text, $post_author, $post_date, $post_category, $post_text_short;
+		if ($resultat = $connection->query("SELECT id,title,text,author,category,date FROM posts WHERE id LIKE '$id'")) {
+			//echo 'SELECT * FROM posts WHERE id LIKE '.$id;
+			//Put database data in variables
+ 			while($daten = $resultat->fetch_object() ){
+ 				//var_dump ($daten);
+ 			 	$post_id = $daten->id;
+				$post_title = $daten->title;
+				$post_text = $daten->text;
+				$post_author = $daten->author;
+				$post_date = $daten->date;
+				$post_category = $daten->category;
+				$post_text_short = shortText($post_text,300);
+			}
+  			$resultat->close();
+		} else {
+			global $id, $connection, $read, $post_id_clean;
+			global $post_id, $post_title, $post_text, $post_author, $post_date, $post_category;
+  					global $error;
+  					$error = "1";
+  					echo "Nothing to read from Database!";
+  					$post_id = "Database error!";
+					$post_title = "Database error!";
+					$post_text = "Database error!";
+					$post_author = "Database error!";
+					$post_date = "Database error!";
+					$post_category = "Database error!";
+					$post_text_short =  "Database error!";
+		}
+	}
+
+
+	function read_category(){
+		global $id, $category, $connection, $read, $category_id_clean;
+		global $post_id, $post_title, $post_text, $post_author, $post_date, $post_category, $post_text_short;
+		if ($resultat = $connection->query("SELECT id,title,text,author,category,date FROM posts WHERE category LIKE '$category' AND id LIKE '$id'")) {
+			//echo 'SELECT * FROM posts WHERE id LIKE '.$id;
+			//Put database data in variables
+ 			while($daten = $resultat->fetch_object() ){
+ 				//var_dump ($daten);
+ 			 	$post_id = $daten->id;
+				$post_title = $daten->title;
+				$post_text = $daten->text;
+				$post_author = $daten->author;
+				$post_date = $daten->date;
+				$post_category = $daten->category;
+				$post_text_short = shortText($post_text,300);
+			}
+  			$resultat->close();
+		} else {
+			global $id, $category, $connection, $read, $category_id_clean;
+			global $post_id, $post_title, $post_text, $post_author, $post_date, $post_category;
+  					global $error;
+  					$error = "1";
+  					echo "Nothing to read from Database!";
+  					$post_id = "Database error!";
+					$post_title = "Database error!";
+					$post_text = "Database error!";
+					$post_author = "Database error!";
+					$post_date = "Database error!";
+					$post_category = "Database error!";
+					$post_text_short =  "Database error!";
+		}
+	}
+
+function read_author(){
+		global $id, $author, $connection, $read, $author_id_clean;
+		global $post_id, $post_title, $post_text, $post_author, $post_date, $post_category, $post_text_short;
+		if ($resultat = $connection->query("SELECT id,title,text,author,category,date FROM posts WHERE author LIKE '$author' AND id LIKE '$id'")) {
+			//echo 'SELECT * FROM posts WHERE id LIKE '.$id;
+			//Put database data in variables
+ 			while($daten = $resultat->fetch_object() ){
+ 				//var_dump ($daten);
+ 			 	$post_id = $daten->id;
+				$post_title = $daten->title;
+				$post_text = $daten->text;
+				$post_author = $daten->author;
+				$post_date = $daten->date;
+				$post_category = $daten->category;
+				$post_text_short = shortText($post_text,300);
+			}
+  			$resultat->close();
+		} else {
+			global $id, $author, $connection, $read, $author_id_clean;
+			global $post_id, $post_title, $post_text, $post_author, $post_date, $post_category;
+  					global $error;
+  					$error = "1";
+  					echo "Nothing to read from Database!";
+  					$post_id = "Database error!";
+					$post_title = "Database error!";
+					$post_text = "Database error!";
+					$post_author = "Database error!";
+					$post_date = "Database error!";
+					$post_category = "Database error!";
+					$post_text_short =  "Database error!";
+		}
+	}
+
+
+
+function shortText($string,$lenght) {
+    if(strlen($string) > $lenght) {
+        $string = substr($string,0,$lenght)."[...]";
+        $string_ende = strrchr($string, " ");
+        $string = str_replace($string_ende," [...]", $string);
+    }
+    return $string;
+}
+//$longtext = $post_text;
+
+
+
+
+
+
+
+
+// Close database connection
+$connection->close();