Subversion-Projekte lars-tiefland.em_wm

Revision

Revision 39 | Revision 90 | Zur aktuellen Revision | Details | Vergleich mit vorheriger | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
3 lars 1 
<?
2 
	class Ort
3 
	{
4 
		var $o_id;
5 
		var $o_name;
33 lars 6 
		var $o_name2;
3 lars 7 
 
8 
		function __construct($o_id)
9 
		{
10 
			global $db, $db_meld, $error, $meld;
11 
			$o_id=intval($o_id);
12 
			$sql="SELECT * FROM locations WHERE l_id=$o_id";
13 
			$res=$db->query($sql);
14 
			if (true == DB::isError($res))
15 
			{
16 
				$error="true";
17 
				$meld="Ein Fehler ist aufgetreten!";
18 
				$db_meld=$res->getUserInfo();
19 
				return $error;
20 
			}
21 
			else
22 
			{
52 lars 23 
				$row=$res->fetchRow();
3 lars 24 
				$this->o_id=$o_id;
25 
				$this->o_name=$row["l_name"];
33 lars 26 
				$this->o_name2=$row["l_name2"];
3 lars 27 
				return $this;
28 
			}
31 lars 29 
		}
5 lars 30 
 
31 
		function Ort($o_id)
32 
		{
33 
			$this->__construct($o_id);
34 
		}
31 lars 35 
 
33 lars 36 
		function update($l_name, $l_name2)
4 lars 37 
		{
31 lars 38 
			$this->l_name=$l_name;
33 lars 39 
			$this->l_name2=$l_name2;
31 lars 40 
		}
41 
 
42 
		function save($op)
43 
		{
44 
			global $db;
45 
			switch($op)
46 
			{
47 
				case "save":
33 lars 48 
					$sql="INSERT INTO locations (l_name, l_name2)
49 
						VALUES ('$this->o_name', '$this->o_name2)";
31 lars 50 
					break;
51 
				case "update":
39 lars 52 
					$sql="UPDATE locations SET l_name='$this->o_name', l_name2='$this->o_name2' WHERE l_id=$this->o_id";
31 lars 53 
					break;
54 
				case "del":
55 
					$sql="DELETE FROM locations WHERE l_id=$this->l_id";
56 
					break;
57 
			}
58 
			return $db->query($sql);
59 
		}
60 
 
61 
		function listeOrt($limit, $start=0)
62 
		{
4 lars 63 
			global $db, $db_meld, $error, $meld, $user;
64 
			$sql="SELECT * FROM locations";
65 
			if ($db->provides('limit') && $limit > 0)
66 
			{
67 
				$res=$db->limitquery($sql, $start, $limit);
68 
			}
69 
			else
70 
			{
71 
				$res=$db->query($sql);
72 
			}
73 
			if (true == DB::isError($res))
74 
			{
75 
				$error=true;
76 
				$meld="Ein Fehler ist aufgetreten!";
77 
				$db_meld=$res->getUserInfo();
78 
			}
79 
			return $res;
80 
		}
31 lars 81 
	}
3 lars 82 
?>