Subversion-Projekte lars-tiefland.ci

<?php

/**
 *
 * @package WebanOS CI
 * @author Lars Tiefland <ltiefland@gmail.com> 
 * @copyright 2016
 * @version $Rev: 1143 $
 */

class Bestelladresse_model extends CI_Model
{
        public function __construct()
        {
                parent::__construct();
        }

        public function get($id)
        {
                $adresse = array();
                $sql = "SELECT
                                vorname,
                                nachname,
                                firma,
                                strasse1,
                                str_nr1,
                                plz,
                                ort,
                                co.`name-ger` AS land
                        FROM
                                bestelladresse ba
                        JOIN
                                content_management.countries co
                        ON
                                co.id=ba.land
                        WHERE
                                ba.id = ".$id."
                ";
                $res = $GLOBALS['order_db']->query($sql);
                $adresse = $res->row_array();
                return $adresse;
        }

}

?>