PHP HELP
-
#151
Eddig jutottam:
<?php
$ossz = mysql_connect("localhost", "akarmi", "akarmi") or die(mysql_error());
mysql_select_db("bea", $ossz) or die(mysql_error());
?>
<html>
<head>
<title></title>
</head>
<body>
<?
$quer=mysql_query("SELECT sid,name,domain FROM server order by sid");?>
<form method=post action="">
<select name="lista" onChange="submit()">
<option value="0">---válassz servert/domaint!---</option>
<?
while ($myrow=mysql_fetch_array($quer)) {
$val = $myrow["name"]." / ".$myrow["domain"]." |".$myrow["sid"];
$sel = ($lista == $val) ? "selected" : "";
printf ("<OPTION VALUE=\"%s\" %s>%s</OPTION>\n", $val, $sel, $val);
}
echo "</select>";
$sid = substr($lista,strpos($lista, "|")+1,$hossz=strlen($lista)-(strpos($lista, "|")+1));
settype($sid2,integer);
$quer1=mysql_query("SELECT aid,nev FROM app WHERE sid=$sid order by nev");
?>
<select name="lista1" onChange="submit()">
<option value="0">---válassz alkalmazást!---</option>
<?
while ($myrow1=mysql_fetch_array($quer1)) {
$val1 = $myrow1["nev"]." |".$myrow1["aid"];
$sel1 = ($lista1 == $val1) ? "selected" : "";
printf ("<OPTION VALUE=\"%s\" %s>%s</OPTION>\n", $val1, $sel1, $val1);
}
echo "</select>";
$aid = substr($lista1,strpos($lista1, "|")+1,strlen($lista1)-(strpos($lista1, "|")+1));
settype($aid2,integer);
$quer2=mysql_query("SELECT cpid,nev FROM cp WHERE aid=$aid order by nev");
?>
<select name="lista2" onChange="submit()">
<option value="0">---válassz cp-t!---</option>
<?
while ($myrow2=mysql_fetch_array($quer2)) {
$cpid = $myrow2["cpid"];
$val2 = $myrow2["nev"];
$sel2 = ($lista2 == $val2) ? "selected" : "";
printf ("<OPTION VALUE=\"%s\" %s>%s</OPTION>\n", $val2, $sel2, $val2);
}
echo "</select>";
?>
<table>
<tr>
<td><p><strong>DS neve: </strong>
</td>
<td><input type="text" name="ds_name" size=40 maxlength=40></td>
</tr>
<tr>
<td><p><strong>JNDI neve: </strong></td>
<td><input type="text" name="ds_jndiname" size=40 maxlength=80></td>
</tr>
</table>
</form>
</body>
</html>
A listák szépen változnak. Viszont, hova és mit kell tenni, hogy a beírt adatokat fel is tudjam tölteni a 4. táblába?
$ds_add = "insert into ds values ('', '$_POST[lista2]', '$_POST[ds_name]', '$_POST[ds_jndiname]')";