Volentieri.
Grazie ancora...
Il programma si chiama mod_spese.php
Codice PHP:
<?php
session_start();
$cod_cond = $_SESSION['cod_cond'];
$Denominazione = $_SESSION['Denominazione'];
$user_id=$_SESSION['user_id'];
$nick=$_SESSION['nick'];
//echo "sono ---> $nick --> $user_id";
//echo "Ecco i risultati mod_condomino -- $cod_cond -- $Denominazione ";
require ("conf.php");
require ("testa.php");
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN">
<html>
<head>
<title>Modifica Spese</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="GENERATOR" content="Quanta Plus">
<style type="text/css">
input {font-size:10pt;}</style>
</head>
<?php
$id_spese=$_GET['id'];
$connessione = mysql_connect($server,$utente,$password) or die
("Non riesco a connettermi al database".mysql_error());
mysql_select_db($datab,$connessione);
$s = mysql_query("select * from spese where id_spese = '$id_spese' and cod_cond_spese = '$cod_cond'");
$ref = mysql_fetch_row($s);
if ($ref != null)
{
$id_spese = $ref['0'];
$anno_comp = $ref['2'];
$fabbricato = $ref['3'];
$scala = $ref['4'];
$tipo_riparto = $ref['6'];
$categoria_spesa = $ref['7'];
$tipo_doc = $ref['8'];
$data_doc = $ref['9'];
$numero = $ref['10'];
$impon = $ref['11'];
$iva = $ref['12'];
$rit_acc = $ref['13'];
$CNPAIA_dec = $ref['14'];
$totale = $ref['15'];
$id_fornitore = $ref['16'];
$tipo_spese = $ref['17'];
$data_scaden = $ref['18'];
$data_pagam = $ref['19'];
$tipo_pag = $ref['20'];
$rif_pag = $ref['21'];
$acc = $ref['22'];
}
?>
[b]Modifica Spese[/b]
<form action="agg_spese.php" method="post">
<table width='100%' border='0' colspan='2'><tr><td width='50%'>
<table width='95%' border='1' bgcolor='#ddd888'></td>
<td style='font size:14pt' align='center' colspan='2' bgcolor='#bbb555'>[b]Dati Immobile[/b]</td><tr>
<td style='font size:14pt'>[b]Fabbricato (spazio=tutti)[/b]</td>
<td style='font size:14pt'><input type='text' name='fabbricato' value="<?php echo $fabbricato;?>"size=5 maxlength=3 alt='fabbricato' align='left'<tr>
<td style='font size:14pt'>[b]Scala (spazio=tutti)[/b]</td>
<td style='font size:14pt'><input type='text' name='scala' size=5 value="<?php echo $scala;?>"maxlength=5 alt='scala' align='left'<tr>
<td style='font size:14pt' align='center' colspan='2' bgcolor='#bbb555'>[b]Dati di riparto[/b]</td><tr>
<td style='font size:14pt'>[b]Anno competenza[/b]</td>
<td style='font size:14pt'><input type='text' name='anno' value="<?php echo $anno_comp;?>"size=4 maxlength=4 alt='anno' align='left'<tr>
<td style='font size:14pt'>[b]Tipo Riparto[/b]</td>
<td><select name='tipo_riparto' style='font-size:10pt'>
<option><?php echo $tipo_riparto;?></option>
<option value="P">Proprieta</option>
<option value="A">Acqua</option>
<option value="S">Supercondominio</option>
</select></td><tr>
<td style='font size:14pt'>[b]Categoria spesa[/b]</td>
<td><select name='categoria_spesa' style='font-size:10pt'>
<option><?php echo $categoria_spesa;?></option>
<option value="P">Preventivo</option>
<option value="C">Consuntivo</option>
</select></td><tr>
<td style='font size:14pt'>[b]Tipo Spesa[/b]</td>
-->
<?php
// connessione e selezione db
$link = mysql_connect($server,$utente,$password)
or die
("
[b]Non posso connettrmi al Server[/b]
".mysql_error());
$conn=mysql_select_db($datab, $link) or die("
[b]Non riesco a connettermi al Database.[/b]
".mysql_error());
$result = mysql_query("select * from tipo_spese order by descrizione_tipi_spese");
$result = mysql_query($sql);
echo"<td><select name='Tipo Spesa'>";
while($row = mysql_fetch_array($row))
{
if($tipo_spese==$row['id_tipo_spese'])
{
echo "<option value=\"{$row['id_tipo_spese']}\" $selected>{$row['descrizione_tipi_spese']}</option></td>";
}
echo "<option value=\"$row['id_tipo_spese']\">$row['descrizione_tipi_spese']</option>";
}
echo "</select><tr>";
?>
<td style='font size:14pt' align='center' colspan='2'bgcolor='#bbb555'>[b]Dati Pagamento[/b]</td><tr>
<td style='font size:14pt'>[b]Data Pagamento[/b]</td>
<td><input name="data_pag" onkeyup="if((this.value.length==2||this.value.length==5)&&event.keyCode!=8&&event.keyCode!=46){this.value=this.value+'/';}" /></td><tr></tr>
<!--
<td style='font size:14pt'><input type='text' name='data_pag' size=11 maxlength=10 alt='data_pag' align='left'<tr>
-->
<td style='font size:14pt'>[b]Tipo Pagamento[/b]</td>
<?php
// connessione e selezione db
$link = mysql_connect($server,$utente,$password)
or die
("
[b]Non posso connettrmi al Server[/b]
".mysql_error());
$conn=mysql_select_db($datab, $link) or die("
[b]Non riesco a connettermi al Database.[/b]
".mysql_error());
$result = mysql_query("select * from tipo_incassi order by descrizione_tipi_incassi");
echo "<td><select name='tipo_pag' style='font-size:10pt'>";
while ($row = mysql_fetch_array($result))
{
$selected=($tipo_pag == $row['descrizione_tipi_incassi'])?'selected':'';
echo "<option value=\"{$row['id_tipo_incassi']}\" $selected>{$row['descrizione_tipi_incassi']}</option>";
}
echo "</select><tr>";
?>
<td style='font size:14pt'>[b]Riferimento.[/b]</td>
<td style='font size:14pt'><input type='text' name='rif_pag' value="<?php echo $rif_pag;?>" size=25 maxlength=20 alt='rif_pag' align='left'<tr>
<td style='font size:14pt'>[b]Acconto[/b]</td>
<td style='font size:14pt'><input type='text' name='acconto' value="<?php echo $acc;?>" size=12 maxlength=11 alt='acconto' align='left'<tr>
</table></td>
<td align='center'>
<table width='100%' border='1' bgcolor='#ddd888'><tr>
<td style='font size:14pt' align='center' colspan='2' bgcolor='#bbb555'>[b]Dati Fattura/Documento[/b]</td><tr>
<td style='font size:12pt'>[b]Data[/b]</td>
<td><input name="data_ft" onkeyup="if((this.value.length==2||this.value.length==5)&&event.keyCode!=8&&event.keyCode!=46){this.value=this.value+'/';}" value="<?php echo $data_doc;?>"/></td><tr></tr>
<!--
<td style='font size:14pt'><input type='text' name='data_ft' size=11 maxlength=10 alt='data_ft' align='left'<tr>
-->
<td style='font size:14pt'>[b]Numero[/b]</td>
<td style='font size:14pt'><input type='text' name='numero' value="<?php echo $numero;?>"size=18 maxlength=15 alt='numero' align='left'<tr>
<td style='font size:14pt'>[b]Tipo documento[/b]</td>
<td><select name='tipo_doc' value="<?php echo $tipo_doc;?>"style='font-size:10pt'>
<option value="F">Fattura</option>
<option value="N">Nota Credito</option>
<option value="S">Scontrino fisc.</option>
<option value="A">Altro</option>
</select></td><tr>
<td style='font size:14pt'>[b]Fornitore.[/b]</td>
<?php
// connessione e selezione db
$link = mysql_connect($server,$utente,$password)
or die
("
[b]Non posso connettrmi al Server[/b]
".mysql_error());
$conn=mysql_select_db($datab, $link) or die("
[b]Non riesco a connettermi al Database.[/b]
".mysql_error());
$result = mysql_query("select * from fornitori order by ragione_sociale");
echo "<td><select name='fornitore' style='font-size:10pt'>";
while ($row = mysql_fetch_array($result))
{
$selected=($fornitore == $row['ragione_sociale'])?'selected':'';
echo "<option value=\"{$row['id_fornitore']}\" $selected>{$row['ragione_sociale']}</option>";
}
echo "</select><tr>";
?>
<td style='font size:14pt'>[b]Imponibile.[/b]</td>
<td style='font size:14pt'><input type='text' name='imponibile' value="<?php echo $impon;?>"size=12 maxlength=11 alt='imponibile' align='left'<tr>
<td style='font size:14pt'>[b]Iva[/b]</td>
<td style='font size:14pt'><input type='text' name='iva' value="<?php echo $iva;?>" size=12 maxlength=11 alt='iva' align='left'<tr>
<td style='font size:14pt'>[b]Ritenuta d'acconto.[/b]</td>
<td style='font size:14pt'><input type='text' name='rit_acconto' value="<?php echo $rit_acc;?>"size=12 maxlength=11 alt='rit_acconto' align='left'<tr>
<td style='font size:14pt'>[b]CNPAIA[/b]</td>
<td style='font size:14pt'><input type='text' name='CNPAIA' value="<?php echo $CNPAIA;?>"size=12 maxlength=11 alt='CNPAIA' align='left'<tr>
<td style='font size:14pt'>[b]Totale Documento[/b]</td>
<td style='font size:14pt'><input type='text' name='totale_doc' value="<?php echo $totale;?>"size=12 maxlength=11 alt='totale_doc' align='left'<tr>
<td style='font size:14pt'>[b]Data scadenza[/b]</td>
<td><input name="data_scad" onkeyup="if((this.value.length==2||this.value.length==5)&&event.keyCode!=8&&event.keyCode!=46){this.value=this.value+'/';}" value="<?php echo $data_scaden;?>"/></td><tr></tr>
<!--
<td style='font size:14pt'><input type='text' name='data_scad' size=11 maxlength=10 alt='data_scad' align='left'<tr>
-->
<td style='font size:14pt'></td><td></td></tr>
<td style='font size:14pt'></td><td></td></tr></table></table>
<div align="center">
<hr>
<table align='left' width="100%">
<td>[b][url='menu.php']Torna al menu[/url][/b]</td>
<td align='center'>[url="javascript:history.back();"][b]Torna indietro[/b][/url]</td>
<!--<?php echo"<td>[b]<a href=\"situaz_contabile_anag.php?id_anag=$id_anag\">Situazione contabile</a>[/b]</td>";?>
-->
<td><input type="submit" name="Aggiorna" value="Aggiorna"/>
</td>
</table>
</html>
Un po' lungo.....
Rispondi quotando