bdd_connecter_base("OBERLECHNER.NET"); $delete = isset($_GET['DELETE']); $statutlu = ""; $tableauligue1 = array( "1" => "1-Paris Saint-Germain", "2" => "2-Olympique Lyonnais", "3" => "3-Olympique de Marseille", "4" => "4-FC Metz", "5" => "5-Girondins de Bordeaux", "6" => "6-FC Nantes Atlantique" ); // DEFINITION DU FORMULAIRE ############################################################################## $f = New Forms; $f->frm_Init($delete,'150px'); definition_des_champs(); // ILLUSTRATION DE LA RE-ENTRANCE FORMULAIRE ############################################################# $ret = $f->frm_Aiguiller('USR_ID'); $valeurpardefaut = false; switch ( $ret ) { // AJOUT 1ER APPEL ############################################################# case "A0" : $requete = "SELECT COUNT(*) FROM testbase"; $base->bdd_execsql($requete); $cpt = $base->bdd_lire_champ(1); if ($cpt>=1) { $requete = "SELECT * FROM testbase"; $base->bdd_execsql($requete); $f->frm_ChargerLesChamps( $base->bdd_resultats_vers_tableau() ); } else { $valeurpardefaut = true; } break; // AJOUT RE-ENTRANT ############################################################# case "A1" : $requete = "SELECT COUNT(*) FROM testbase"; $base->bdd_execsql($requete); $cpt = $base->bdd_lire_champ(1); if ($cpt>=1) { $requete1 = $base->bdd_creationrequete("testbase","T_CLEF","M" ); } else { $requete1 = $base->bdd_creationrequete("testbase","T_CLEF","A" ); } $base->bdd_execsql($requete1); $requete = "SELECT * FROM testbase"; $base->bdd_execsql($requete); $f->frm_ChargerLesChamps( $base->bdd_resultats_vers_tableau() ); break; case "L0" : // EFFACEMENT 1ER APPEL ############################################################# $f->frm_LibBoutons("Effacer"); $requete = "SELECT COUNT(*) FROM testbase"; $base->bdd_execsql($requete); $cpt = $base->bdd_lire_champ(1); if ($cpt>=1) { $requete = "SELECT * FROM testbase"; $base->bdd_execsql($requete); $f->frm_ChargerLesChamps( $base->bdd_resultats_vers_tableau() ); } break; // EFFACEMENT RE-ENTRANT ############################################################# case "L1" : // ATTENTION ON ZAPE ! $requete = "DELETE FROM testbase WHERE t_clef=".$_POST['T_CLEF']; $base->bdd_execsql($requete); header('location: testbase.php'); break; case "AQ" : case "LQ" : header('location: testbase.php'); break; } ?> www.oberlechner.net - TESTER LES CHAMPS D'UNE BASE DE DONNEES




VOIR LE SOURCE Zaper l`enregistrement dans la base"; } if ($delete) { $titre = "EFFACER L'ENREGISTREMENT DE LA BASE"; } else { $titre = "EDITER LA BASE DE DONNEES"; } print "$titre"; $f->frm_Ouvrir(); if ($ret == "A1") { print "
"; print "POUR VOIR LA SYNTAXE EXACTE DE LA REQUETE EDITER LE SOURCE"; print "
"; print "\n\n
";
			print $requete1;
			print "\n
\n"; } if ( !$delete ) { print "

Le nom de tous les champs : ->bdd_listerchamps()
"; print "
";
			$tab =  $base->bdd_listerchamps("testbase");
			print_r($tab);
			print "
"; print "
Le type de champs : ->bdd_listertypechamps()
"; print "
";
			$tab =  $base->bdd_listertypechamps("testbase");
			print_r($tab);
			print "
"; } // ON PREVIENT QUE LA BASE EST VIDE if ($valeurpardefaut) { print "\n"; } ?>
frm_ObjetChampCache("T_CLEF", "1"); $f->frm_ObjetChampTexte("T_TINYINT", array( "attrib" => "N", "label" => "TINYINT (1 octet)", "maxlength" => "4", "width" => "50px", "default" => "127", "help" => "TINYINT = 1 octet, [-128..127] signé [0..255] non signé", ) ); $f->frm_ObjetChampTexte("T_SMALLINT", array( "attrib" => "N", "label" => "SMALLINT (2 octets)", "maxlength" => "6", "width" => "80px", "default" => "32000", "help" => "SMALLINT =2 octets, [-32768..32767] signé [0..65535] non signé", ) ); $f->frm_ObjetChampTexte("T_INT", array( "attrib" => "N", "label" => "INT (4 octets)", "maxlength" => "15", "width" => "160px", "default" => "1000000", "help" => "INT = 4 octets, [-2.147.483.648 ~ +2147483647] signé [0 ~ +4.294.967.295] non signé", ) ); $f->frm_SautLignes(1); $f->frm_ObjetChampTexte("T_VARCHAR", array( "attrib" => "U", "label" => "VARCHAR(10)", "maxlength" => "10", "width" => "100px", "default" => "**DEFAUT**", "help" => "VARCHAR(10) = 10 caractères maximum" ) ); $f->frm_SautLignes(1); $f->frm_ObjetChampTexte("T_DATE", array( "label" => "DATE", "attrib" => "DP", "help" => "Saisir une date ou la sélectionner dans au calendrier") ); $f->frm_ObjetChampTexte("T_DATETIME", array( "label" => "DATETIME", "attrib" => "T", "help" => "sélectionner une date dans le calendrier", ) ); $f->frm_SautLignes(2); $f->frm_ObjetChampMemo("T_TEXT", array( "label" => "TEXT", "width" => "400px", "height" => "100px", "default" => "Champ de type TEXT (valeur par défaut)" ) ); $f->frm_SautLignes(1); $f->frm_ObjetChampMemo("T_BLOB", array( "label" => "BLOB", "width" => "400px", "rows" => "8", "default" => "Champ de type BLOB (valeur par défaut)" ) ); $f->frm_SautLignes(1); $f->frm_ObjetEditeur("T_LONGBLOB", array( "label" => "LONGBLOB", "width" => "550px", "height" => "100px", "default" => "Ceci est la valeur par défaut passé au champ \"Editeur\"
Le contenu de ce champ est évidemment à sauvegarder dans un champ MEMO(Access) ou BLOB (mySQL)" ) ); $f->frm_ObjetSortSelect("T_SORTSELECT", array( "label" => "Liste pré-triée", "default" => "", "order" => $ordre1, "rows" => "10", "separators" => "true", "help" => "Donner le classement de la ligue 1", "width" => "200px"), $tableauligue1 ); } ?>