6
« Įrašytas: 2013-08-03 17:03:17 pm »
Štai dalis kodo:
$colname_IeskovasId = "-1";
mysql_select_db($database_Teisininkai, $Teisininkai);
if (isset($_POST['paieska'])) {
$paieskoszodis = $_POST['paieska'];
$query_IeskovasId = "
SELECT IeskovasId.ID, Ieskovai.Vardas, Ieskovai.Pavarde, Ieskovai.AsmK, Ieskovai.Tel, Ieskovai.ElPastas, Bylos.BylosNr, BylosEsme.Esme FROM IeskovasId
LEFT JOIN Bylos ON Bylos.ID=IeskovasId.BylosID
LEFT JOIN Ieskovai ON Ieskovai.ID = IeskovasId.IeskovasId
LEFT JOIN BylosEsme ON Bylos.BylosEsme=BylosEsme.ID
WHERE Ieskovai.ID LIKE '%".$paieskoszodis."%' ";
}
else
{
$query_IeskovasId = "
SELECT IeskovasId.ID, Ieskovai.Vardas, Ieskovai.Pavarde, Ieskovai.AsmK, Ieskovai.Tel, Ieskovai.ElPastas, Bylos.BylosNr, BylosEsme.Esme FROM IeskovasId
LEFT JOIN Bylos ON Bylos.ID=IeskovasId.BylosID
LEFT JOIN Ieskovai ON Ieskovai.ID = IeskovasId.IeskovasId
LEFT JOIN BylosEsme ON Bylos.BylosEsme=BylosEsme.ID
";
}
$query_limit_IeskovasId = sprintf("%s LIMIT %d, %d", $query_IeskovasId, $startRow_IeskovasId, $maxRows_IeskovasId);
$IeskovasId = mysql_query($query_limit_IeskovasId, $Teisininkai) or die(mysql_error());
$row_IeskovasId = mysql_fetch_assoc($IeskovasId);
mysql_select_db($database_Teisininkai, $Teisininkai);
$query_Ieskovai = "SELECT ID, CONCAT_WS(' ',Vardas, Pavarde) AS Bendras FROM Ieskovai";
$Ieskovai = mysql_query($query_Ieskovai, $Teisininkai) or die(mysql_error());
$row_Ieskovai = mysql_fetch_assoc($Ieskovai);
$totalRows_Ieskovai = mysql_num_rows($Ieskovai);
<div class="lentele2" >
<form action="" method="post" id="paieska">
<p>
<select name="paieska">
<option value="value">---Pasirinkite---</option>
<?php
do {
?>
<option value="<?php echo $row_Ieskovai['ID']?>"><?php echo $row_Ieskovai['Bendras']?></option>
<?php
} while ($row_Ieskovai = mysql_fetch_assoc($Ieskovai));
$rows = mysql_num_rows($Ieskovai);
if($rows > 0) {
mysql_data_seek($Ieskovai, 0);
$row_Ieskovai = mysql_fetch_assoc($Ieskovai);
}
?>
</select>
<input name="submit" type="submit" id="submit" value="Paieska" />
</p>
<form action="<?php echo $editFormAction; ?>" method="post" name="form2" id="form2">
<table width="350" align="center">
<tr valign="baseline">
<td align="left" valign="top" nowrap="nowrap">Vardas:</td>
<td><input name="Vardas" type="text" value="<?php echo htmlentities($row_IeskovasId['Vardas'], ENT_COMPAT, 'utf-8'); ?>" size="32" readonly="readonly" /></td>
</tr>
<tr valign="baseline">
<td align="left" valign="top" nowrap="nowrap">Pavardė:</td>
<td><input name="Pavarde" type="text" value="<?php echo htmlentities($row_IeskovasId['Pavarde'], ENT_COMPAT, 'utf-8'); ?>" size="32" readonly="readonly" /></td>
</tr>
<tr valign="baseline">
<td align="left" valign="top" nowrap="nowrap">Asmens Kodas:</td>
<td><input name="AsmK" type="text" value="<?php echo htmlentities($row_IeskovasId['AsmK'], ENT_COMPAT, 'utf-8'); ?>" size="32" readonly="readonly" /></td>
</tr>
<tr valign="baseline">
<td align="left" valign="top" nowrap="nowrap">Telefonas:</td>
<td><input name="Tel" type="text" value="<?php echo htmlentities($row_IeskovasId['Tel'], ENT_COMPAT, 'utf-8'); ?>" size="32" readonly="readonly" /></td>
</tr>
<tr valign="baseline">
<td align="left" valign="top" nowrap="nowrap">El. Paštas:</td>
<td><input name="ElPastas" type="text" value="<?php echo htmlentities($row_IeskovasId['ElPastas'], ENT_COMPAT, 'utf-8'); ?>" size="32" readonly="readonly" /></td>
<tr valign="baseline">
<td align="left" valign="top" nowrap="nowrap">Bylos</td>
<td> </td>
</table>
<table width="350" align="center">
<tr valign="baseline">
<td width="146" align="right" valign="top" nowrap="nowrap"><p>Bylos Numeris
</p>
<p>
<input name="BylosNr" type="text" value="<?php echo htmlentities($row_IeskovasId['BylosNr'], ENT_COMPAT, 'utf-8'); ?>" size="15" readonly="readonly" />
</p></td>
<td width="192" align="left" valign="top" nowrap="nowrap"><p>Bylos Esmė</p>
<p>
<input name="BylosEsme" type="text" value="<?php echo htmlentities($row_IeskovasId['Esme'], ENT_COMPAT, 'utf-8'); ?>" size="26" readonly="readonly" />
</p></td>
</tr>
<tr valign="baseline">
<td align="left" valign="top" nowrap="nowrap"> </td>
<td><input type="submit" value="Pakeisti" /></td>
</tr>
</table>
<input type="hidden" name="MM_update" value="form2" />
<input type="hidden" name="ID" value="<?php echo $row_IeskovasId['ID']; ?>" />
</form>
<p> </p>
<p> </p>
<p> </p>
</div>
Ir gaunasi:
O turi buti prie bylu tam tikrame kontakte prijungta dar viena byla...
Rodyti pranešimus
