Subversion-Projekte lars-tiefland.ci

<?php

class Directory_model extends CI_Model

{

	public function get_list($dir=-1)

	{

		$sql="SELECT

				*

			FROM

				directory

			WHERE

				father=".$dir."

			ORDER BY

				kennung

		";

		$res = $this->db->query($sql);

		$dirs = $res->result_array();

		return $dirs;

	}

	public function get($id)

	{

		$sql = "SELECT

				*

			FROM

				directory

			WHERE

				id=".$id."

		";

		$res = $this->db->query($sql);

		$row = $res->unbuffered_row('array');

		$sql = "SELECT

				meta_content,

				meta_type

			FROM

				metatags

			WHERE

				table_foreign='directory'

			AND

				data_foreign=".$id."

		";

		$res = $this->db->query($sql);

		while ($metaRow = $res->unbuffered_row('array'))

		{

			$row[$metaRow["meta_type"]] = $metaRow["meta_content"];

		}

		return $row;

	}

}