camne nak kira data guna php

putrisakura

actually aku nak kuarkan data cam bawah ni :

CTH :

Nama : Ali

Tarikh        Penerangan                       Bayaran        Jumlah
1/1/09        Bayaran pertama              100                100
1/2/09        Bayaran kedua                   50                150
1/3/09        Bayaran ketiga                  100                250

Masalahnya la ni aku tak tau camne nak kuarkan jumlah tu. data bayaran tu amek dari database la kan. la ni aku nak jumlah automatik kira sendiri. bila masuk row baru, terus kira jumlah tu. misalnye mula2 masuk data bulan 1, bayaran 100, so jumlah bayaran setakat ni adalah 100. Bila masuk bulan 2, bayaran kedua 50, so jumlah 150 la (100(bulan1)+50). tp sebab data bayaran tu repeat region dari database, so camne aku nak kira jumlah tu secara automatik.

Please help me as soon as possible.

slier81

apa yg susahnya..tambah jer la

let say mcm ni

1. <table bla..bla..>
   
2. <tr>
   
3. <td>Tarikh</td><td>Penerangan</td><td>Bayaran</td><td>Jumlah</td>
   
4. </tr>
   
5. 
   
6. <?
   
7. $jumlah='';
   
8. //db stuff goes here
   
9. $result=mysql_query("select * from tableName");
   
10. foreah($result as $data):
    
11. $jumlah+=$data['bayaran'];
    
12. ?>
    
13. 
    
14. <tr>
    
15. <td><?echo$data['tarikh']?></td><td><?echo$data['penerangan']?></td><td><?echo$data['bayaran']?></td><td><?echo$jumlah?></td>
    
16. </tr>

Copy the Code

$data['tarikh'],$data['penerangan'], dan yg lain tu dtg dr database..aku assume tu adalah nama comun dalam database ko..gantikan ngan nama column dr databse ko

[ Last edited by  slier81 at 12-2-2009 12:45 AM ]

putrisakura

sori tapi foreah tu ape? for each ke? aku da try da tapi error tang line foreah tu la.

" foreah($result as $data): "

putrisakura

OK. bawah ni design table aku.
Aku gunakan table transaction. dalam table transaction tu ada column datepaid, description dan transaction (abaikan nama debit dan kredit).
So dalam table tu, setakat ni aku da masukkan data untuk bulan 1 dan bulan 2.




So sepatutnya data yang kuar kat column balance to date macam ni :




Tapi tu la masalahnya, aku xdapat nak kuarkan balance to date yang macam tu. gambar tu aku edit dari skrin asal sebab nak bagi korang paham kan output sebenar yang aku nak. asyik2aku dapat balance to date 1000, 1500 atau 2000, 3000. aku nak 1000,2500. (cth je)

And then, lain kali bila aku masuk data bulan 3, cthnye debit 1000, so balance to date automatik jadik 3500 (1000+2500+1000).

Hope penerangan bergambar aku ni dapat membantu kalian membantu aku.

[ Last edited by  putrisakura at 12-2-2009 01:40 AM ]

slier81

bukan foeah la

foreach la

try guna kod yg aku bg tu..sure boleh jer...small matter jer ni

[ Last edited by  slier81 at 12-2-2009 01:27 AM ]

putrisakura

x menjadik jugak la slier.

error :

Warning: Invalid argument supplied for foreach() in C:\Program Files\xampp\htdocs\mis\print_preview.php on line 150
1000

Warning: Invalid argument supplied for foreach() in C:\Program Files\xampp\htdocs\mis\print_preview.php on line 150
1500

[ Last edited by  putrisakura at 12-2-2009 01:33 AM ]

slier81

mana la nak jadi sbb ko copy seketul....kena la modified...

ko letak kod ko kt cni

putrisakura

<?

$jumlah='';
//db stuff goes here
$result=mysql_query("select * from transaction");
foreach($result as $row_Recordset3);
$jumlah+=$row_Recordset3['transaction'];

echo $jumlah;
?>

slier81

sory my mistake lol

1. <?
   
2. 
   
3. $jumlah='';
   
4. //db stuff goes here
   
5. $result=mysql_query("select * from transaction");
   
6. 
   
7. while($row_Recordset3=mysql_fetch_assoc($result))
   
8. {
   
9. $jumlah+=$row_Recordset3['transaction'];
   
10. 
    
11. }
    
12. 
    
13. echo $jumlah;
    
14. ?>

Copy the Code

putrisakura

terima kasih kerana membantu. dah takde error tapi outputnye salah. saya nakkan output 1000,2500. tapi output yang diperoleh daripada coding awak adalah 4500,4500. tak tau la dari mana 4500 tu ble datang.

how come?

[ Last edited by  putrisakura at 12-2-2009 01:59 AM ]

slier81

mmg la...dh ko echo bila habis loop...

klu nak beza ko kena outputkan nilai pada setiap loop

ko bg full code ko kan senang aku nak usha...iskk bg pn sekerat ja...

putrisakura

ok..sori. my mistakes. ni full coding, ok.

<?php require_once('Connections/mis.php'); ?>
<?php
$colname_Recordset1 = "1";
if (isset($_GET['Name'])) {
  $colname_Recordset1 = (get_magic_quotes_gpc()) ? $_GET['Name'] : addslashes($_GET['Name']);
}
mysql_select_db($database_mis, $mis);
$query_Recordset1 = sprintf("SELECT * FROM investor WHERE Name = '%s'", $colname_Recordset1);
$Recordset1 = mysql_query($query_Recordset1, $mis) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);

$colname_id = "1";
if (isset($_GET['username'])) {
  $colname_id = (get_magic_quotes_gpc()) ? $_GET['username'] : addslashes($_GET['username']);
}
mysql_select_db($database_mis, $mis);
$query_id = sprintf("SELECT * FROM `user` WHERE username = '%s'", $colname_id);
$id = mysql_query($query_id, $mis) or die(mysql_error());
$row_id = mysql_fetch_assoc($id);
$totalRows_id = mysql_num_rows($id);

$colname_Recordset2 = "1";
if (isset($_GET['id'])) {
  $colname_Recordset2 = (get_magic_quotes_gpc()) ? $_GET['id'] : addslashes($_GET['id']);
}
mysql_select_db($database_mis, $mis);
$query_Recordset2 = sprintf("SELECT * FROM rate WHERE id = '%s'", $colname_Recordset2);
$Recordset2 = mysql_query($query_Recordset2, $mis) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysql_num_rows($Recordset2);

$colname_Recordset3 = "1";
if (isset($_GET['ID'])) {
  $colname_Recordset3 = (get_magic_quotes_gpc()) ? $_GET['ID'] : addslashes($_GET['ID']);
}
mysql_select_db($database_mis, $mis);
$query_Recordset3 = sprintf("SELECT * FROM `transaction` WHERE ID = '%s' ORDER BY id_investor ASC", $colname_Recordset3);
$Recordset3 = mysql_query($query_Recordset3, $mis) or die(mysql_error());
$row_Recordset3 = mysql_fetch_assoc($Recordset3);
$totalRows_Recordset3 = mysql_num_rows($Recordset3);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Preview</title>
<meta http-equiv="Content-Type" c>
<style type="text/css">
<!--
.style3 {font-family: Arial, Helvetica, sans-serif; font-size: 12px; }
.style6 {
    font-family: Arial, Helvetica, sans-serif;
    font-size: 24px;
    font-weight: bold;
}
.style15 {font-family: Arial, Helvetica, sans-serif; font-size: 14px; }
.style17 {font-family: Arial, Helvetica, sans-serif; font-size: 14px; font-weight: bold; }
.style18 {color: #FF0000}
-->
</style>
<script type="text/javascript">
function cetak(){
window.print()
}
</script>

</head>

<body>
<form name="form1" method="post" action="">
  <table width="1077" height="680" border="1" align="center" cellpadding="1" cellspacing="0" bordercolor="#333333">
    <tr>
      <td width="1071" height="76" align="center" valign="middle"><div align="center">
          <p class="style6">RS CAPITAL HOLDING BERHAD</p>
      </div></td>
    </tr>
    <tr>
      <td height="26"><div align="center" class="style3"><strong>Statement of Dividen Payment </strong></div></td>
    </tr>
    <tr>
      <td valign="top"><table width="1066" border="0" cellspacing="0" cellpadding="1">
        <tr>
          <td width="81" height="59"> </td>
          <td width="6"> </td>
          <td colspan="4"> </td>
          <td width="46"><span class="style17">Date</span></td>
          <td width="9"><span class="style17"> :</span></td>
          <td width="160"><?php print  date("d"); ?> / <?php print  date("m"); ?> / <?php print  date("Y"); ?> </td>
        </tr>
        <tr>
          <td><span class="style17">Name</span></td>
          <td><span class="style17">:</span></td>
          <td width="242"><span class="style15"><?php echo $row_Recordset1['Name']; ?></span></td>
          <td width="124"><span class="style17">I/C No. </span></td>
          <td width="5"><span class="style17">:</span></td>
          <td width="375"><span class="style15"><?php echo $row_Recordset1['IC']; ?></span></td>
          <td colspan="3"> </td>
        </tr>
        <tr>
          <td><span class="style17">Address</span></td>
          <td><span class="style17">:</span></td>
          <td><span class="style15"><?php echo $row_Recordset1['Address']; ?></span></td>
          <td><span class="style17">ID No. </span></td>
          <td><span class="style17">:</span></td>
          <td><span class="style15"><?php echo $row_Recordset1['ID']; ?></span></td>
          <td colspan="3"> </td>
        </tr>
        <tr>
          <td> </td>
          <td> </td>
          <td> </td>
          <td><span class="style17">Date Registered </span></td>
          <td><span class="style17">:</span></td>
          <td><span class="style15"><?php echo $row_Recordset1['Date_registered']; ?></span></td>
          <td colspan="3"> </td>
        </tr>
        <tr>
          <td> </td>
          <td> </td>
          <td> </td>
          <td><span class="style17">Principle</span></td>
          <td><span class="style17">:</span></td>
          <td><span class="style15"><?php echo $row_Recordset1['Amount']; ?></span></td>
          <td colspan="3"> </td>
        </tr>
      </table>        
        <p> </p>        <table width="872" border="1" cellpadding="1" cellspacing="0" bordercolor="#333333">
          <tr>
            <td width="122"><span class="style17">Date</span></td>
            <td width="166"><span class="style17">Decription</span></td>
            <td width="186"> </td>
            <td width="123"><span class="style17">Debit</span></td>
            <td width="101"><span class="style17">Credit</span></td>
            <td width="148"><span class="style17">Balance to date </span></td>
          </tr>
          <?php if ($totalRows_Recordset3 > 0) { // Show if recordset not empty ?>
          <?php do { ?>
          <tr>
            <td><span class="style15"><?php echo $row_Recordset3['datepaid']; ?></span></td>
            <td><span class="style15"><?php echo $row_Recordset3['description']; ?></span></td>
            <td> </td>
            <td><span class="style15"><?php echo $row_Recordset3['transaction']; ?></span></td>
            <td> </td>
            <td>
<?

$jumlah='';
//db stuff goes here
$result=mysql_query("select * from transaction");

while($row_Recordset3=mysql_fetch_assoc($result))
{
$jumlah+=$row_Recordset3['transaction'];

}

echo $jumlah;
?>
            
            </td>
          </tr>
          <?php } while ($row_Recordset3 = mysql_fetch_assoc($Recordset3)); ?>
          <?php } // Show if recordset not empty ?>
          <?php if ($totalRows_Recordset3 == 0) { // Show if recordset empty ?>
          <tr>
            <td colspan="6"><div align="center" class="style15 style18">No payment yet </div></td>
          </tr>
          <?php } // Show if recordset empty ?>
        </table>        <p> </p>
        <p> </p>
        <p> </p>
          <p> </p>
          <p class="style3"> </p>
          <p class="style3"> </p></td>
    </tr>
  </table>
  <p align="center">
    <input name="Cetak" type="submit" id="Cetak" value="Cetak" >
  </p>
</form>
<p align="center"><span class="style15">
  <input name="Kembali" type="submit" id="Kembali3" value="Kembali" onclick=javascript:history.go(-1)>
</span></p>
<p> </p>
</body>
</html>
<?php
mysql_free_result($Recordset1);

mysql_free_result($id);

mysql_free_result($Recordset2);

mysql_free_result($Recordset3);
?>

slier81

adeh la..teruknya markup....susah gila nak baca..

try kod yg ni

1. 
   
2. <?php require_once('Connections/mis.php'); ?>
   
3. <?php
   
4. $colname_Recordset1 = "1";
   
5. if (isset($_GET['Name'])) {
   
6.   $colname_Recordset1 = (get_magic_quotes_gpc()) ? $_GET['Name'] : addslashes($_GET['Name']);
   
7. }
   
8. mysql_select_db($database_mis, $mis);
   
9. $query_Recordset1 = sprintf("SELECT * FROM investor WHERE Name = '%s'", $colname_Recordset1);
   
10. $Recordset1 = mysql_query($query_Recordset1, $mis) or die(mysql_error());
    
11. $row_Recordset1 = mysql_fetch_assoc($Recordset1);
    
12. $totalRows_Recordset1 = mysql_num_rows($Recordset1);
    
13. 
    
14. $colname_id = "1";
    
15. if (isset($_GET['username'])) {
    
16.   $colname_id = (get_magic_quotes_gpc()) ? $_GET['username'] : addslashes($_GET['username']);
    
17. }
    
18. mysql_select_db($database_mis, $mis);
    
19. $query_id = sprintf("SELECT * FROM `user` WHERE username = '%s'", $colname_id);
    
20. $id = mysql_query($query_id, $mis) or die(mysql_error());
    
21. $row_id = mysql_fetch_assoc($id);
    
22. $totalRows_id = mysql_num_rows($id);
    
23. 
    
24. $colname_Recordset2 = "1";
    
25. if (isset($_GET['id'])) {
    
26.   $colname_Recordset2 = (get_magic_quotes_gpc()) ? $_GET['id'] : addslashes($_GET['id']);
    
27. }
    
28. mysql_select_db($database_mis, $mis);
    
29. $query_Recordset2 = sprintf("SELECT * FROM rate WHERE id = '%s'", $colname_Recordset2);
    
30. $Recordset2 = mysql_query($query_Recordset2, $mis) or die(mysql_error());
    
31. $row_Recordset2 = mysql_fetch_assoc($Recordset2);
    
32. $totalRows_Recordset2 = mysql_num_rows($Recordset2);
    
33. 
    
34. $colname_Recordset3 = "1";
    
35. if (isset($_GET['ID'])) {
    
36.   $colname_Recordset3 = (get_magic_quotes_gpc()) ? $_GET['ID'] : addslashes($_GET['ID']);
    
37. }
    
38. mysql_select_db($database_mis, $mis);
    
39. $query_Recordset3 = sprintf("SELECT * FROM `transaction` WHERE ID = '%s' ORDER BY id_investor ASC", $colname_Recordset3);
    
40. $Recordset3 = mysql_query($query_Recordset3, $mis) or die(mysql_error());
    
41. $row_Recordset3 = mysql_fetch_assoc($Recordset3);
    
42. $totalRows_Recordset3 = mysql_num_rows($Recordset3);
    
43. ?>
    
44. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    
45. <html>
    
46. <head>
    
47. <title>Preview</title>
    
48. <meta http-equiv="Content-Type" c>
    
49. <style type="text/css">
    
50. <!--
    
51. .style3 {font-family: Arial, Helvetica, sans-serif; font-size: 12px; }
    
52. .style6 {
    
53.     font-family: Arial, Helvetica, sans-serif;
    
54.     font-size: 24px;
    
55.     font-weight: bold;
    
56. }
    
57. .style15 {font-family: Arial, Helvetica, sans-serif; font-size: 14px; }
    
58. .style17 {font-family: Arial, Helvetica, sans-serif; font-size: 14px; font-weight: bold; }
    
59. .style18 {color: #FF0000}
    
60. -->
    
61. </style>
    
62. <script type="text/javascript">
    
63. function cetak(){
    
64. window.print()
    
65. }
    
66. </script>
    
67. 
    
68. </head>
    
69. 
    
70. <body>
    
71. <form name="form1" method="post" action="">
    
72.   <table width="1077" height="680" border="1" align="center" cellpadding="1" cellspacing="0" bordercolor="#333333">
    
73.     <tr>
    
74.       <td width="1071" height="76" align="center" valign="middle"><div align="center">
    
75.           <p class="style6">RS CAPITAL HOLDING BERHAD</p>
    
76.       </div></td>
    
77.     </tr>
    
78.     <tr>
    
79.       <td height="26"><div align="center" class="style3"><strong>Statement of Dividen Payment </strong></div></td>
    
80.     </tr>
    
81.     <tr>
    
82.       <td valign="top"><table width="1066" border="0" cellspacing="0" cellpadding="1">
    
83.         <tr>
    
84.           <td width="81" height="59"> </td>
    
85.           <td width="6"> </td>
    
86.           <td colspan="4"> </td>
    
87.           <td width="46"><span class="style17">Date</span></td>
    
88.           <td width="9"><span class="style17"> :</span></td>
    
89.           <td width="160"><?php print  date("d"); ?> / <?php print  date("m"); ?> / <?php print  date("Y"); ?> </td>
    
90.         </tr>
    
91.         <tr>
    
92.           <td><span class="style17">Name</span></td>
    
93.           <td><span class="style17">:</span></td>
    
94.           <td width="242"><span class="style15"><?php echo $row_Recordset1['Name']; ?></span></td>
    
95.           <td width="124"><span class="style17">I/C No. </span></td>
    
96.           <td width="5"><span class="style17">:</span></td>
    
97.           <td width="375"><span class="style15"><?php echo $row_Recordset1['IC']; ?></span></td>
    
98.           <td colspan="3"> </td>
    
99.         </tr>
    
100.         <tr>
     
101.           <td><span class="style17">Address</span></td>
     
102.           <td><span class="style17">:</span></td>
     
103.           <td><span class="style15"><?php echo $row_Recordset1['Address']; ?></span></td>
     
104.           <td><span class="style17">ID No. </span></td>
     
105.           <td><span class="style17">:</span></td>
     
106.           <td><span class="style15"><?php echo $row_Recordset1['ID']; ?></span></td>
     
107.           <td colspan="3"> </td>
     
108.         </tr>
     
109.         <tr>
     
110.           <td> </td>
     
111.           <td> </td>
     
112.           <td> </td>
     
113.           <td><span class="style17">Date Registered </span></td>
     
114.           <td><span class="style17">:</span></td>
     
115.           <td><span class="style15"><?php echo $row_Recordset1['Date_registered']; ?></span></td>
     
116.           <td colspan="3"> </td>
     
117.         </tr>
     
118.         <tr>
     
119.           <td> </td>
     
120.           <td> </td>
     
121.           <td> </td>
     
122.           <td><span class="style17">Principle</span></td>
     
123.           <td><span class="style17">:</span></td>
     
124.           <td><span class="style15"><?php echo $row_Recordset1['Amount']; ?></span></td>
     
125.           <td colspan="3"> </td>
     
126.         </tr>
     
127.       </table>        
     
128.         <p> </p>
     
129.         
     
130.         <table width="872" border="1" cellpadding="1" cellspacing="0" bordercolor="#333333">
     
131.         
     
132.           <tr>
     
133.             <td width="122"><span class="style17">Date</span></td>
     
134.             <td width="166"><span class="style17">Decription</span></td>
     
135.             <td width="186">Transaction</td>
     
136.             <td width="123"><span class="style17">Debit</span></td>
     
137.             <td width="101"><span class="style17">Credit</span></td>
     
138.             <td width="148"><span class="style17">Balance to date </span></td>
     
139.           </tr>
     
140.          
     
141.           <?php if ($totalRows_Recordset3 > 0):?>
     
142.               <?$jumlah=0;
     
143.                while($row_Recordset3 = mysql_fetch_assoc($Recordset3)):
     
144.                $jumlah+=$row_Recordset3['transaction'];
     
145.                ?>
     
146.               
     
147.               <tr>
     
148.                 <td><span class="style15"><?php echo $row_Recordset3['datepaid']; ?></span></td>
     
149.                 <td><span class="style15"><?php echo $row_Recordset3['description']; ?></span></td>
     
150.                 <td> Transaction</td>
     
151.                 <td><span class="style15"><?php echo $row_Recordset3['transaction']; ?></span></td>
     
152.                 <td>sdfsfsdfsfs </td>
     
153.                
     
154.                 <td><?echo $jumlah;?></td>
     
155.             
     
156.           </tr>
     
157.           <?php endwhile;?>
     
158.          
     
159.           <?endif; ?>
     
160.          
     
161.          
     
162.           <?php if ($totalRows_Recordset3 == 0): // Show if recordset empty ?>
     
163.               <tr>
     
164.                 <td colspan="6"><div align="center" class="style15 style18">No payment yet </div></td>
     
165.               </tr>
     
166.           <?endif;?>
     
167.          
     
168.         </table>
     
169.         
     
170.               <p> </p>
     
171.         <p> </p>
     
172.         <p> </p>
     
173.           <p> </p>
     
174.           <p class="style3"> </p>
     
175.           <p class="style3"> </p></td>
     
176.     </tr>
     
177.   </table>
     
178.   <p align="center">
     
179.     <input name="Cetak" type="submit" id="Cetak" value="Cetak" >
     
180.   </p>
     
181. </form>
     
182. <p align="center"><span class="style15">
     
183.   <input name="Kembali" type="submit" id="Kembali3" value="Kembali" onclick=javascript:history.go(-1)>
     
184. </span></p>
     
185. <p> </p>
     
186. </body>
     
187. 
     
188. </html>
     
189. <?php
     
190. mysql_free_result($Recordset1);
     
191. 
     
192. mysql_free_result($id);
     
193. 
     
194. mysql_free_result($Recordset2);
     
195. 
     
196. mysql_free_result($Recordset3);
     
197. ?>
     

Copy the Code

putrisakura

tak jadik jugak la.

jadik satu row je yg kuar.

putrisakura

Ok sekarang ni, coding yang aku gunakan adalah macam ni :

<?
$jum='';
//db stuff goes here
$result=mysql_query("select * from transaction");
while ($row = mysql_fetch_array($result))
{
$bayar = $row_Recordset3['transaction'];
$jum = $jum + $bayar;
}

echo $jum;

?>

Output yang kuar macam ni :



macam dah ok sket, cuma kenape keluar 3000 kat first row tu? sepatutnya 1000 kan? and 4500 tu rasanya datang dari 3000+1500. that should be ok. if the first row output at balance to date  is 1000, so supposely the right output 2500(1000+1500) should be come out, right?

The right output at balance to date should be 1000, 2500.

BorderManager

<?
$jum='';
//db stuff goes here
$result=mysql_query("select * from transaction");
while ($row = mysql_fetch_array($result))
{
echo $bayar = $row['transaction']; // n balance utk setiap row
$jum = $jum + $bayar;
}

echo $jum; // n patutu grand total balance



?>

putrisakura

Originally posted by BorderManager at 12-2-2009 11:05 PM

<?
$jum='';
//db stuff goes here
$result=mysql_query("select * from transaction");
while ($row = mysql_fetch_array($result))
{
echo $bayar = $row['transaction']; // n balance utk setiap row
$jum = $jum + $bayar;
}

echo $jum; // n patutu grand total balance
?>

Tak jadik la guna coding ni.Outputnya jadik camni :

putrisakura

Aku takut korang tak paham masalah aku ni, so aku letakkan analogi yang mudah difahami sket.

Tambah nilai rows 1 and 2 to row 2, then add values in rows 2 and 3 to row 3, etc.

Example:
Row 1  10     Remain 10
Row 2    2     Would become 12
Row 3    4     Would become 16
Row 4  12     Would become  28

Ada boleh kah?

BorderManager

<?
$jum='';
//db stuff goes here
$result=mysql_query("select * from transaction");
while ($row = mysql_fetch_array($result))
{
echo $bayar = $row['transaction'];
echo $jum+= $bayar;
}

?>

putrisakura

Still tak menjadi jugak.