<?php
////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////
//	if (AjouteSynd($connect,$codes,$noms,$villes,$fds))

function	AjouteSynd($co,$code,$nom,$fd,$ville,$dep)
		{
		$requete = "INSERT INTO syndicat_ajout ";
		$requete = $requete . "values( \"".$code."\"  ,  \"".$nom."\"  , \"".$ville."\" , \"".$fd."\"  ,  \"".$dep."\"  )";
		$rep = mysqli_query($co,$requete);
//		echo $requete."<br>" ;
		if (mysqli_error($co)) return false ;
		return true ;
		}

/////////////////////////////////////
 require 'error.php';
 require 'connect.php';
 require 'fonctions.php';
 require 'config.php';
 require 'vsession.php';
///////////////////////////////////
 require 'tpage.php';
///////////////////////////////////
require 'menu.php';
///////////////////////////////////

// $tbl = "cheminots" ;
$nbopt = NbEnr($connect,"syndicat_wd") ;
$msg = "Nombre [".$nbopt."]" ;




echo "<div class='container container-gpage'>\n" ;

TitrePageBS($msg,"h4","text-primary well") ;
include ('mess.php') ;
///////////////////////////////////////////////////

$nbmanque = 0 ;
$nbt = 0 ;
$nbx = 0 ;
$nbtrouve = 0 ;
$nbajour = 0  ;
$font = $vert ;
$nba = 0 ;

$requete = "SELECT code_synd,libel_cogetis,territoire,code_fd,cd from syndicat_wd where libel_cogetis > ' '" ;

CommentHtml("Requete = ".$requete);

$rep = mysqli_query($connect,$requete);

while (list($codes,$noms,$villes,$fds,$deps) = mysqli_fetch_row($rep))
	{
//function	AjouteSynd($co,$code,$nom,$fd,$ville,$dep)
	$ret = AjouteSynd($connect,$codes,$noms,$villes,$fds,$deps);
	if ($ret == true)
		{
		echo "code[".$codes."] nom[".$noms."]<br>" ;
		$nbajout ++ ;
		}
	else
		{
		echo "pas d'ajout<br>";
		}
	flush() ;
	$nbt ++ ;
//	if ($nbt > 1000 )  break ;
	}


// echo "</tbody></table>\n" ;
$msg = $nbajout." ajouts/".$nbt." lus" ;
TitrePageBS($msg,"h4","text-primary well") ;

////////////////////// script  /////////////////////
/*
   echo "<script>\n" ;
   echo "var table = $('#membre').DataTable( {\n" ;
   echo " 'dom': '<toolbar>Bfrtip',\n" ;
   echo " 'buttons': [\n" ;
   echo "'excel'],\n" ;
   echo  "stateSave: true ,\n" ;
   echo "'language': \n" ;
   echo            "{'url': 'js/french.json'} \n" ;
   echo "} );\n " ;
//   echo "	table.buttons( 0 ).disable();\n" ;
   echo "	table.search( '".$vretour."' );\n" ;
   echo "	table.draw();\n" ;
   echo "</script>\n" ;
*/

echo "</div>" ;
require ('bpage.php');

?>