<?php
class DB{
	// conexion a la DB
	private $dbHost     = "localhost";
	private $dbUsername = "root";
	private $dbPassword = "password";
	private $dbName     = "croquis";
	private $imgTbl     = 'mesas';

	function __construct(){
		if(!isset($this->db)){
            // conectar a la db
            $conn = new mysqli($this->dbHost, $this->dbUsername, $this->dbPassword, $this->dbName);
            if($conn->connect_error){
                die("Error de conexion a la DB: " . $conn->connect_error);
            }else{
                $this->db = $conn;
            }
        }
	}

	function getRows(){
		$query = $this->db->query("SELECT * FROM ".$this->imgTbl." ORDER BY img_order ASC");
		if($query->num_rows > 0){
			while($row = $query->fetch_assoc()){
				$result[] = $row;
			}
		}else{
			$result = FALSE;
		}
		return $result;
	}

	function updateOrder($id_array){
		$count = 1;
		foreach ($id_array as $id){
			$update = $this->db->query("UPDATE ".$this->imgTbl." SET img_order = $count WHERE id = $id");
			$count ++;
		}
		return TRUE;
	}
}
?>