MODIFICATEUR DE DONNEES DANS UNE BASE SQL AVEC LISTING DES TABLES

<?php

session_start();


// DECLARATION DES INFO SQL   -----> ATTENTION MODIFIER A VOTRE GUISE  (lignes 5 et 211)

$host = 'localhost';
$user = 'root';
$pass = '';
$db = 'BASE';


 ?>
<div>
<?php


				//  INITIALISATION DE LA SESSION
		if (!isset($_SESSION['ok'])){$_SESSION['ok']=0;
		}

							
				//  VERIFICATION DE L'EXISTENCE DES DONNEES REMPLIES DANS LES 3 CHAMPS DU FORM

	if (( !isset($_POST['Text1']))||( $_POST['Text1']==" "	) )	{ $_POST['Text1'] =0; } 
	if (( !isset($_POST['Text2']))||( $_POST['Text2']==" "	) )	{ $_POST['Text2'] =0; } 
	if (( !isset($_POST['Text3']))||( $_POST['Text3']==" "	) )	{ $_POST['Text3'] =0; } 
//**********************************************************************************************************************************************
		
										echo "<br/>";							
			
			
			if (empty ($_POST['Text1'])){
				//echo "text 1 vide<br/>";
				$valide_1=0;
				}else{
				//echo "Nom de la table bien defini<br/>";
				$valide_1=1;}
			if (empty ($_POST['Text2'])){
				//echo "text 2 vide<br/>";
				$valide_2=0;
				}else{
				//echo "Nom du champ bien defini<br/>";
				$valide_2=1;}
			if (empty ($_POST['Text3'])){
				//echo "text 3 vide<br/>";
				$valide_3=0;
				}else{
				//echo "Valeur du champ bien defini<br/>";
				$valide_3=1;}
			
		$ver_2_ter_lol=$valide_1.$valide_2.$valide_3;		//echo $ver_2_ter_lol;
				
			if ($ver_2_ter_lol==111)	{$_SESSION['ok'] = 1;} else {$_SESSION['ok'] = 0;}//	SI LES 3 CHAMPS DU FORM SONT REMPLIS ---> $_SESSION['ok'] = 1

				

//*************************************************************** RECUPERATION DU FORMULAIRE *******************************************************************************


	$nom_table=0;
	$nom_seting=0;
	$valeur_seting=0;

$nom_table = $_POST['Text1'];
$nom_seting = $_POST['Text2'];
$valeur_seting = $_POST['Text3'];

				//************************ modif pr gerer les heures
				
				$chaine1 = str_replace("espaceX"," ",$valeur_seting) ;
				$chaine2 = str_replace("ptX",":",$chaine1) ;
				$valeur_seting=$chaine2;

				
				//************************			espace_heure et pt_heure pr remplacer 

//********************************************************** OBSERVATION DES TABLES EXISTENTES *************************************************************************************

if ($_SESSION['ok'] == 0) {	
$espace=" ";
//**************
$link = mysql_connect ($host,$user,$pass) or die ('Erreur : '.mysql_error() );
								mysql_select_db($db) or die ('Erreur :'.mysql_error());


$query = "show tables";		// on va observer les tables
	$result = mysql_query($query);
	$num_results = mysql_num_rows($result);
	for ($i = 0; $i < $num_results; $i++)
	{
	$row = mysql_fetch_array($result);
	$rs=mysql_query("SELECT * FROM ". $row[0] ."");
	$cols = mysql_num_fields($rs);
	echo "<b>";
	echo $row[0];
	echo "</b><br>";
	   for ($j = 0; $j < $cols; $j++) {
		$type  = mysql_field_type($rs, $j);
		$name  = mysql_field_name($rs, $j);
		echo "Types : <strong> $type </strong>";
		echo " | ";
		echo "Champs : <strong> $name </strong>";
		 echo "<br>";
	  }}



echo "___________________________________________________________________________________________________________________________________________________<br/>";
echo "___________________________________________________________________________________________________________________________________________________<br/>";

//**************	RECUPERATION DE L'HEURE AU CAS OU VOUS MODIFIEZ UN DATETIME PAR ex
	$date = date("Y-m-d");//	DATE
	$heure = date("H:i:s");//	HEURE
	$date_de_toutdesuite=0;
	$date_de_toutdesuite=$date." ".$heure;//	MISE AU FORMAT DATETIME
	echo"<br/>";	//	On est le : 	
	echo "Date et heure actuelle : $date_de_toutdesuite";
	echo"<br/>";
//***************	
echo "___________________________________________________________________________________________________________________________________________________<br/>";
echo "___________________________________________________________________________________________________________________________________________________<br/>";

 
echo "<strong>Exemple	:</strong>Pour metre un espace , utiliser la variable ".'"espaceX" et "ptX" pr remplacer " <strong> : </strong>"';

echo "<br/> Exemple qui fonctionne ^^ =><strong> 2010-07-27espaceX10pt_heure02ptX37 </strong><br/><br/>";
//***************
echo "___________________________________________________________________________________________________________________________________________________<br/>";
echo "___________________________________________________________________________________________________________________________________________________<br/>";

echo "<br/><br/>	<strong>Exemple	:</strong>   Pour modifier les valeurs d'un seul ID ( ici on va inserer 25 quand \"id\"=2 ) =>  <strong>	25espaceXWHEREespaceXid=2	</strong>	";

//***************
echo "___________________________________________________________________________________________________________________________________________________<br/>";
echo "___________________________________________________________________________________________________________________________________________________<br/>";

echo "<br/><strong>EN COURS D'EXECUTION</strong> <br/><br/>Modification de la table <strong> \" $nom_table \" </strong> et du champ <strong>\" $nom_seting \"</strong> pour insérer la valeur <strong>\" $valeur_seting \" </strong> <br/><br/>";

//if (($nom_table!=0)&&($nom_seting!=0)){$_SESSION['ok'] = 1;} else {$_SESSION['ok'] = 0;}

echo "<br/><br/>Valeur de la session : ".$_SESSION['ok']."<br/><br/>";
}

//***********************************************************************************************************************************************
if ($_SESSION['ok'] == 1) {	

		
$host = 'localhost';
$user = 'root';
$pass = '';
$db = 'BASE';
	
								$link = mysql_connect ($host,$user,$pass) or die ('Erreur : '.mysql_error() );
								mysql_select_db($db) or die ('Erreur :'.mysql_error());

									$rebhgbtrkjamax2rere41 = "UPDATE $nom_table SET $nom_seting=$valeur_seting";	//WHERE id = '1'
									mysql_query($rebhgbtrkjamax2rere41) or die('Erreur n°1 la requete ne peut pas aboutir <br/>Verifier vos champs <br/>: '.mysql_error());	//	AFFICHERA L'ERREUR n°1 SQL
								



										echo "Modification effectuees avec succes !!";
										
										header ("Refresh: 3;URL=".$_SERVER['PHP_SELF']);	// on redirige après réussite du programme.
 										exit;

	}
////***********************************************************************************************************************************************////
////************************************** BY CRAM 121 ************************************************************ BY CRAM 121 *******************////
////************* BY CRAM 121 **************************************************** BY CRAM 121 ****************************************************////
////***********************************************************************************************************************************************////
////********************************************** BY CRAM 121 ************************************************* BY CRAM 121 **********************////
////***********************************************************************************************************************************************////
////************ BY CRAM 121 **********************************************************************************************************************////
////*************************************************************************************** BY CRAM 121 *******************************************////
////*********************************************** BY CRAM 121 ***********************************************************************************////
////***********************************************************************************************************************************************////
////********************************************************************************************************************* BY CRAM 121 *************////
////******************************************************************* BY CRAM 121 ***************************************************************////
////*************************** BY CRAM 121 ******************************************** BY CRAM 121 **********************************************////
////***********************************************************************************************************************************************////
////****************** BY CRAM 121 ****************************************************************************************************************////
////******************************************************************************************** BY CRAM 121 **************************************////
////***************************************************** BY CRAM 121 ****************************************************** BY CRAM 121 **********////
////********** BY CRAM 121 ************************************************************************************************************************////
////******************************************************************** BY CRAM 121 **************************************************************////
////***********************************************************************************************************************************************////

?>
</div>
<br/><br/>

<form action="<?php $_SERVER['PHP_SELF'] ; ?>" method="post" style="width: 350px; height: 110px" >
	<div >
	<input name="Text1" type="text"/>&nbsp;&nbsp;&nbsp; <strong>Nom de la table a modifier</strong><br/>	
	<input name="Text2" type="text"/>&nbsp;&nbsp;&nbsp; <strong>Nom du champ a modifier</strong><br/>
	<input name="Text3" type="text"/>&nbsp;&nbsp;&nbsp; <strong>Valeur du champ a modifier</strong><br/>	
	<input name="Submit1" type="submit" value="valider" class="style1" style="width: 90px"/>
	</div>
</form>