Exemplo n.º 1
0
 function forzardelete($Code)
 {
     $parametros = array();
     $parametros['CountryCode'] = $Code;
     $gestor = new ManageCity($this->bd);
     $gestor->deleteCity($parametros);
     $this->bd->delete("countryLanguage", $parametros);
     $parametros = array();
     $parametros['Code'] = $Code;
     return $this->bd->delete($this->tabla, $parametros);
 }
Exemplo n.º 2
0
<?php

require '../clases/AutoCarga.php';
$bd = new DataBase();
$gestor = new ManageCity($bd);
$city = $gestor->get(5);
echo $city->getJson();
echo "<hr>";
echo $gestor->getListJson();
Exemplo n.º 3
0
<?php

require '../clases/AutoCarga.php';
header('Contet-Type: application/json');
$sesion = new Session();
$no = json_encode(array('insert' => -1));
if ($sesion->isLogged()) {
    $bd = new DataBase();
    $gestor = new ManageCity($bd);
    $city = new City();
    $city->read();
    $r = $gestor->insert($city);
    $bd->close();
    $respuesta = '{"insert":' . $r . '}';
    echo $respuesta;
    //var_dump($bd->getError());
} else {
    echo $no;
}
Exemplo n.º 4
0
<?php

require '../clases/AutoCarga.php';
$bd = new BaseDatos();
$gestor = new ManageCity($bd);
$Name = Request::post("Name");
$CountryCode = Request::post("CountryCode");
$District = Request::post("District");
$Population = Request::post("Population");
$city = new City(0, $Name, $CountryCode, $District, $Population);
//var_dump($city);
$r = $gestor->insertCity($city);
$bd->close();
echo '<br>';
echo $r;
echo '<br>';
var_dump($bd->getError());
//header ("Location:index.php?op=Insertado ");
Exemplo n.º 5
0
<?php

require '../clases/AutoCarga.php';
$bd = new BaseDatos();
$gestor = new ManageCity($bd);
//$page = Request::get("page");
//if ($page === NULL || $page === "") {
//    $page = 1;
//}
//$registros = $gestor->count();
//$pages = ceil($registros / Configuracion::NRPP);
//
//$order = Request::get("order");
//$sort = Request::get("sort");
//
//$orden = "$order $sort";
//$trozoEnlace = "";
//
//if (trim($orden) != "") {
//    $trozoEnlace = "&order=$order&sort=$sort";
//}
//
//$ciudades = $gestor->getList($page, $orden);
//$op = Request::get("op");
//$r = Request::get("r");
$filtro = Request::get("filtro");
if ($filtro === null) {
    $params = array();
    $condicion = "1=1";
} else {
    $params["filtro"] == $filtro . "%";
Exemplo n.º 6
0
<?php

require '../clases/AutoCarga.php';
$bd = new BaseDatos();
$gestor = new ManageCity($bd);
$id = Request::get("ID");
$r = $gestor->deleteCity($id);
//var_dump($bd->getError());
$bd->close();
header("Location: index.php?op=delete&r={$r}");
Exemplo n.º 7
0
<?php

require '../clases/AutoCarga.php';
header('Contet-Type: application/json');
$sesion = new Session();
$no = json_encode(array('edit' => -1));
if ($sesion->isLogged()) {
    $bd = new DataBase();
    $gestor = new ManageCity($bd);
    $city = new City();
    $city->read();
    $r = $gestor->set($city);
    $bd->close();
    $respuesta = '{"edit":' . $r . '}';
    echo $respuesta;
    //var_dump($bd->getError());
} else {
    echo $no;
}
Exemplo n.º 8
0
<?php

require '../clases/AutoCarga.php';
header('Contet-Type: application/json');
$sesion = new Session();
$no = json_encode(array('delete' => -1));
if ($sesion->isLogged()) {
    $bd = new DataBase();
    $gestor = new ManageCity($bd);
    $id = Request::req("ID");
    $r = $gestor->delete($id);
    $bd->close();
    $respuesta = '{"delete":' . $r . '}';
    echo $respuesta;
    //var_dump($bd->getError());
} else {
    echo $no;
}
Exemplo n.º 9
0
<?php

require '../clases/AutoCarga.php';
header('Contet-Type: application/json');
$sesion = new Session();
$no = json_encode(array('login' => false));
$pagina = Request::req("pagina");
if ($pagina === null) {
    $pagina = 1;
}
if ($sesion->isLogged()) {
    $bd = new DataBase();
    $gestor = new ManageCity($bd);
    $pager = new Pager($gestor->count());
    $paginas = $pager->getPaginas();
    $ciudades = $gestor->getListJson($pagina);
    echo '{"ciudades":' . $ciudades . ', "paginas": ' . $paginas . '}';
    $bd->close();
} else {
    echo $no;
}
Exemplo n.º 10
0
<?php

require '../clases/AutoCarga.php';
$bd = new BaseDatos();
$gestor = new ManageCity($bd);
$id = Request::get("ID");
$city = $gestor->get($id);
$gestorCountry = new ManageCountry($bd);
// SIEMPRE SE OCULTAN TODOS LOS CAMPOS DE LA CLAVE PRINCIPAL.
// SI LA CLAVE PRINCIPAL NO ES AUTONUMERICA, una se pone oculta y otra visible
// la oculta pkid
// la visible id
?>

<!DOCTYPE html>
<html>
    <head>
        <meta charset="UTF-8">
        <title></title>
    </head>
    <body>
        <a href="index.php">INICIO</a><br>
        <form action="phpedit.php" method="POST">
            <input type="hidden" name="pkID" value="<?php 
echo $id;
?>
" /><br>
            <input type="hidden" name="page" value="<?php 
echo Request::get("page");
?>
" /><br>