public function index()
    {
		if (!$this->ion_auth->logged_in())
		{
			// redirect them to the login page
			redirect('auth/login', 'refresh');
		}
		header("Access-Control-Allow-Origin: *");
        $data = array();
		$chauffeur = 'Mick';


		$data['data']=$this->Data_mdl->get_results($chauffeur);
		$data['chauffeurs']=$this->Data_mdl->get_chauffeurs();
		$this->template->set('webtitle', 'Lortyé Dagrapport');
		$this->template->set('img', '<img src="'. base_url().'/assets/img/logo.png" alt="Lortye" title="Lortye" width="90" height="50" style="margin-top: -15px;">');
        $this->template->set('title', 'Dagrapport');
		$data['title']='Dagrapport';
        $this->template->load('default_layout', 'contents' , 'home', $data);
    }

script type="text/print" id="print_output"><?php echo $this->config->item('company'); ?>




<?php echo $this->Location->get_info_for_key('address',isset($override_location_id) ? $override_location_id : FALSE); ?>


<?php echo $this->Location->get_info_for_key('phone',isset($override_location_id) ? $override_location_id : FALSE); ?>


<?php if($this->config->item('website')) { ?>
<?php echo $this->config->item('website'); ?>
<?php } ?>




<?php echo $receipt_title; ?>




<?php echo $transaction_time; ?>


<?php if(isset($customer))
{
?>
<?php echo lang('common_customer').": ".$customer; ?>


<?php if(!empty($customer_address_1)){ ?><?php echo lang('common_address'); ?>: <?php echo $customer_address_1. ' '.$customer_address_2; ?>
<?php } ?>
<?php if (!empty($customer_city)) { echo $customer_city.' '.$customer_state.', '.$customer_zip; ?>


<?php } ?>
<?php if (!empty($customer_country)) { echo $customer_country; ?>
<?php } ?>
<?php if(!empty($customer_phone)){ ?><?php echo lang('common_phone_number'); ?> : <?php echo $customer_phone; ?>
<?php } ?>
<?php if(!empty($customer_email)){ ?><?php echo lang('common_email'); ?> : <?php echo $customer_email; ?><?php } ?>


<?php
}
?>
<?php echo lang('sales_id').": ".$sale_id; ?>


<?php if (isset($sale_type)) { ?>
<?php echo $sale_type; ?>
<?php } ?>


<?php echo lang('common_employee').": ".$employee; ?>


<?php 
if($this->Location->get_info_for_key('enable_credit_card_processing',isset($override_location_id) ? $override_location_id : FALSE))
{
	echo lang('common_merchant_id').': '.$this->Location->get_merchant_id(isset($override_location_id) ? $override_location_id : FALSE);
}
?>


<?php echo lang('common_item');?>                 <?php echo lang('common_price'); ?>   <?php echo lang('common_quantity'); ?><?php if($discount_exists){echo ' '.lang('common_discount_percent');}?>   <?php echo lang('common_total'); ?>


------------------------------------------------------------
<?php
foreach(array_reverse($cart, true) as $line=>$item)
{
?>
<?php echo character_limiter($item['name'], 14,'...'); ?><?php echo strlen($item['name']) < 14 ? str_repeat(' ', 14 - strlen($item['name'])) : ''; ?>    <?php echo str_replace('<span style="white-space:nowrap;">-</span>', '-', to_currency($item['price'])); ?>      <?php echo to_quantity($item['quantity']); ?><?php if($discount_exists){echo ' '.$item['discount'];}?>         <?php echo str_replace('<span style="white-space:nowrap;">-</span>', '-', to_currency($item['price']*$item['quantity']-$item['price']*$item['quantity']*$item['discount']/100)); ?>


  <?php echo $item['description']; ?>  <?php echo isset($item['serialnumber']) ? $item['serialnumber'] : ''; ?>


<?php
}
?>

<?php echo lang('common_item');?>                 <?php echo lang('common_price'); ?>   <?php echo lang('common_quantity'); ?><?php if($discount_exists){echo ' '.lang('common_discount_percent');}?>   <?php echo lang('common_total'); ?>


------------------------------------------------------------
<?php
foreach(array_reverse($cart, true) as $line=>$item)
{
?>
<?php echo character_limiter($item['name'], 14,'...'); ?><?php echo strlen($item['name']) < 14 ? str_repeat(' ', 14 - strlen($item['name'])) : ''; ?>    <?php echo str_replace('<span style="white-space:nowrap;">-</span>', '-', to_currency($item['price'])); ?>      <?php echo to_quantity($item['quantity']); ?><?php if($discount_exists){echo ' '.$item['discount'];}?>         <?php echo str_replace('<span style="white-space:nowrap;">-</span>', '-', to_currency($item['price']*$item['quantity']-$item['price']*$item['quantity']*$item['discount']/100)); ?>


  <?php echo $item['description']; ?>  <?php echo isset($item['serialnumber']) ? $item['serialnumber'] : ''; ?>


<?php
}
?>

<?php
defined('BASEPATH') OR exit('No direct script access allowed');


class Webshop extends CI_Controller 
{
	function __Construct()
	{
		parent::__Construct ();
		$this->load->database(); // load database
		$this->load->model('Webshop_Model'); // load model
	}


public function products()
{
    $this->data['webshop'] = $this->Webshop_Model->getProducts();
    $this->load->helper('url');
    $this->load->view('template/header');
    $this->load->view('template/slider');
    $this->load->view('template/menu');
    $this->load->view('webshop/products', $this->data);
    $this->load->view('template/footer');
}


}

<?php
class Webshop_Model extends CI_Model 
{
	function getProducts()
	{
		$this->db->select('*');
		$this->db->from('webshop');
		$this->db->where('category_id', $_GET['category']);
		$this->db->limit(10);
		$query = $this->db->get();
		return $query->result();
	}

<?php foreach($webshop as $item)
							{
								echo'
								<div class="col-md-3 col-sm-6 hero-feature">
									<div class="thumbnail">
										<img src="'.base_url("assets/images/webshop/".$item->image_url."").'" alt="'.$item->title.'" title="'.$item->title.'">
										<div class="caption">
											<h3>'.$item->title.'</h3>
											<p>'.$item->discription.'</p>
											<p><b>&euro; '.$item->price.'</b></p>
											<p>
												<a href="#" class="btn btn-success">Toevoegen</a> <a href="view?id='.$item->id.'" class="btn btn-info">Lees meer</a>
											</p>
										</div>
									</div>
								</div>';
							} 
							?>

--
-- Tabelstructuur voor tabel `TABELNAAM`
--


CREATE TABLE IF NOT EXISTS `TABELNAAM` (
  `inkomsten` bigint(255) NOT NULL DEFAULT '0',
  `kleingeld` bigint(255) NOT NULL DEFAULT '0',
  `grootgeld` bigint(255) NOT NULL DEFAULT '0',
  PRIMARY KEY (`inkomsten`)
);


--
-- Gegevens worden geëxporteerd voor tabel `TABELNAAM`
--

include('inc.config.php');


$uid	= $_SESSION['userId'];
$sql = "SELECT * FROM planning WHERE userId = ".$uid;
$result = mysqli_query($mysqli, $sql) or die('-1'.mysqli_error());




$arr = array();


while($obj = mysqli_fetch_object($result)) {
$arr[] = $obj;
}
echo json_encode($arr);

//Connect
$mysqli = new mysqli($dbhost, $dbuser, $dbpass, $dbname);
if (mysqli_connect_errno()) {
	printf("MySQLi connection failed: ", mysqli_connect_error());
	exit();
}
	// Get Settings Data
	$setSql = "
		SELECT
			id,
			title,
			start,
			end,
			url,
			allDay
		FROM
			planning
	";
	$res = mysqli_query($mysqli, $setSql) or die('-1'.mysqli_error());


	
	/* fetch associative array */
    while ($row = mysqli_fetch_assoc($res)) {
        title: $row['title'];
		start: $row['start'];
    }