PHP updateRessources Examples

Example #1

File: ade.php Project: IMR18/web

<?php

if (isset($_GET["action"])) {
    $action = $_GET["action"];
} else {
    $res = array("NO ACTION SET");
    echo json_encode($res);
    exit;
}
require "functions_ade.php";
$db = PDO();
switch ($action) {
    case "updateALL":
        $res = updateRessources($db, ressources2update($db));
        break;
    case "getEvents":
        $ressources = isset($_GET["ressource"]) && !empty($_GET["ressource"]) ? $_GET["ressource"] : "1";
        if ($ressources != '1') {
            $ressources = "'" . implode("','", explode(",", $ressources)) . "'";
        }
        $req = $db->prepare("select * from events where ressource in ({$ressources}) or 1=?");
        $req->execute(array($ressources));
        $res = $req->fetchAll(PDO::FETCH_ASSOC);
        break;
    case "getEventsJson":
        $ressources = isset($_GET["ressource"]) && !empty($_GET["ressource"]) ? $_GET["ressource"] : "1";
        if ($ressources != '1') {
            $ressources = "'" . implode("','", explode(",", $ressources)) . "'";
        }
        $req = $db->prepare("select UID as id, StartDate,EndDate,StartTime,EndTime,Title as title,location from events where ressource in ({$ressources}) or 1=?");
        $req->execute(array($ressources));

Example #2

File: admin_ressources.php Project: Laurent4671/mvc-warin-ressources

             if (!$ressource_titre) {
                 $msg .= "<p class='text-red'><i class='fa fa-long-arrow-right'></i> Titre obligatoire</p>";
             }
             if (!$ressource_url_href) {
                 $msg .= "<p class='text-red'><i class='fa fa-long-arrow-right'></i> URL obligatoire</p>";
             }
             if (!$ressource_url_title) {
                 $msg .= "<p class='text-red'><i class='fa fa-long-arrow-right'></i> Title obligatoire</p>";
             }
             if (!$ressource_img_alt) {
                 $msg .= "<p class='text-red'><i class='fa fa-long-arrow-right'></i> ALT obligatoire</p>";
             }
         }
         $page = "admin_ressources_update";
     } else {
         $update = updateRessources($sous_categ_id, $ressource_titre, $ressource_url_href, $ressource_url_title, $ressource_img_alt, $get_id);
         if ($update) {
             $msg .= "<div class='box-body'><div class='alert alert-success alert-dismissable'><button type='button' class='close' data-dismiss='alert' aria-hidden='true'>&times;</button><h4><i class='icon fa fa-check'></i> Alert!</h4>Ressource modifiée avec succès</div></div>\n";
         } else {
             $msg .= "<div class='box-body'><div class='alert alert-danger alert-dismissable'><button type='button' class='close' data-dismiss='alert' aria-hidden='true'>&times;</button><h4><i class='icon fa fa-ban'></i> Alert!</h4>Oupsss... problème lors de la modification de la ressource</div></div>\n";
         }
         $page = "admin_ressources_update";
     }
     break;
 case "delete":
     $delete = deleteRessources($get_id);
     if ($delete) {
         $msg .= "<div class='box-body'><div class='alert alert-success alert-dismissable'><button type='button' class='close' data-dismiss='alert' aria-hidden='true'>&times;</button><h4><i class='icon fa fa-check'></i> Alert!</h4>Ressource supprimée avec succès</div></div>\n";
     } else {
         $msg .= "<div class='box-body'><div class='alert alert-danger alert-dismissable'><button type='button' class='close' data-dismiss='alert' aria-hidden='true'>&times;</button><h4><i class='icon fa fa-ban'></i> Alert!</h4>Oupsss... problème lors de la suppression de la ressource</div></div>\n";
     }