<?php include_once "db.php"; $idDocument = $_REQUEST["id"]; // SQL $idModele = DBAccess::singleValue("SELECT idModele\n FROM documentGamme, gamme, anneeModele\n WHERE documentGamme.idGamme=gamme.idGamme\n AND gamme.idAnneeModele = anneeModele.idAnneeModele\n AND idDocumentGamme='{$idDocument}'"); DBAccess::exec("UPDATE documentGamme\n SET emblem_modele=0\n WHERE idGamme IN\n (\n SELECT idGamme\n FROM gamme, anneeModele\n WHERE gamme.idAnneeModele = anneeModele.idAnneeModele\n AND idModele='{$idModele}'\n )"); DBAccess::exec("UPDATE documentGamme\n SET emblem_modele=1\n WHERE idDocumentGamme='{$idDocument}'"); $response = 'ok'; print json_encode($response, JSON_PRETTY_PRINT);
<?php include_once "db.php"; $idModele = $_REQUEST["idModele"]; $mini = $_REQUEST["mini"]; // SQL DBAccess::exec("UPDATE modele\n SET mini = '{$mini}'\n WHERE idModele = '{$idModele}'"); include_once "list-mini.php";
$status['query'] = "UPDATE documentMarque\n\t\t\t\t\t\t\t\t\t\t\t\t SET idMarque='{$idMarque}', ordre='{$ordre}', source='{$source}', date='{$date}', legende='{$legende}', motCle='{$motCle}'\n\t\t\t\t\t\t\t\t\t\t\t\t WHERE idDocumentMarque = '{$idDocumentMarque}'"; } } else { if ($objet == "docGamme") { $idGamme = getParam("idGamme"); $source = getParam("source"); $date = getParam("date"); $legende = getParam("legende"); $lien = getParam("lien"); if ($action == "add") { $status['query'] = "INSERT INTO documentGamme(idGamme, source, date, legende, lien)\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t VALUES('{$idGamme}', '{$source}', '{$date}', '{$legende}', '{$lien}')"; } else { $idDocumentGamme = getParam("idDocumentGamme"); $status['query'] = "UPDATE documentGamme\n\t\t\t\t\t\t\t\t\t\t\t\t SET idGamme='{$idGamme}', source='{$source}', date='{$date}', legende='{$legende}', lien='{$lien}'\n\t\t\t\t\t\t\t\t\t\t\t\t WHERE idDocumentGamme = '{$idDocumentGamme}'"; } } } } } } $status['result'] = DBAccess::exec($status['query']) ? "ok" : "ko"; if ($action == "add") { if ($objet == "docMarque") { $status['new'] = DBAccess::singleValue("SELECT max(idDocumentMarque) as id FROM documentMarque"); } else { if ($objet == "docGamme") { $status['new'] = DBAccess::singleValue("SELECT max(idDocumentGamme) as id FROM documentGamme"); } } } print json_encode($status, JSON_PRETTY_PRINT);