Example #1
0
function EliminarProductos($id)
{
    $mdl = new Modelo();
    $res = $mdl->exec("DELETE FROM inventario WHERE _id ='{$id['_id']}'");
    $mdl->close();
}
Example #2
0
<?php

class Modelo extends SQLite3
{
    function __construct()
    {
        $this->open('almacen.db');
    }
}
$mdl = new Modelo();
$str_datos = file_get_contents("Inventario.json");
$data = json_decode($str_datos, true);
print_r($data[0]['Serie']);
print_r($data[3]);
for ($i = 0; $i <= count($data); $i++) {
    if ($data[$i] > 2) {
        $mdl->exec("INSERT INTO inventario \n\t\t\tVALUES ('{$data[$i]['_id']}','{$data[$i]['Serie']}','{$data[$i]['Nombre']}',\n\t\t\t'{$data[$i]['Cantidad']}','{$data[$i]['Costo']}','{$data[$i]['Precio']}')");
    }
}
/*	
array_push($datos, $json);
$fh = fopen("/Inventario.json", 'w')
	   			   or die("Error al abrir fichero de salida");
fwrite($fh, json_encode($datos,JSON_UNESCAPED_UNICODE));
*/