Codice PHP:
<form id="formName" action="javascript:completeAHAH.likeSubmit('ricevo3.php', 'POST', 'formName', 'result');">
<table id="tabella">
<tr>
<td>Cliente:</td>
<td><input type="text" id="client" name="client" value="ForMe s.r.l." disabled="true"></td>
</tr>
<tr>
<td>Cliente Finale:</td>
<?php
function cliente(){
$query="SELECT Ragione_Sociale FROM db_clienti";
$ris = mysql_query($query);
while ($value=mysql_fetch_array($ris)){
echo "<option>".$value['Ragione_Sociale']."</option>";
}
}
?>
<td><select id="client2" name="client2">
<?php cliente(); ?>
</select></td>
</tr>
<tr>
<td>Venditore:</td><td>
<select id="vendit" name="vendit">
<option value="Alessandro">Alessandro</option>
<option value="Marco">Marco</option>
<option value="Milano">Milano</option>
</select></td>
</tr>
<tr>
<td>Data Ordine:</td><td><input type="text" id="sel3" name="date3" size="20">
<button type="reset" id="f_trigger_b">Calendario</button>
<script type="text/javascript">
Calendar.setup({
inputField : "sel3", // id of the input field
ifFormat : "%d/%m/%Y", // format of the input field
showsTime : false, // will display a time selector
button : "f_trigger_b", // trigger for the calendar (button ID)
singleClick : false, // double-click mode
step : 1 // show all years in drop-down boxes (instead of every other year as default)
});
</script></td>
</tr>
<tr>
<td>Data Consegna:</td><td><input type="text" id="sel4" name="date4" size="20">
<button type="reset" id="f_trigger_c">Calendario</button>
<script type="text/javascript">
Calendar.setup({
inputField : "sel4", // id of the input field
ifFormat : "%d/%m/%Y", // format of the input field
showsTime : false, // will display a time selector
button : "f_trigger_c", // trigger for the calendar (button ID)
singleClick : false, // double-click mode
step : 1 // show all years in drop-down boxes (instead of every other year as default)
});
</script></td>
</tr>
<tr>
<td>Pagamento:</td><td><input type="text" id="list2" name="list2" value="Pagamento 90gg" disabled="true"></td>
</tr>
<tr>
<td>Sconto (%):</td><td><input type="text" id="scont" name="scont" value="8%" disabled="true"></td>
</tr>
<tr>
<td>Articoli:</td><td><input type="text" value="" name="findme" id="findme"> </td>
<td>
</td>
</tr>
<tr>
<td>Consegna Solo Completo:</td><td>
<select id="cons_compl" name="cons_compl">
<option value="SI">SI</option>
<option value="NO">NO</option>
</select></td>
</tr>
<tr>
<td>Note:</td><td><textarea id="not" name="not" value="" cols="40" rows="5"></textarea></td>
</tr>
<tr>
<td colspan="2"><center><input type="submit" value="Inserisci Ordine" onclick="return Conferma();"></center></td>
</tr>
</form></table>
Al momento sono messo così 
Cioè ho solo creato il form, come vedi dove c'è la scritta articoli al momento c'è solo una text che farà l'autocompletamento.
Il dump del db_clienti:
Codice PHP:
CREATE TABLE IF NOT EXISTS `db_clienti` (
`ID` smallint(10) NOT NULL AUTO_INCREMENT,
`Ragione_Sociale` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`Riferimento` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
`Indirizzo` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`CAP` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
`Citta` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`Provincia` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
`PIVA` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`C_Fiscale` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`Telefono` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`Fax` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`Cellulare` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`Email` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
`Listino` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
`Pagamento` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
`Banca` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`Filiale` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`ABI` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`CAB` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`IBAN` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=16 ;
Mentre il dump del db_ordini:
Codice PHP:
CREATE TABLE IF NOT EXISTS `db_ordini` (
`ID` smallint(6) NOT NULL AUTO_INCREMENT,
`Ordine` varchar(50) CHARACTER SET utf8 NOT NULL,
`Cliente` varchar(100) CHARACTER SET utf8 NOT NULL,
`Cliente_Finale` varchar(200) CHARACTER SET utf8 NOT NULL,
`Venditore` varchar(30) CHARACTER SET utf8 NOT NULL,
`Riferimento` varchar(200) CHARACTER SET utf8 NOT NULL,
`Data_Ordine` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
`Data_Consegna` varchar(15) CHARACTER SET utf8 NOT NULL,
`Pagamento` varchar(120) CHARACTER SET utf8 NOT NULL,
`Sconto` varchar(10) CHARACTER SET utf8 NOT NULL,
`Consegna_Solo_Completo` varchar(2) CHARACTER SET utf8 NOT NULL,
`Note` varchar(400) CHARACTER SET utf8 NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=27 ;
Ed il dump del db_magazzino:
Codice PHP:
CREATE TABLE IF NOT EXISTS `db_magazzino` (
`ID` smallint(5) NOT NULL AUTO_INCREMENT,
`Codice` varchar(15) CHARACTER SET utf8 NOT NULL,
`Descrizione` varchar(400) CHARACTER SET utf8 NOT NULL,
`Prezzo_Acquisto` decimal(10,2) NOT NULL,
`Listino_1` decimal(10,2) NOT NULL,
`Listino_2` decimal(10,2) NOT NULL,
`Tessuto` varchar(70) CHARACTER SET utf8 NOT NULL,
`Colori` varchar(70) CHARACTER SET utf8 NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;
Non so sinceramente cosa possa aiutare, io ho postato tutto quello che ho
Rispondi quotando
