Форум программистов [Powered by Invision Power Board]

Код


$result = mysql_query("SELECT * FROM tree ORDER BY title;", $link);
        while($row = mysql_fetch_array($result)){
               echo '<a href="index.php?op=typedoc&id='.$row['id'].'">'.stripslashes($row['title']).'</a>';
        }

Код


<?php 
$result = mysql_query("SELECT * FROM tree WHERE id = '".$_GET['id']."';", $link);
$row = mysql_fetch_array($result);
?>

<input type="text" name="title" value="<?=htmlspecialchars(stripslashes($row['title']));?>" class="enter" size="79">

Код


<?php
$result = mysql_query("SELECT * FROM tree WHERE id = '".$_GET['id']."';", $link);
$row = mysql_fetch_array($result);
echo '<select name="pid">';
$result = mysql_query("SELECT id, title, pid FROM tree");
while($row = mysql_fetch_object($result2)) {
   if($row->title == $row['pid']){
      echo "<option selected='selected' value='".$row->id."'>".$row->title."</option>";
   } else {
      echo "<option value='".$row->id."'>".$row->title."</option>";
   }
}
  echo '</select>';
?>

Код


$result = mysql_query("SELECT id, title, pid FROM tree WHERE id= '".$_GET['id']."';", $link);
      $row = mysql_fetch_object($result);
      echo $row->id;         
      echo $row->title;
      echo $row->pid;

Код


$result = mysql_query("SELECT id, title, pid FROM tree WHERE id= '".$_GET['id']."';", $link);
$row = mysql_fetch_object($result);
echo $row->id;
echo $row->title;
echo $row->pid;

$result2 = mysql_query("SELECT id, title, pid FROM tree WHERE id = '".$row->pid."';", $link);
$row2 = mysql_fetch_array($result2);
echo $row2['title'];

Код

Код


<?php
$sql2 = "SELECT * FROM tree WHERE id = '".$_GET['id']."';";
$result2 = mysql_query($sql2, $link);
$row2 = mysql_fetch_array($result2);

$result3 = mysql_query("SELECT * FROM tree WHERE id = '".$row2['pid']."';", $link);
$row3 = mysql_fetch_array($result3);

echo '<select name="pid">';
$result4 = mysql_query("SELECT id, title, pid FROM tree;");
while($row4 = mysql_fetch_object($result4)){
   if($row3['id'] == $row4->id){
      echo "<option selected='selected' value='".$row3->id."'>".$row3['title']."</option>";
   }
   else{
      echo "<option value='".$row4->id."'>".$row4->title."</option>";
   }
}
echo '</select>';
?>

Код


$sql = 'SELECT id, title, pid FROM tree;';
$r = select_from_db($sql);
$select = formSelect($r, 'pid', array('id','titile'), $row3['id'], 4, true);

echo $select;


/**************************************************************************/
function select_from_db($q, $id = false) {
    $r = mysql_query($q); $n = 0;
    if(!empty($r)) $n = mysql_num_rows($r);
    if($id === true) { for($i = 0; $i < $n; $i++) {
            $a = mysql_fetch_array($r, MYSQL_ASSOC); $s[$a['id']] = $a; }}
    elseif($id) { for($i = 0; $i < $n; $i++) {
            $a = mysql_fetch_array($r, MYSQL_ASSOC); $s[$a[$id]] = $a; }}
    else { for($i = 0; $i < $n; $i++) { $s[$i] = mysql_fetch_array($r, MYSQL_ASSOC); }}
    if(!empty($s)) return $s;
    else return array(); }
function formSelect($itxt, $name = '', $val = array(), $selected = 0, $data = 0, $nullF = false, $atr = '', $optatr = array()) {
    $html = '<select name="'.$name.'" '.$atr.">\r\n";
    if($nullF) { $html .= '<option value="0"> </option>'; }
    if($data == 3) { $start = $itxt; $count = $val[0]; $step = $val[1]; }
    else { $count = count($itxt); }
    for($i = 0; $i < $count; $i++) {
        if($data == 1) { $key = $val[$i]; $txt = $itxt[$i]; }
        elseif($data == 2) { $key = $i; $txt = $itxt[$i]; }
        elseif($data == 3) { $txt = $key = ($start + ($step*$i)); }
        elseif($data == 4) { $key = $itxt[$i][$val[0]]; $txt = $itxt[$i][$val[1]]; }
        else { $key = $txt = $itxt[$i]; }
        if($selected == $key) { $sel = 'selected'; } else { $sel = ''; }
        if(!empty($optatr[$i])) { $opt = $optatr[$i]; } else { $opt = ''; }
        $html .= '<option value="'.$key.'" '.$sel.$opt.'>'.$txt."</option>\r\n";
    }
    $html .= "</select>\r\n";
    return $html;
}