Este es el código:
Código PHP:
/**
* Método de búsqueda general.
*
* @ array $search
* [0] - Campo donde buscar (Asociado al Where)
* [1] - Valor aplicado al WHERE del campo
* [2] - Order by (Optional)
* [2]["campo"] - Nombre del Campo por el que será ordenado
* [2]["ascordesc"]- Orden ascendente o descendente
* [3] - Limit (Optional)
* [3]["limit_start"]
* [3]["limit_end"]
* @ return mysql array
*/
public function showAllStock($search){
$this->field = $search[0];
$this->value = $search[1];
$this->orderby = $search[2];
$this->order_field = $this->orderby["campo"];
$this->order_kind = $this->orderby["ascordesc"];
$this->limit = $search[3];
$this->limit_start = $this->limit["start"];
$this->limit_end = $this->limit["end"];
$this->sentencia = "SELECT * FROM stock";
$this->sentencia .= (isset($this->field, $this->value)) ? " WHERE " . $this->field . " = " . $this->value : "";
$this->sentencia .= (isset($this->orderby) && is_array($this->orderby)) ? " ORDER BY " . $this->order_field . " " . $this->order_kind : $this->orderby = "";
$this->sentencia .= (!empty($this->limit)) ? " LIMIT " . $this->limit_start . ", " . $this->limit_end : $this->limit = "";
return mysql_query($this->sentencia);
//return $this->sentencia;
}
Notice: Undefined offset: 3 in /var/www/Proyecto-FP2/funciones.php on line 685
Y la línea 685 es:
Código PHP:
$this->orderby = $search[2];
El método es el siguiente:
Código PHP:
public function stockWithoutLocation(){
$search = array("nLocation", 0, array("campo" => "nID", "ascordesc" => "DESC"));
return $this->showAllStock($search);
}
Gracias