echo $_REQUEST['NM_CHAMP'];
?>
, qui sera utilisé</small></i></TD>
<TD colspan="4">
<? // LD champs FK de la table locale
$lchptbloc = db_qr_comprass("SELECT NM_CHAMP,LIBELLE FROM $TBDname where NM_TABLE='".$_REQUEST['NM_TABLE']."' AND NM_CHAMP!='$NmChDT' order by ORDAFF");
foreach ($lchptbloc as $chp) {
$tbchploc[$chp['NM_CHAMP']] = $chp['NM_CHAMP']." (".$chp['LIBELLE'].")";
}
DispLD($tbchploc,"locFKeys",$Mult="yes",$Fccr="LDF");
?>
</TD></TR>
<TR class="THEAD"><td class="th">Variables obligatoires</td><td class="th" colspan="4">Valeur</td></tr>
<? // list de stables
$tbltab = db_show_tables($DBName);
foreach ($tbltab as $tab) {
//$lb = RecupLib($TBDname,"NM_TABLE","LIBELLE",$tab,"","NM_CHAMP='$NmChDT'"); // trop long, ça le fait ramer
$tbltab4ld[$tab] = $tab.($lb ? ' ('.$lb.')': '');
}
if ($_REQUEST['btv']) { // seulement si table virtuelle ?>
<TR class="backredc"><TD>Table physique</TD><TD colspan="4">
<?
DispLD($tbltab4ld,"physTable",$Mult="no",$Fccr="LDF");
?>
</TD></TR>
<? } ?>
<TR><TD>Table cible</TD><TD colspan="4">
<?
if ($trouve && ($CREATION=="vrai") && count($TableName)>0) {
// effacement des enregistrements, mais uniquement ceux des tables s�ectionn�s
foreach ($TableName as $Table) {
db_query("DELETE FROM $TBDname where NM_TABLE='$Table'") or die ("Req. de vidage de invalide !");
}
} elseif ( !$trouve && ($CREATION!="vrai")) {
echo "<BR><span class=\"normalred11px\">LA TABLE <B>$TBDname</B> n'existe pas ! Impossible de la visualiser</span><BR><br>";
echo "<A HREF=\"CREATE_DESC_TABLES.php\"><img src=\"preced.png\" border=\"0\"></A>";
exit();
}
elseif ($CREATION=="vrai")
{
// pour la requ�e, faire un copier coller de ce qui vient de phpmyadmin
print_r(db_show_tables($DBName));
if (in_array($TBDname,db_show_tables($DBName))) {
echo "Effacement de la table $TBDname existante...DROP TABLE $TBDname";
db_query("DROP TABLE $TBDname");
}
$typchptxt = $GLOBALS["NmChpComment"].($_SESSION['db_type'] != "oracle" ? " text" : " varchar2(2000)");
$reqC="CREATE TABLE $TBDname (
NM_TABLE varchar(50) NOT NULL,
NM_CHAMP varchar(50) NOT NULL,
LIBELLE varchar(250) NOT NULL,
ORDAFF_L varchar(5) DEFAULT '0' ,
TYPAFF_L varchar(5) DEFAULT 'AUT' ,
ORDAFF varchar(5) DEFAULT '0' ,
TYPEAFF varchar(20) DEFAULT 'AUT',
VALEURS ".($_SESSION['db_type'] != "oracle" ? " text" : " varchar2(2000)").",
VAL_DEFAUT varchar(200),
TT_AVMAJ varchar(255) ,
$_SESSION['where_sup']="";
$_SESSION['NM_TABLE']="";
$_SESSION['DBName']="";
sess_start();
//include_once("reg_glob.inc");
$title=trad("LB_title"). $_SERVER["HTTP_HOST"] ."( IP=".gethostbyname($_SERVER["HTTP_HOST"]).")";
$lnkbdd=DBconnect($_REQUEST['lc_parenv[MySqlBddName]']);
//mysql_connect($DBHost,$DBUser, $DBPass) or die ("Impossible de se connecter au serveur $DBHost (user: $DBUser, passwd: $DBPass)");
$resb=db_show_bases();
// liste toutes les bases
foreach ($resb as $tresb) {
$DBName = $tresb;
DBconnect($DBName);
$dbg=db_show_tables($GLOBALS["CisChpp"].$tresb.$GLOBALS["CisChpp"]);
$admok=($dbg && in_array($TBDname,$dbg));
// n'affiche le lien pour �ition que si la table d'admin existe dans la base
if ($admok) {
$theecho.= "<LI> <A HREF=\"LIST_TABLES.php?lc_DBName=$tresb&cfLB=vrai\">$tresb</A></LI>";
$dbok = $tresb;
$nbbases ++;
}
}
if ($nbbases ==0) $theecho = "Aucune base actuellement paramétrée pour PhpYourAdmin; veuillez lancer l'utilitaire de configuration";
if ($nbbases != 1) { // si pas une seule base affiche écran
include ("header.php"); ?>
<H1><?php
echo $title;
?>
