Ho un form per inserire i libri nel DB di mysql. Vorrei che quando seleziono l'editore dal menù a tendina un codice javascritp mi cattura ID dell'editore e lo passa come valore al menù a tendina Collane. Si può fare senza ricaricare la pagina inserendo solo il codice javascript e utilizzare la funzione onchange sul menù a tendina Editore.
Se sì qualcuno gentilmente potrebbe integrarmi il codice in questo:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Inserisci Libri</title>
</head>
<head>
<form action="Inserisci_Libri_Save.php" method="post">
<body background="file:///C|/Nuova_cartella/home/homepage/sfondovat.jpg">
<p class="Stile2" style="margin-top: 0; margin-bottom: 0">
Inserire Libri</p>
<p class="Stile2" style="margin-top: 0; margin-bottom: 0">
Autore</p>
<p class="Stile2" style="margin-top: 0; margin-bottom: 0">
<select name="ID_Autori">
<?php
$connection = mysql_connect("localhost","user","password") or die("Connection Failed");
$db = mysql_select_db("bdb") or die("Connection Failed");
$mydb=mysql_set_charset('utf8');
$query="SELECT ID, Autori FROM autori ORDER BY Autori";
$result=mysql_query($query) or die ("Query to get data from firsttable failed: ".mysql_error());
while ($row=mysql_fetch_array($result)) {
$ID = $row['ID'];
$autori = $row['Autori'];
echo "<option value =\"$ID\">$autori</option>";
}
?>
</select>
<p style="margin-top: 0; margin-bottom: 0">Titolo</p>
<p style="margin-top: 0; margin-bottom: 0"> <font size="4">
<input name="Titolo" size="40">
</font> </p>
<p class="Stile2" style="margin-top: 0; margin-bottom: 0">
Editore</p>
<p class="Stile2" style="margin-top: 0; margin-bottom: 0">
<select name="ID_Editori">
<?php
$connection = mysql_connect("localhost","user","password") or die("Connection Failed");
$db = mysql_select_db("bdb") or die("Connection Failed");
$mydb=mysql_set_charset('utf8');
$query="SELECT ID, Editori FROM editori ORDER BY Editori";
$result=mysql_query($query) or die ("Query to get data from firsttable failed: ".mysql_error());
while ($row=mysql_fetch_array($result)) {
$ID_E = $row['ID'];
$editori = $row['Editori'];
echo "<option value =\"$ID_E\">$editori</option>";
}
?>
</select>
<p class="Stile2" style="margin-top: 0; margin-bottom: 0">Collana
<p class="Stile2" style="margin-top: 0; margin-bottom: 0">
<select name="ID_Collane">
<?php
$connection = mysql_connect("localhost","user","password") or die("Connection Failed");
$db = mysql_select_db("bdb") or die("Connection Failed");
$mydb=mysql_set_charset('utf8');
$query="SELECT ID, Collane FROM collane WHERE ID_Editori = $ID_E ORDER BY Collane";
$result=mysql_query($query) or die ("Query to get data from firsttable failed: ".mysql_error());
while ($row=mysql_fetch_array($result)) {
$ID_C = $row['ID'];
$collane = $row['Collane'];
echo "<option value =\"$ID_C\">$collane</option>";
}
?>
</select>
<p class="Stile2" style="margin-top: 0; margin-bottom: 0">
<input type="submit" name="submit" value="Inserisci">
</form>
</body>
</html>