Beiträge von palwal

<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);


class GeoApi
{
	private $db;

	private $get_plz = NULL;
	private $get_debug = NULL;
	private $get_city_id = NULL;

	private $city_id;
	private $state_id; //Bundesland
	private $county_id; //Kreis
	private $lat;
	private $lng;

	private $plz_exist;

	private $o_place;
	private $state;
	private $county;

	function __construct()
	{
		require_once 'system/classes/db.class.php';
		$this->db = new Database;


	}

	public function input ($get)
	{
		$this->get_plz = (isset($get['plz'])) ? $get['plz'] : NULL;
		$this->get_debug = (isset($get['debug'])) ? $get['debug'] : NULL;
		$this->get_city_id = (isset($get['city_id'])) ? $get['city_id'] : NULL;
		$this->_readCityByZip();
		$this->placeByCityId();
		$this->_readStateByPlace();
		$this->_readCountyByPlace(); // <== Das ist mein Problemkind!
		if($this->get_debug!=NULL) {
			if($this->get_plz!=NULL) {
				return $this->DebugPLZ();
			} elseif($this->get_city_id!=NULL) {
				return $this->DebugCity_id();
			}

		}elseif($this->get_plz!=NULL&&$this->plz_exist==FALSE) {
			$array = array("error" => "Die Postleitzahl $this->get_plz existiert nicht");
		} else {
			$array = array(
					"zipcode" => $this->get_plz,
					"place" => $this->o_place,
					"state" => $this->state,
					"county" => $this->county,
					"lat" => $this->lat,
					"lng" => $this->lng);
		}

		return json_encode($array);
	}

	function placeByCityId() 
	{
		try {
			$this->db->Query("SELECT * FROM `city` WHERE `id`=:id");
			$this->db->bind(':id', $this->city_id);
			$this->db->execute();
		} catch(PDOException $e) {
			die($e->getMessage());
		}

		$this->o_place = ($this->db->rowCount()==0) ? NULL : $this->db->fetch()->name;
		$this->state_id = ($this->db->rowCount()==0) ? NULL : $this->db->fetch()->state_id;
		$this->county_id = ($this->db->rowCount()==0) ? NULL : $this->db->fetch()->county_id;
		//$this->county_id ($this->db->rowCount()==0) ? NULL : $this->db->fetch()->county_id;
		//$this->lat ($this->db->rowCount()==0) ? NULL : $this->db->fetch()->lat;
		//$this->lng ($this->db->rowCount()==0) ? NULL : $this->db->fetch()->lng;
		//$this->state_id ($this->db->rowCount()==0) ? NULL : $this->db->fetch()->state_id;
	}

	function _readStateByPlace()
	{
		if($this->state_id==NULL) {
			return false;
		} else {
			try {
				$this->db->Query("SELECT * FROM `state` WHERE `id`=:state");
				$this->db->bind(':state', $this->state_id);
				$this->db->execute();
			} catch(PDOException $e) {
				die($e->getMessage());
			}

			$this->state = ($this->db->rowCount()==0) ? NULL : $this->db->fetch()->name;
		}
	}
	function _readCountyByPlace()
	{
		if($this->county_id==NULL) {
			return false;
		} else {
			try {
				$this->db->Query("SELECT * FROM `county` WHERE `id`=:county");
				$this->db->bind(':county', $this->county_id);
				$this->db->execute();

			}catch(PDOException $e) {
				die($e->getMessage());
			}

			//if($this->db->rowCount()==0) {die('failed');} else(die('okay'));
			$this->county = ($this->db->rowCount()==0) ? NULL : $this->db->fetch()->name;
		}
	}

	function _readCityByZip()
	{
		if($this->get_plz==NULL) {
			return false;
		} else {
			try {
				$this->db->Query("SELECT * FROM `zipcode` WHERE `zipcode`=:plz");
				$this->db->bind(':plz', $this->get_plz);
				$this->db->execute();
			}catch(PDOException $e) {
				die($e->getMessage());
			}

			$this->plz_exist = ($this->db->rowCount()==0) ? FALSE : TRUE;
			$this->city_id = ($this->db->rowCount()==0) ? 'NULL' : $this->db->fetch()->city_id;
		}
	}

	function DebugPLZ() 
	{
		if($this->get_plz=="") {
			$r = array("error" => "Keine Postleitzahl angegeben");
		} else {
			try 
			{
				$this->db->Query("SELECT * FROM `zipcode` WHERE `zipcode`=:plz");
				$this->db->bind(':plz', $this->get_plz);
				$this->db->execute();
				$r = $this->db->fetch(PDO::FETCH_ASSOC);
			} catch(PDOException $e) {
				$r = array("error" => $e->getMessage());
			}



		}
		return json_encode($r);
	}

	function DebugCity_id() 
	{
		if($this->get_city_id=="") {
			$r = array("error" => "Keine City_id angegeben");
		} else {
			try 
			{
				$this->db->Query("SELECT * FROM `city` WHERE `id`=:cityid");
				$this->db->bind(':cityid', $this->get_city_id);
				$this->db->execute();
				$r = ($this->db->rowCount()==0) ? array("error" => "Die City_id $this->get_city_id existiert nicht") : $this->db->fetch(PDO::FETCH_ASSOC);
			} catch(PDOException $e) {
				$r = array("error" => $e->getMessage());
			}



		}
		return json_encode($r);
	}
}


?>

<?php


class Ajax 
{
	public $db;

	function __construct() 
	{
		require_once 'db.class.php';
		$this->db = new Database;
	}
	//firma

	public function company($str) 
	{
		try
		{
			$this->db->Query("SELECT * FROM customers WHERE firma LIKE '%$str%'");
			$this->db->execute();
			if($this->db->rowCount()==0) {return 0;} else {

				$f = $this->db->fetchAll();
				$r = '';
				for($x=1;$x<$this->db->rowCount();$x++) {
					$r.= $f[$x]['firma'].'<br />';
				}


				return $r;
			}
		} catch(PDOException $e) {
			die($e->getMessage());
		}



	}


}
?>

function PostResponse()
	{
		global $_POST;
		if(isset($_POST['LoginResponse'])&&$_POST['LoginResponse']==1) {
			$uid = $this->session->AccountExist($_POST['nickname'], $_POST['password']);
			if($uid==false) {
				$this->page->Assign('response', 'login_not_found');
			} else {

				exit(var_dump($this->session->UserFetch(37)));

			}

		}
		return;
	}

<?php




class Database
{


	private $host 	= 'localhost';
	private $user = 'root';
	private $pass 	= '';
	private $dbname = 'palwal';
	private $synup;
	private $error;
	private $stmt;
	protected $dsn;

	public function viewDB()
	{
		return $this->dbname;
	}

	public function close()
	{
		$this->synup = NULL;
		return;
	}
	public function viewuser() {
		return $this->user;
	}

	public function __deconstruct()
	{
		$this->close();
	}


	

	public function __construct()
	{


		$this->dsn = 'mysql:host='.$this->host.';dbname='.$this->dbname;

		$optionen = array(
				\PDO::ATTR_PERSISTENT => false
				/*,
				\PDO::ATTR_ERRMODE => \PDO::ERRMODE_EXCEPTION*/);

		try{
			$this->synup = new \PDO($this->dsn, $this->user, $this->pass, $optionen);
			$this->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
			$this->setAttribute(\PDO::ATTR_EMULATE_PREPARES, false);
		} catch(\PDOException $e)
		{
			$this->error = $e->getMessage();
			die($e->getMessage());
		}

	}

	public function Query($sql)
	{
		$this->stmt = $this->synup->prepare($sql);
	}

	public function errorInfo()
	{
		$this->stmt = $this->synup->errorInfo();
	}

	public function errorCode()
	{
		$this->stmt = $this->synup->errorCode();
	}

	public function getAttribute($att)
	{
		$this->stmt = $this->synup->getAttribute($att);
	}

	public function setAttribute($att, $value)
	{
		$this->stmt = $this->synup->setAttribute($att, $value);
	}


	public function bind($param, $value, $type = NULL)
	{
		if(is_null($type))
		{
			switch(true)
			{
				case is_int($value):
					$type = \PDO::PARAM_INT;
					break;
				case is_null($value):
					$type = \PDO::PARAM_BOOL;
					break;
				default:
					$type = \PDO::PARAM_STR;
			}
		}

		$this->stmt->bindValue($param, $value, $type);
	}

	public function execute()
	{
		return $this->stmt->execute();
	}

	public function fetchAll()
	{
		return $this->stmt->fetchAll();	
	}

	public function debug()
	{
		return $this->stmt->debugDumpParams();
	}

	public function nextRowset()
	{
		return $this->stmt->nextRowset();
	}
	public function resultset()
	{
		$this->execute();
		return $this->stmt->fetchAll(\PDO::FETCH_ASSOC);
	}

	public function fetch($typ = \PDO::FETCH_OBJ)
	{
		$this->execute();
		return $this->stmt->fetch($typ);
	}

	public function rowCount()
	{
		return $this->stmt->rowCount();
	}

	public function lastInsertId()
	{
		return $this->synup->lastInsertId();
	}

	public function columnCount()
	{
		return $this->stmt->columnCount();
	}

	public function getColumnMeta($c = 0)
	{
		return $this->stmt->getColumnMeta($c);
	}

	public function beginTransaktion()
	{
		return $this->synup->beginTransaction();
	}

	public function commit()
	{
		return $this->synup->commit();
	}

	public function rollBack()
	{
		return $this->synup->rollBack();
	}

	/*public function debug()
	{
		return $this->stmt->debugDumpParams();
	}*/
}
?>