<?php //connexion à la BDD //(que je placerai dans un fichier à part personnellement....) $bdd = new PDO('mysql:host=localhost;dbname=youtube', 'root', 'root'); $bdd->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $action = isset($_POST['action'])?$_POST['action']:NULL; $id_video = isset($_POST['id_video'])?$_POST['id_video']:NULL; switch($action){ case "ACCEPTER": $etat_video = 1; break; case "REFUSER": $etat_video = 2; break; default: // Aucune action connue... $action=$_POST break; } // Ici tu code la fonction d'update dans ta BDD... $sql = "UPDATE tatable SET etat = '$etat_video' WHERE cont_id = '$id_video' "; $req = $bdd->prepare($sql); $resultat = $req->execute(); // Retour de fichier ajax print json_encode($result); ?>
function changeEtatVideo(id_video,action){ var urlAjx = "maj_video.ajx.php"; var data = {action:action,id_video:id_video}; $.ajax({ type: "POST", url:urlAjx, data: data, async: false, dataType: "json", success: function(reponse){ // ici tu peux mettre du code // lorsque la maj s'est bien faite par exemple }, error:function(jqXHR, textStatus){ alert('error :' + textStatus); }, statusCode:{ 404: function(){alert("ERREUR 404 : "+ urlAjx + " NOT FOUND !" );} } }); }
echo "<input type='button' name='valider' value='VALIDER' onclick='changeEtatVideo(\"".$id_video."\",\"ACCEPTER\")'>";
une erreur concernant le code pour la page de "traitement" comme vous dites.
{ de trop à la ligne 11.
if(isset($_POST['valider'])){ $etat_video = 1; } if(isset($_POST['remove'])){ $etat_video = 2; }
$req = $bdd->query("SELECT * FROM youtube WHERE etat = 0"); while($donnees = $req->fetch()) { ?> <tr> <td><?php echo htmlentities($donnees ['cont_pseudorg']);?></td> <td><a href="http://youtube.com/user/<?php echo $donnees ['cont_pseudoyt']?>" target="_blank"><?php echo htmlentities($donnees ['cont_pseudoyt']);?></a></td> <td><?php echo htmlentities($donnees ['cont_titrevideo']);?></td> <td><a href="<?php echo $donnees['cont_urlvideo'];?>" target="_blank"><?php echo htmlentities($donnees ['cont_urlvideo']);?></a></td> <td><img style="width:50px;"src="http://sec-rg.fr/img/Logo_sec.png"></img></td> <td><?php echo htmlentities($donnees ['cont_description']);?></td> <td> <a class="btn btn-success" href="page_traitement.php?id_video=<?php echo $donnees['cont_id'];?>&action=valider"><i class="glyphicon glyphicon-ok"></i></a> <a class="btn btn-danger" href="page_traitement.php?id_video=<?php echo $donnees['cont_id'];?>&action=remove"><i class="glyphicon glyphicon-remove"></i></a> <a class="btn btn-default" href=""><i class="glyphicon glyphicon-info-sign"></i></a> </td> </tr> <?php } ?>
<?php //connexion à la BDD //(que je placerai dans un fichier à part personnellement....) $bdd = new PDO('mysql:host=localhost;dbname=youtube', 'root', 'root'); $bdd->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); //récupération des variables : $id_video = isset($_POST['id_video'])?$_POST['id_video']:NULL; //Choix du traitement en fonction du formulaire if(isset($_GET['valider'])){ $etat_video = 1; } if(isset($_GET['remove'])){ $etat_video = 2; } $sql = "UPDATE tatable SET etat = '$etat_video' WHERE cont_id = '$id_video' "; $req = $bdd->prepare($sql); $resultat = $req->execute(); ?>
<?php //connexion à la BDD //(que je placerai dans un fichier à part personnellement....) $bdd = new PDO('mysql:host=localhost;dbname=youtube', 'root', 'root'); $bdd->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); //récupération des variables : $id_video = isset($_GET['id_video'])?$_GET['id_video']:NULL; $action = isset($_GET['action'])?$_GET['action']:NULL; //Choix du traitement en fonction du formulaire if($action =="valider"){ $etat_video = 1; }elseif($action =="remove"){ $etat_video = 2; }else{ $etat_video=NULL; } if($etat_video && $id_video){ $sql = "UPDATE tatable SET etat = '$etat_video' WHERE cont_id = '$id_video' "; $req = $bdd->prepare($sql); $resultat = $req->execute(); }else{ echo "<br>etat_video ou id_video inconnu"; } ?>
Nous sommes d'accord que je dois re-créer une nouvelle page traitement.php
<a class="btn btn-success" href="page_traitement.php?id_video=<?php echo $donnees['cont_id'];?>&etat=1"><i class="glyphicon glyphicon-ok"></i></a> <a class="btn btn-danger" href="page_traitement.php?id_video=<?php echo $donnees['cont_id'];?>&etat=2"><i class="glyphicon glyphicon-remove"></i></a>
<?php //connexion à la BDD //(que je placerai dans un fichier à part personnellement....) $bdd = new PDO('mysql:host=localhost;dbname=youtube', 'root', 'root'); $bdd->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); //récupération des variables : $id_video = isset($_GET['id_video'])?$_GET['id_video']:NULL; $etat_video= isset($_GET['etat'])?$_GET['etat']:NULL; if($etat_video && $id_video){ $sql = "UPDATE tatable SET etat = '$etat_video' WHERE cont_id = '$id_video' "; $req = $bdd->prepare($sql); $resultat = $req->execute(); }else{ echo "<br>etat_video ou id_video inconnu"; } ?>
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question<?php $oForm=new plugin_form($this->oYoutube); $oForm->setMessage($this->tMessage); ?> <script src='https://www.google.com/recaptcha/api.js'></script> <form class="form-horizontal" action="" method="POST" enctype="multipart/form-data"> <div class="form-group"> <label class="col-sm-2 control-label">Pseudo RealityGaming :</label> <div class="col-sm-10"><?php echo $oForm->getInputText('cont_pseudorg',array('class'=>'form-control'))?></div> </div> <div class="form-group"> <label class="col-sm-2 control-label">Pseudo YouTube :</label> <div class="col-sm-10"><?php echo $oForm->getInputText('cont_pseudoyt',array('class'=>'form-control'))?></div> </div> <div class="form-group"> <label class="col-sm-2 control-label">Titre de la video :</label> <div class="col-sm-10"><?php echo $oForm->getInputText('cont_titrevideo',array('class'=>'form-control'))?></div> </div> <div class="form-group"> <label class="col-sm-2 control-label">Lien de la video :</label> <div class="col-sm-10"><?php echo $oForm->getInputText('cont_urlvideo',array('class'=>'form-control'))?></div> </div> <div class="form-group"> <label class="col-sm-2 control-label">Miniature personnalisée</label> <div class="col-sm-10"><?php echo $oForm->getInputUpload('cont_miniature',array('class'=>'form-control'))?></div> </div> <div class="form-group"> <label class="col-sm-2 control-label">Description :</label> <div class="col-sm-10"><?php echo $oForm->getInputTextarea('cont_description',array('class'=>'form-control'))?></div> </div> <!-- <div class="form-group"> <center><div class="g-recaptcha" data-sitekey="6Ld3OwUTAAAAAPIJiBaicgWiryZA-O7nQ4pEmpQ9"></div></center> </div> !--> <?php echo $oForm->getToken('token',$this->token)?> <div class="form-group"> <div class="col-sm-offset-2 col-sm-10"> <input type="submit" class="btn btn-success" value="Envoyer"> <a class="btn btn-link" href="<?php echo $this->getLink('youtube::list')?>">Annuler</a> </div> </div> </form>
<?php $bdd = new PDO('mysql:host=localhost;dbname=youtube', 'root', 'root'); $bdd->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $req = $bdd->query("SELECT * FROM youtube WHERE etat = 1"); while($donnees = $req->fetch()) { ?> Pseudo RG: <?php echo $donnees['cont_pseudorg']; ?> Pseudo YT: <?php echo $donnees['cont_pseudoyt'];?> Pseudo YT: <?php echo $donnees['cont_titrevideo'];?> Pseudo YT: <?php echo $donnees['cont_urlvideo'];?> Pseudo YT: <?php echo $donnees['cont_miniature'];?> Pseudo YT: <?php echo $donnees['cont_description'];?> <?php } ?>
<?php $bdd = new PDO('mysql:host=localhost;dbname=youtube', 'root', 'root'); $bdd->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); ?> <table class="table table-striped"> <tr> <th>RealityGaming</th> <th>YouTube</th> <th>Titre </th> <th>URL</th> <th>Miniature</th> <th>Description</th> </tr> <?php $req = $bdd->query("SELECT * FROM youtube WHERE etat = 0"); while($donnees = $req->fetch()) { ?> <tr> <td><?php echo $donnees['cont_pseudorg'];?></td> <td><?php echo $donnees['cont_pseudoyt'];?></td> <td><?php echo $donnees['cont_titrevideo'];?></td> <td><a href="<?php echo $donnees['cont_urlvideo'];?>" target="_blank"><?php echo $donnees['cont_urlvideo'];?></a></td> <td><a href="<?php echo $donnees['cont_miniature'];?>" target="_blank"><img style="width:40px;"src="<?php echo $donnees['cont_miniature'];?>"></a></td> <td><?php echo $donnees['cont_description'];?></td> <td> <a class="btn btn-success" href=""><i class="glyphicon glyphicon-ok"></i></a> <a class="btn btn-danger" href=""><i class="glyphicon glyphicon-remove"></i></a> <a class="btn btn-default" href=""><i class="glyphicon glyphicon-info-sign"></i></a> </td> </tr> <?php } ?>
<form name="valider" action="validate.php"> <input type="hidden" name="id_video" value="<?php echo $donnees['cont_id'] ;?>"> <a class="btn btn-success" href="" onclick="document.valider.submit();"><i class="glyphicon glyphicon-ok"></i></a> </form> <form name="remove" action="validate.php"> <input type="hidden" name="id_video" value="<?php echo $donnees['cont_id'] ;?>"> <a class="btn btn-danger" href="" onclick="document.remove.submit();"><i class="glyphicon glyphicon-remove"></i></a> </form> <a class="btn btn-default" href="" ><i class="glyphicon glyphicon-info-sign"></i></a>
<?php //connexion à la BDD //(que je placerai dans un fichier à part personnellement....) $bdd = new PDO('mysql:host=localhost;dbname=youtube', 'root', 'root'); $bdd->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); //récupération des variables : $id_video = isset($_POST['id_video'])?$_POST['id_video']:NULL; //Choix du traitement en fonction du formulaire if(isset($_POST['valider']){ $etat_video = 1; } if(isset($_POST['remove']){ $etat_video = 2; } $sql = "UPDATE tatable SET etat = '$etat_video' WHERE cont_id = '$id_video' "; $req = $bdd->prepare($sql); $resultat = $req->execute(); ?>
<html lang="fr">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>SEC - YouTube</title>
<link rel="stylesheet" href="//netdna.bootstrapcdn.com/bootstrap/3.1.1/css/bootstrap.min.css">
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.4/js/bootstrap.min.js"></script>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.2/jquery.min.js"></script>
<script src="/SHARING/src/js/bootstrap.min.js"></script>
<meta charset="utf-8">
</head>
<body>
<nav class="navbar navbar-default" role="navigation">
<!-- Brand and toggle get grouped for better mobile display -->
<div class="navbar-header">
<button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-ex1-collapse">
<span class="sr-only"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand" href="#"><i class="glyphicon glyphicon-facetime-video"></i> Gestions des vidéos</a>
</div>
<!-- Collect the nav links, forms, and other content for toggling -->
<div class="collapse navbar-collapse navbar-ex1-collapse">
<ul class="nav navbar-nav">
<li class="active"><a href="#">Accueil</a></li>
<li><a href="#">Formulaire</a></li>
</ul>
<ul class="nav navbar-nav navbar-right">
<li class="dropdown">
<a href="#" class="dropdown-toggle" data-toggle="dropdown"><i class="glyphicon glyphicon-cog"></i> <b class="caret"></b></a>
<ul class="dropdown-menu">
<li><a href="list.php"><i class="glyphicon glyphicon-facetime-video"></i> Gestionnaire de vidéos</a></li>
<li><a href="valide.php"><i style="color:green;" class="glyphicon glyphicon-ok"></i> Vidéos validées</a></li>
<li><a href="refuse.php"><i style="color:red;" class="glyphicon glyphicon-remove"></i> Vidéos refusées</a></li>
</ul>
</li>
</ul>
</div><!-- /.navbar-collapse -->
</nav>
<?php
$bdd = new PDO('mysql:host=localhost;dbname=youtube', 'root', 'root');
$bdd->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
?>
<table class="table table-striped">
<tr>
<th>RealityGaming</th>
<th>YouTube</th>
<th>Titre </th>
<th>URL</th>
<th>Miniature</th>
<th>Description</th>
</tr>
<?php
$req = $bdd->query("SELECT * FROM youtube WHERE etat = 0");
while($donnees = $req->fetch())
{
?>
<tr>
<td><?php echo htmlentities($donnees ['cont_pseudorg']);?></td>
<td><a href="http://youtube.com/user/<?php echo $donnees ['cont_pseudoyt']?>" target="_blank"><?php echo htmlentities($donnees ['cont_pseudoyt']);?></a></td>
<td><?php echo htmlentities($donnees ['cont_titrevideo']);?></td>
<td><a href="<?php echo $donnees['cont_urlvideo'];?>" target="_blank"><?php echo htmlentities($donnees ['cont_urlvideo']);?></a></td>
<td><img style="width:50px;"src="http://sec-rg.fr/img/Logo_sec.png"></img></td>
<td><?php echo htmlentities($donnees ['cont_description']);?></td>
<td>
<a class="btn btn-success" href=""><i class="glyphicon glyphicon-ok"></i></a>
<a class="btn btn-danger" href=""><i class="glyphicon glyphicon-remove"></i></a>
<a class="btn btn-default" href=""><i class="glyphicon glyphicon-info-sign"></i></a>
</td>
</tr>
<?php } ?>
<!-- FOTTER -->
<nav class="navbar navbar-default navbar-fixed-bottom" role="navigation">
<center> <span style="color:black;"class="navbar">Copyright SEC - RealityGaming - 2015 | <b>Louki</b> avec l'aide de <b>Fabien</b> et <b>Maxence</b> </span></center>
</nav>
<html lang="fr"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1"> <title>SEC - YouTube</title> <link rel="stylesheet" href="//netdna.bootstrapcdn.com/bootstrap/3.1.1/css/bootstrap.min.css"> <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.4/js/bootstrap.min.js"></script> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.2/jquery.min.js"></script> <script src="/SHARING/src/js/bootstrap.min.js"></script> <meta charset="utf-8"> </head> <body> <nav class="navbar navbar-default" role="navigation"> <!-- Brand and toggle get grouped for better mobile display --> <div class="navbar-header"> <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-ex1-collapse"> <span class="sr-only"></span> <span class="icon-bar"></span> <span class="icon-bar"></span> <span class="icon-bar"></span> </button> <a style="color:green;" class="navbar-brand" href="#"><i style="color:green;" class="glyphicon glyphicon-ok"></i> Vidéos validées</a> </div> <!-- Collect the nav links, forms, and other content for toggling --> <div class="collapse navbar-collapse navbar-ex1-collapse"> <ul class="nav navbar-nav"> <li class="active"><a href="#">Accueil</a></li> <li><a href="#">Formulaire</a></li> </ul> <ul class="nav navbar-nav navbar-right"> <li class="dropdown"> <a href="#" class="dropdown-toggle" data-toggle="dropdown"><i class="glyphicon glyphicon-cog"></i> <b class="caret"></b></a> <ul class="dropdown-menu"> <li><a href="list.php"><i class="glyphicon glyphicon-facetime-video"></i> Gestionnaire de vidéos</a></li> <li><a href="valide.php"><i style="color:green;" class="glyphicon glyphicon-ok"></i> Vidéos validées</a></li> <li><a href="refuse.php"><i style="color:red;" class="glyphicon glyphicon-remove"></i> Vidéos refusées</a></li> </ul> </li> </ul> </div><!-- /.navbar-collapse --> </nav> <?php $bdd = new PDO('mysql:host=localhost;dbname=youtube', 'root', 'root'); $bdd->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); ?> <table class="table table-striped"> <tr> <th>RealityGaming</th> <th>YouTube</th> <th>Titre </th> <th>URL</th> <th>Miniature</th> <th>Description</th> </tr> <?php $req = $bdd->query("SELECT * FROM youtube WHERE etat = 1"); while($donnees = $req->fetch()) { ?> <tr> <td><?php echo htmlentities($donnees ['cont_pseudorg']);?></td> <td><?php echo htmlentities($donnees ['cont_pseudoyt']);?></td> <td><?php echo htmlentities($donnees ['cont_titrevideo']);?></td> <td><a href="<?php echo $donnees['cont_urlvideo'];?>" target="_blank"><?php echo htmlentities($donnees ['cont_urlvideo']);?></a></td> <td><img style="width:50px;"src="http://sec-rg.fr/img/Logo_sec.png"></img></td> <td><?php echo htmlentities($donnees ['cont_description']);?></td> <?php } ?> <!-- FOTTER --> <nav class="navbar navbar-default navbar-fixed-bottom" role="navigation"> <center> <span style="color:black;"class="navbar">Copyright SEC - RealityGaming - 2015 | <b>Louki</b> avec l'aide de <b>Fabien</b> et <b>Maxence</b> </span></center> </nav>
<html lang="fr"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1"> <title>SEC - YouTube</title> <link rel="stylesheet" href="//netdna.bootstrapcdn.com/bootstrap/3.1.1/css/bootstrap.min.css"> <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.4/js/bootstrap.min.js"></script> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.2/jquery.min.js"></script> <script src="/SHARING/src/js/bootstrap.min.js"></script> </head> <body> <nav class="navbar navbar-default" role="navigation"> <!-- Brand and toggle get grouped for better mobile display --> <div class="navbar-header"> <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-ex1-collapse"> <span class="sr-only"></span> <span class="icon-bar"></span> <span class="icon-bar"></span> <span class="icon-bar"></span> </button> <a style="color:red;"class="navbar-brand" href="#"><i style="color:red;" class="glyphicon glyphicon-remove"></i> Vidéos refusées</a> </div> <!-- Collect the nav links, forms, and other content for toggling --> <div class="collapse navbar-collapse navbar-ex1-collapse"> <ul class="nav navbar-nav"> <li class="active"><a href="#">Accueil</a></li> <li><a href="#">Formulaire</a></li> </ul> <ul class="nav navbar-nav navbar-right"> <li class="dropdown"> <a href="#" class="dropdown-toggle" data-toggle="dropdown"><i class="glyphicon glyphicon-cog"></i> <b class="caret"></b></a> <ul class="dropdown-menu"> <li><a href="list.php"><i class="glyphicon glyphicon-facetime-video"></i> Gestionnaire de vidéos</a></li> <li><a href="valide.php"><i style="color:green;" class="glyphicon glyphicon-ok"></i> Vidéos validées</a></li> <li><a href="refuse.php"><i style="color:red;" class="glyphicon glyphicon-remove"></i> Vidéos refusées</a></li> </ul> </li> </ul> </div><!-- /.navbar-collapse --> </nav> <!-- FIN DE NAVBAR --> <?php $bdd = new PDO('mysql:host=localhost;dbname=youtube', 'root', 'root'); $bdd->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); ?> <table class="table table-striped"> <tr> <th>RealityGaming</th> <th>YouTube</th> <th>Titre </th> <th>URL</th> <th>Miniature</th> <th>Description</th> </tr> <?php $req = $bdd->query("SELECT * FROM youtube WHERE etat = 2"); while($donnees = $req->fetch()) { ?> <tr> <td><?php echo htmlentities($donnees ['cont_pseudorg']);?></td> <td><?php echo htmlentities($donnees ['cont_pseudoyt']);?></td> <td><?php echo htmlentities($donnees ['cont_titrevideo']);?></td> <td><a href="<?php echo $donnees['cont_urlvideo'];?>" target="_blank"><?php echo htmlentities($donnees ['cont_urlvideo']);?></a></td> <td><img style="width:50px;"src="http://sec-rg.fr/img/Logo_sec.png"></img></td> <td><?php echo htmlentities($donnees ['cont_description']);?></td> </tr> <?php } ?> <!-- FOTTER --> <nav class="navbar navbar-default navbar-fixed-bottom" role="navigation"> <center> <span style="color:black;"class="navbar">Copyright SEC - RealityGaming - 2015 | <b>Louki</b> avec l'aide de <b>Fabien</b> et <b>Maxence</b> </span></center> </nav>