WebSVN – lars-tiefland.em_wm – Diff – /trunk/include/orte.php

 				$row=$res->fetchRow(DB_FETCHMODE_ASSOC);
 				$this->o_id=$o_id;
 				$this->o_name=$row["l_name"];
 				return $this;
+			}
-  		}
+		}
 		function Ort($o_id)
+		{
 			$this->__construct($o_id);
 		}
+		function update($l_name)
+		{
+			$this->l_name=$l_name;
+		}
+		function save($op)
+		{
+			global $db;
+			switch($op)
+			{
+				case "save":
+					$sql="INSERT INTO locations (l_name)
+						VALUES ('$this->l_name')";
+					break;
+				case "update":
+					$sql="UPDATE locations SET l_name='$this->l_name' WHERE l_id=$this->l_id";
+					break;
+				case "del":
+					$sql="DELETE FROM locations WHERE l_id=$this->l_id";
+					break;
+			}
+			return $db->query($sql);
+		}
-  		function listeOrt($limit, $start=0)
+		function listeOrt($limit, $start=0)
+		{
 			global $db, $db_meld, $error, $meld, $user;
-			$sql="SELECT * FROM locations";
-//			echo $db->provides('limit');
+			$sql="SELECT * FROM locations";
 			if ($db->provides('limit') && $limit > 0)
+			{
 				$res=$db->limitquery($sql, $start, $limit);
+			}
 				$meld="Ein Fehler ist aufgetreten!";
 				$db_meld=$res->getUserInfo();
+			}
 			return $res;
+		}
- 	}
+	}
 ?>

Subversion-Projekte lars-tiefland.em_wm