Форумы портала PHP.SU

PHP:
скопировать код в буфер обмена

 
<?PHP 
//Соединение с сервером базы данных
$link = mysql_connect('localhost', 'root', '');
 
// Получаем cписок БД на сервере
$db_list = mysql_list_dbs($link);
while ( $db = mysql_fetch_row($db_list) )
{  
  $db_names[] = $db[0];
}
// Формируем JavaScript
for ( $i = 0; $i < count($db_names); $i++ )
{
  $switch[$i] = "case ".$i.":\\n";
  for ( $j = 0; $j < count($db_names); $j++ )
  {
    if ( $i == $j )
    {
      $switch[$i] = $switch[$i]."  document.getElementById('db_".$db_names[$j]."_tables').disabled = false;\\n";
      $switch[$i] = $switch[$i]."  document.getElementById('db_".$db_names[$j]."_tables').style.display = 'block';\\n";
    }
    else
    {
      $switch[$i] = $switch[$i]."  document.getElementById('db_".$db_names[$j]."_tables').disabled = true;\\n";
      $switch[$i] = $switch[$i]."  document.getElementById('db_".$db_names[$j]."_tables').style.display = 'none';\\n";
    }
  }
  $switch[$i] = $switch[$i]."  break;\\n\\n";
}
?>
< script type="text/javascript">
function dsblEnblSelect(s)
{
  switch(s.selectedIndex)
  {
<?PHP 
foreach( $switch as $value ) echo $value; 
?>
  }
}
</script>
 
<?PHP 
// Получаем cписок БД на сервере
$db_list = mysql_list_dbs($link);
$dbs_select = "<select name='dbname' onchange='dsblEnblSelect(this)'>\\n";
$i = 0; 
while ( $db = mysql_fetch_row($db_list) )
{  
    $dbs_select = $dbs_select."<option value='".$db[0]."'>".$db[0]."</option>\\n";
  $tbls = mysql_list_tables($db[0]);
  if( $i == 0 )
    $tables[$db[0]] = "<select name='db_".$db[0]."_tables' id='db_".$db[0]."_tables' style='position:relative; display:block'>\\n";
  else
    $tables[$db[0]] = "<select name='db_".$db[0]."_tables' id='db_".$db[0]."_tables' style='position:relative; display:none' disabled>\\n";
  while( $tbl = mysql_fetch_row($tbls) )
  {
    $tables[$db[0]] = $tables[$db[0]]."<option value='".$tbl[0]."'>".$tbl[0]."</option>\\n";
  }
  $tables[$db[0]] = $tables[$db[0]]."</select>\\n";
  $i++;
}  
$dbs_select = $dbs_select."</select>\\n";
 
echo "<form name='db_and_tables' action='".$_SERVER["PHP_SELF"]."' method='GET'>\\n";
// Выводим список БД
echo "Доступные базы данных<br/>\\n ".$dbs_select."<br/><br/>\\n";
// Выводим список таблиц
echo "Таблицы<br/>\\n";
foreach( $tables as $value ) echo $value."\\n";
echo "<br/><input type='submit' name='mysubmit' value='Выбрать' />\\n";
echo "</form>\\n";
 
if ( isset($_GET["mysubmit"]) ) echo "< p>Выбрана БД ".$_GET["dbname"]." и таблица ".$_GET["db_".$_GET["dbname"]."_tables"]."</p>\\n";
 
?>
 

PHP:
скопировать код в буфер обмена

 
< script type="text/javascript">
function dsblEnblSelect(s)
{
  switch(s.selectedIndex)
  {
    case 0:
      document.getElementById('db_banners_tables').disabled = false;
      document.getElementById('db_banners_tables').style.display = 'block';
      document.getElementById('db_dbtree_tables').disabled = true;
      document.getElementById('db_dbtree_tables').style.display = 'none';
      document.getElementById('db_mycms_tables').disabled = true;
      document.getElementById('db_mycms_tables').style.display = 'none';
      break;
 
    case 1:
      document.getElementById('db_banners_tables').disabled = true;
      document.getElementById('db_banners_tables').style.display = 'none';
      document.getElementById('db_dbtree_tables').disabled = false;
      document.getElementById('db_dbtree_tables').style.display = 'block';
      document.getElementById('db_mycms_tables').disabled = true;
      document.getElementById('db_mycms_tables').style.display = 'none';
      break;
 
    case 2:
      document.getElementById('db_banners_tables').disabled = true;
      document.getElementById('db_banners_tables').style.display = 'none';
      document.getElementById('db_dbtree_tables').disabled = true;
      document.getElementById('db_dbtree_tables').style.display = 'none';
      document.getElementById('db_mycms_tables').disabled = false;
      document.getElementById('db_mycms_tables').style.display = 'block';
      break;
  }
}
</script>
 
<form name='db_and_tables' action='/index.php' method='GET'>
Доступные базы данных<br/>
<select name='dbname' onchange='dsblEnblSelect(this)'>
  <option value='banners'>banners</option>
  <option value='dbtree'>dbtree</option>
  <option value='mycms'>mycms</option>
</select>
<br/><br/>
 
Таблицы<br/>
 
<select name='db_banners_tables' id='db_banners_tables' style='position:relative; display:block'>
  <option value='banners'>banners</option>
  <option value='referat'>referat</option>
</select>
 
<select name='db_dbtree_tables' id='db_dbtree_tables' style='position:relative; display:none' disabled>
  <option value='categories'>categories</option>
</select>
 
<select name='db_mycms_tables' id='db_mycms_tables' style='position:relative; display:none' disabled>
  <option value='articles'>articles</option>
  <option value='news'>news</option>
  <option value='pages'>pages</option>
</select>
 
<br/>
<input type='submit' name='mysubmit' value='Выбрать' />
</form>
 