Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <HTML>
- <BODY>
- <FORM ACTION="listino.php" METHOD="POST">
- <select name="hlab_form_ric_area" onchange="hlab_ajax('/', 'hlab_form_id_ric_ricerca1', true, 'hlab_form_id_ric_ricerca1_perform=EventoCambioArea')"><option value="0">* area tematica</option><option value="1">Sviluppo Web</option><option value="2">Sistemistica & Sicurezza</option><option value="4">Motori di ricerca e Web Marketing</option><option value="5">Multimedia e Web Design</option><option value="6">Informatica di base</option><option value="7">M come Mobile</option><option value="12">Soft Skill</option></select>
- <INPUT TYPE="text" NAME="codice"> Codice Prodotto <BR>
- <INPUT TYPE="submit" VALUE="Query!"><BR>
- </FORM>
- </BODY>
- </HTML>
- <?php
- $cod_art= $_POST['codice'];
- $Connessione = mysql_connect("localhost", "root", "");
- if(!$Connessione)
- {
- print ("<H1>Connessione al server MySQL fallita</H1>");
- exit;
- }
- $DB = mysql_select_DB("Articolo");
- if(!$DB)
- {
- print("<H1>Connessione al database Articolo fallita</H1>");
- exit;
- }
- $Sql="SELECT * FROM Tabella where Cod_Art='".$cod_art."'";
- if(!($Results=mysql_query($Sql)))
- print("Query Fallita");
- else
- {
- print("<table STYLE = \"border-style:double; border-width:5pt;
- border-color:green\">");
- print("<tr STYLE = \"font-weight: bold\"><td>Cod_Articolo</td>");
- print("<td> Descrizione </td>");
- print("<td> Prezzo </td>");
- print("<td> Quantità restante </td>");
- print("<td> Categoria </td>");
- print("<td> Fornitore </td></tr>");
- while ($Data = mysql_fetch_object ($Results))
- {
- print("<tr><td>".$Data->Cod_Art."</td>");
- print("<td>".$Data->descrizione."</td>");
- print("<td>".$Data->prezzo."</td>");
- print("<td>".$Data->qt."</td>");
- print("<td>".$Data->categoria."</td>");
- print("<td>".$Data->fornitore."</td></tr>");
- }
- }
- print("</table>");
- mysql_close($Connessione);
- ?>
Add Comment
Please, Sign In to add comment