PHP getPredmet示例

示例#1

文件： maket.php 项目： Vakuu/projects

     $html .= "<tr><td>&nbsp;</td></tr>";
 }
 $html .= "</table><br/>";
 /* ****************************************** results tables ************************************************ */
 $html .= "<br/><table class='sdr_results' border='1'>";
 $html .= "<tr>";
 $html .= "<td class='tds'><span>Наименование: " . $row2['asoc_name'] . "</span>";
 $html .= "<div class='results hide'>";
 $html .= "<table class='style_table'>";
 $html .= "<tr>";
 $html .= "<td valign='top'>Адрес: </td>";
 $html .= "<td valign='top'>" . $row2['asoc_address'] . "</td>";
 $html .= "</tr>";
 $html .= "<tr>";
 $html .= "<td>Предмет на дейност: </td>";
 $html .= "<td>" . getPredmet($row2['predmet']) . "</td>";
 $html .= "</tr>";
 $html .= "<tr>";
 $html .= "<td>Срок на учредяване: </td>";
 $html .= "<td>" . getSrok($row2['srok']) . "</td>";
 $html .= "</tr>";
 $html .= "<tr>";
 $html .= "<td>Представение идеални части: </td>";
 $html .= "<td valign='top'>" . $row2['asoc_ideal_parts'] . "</td>";
 $html .= "</tr>";
 $html .= "<tr>";
 $html .= "<td valign='top'>Управителен съвет: </td>";
 $html .= "<td valign='top'>";
 $html .= "<div style='overflow-y: auto; height: 184px;'>";
 $sql3 = "SELECT p.*, e.cod_name  \n\t\t\t\t\t\t\t\t\t\t\t\t FROM people p, elements e \n\t\t\t\t\t\t\t\t\t\t\t\t WHERE p.asoc_id = '" . $row2['asoc_id'] . "' \n\t\t\t\t\t\t\t\t\t\t\t\t AND e.nom_code = '01' \n\t\t\t\t\t\t\t\t\t\t\t\t AND p.type = e.cod_cod and p.invalid='0'";
 $res3 = mysql_query($sql3) or die(mysql_error());

示例#2

文件： print.php 项目： Vakuu/projects

/* ----------------------------------------------------------------------------------------------------- */
//tuk ne selektiram ime na sdrujenie
// 6te se vzima ot GET-a
$sqlUd = "SELECT z.number, p.*, a.date_of_entry, a.asoc_name, a.asoc_address, \n\t\t\t\t\ta.srok, a.predmet, a.asoc_numb, a.predst, \n\t\t\t\t\tb.build_numb, b.kvartal, b.street, b.str_nom, \n\t\t\t\t\ta.asoc_ideal_parts \n\t\t\t  FROM documents z, people p, asoc a, buildings b  \n\t\t\t  WHERE a.id = '{$a_id}' \n\t\t\t  AND p.type = '1'\n\t\t\t  AND a.building_id = b.id and a.invalid='0' and b.invalid='0' and p.invalid='0'";
$resUd = mysql_query($sqlUd) or die(mysql_error());
while ($rowUd = mysql_fetch_assoc($resUd)) {
    $vh_nom = $rowUd['number'];
    $preds = $rowUd['name'];
    $sdr_name = $rowUd['asoc_name'];
    $vp_date = $rowUd['date_of_entry'];
    $aso_id = $rowUd['asoc_numb'];
    $kvIra = getKvAndRaion($rowUd['kvartal']);
    $street = $rowUd['street'];
    $bl = $rowUd['build_numb'];
    $address = $kvIra . ', ' . $street . ' №' . $rowUd['str_nom'] . ', бл.' . $bl;
    $predmet = getPredmet($rowUd['predmet']);
    $srok = $rowUd['srok'];
    $ideal = $rowUd['asoc_ideal_parts'];
    $name = $rowUd['name'];
    $n_predst = getPredstavitelstvo($rowUd['predst']);
}
//echo $vh_nom;
//echo $preds;
//echo $sdr_name;
//echo convertDate($vp_date);
//echo $r;
//echo $address;
// echo $predmet;
//echo $srok;
//echo $ideal;
// echo $chlens; //za ponedelnik