include("login_check.php"); include("include/header.php"); //connexion a la base de donnees include("banner.php"); include("parametre.php"); include("library/fonctions_php.php"); if( isset( $_GET['id_label'] ) ) $id_label = ( $_GET['id_label'] );//id du label du noeud if( isset( $_GET['id_label1'] ) ) $id_label1 = ( $_GET['id_label1'] );//id du label du noeud if( isset( $_GET['id_label2'] ) ) $id_label2 = ( $_GET['id_label2'] );//id du label du noeud if( isset( $_GET['type'] ) ) $type = ( $_GET['type'] );//type de labellisation generique/specifique if( isset( $_GET['periode'] ) ) $my_period =derange_periode($_GET['periode']);// periode else $my_period = '-1'; connexion_base($server,$user,$password,$database); //bloc recuperation infos du noeud de la carte: //un noeud= un ensemble de clusters qui partagent le même label. $resultat=mysql_query("select id,forme_principale FROM concepts ORDER by forme_principale") or die ("Requête non executée."); while ($ligne=mysql_fetch_array($resultat)) $liste_termes[$ligne['id']] = $ligne['forme_principale']; create_concept_string(); if ($type=="s") { $sql ="select id_cluster FROM cluster WHERE periode = \"".$my_period."\" and label_2 = \"".$id_label."\" GROUP by id_cluster";//on s'attache à extraire l'ensemble des clusters associés au label specifique donné } elseif ($type=="g") {
function remove_sondage($connect, $numsondage) { $connect->StartTrans(); $req = 'DELETE FROM sondage WHERE id_sondage = ' . $connect->Param('numsondage'); $sql = $connect->Prepare($req); $connect->Execute($sql, array($numsondage)); $req = 'DELETE FROM sujet_studs WHERE id_sondage = ' . $connect->Param('numsondage'); $sql = $connect->Prepare($req); $connect->Execute($sql, array($numsondage)); $req = 'DELETE FROM user_studs WHERE id_sondage = ' . $connect->Param('numsondage'); $sql = $connect->Prepare($req); $connect->Execute($sql, array($numsondage)); $req = 'DELETE FROM comments WHERE id_sondage = ' . $connect->Param('numsondage'); $sql = $connect->Prepare($req); $connect->Execute($sql, array($numsondage)); $suppression_OK = !$connect->HasFailedTrans(); $connect->CompleteTrans(); return $suppression_OK; } $connect = connexion_base(); define('COMMENT_EMPTY', 0x1); define('COMMENT_USER_EMPTY', 0x10); define('COMMENT_INSERT_FAILED', 0x100); define('NAME_EMPTY', 0x1000); define('NAME_TAKEN', 0x10000); define('NO_POLL', 0x100000); define('NO_POLL_ID', 0x1000000); define('INVALID_EMAIL', 0x10000000); define('TITLE_EMPTY', 0x100000000); define('INVALID_DATE', 0x1000000000); $err = 0;