Codice PHP:
<?php require_once('../Connections/Prova.php'); ?>
<?php require_once('Connections/Prova.php'); ?>
<?php
mysql_select_db($database_Prova, $Prova);
$query_Recordset2 = "SELECT clienti.Cod_cliente FROM clienti WHERE clienti.Cod_cliente";
$Recordset2 = mysql_query($query_Recordset2, $Prova) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysql_num_rows($Recordset2);
$maxRows_Recordset1 = 10;
$pageNum_Recordset1 = 0;
if (isset($_GET['pageNum_Recordset1'])) {
$pageNum_Recordset1 = $_GET['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;
mysql_select_db($database_Prova, $Prova);
$query_Recordset1 = "SELECT clienti.Cod_cliente, clienti.Cliente FROM clienti";
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $Prova) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
if (isset($_GET['totalRows_Recordset1'])) {
$totalRows_Recordset1 = $_GET['totalRows_Recordset1'];
} else {
$all_Recordset1 = mysql_query($query_Recordset1);
$totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;
$maxRows_Recordset3 = 20;
$pageNum_Recordset3 = 0;
if (isset($_GET['pageNum_Recordset3'])) {
$pageNum_Recordset3 = $_GET['pageNum_Recordset3'];
}
$startRow_Recordset3 = $pageNum_Recordset3 * $maxRows_Recordset3;
$lavori_Recordset3 = "clientiid";
if (isset(cod_cliente)) {
$lavori_Recordset3 = (get_magic_quotes_gpc()) ? cod_cliente : addslashes(cod_cliente);
}
mysql_select_db($database_Prova, $Prova);
$query_Recordset3 = sprintf("SELECT %s.Cod_lavoro, %s.Data_inserimento, %s.Clientiid, %s.Incarico, %s.Collaboratoriid, FROM %s, clienti WHERE clienti.Cod_cliente", $lavori_Recordset3,$lavori_Recordset3,$lavori_Recordset3,$lavori_Recordset3,$lavori_Recordset3,$lavori_Recordset3);
$query_limit_Recordset3 = sprintf("%s LIMIT %d, %d", $query_Recordset3, $startRow_Recordset3, $maxRows_Recordset3);
$Recordset3 = mysql_query($query_limit_Recordset3, $Prova) or die(mysql_error());
$row_Recordset3 = mysql_fetch_assoc($Recordset3);
if (isset($_GET['totalRows_Recordset3'])) {
$totalRows_Recordset3 = $_GET['totalRows_Recordset3'];
} else {
$all_Recordset3 = mysql_query($query_Recordset3);
$totalRows_Recordset3 = mysql_num_rows($all_Recordset3);
}
$totalPages_Recordset3 = ceil($totalRows_Recordset3/$maxRows_Recordset3)-1;
$maxRows_DetailRS1 = 10;
$pageNum_DetailRS1 = 0;
if (isset($_GET['pageNum_DetailRS1'])) {
$pageNum_DetailRS1 = $_GET['pageNum_DetailRS1'];
}
$startRow_DetailRS1 = $pageNum_DetailRS1 * $maxRows_DetailRS1;
mysql_select_db($database_Prova, $Prova);
$recordID = $_GET['recordID'];
$query_DetailRS1 = "SELECT clienti.Cod_cliente, clienti.Cliente, clienti.Sede_legale, clienti.`Data`, clienti.Note FROM clienti WHERE Cod_cliente = '$recordID'";
$query_limit_DetailRS1 = sprintf("%s LIMIT %d, %d", $query_DetailRS1, $startRow_DetailRS1, $maxRows_DetailRS1);
$DetailRS1 = mysql_query($query_limit_DetailRS1, $Prova) or die(mysql_error());
$row_DetailRS1 = mysql_fetch_assoc($DetailRS1);
if (isset($_GET['totalRows_DetailRS1'])) {
$totalRows_DetailRS1 = $_GET['totalRows_DetailRS1'];
} else {
$all_DetailRS1 = mysql_query($query_DetailRS1);
$totalRows_DetailRS1 = mysql_num_rows($all_DetailRS1);
}
$totalPages_DetailRS1 = ceil($totalRows_DetailRS1/$maxRows_DetailRS1)-1;
$queryString_Recordset1 = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_Recordset1") == false &&
stristr($param, "totalRows_Recordset1") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_Recordset1 = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_Recordset1 = sprintf("&totalRows_Recordset1=%d%s", $totalRows_Recordset1, $queryString_Recordset1);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Gestione lavori</title>
<meta http-equiv="Content-Type"
content="text/html; charset=iso-8859-1" />
<style type="text/css">
<!--
body {
background-color: #CCCCCC;
}
#Layer1 {
position:absolute;
left:266px;
top:181px;
width:682px;
height:531px;
z-index:1;
background-color: #FFFFFF;
overflow: visible;
right: 20%;
bottom: auto;
vertical-align: middle;
background-position: center center;
visibility: visible;
}
.Stile1 {color: #FF0000}
#Layer2 {
position:absolute;
left:554px;
top:233px;
width:630px;
height:291px;
z-index:1;
background-color: #FFFFFF;
right: auto;
}
-->
</style></head>
<body>
<h1 align="center"><span class="Stile1">Gestione Studio</span></h1>
<h1 align="center">Gestione lavori </h1>
<p align="center">
<table border="1" align="center" id="Lavori">
<tr>
<td width="111" bordercolor="#FF0000" bgcolor="#FFFFFF">Codice cliente</td>
<td width="242" bordercolor="#FF0000" bgcolor="#FFFFFF"><?php echo $row_DetailRS1['Cod_cliente']; ?> </td>
</tr>
<tr>
<td bordercolor="#FF0000" bgcolor="#FFFFFF">Cliente</td>
<td bordercolor="#FF0000" bgcolor="#FFFFFF"><?php echo $row_DetailRS1['Cliente']; ?> </td>
</tr>
<tr>
<td bordercolor="#FF0000" bgcolor="#FFFFFF">Sede legale</td>
<td bordercolor="#FF0000" bgcolor="#FFFFFF"><?php echo $row_DetailRS1['Sede_legale']; ?> </td>
</tr>
<tr>
<td bordercolor="#FF0000" bgcolor="#FFFFFF">Data ingresso </td>
<td bordercolor="#FF0000" bgcolor="#FFFFFF"><?php echo $row_DetailRS1['Data']; ?> </td>
</tr>
<tr>
<td bordercolor="#FF0000" bgcolor="#FFFFFF">Note</td>
<td bordercolor="#FF0000" bgcolor="#FFFFFF"><?php echo $row_DetailRS1['Note']; ?> </td>
</tr>
</table>
<p align="center"></p>
<table border="1" align="center" cellpadding="4" cellspacing="4">
<tr>
<td>Codice lavoro</td>
<td>Incarico</td>
<td>Collaboratore</td>
<td>Data inserimento</td>
</tr>
<?php do { ?>
<tr>
<td><?php echo $row_Recordset3['Cod_lavoro']; ?></td>
<td><?php echo $row_Recordset3['Incarico']; ?></td>
<td><?php echo $row_Recordset3['Collaboratoriid']; ?></td>
<td><?php echo $row_Recordset3['Data_inserimento']; ?></td>
</tr>
<?php } while ($row_Recordset3 = mysql_fetch_assoc($Recordset3)); ?>
</table>
<?php do { ?>
<tr>
</tr>
<?php } while ($row_Recordset3 = mysql_fetch_assoc($Recordset3)); ?>
</table>
<p align="center">[url="newlavoro.php"]Inserisci nuovo lavoro [/url]</p>
</body>
</html>
<?php
mysql_free_result($Recordset3);
?>
Grazie mille per la celerità.
Rispondi quotando