Subversion-Projekte lars-tiefland.em_wm

Revision

Revision 92 | Revision 114 | 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 
 
33 lars 31 
		function update($l_name, $l_name2)
4 lars 32 
		{
90 lars 33 
			$this->o_name=$l_name;
34 
			$this->o_name2=$l_name2;
31 lars 35 
		}
36 
 
37 
		function save($op)
38 
		{
39 
			global $db;
40 
			switch($op)
41 
			{
42 
				case "save":
33 lars 43 
					$sql="INSERT INTO locations (l_name, l_name2)
111 lars 44 
						VALUES ('$this->o_name', '$this->o_name2')";
31 lars 45 
					break;
46 
				case "update":
39 lars 47 
					$sql="UPDATE locations SET l_name='$this->o_name', l_name2='$this->o_name2' WHERE l_id=$this->o_id";
31 lars 48 
					break;
49 
				case "del":
90 lars 50 
					$sql="DELETE FROM locations WHERE l_id=$this->o_id";
31 lars 51 
					break;
52 
			}
53 
			return $db->query($sql);
54 
		}
55 
 
56 
		function listeOrt($limit, $start=0)
57 
		{
4 lars 58 
			global $db, $db_meld, $error, $meld, $user;
59 
			$sql="SELECT * FROM locations";
60 
			if ($db->provides('limit') && $limit > 0)
61 
			{
62 
				$res=$db->limitquery($sql, $start, $limit);
63 
			}
64 
			else
65 
			{
66 
				$res=$db->query($sql);
67 
			}
68 
			if (true == DB::isError($res))
69 
			{
70 
				$error=true;
71 
				$meld="Ein Fehler ist aufgetreten!";
72 
				$db_meld=$res->getUserInfo();
73 
			}
74 
			return $res;
75 
		}
31 lars 76 
	}
3 lars 77 
?>