scusate la mia ignoranza ma non ci sto capendo nulla!!!
grazie mille per la vostra disponibilità
allora la connessione è questa
codice:
<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_connessione = "localhost";
$database_connessione = "localbus";
$username_connessione = "actionlab";
$password_connessione = "actionlab";
$connessione = mysql_pconnect($hostname_connessione, $username_connessione, $password_connessione) or trigger_error(mysql_error(),E_USER_ERROR);
?>
mentre la pagina php è questa
codice:
<?php require_once('../Connections/connessione.php'); ?>
<?php
mysql_select_db($database_connessione, $connessione);
$query_Recordset = "SELECT * FROM prodotti";
$Recordset = mysql_query($query_Recordset, $connessione) or die(mysql_error());
$row_Recordset = mysql_fetch_assoc($Recordset);
$totalRows_Recordset = mysql_num_rows($Recordset);
mysql_free_result($Recordset);
?>
<style type="text/css">
<!--
.Stile1 {font-family: Arial, Helvetica, sans-serif}
.Stile3 {font-family: Arial, Helvetica, sans-serif; font-size: 12px; }
.Stile4 {font-size: 10px}
.Stile5 {font-family: Arial, Helvetica, sans-serif; font-size: 10px; }
.Stile6 {
font-size: 12px;
font-weight: bold;
}
.Stile8 {font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-weight: bold; }
-->
</style>
<p align="center">[img]images/lafabbrica.jpg[/img]</p>
<table border="1" align="center" bordercolor="#FFFFFF" bgcolor="#FFFFFF">
<tr bgcolor="#CCCCCC">
<td class="Stile1 Stile6">Codice Prodotto</td>
<td><span class="Stile8">Categoria</span></td>
<td><span class="Stile8">Prodotto</span></td>
<td><span class="Stile8">Marca</span></td>
<td><span class="Stile8">Quantità</span></td>
<td><span class="Stile8">Prezzo</span></td>
<td><span class="Stile8">Gestore</span></td>
</tr>
<?php do { ?>
<tr>
<td> <?php echo $row_Recordset['codProdotto']; ?> </td>
<td> <span class="Stile5"><?php echo $row_Recordset['Categoria']; ?> </span></td>
<td> <span class="Stile5"><?php echo $row_Recordset['Prodotto']; ?> </span></td>
<td> <span class="Stile5"><?php echo $row_Recordset['marca']; ?> </span></td>
<td> <span class="Stile5"><?php echo $row_Recordset['quantit']; ?> </span></td>
<td> <span class="Stile5"><?php echo $row_Recordset['Prezzo']; ?> </span></td>
<td> <span class="Stile5"><?php echo $row_Recordset['gestore']; ?> </span></td>
</tr>
<?php } while ($row_Recordset = mysql_fetch_assoc($Recordset)); ?>
</table>
<span class="Stile3"><?php echo $totalRows_Recordset ?> Record da Totale
</span>