Subversion-Projekte lars-tiefland.ci

Revision

Revision 1578 | Revision 1672 | Zur aktuellen Revision | Ganze Datei anzeigen | Leerzeichen ignorieren | Details | Blame | Letzte Änderung | Log anzeigen | RSS feed

Revision 1578 Revision 1619
Zeile 1... Zeile 1...
1 
<?php
 1 
<?php
Zeile 2... Zeile 2...
2 
 
 2 
 
3 
class Artikel_model extends CI_Model
 3 
class Artikel_model extends CI_Model
4 
{
 4 
{
5 
	public function get_list($dir=-1)
 5 
	public function get_list($dir = -1)
6 
	{
 6 
	{
7 
		$sql="SELECT
 7 
		$sql = "SELECT
8 
				*
 8 
				*
9 
			FROM
 9 
			FROM
10 
				artikel
 10 
				artikel
11 
			WHERE
 11 
			WHERE
Zeile 15... Zeile 15...
15 
		";
 15 
		";
16 
		$res = $this->db->query($sql);
 16 
		$res = $this->db->query($sql);
17 
		$items = $res->result_array();
 17 
		$items = $res->result_array();
18 
		return $items;
 18 
		return $items;
19 
	}
 19 
	}
20
20 
 
21 
	public function get($id)
 21 
	public function get($id)
22 
	{
 22 
	{
23 
		$sql="SELECT
 23 
		$sql = "SELECT
24 
				*
 24 
				*
25 
			FROM
 25 
			FROM
26 
				artikel
 26 
				artikel
27 
			WHERE
 27 
			WHERE
28 
				id=".$id."
 28 
				id=".$id."
29 
		";
 29 
		";
30 
		$res = $this->db->query($sql);
 30 
		$res = $this->db->query($sql);
31 
		$row = $res->unbuffered_row('array');
 31 
		$row = $res->unbuffered_row('array');
- 
 
 32 
		$sql = "SELECT
- 
 
 33 
				meta_content,
- 
 
 34 
				meta_type
- 
 
 35 
			FROM
- 
 
 36 
				metatags
- 
 
 37 
			WHERE
- 
 
 38 
				table_foreign='artikel'
- 
 
 39 
			AND
- 
 
 40 
				data_foreign=".$id."
- 
 
 41 
		";
- 
 
 42 
		$res = $this->db->query($sql);
- 
 
 43 
		while ($metaRow = $res->unbuffered_row('array'))
- 
 
 44 
		{
- 
 
 45 
			$row[$metaRow["meta_type"]] = $metaRow["meta_content"];
- 
 
 46 
		}
32 
		return $row;
 47 
		return $row;
33 
	}
 48 
	}
34 
}
 49 
}