Daten aus Blob-Feld in mysql-DB auslesen

<?php




      




      include_once("code-connection.php");




       




      $sql = "SELECT * FROM FD_Articles ORDER BY id DESC";




       




      $ergebnis =    mysql_query($sql) or die("SQL Error: ".mysql_error());




      $anz_ds =    mysql_num_rows($ergebnis);




       




      for ($ii = 0 ; $ii < $anz_ds ; $ii++)




      {




       




      $id = mysql_result($ergebnis,$ii,"id");




      $data = mysql_result($ergebnis,$ii,"data");




      




      




      $message = unserialize($data);




       




      foreach($message as $key => $elem){




      echo $elem."<br />";




      




      //var_dump(unserialize($data));

/**
  	* @description		fetch message image
  	* @param Storage $dbh	valid Storage instance
  	*/
 	static private function fetchMesgImage(Storage $dbh) {
	$tid = (isset($_GET["tid"])) ? intval($_GET["tid"]) : null;
	if(!isset($_SESSION['Admin']) && !isset($_SESSION['User'])) {
	 	print -1;
	 	exit(1);
	}
	else if($tid === null) {
		print -2;
		exit(1);
	}




	$ret = $dbh->query('get_article_by_id', array($tid));
	if(isset($_SESSION['User']) && $ret['login'] !== $_SESSION['User']->Login) {
		print -1;
		exit(1);
	}




	$o = unserialize($ret['data']);
	// Note: format can change if we need multiple images!
	$image = $o->Images;
	$image['type'] = image_type_to_mime_type($image['type']);
	$image['data'] = base64_encode($image['data']);
	print json_encode($image);
 	}




 	/**
  	* @description		store message image
  	* @param Storage $dbh valid Storage instance
  	* @notice	function outputs -3 on ExceedSizeException
  	*/
 	static private function storeMesgImage(Storage $dbh) {
	 $tid = (isset($_GET["tid"])) ? intval($_GET["tid"]) : null;
	 if(!isset($_SESSION['Admin']) && !isset($_SESSION['User'])) {
	 	print -1;
	 	exit(1);
	 }
	 else if($tid === null) {
	 	print -2;
	 	exit(1);
	 }




	 $ret = $dbh->query('get_article_by_id', array($tid));
	 if(isset($_SESSION['User']) && $ret['login'] !== $_SESSION['User']->Login) {
	 	print -1;
	 	exit(1);
	 }




	 try {
		$o = unserialize($ret['data']);
		$image = Render::getUploadedImage(Web::$Cimgtypes, Web::MaxFileSiz, 'entryimg');
		if($image === null) {
		print -1;
		exit(1);
		}
	 }
	 catch(ExceedSizeException $e) {
	 	print -3;
	 	exit(1);
	 }




	 $o->Images = $image;
	 print ($dbh->store($o, $tid)) ? $tid : -1;
 	}




 	/**
  	* @description		remove message image
  	* @param Storage $dbh valid Storage instance
  	*/
 	static private function delMesgImage(Storage $dbh) {
	 $tid = (isset($_GET["tid"])) ? intval($_GET["tid"]) : null;
	 if(!isset($_SESSION['Admin']) && !isset($_SESSION['User'])) {
	 	print -1;
	 	exit(1);
	 }
	 else if($tid === null) {
	 	print -2;
	 	exit(1);
	 }




	 $ret = $dbh->query('get_article_by_id', array($tid));
	 if(isset($_SESSION['User']) && $ret['login'] !== $_SESSION['User']->Login) {
	 	print -1;
	 	exit(1);
	 }




	 $o = unserialize($ret['data']);
	 $o->Images = null;
	 print $dbh->store($o, $tid);
 	}