Forum › Internet Service & Networking › camne nak kira data guna php

putrisakura Publish time 12-2-2009 12:02 AM

camne nak kira data guna php

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 Publish time 12-2-2009 12:41 AM

apa yg susahnya..tambah jer la

let say mcm ni<table bla..bla..>
<tr>
<td>Tarikh</td><td>Penerangan</td><td>Bayaran</td><td>Jumlah</td>
</tr>

<?
$jumlah='';
//db stuff goes here
$result=mysql_query("select * from tableName");
foreah($result as $data):
$jumlah+=$data['bayaran'];
?>

<tr>
<td><?echo$data['tarikh']?></td><td><?echo$data['penerangan']?></td><td><?echo$data['bayaran']?></td><td><?echo$jumlah?></td>
</tr>$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 byslier81 at 12-2-2009 12:45 AM ]

putrisakura Publish time 12-2-2009 12:54 AM

Balas #2 slier81\ catat

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

" foreah($result as $data): "

putrisakura Publish time 12-2-2009 01:23 AM

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.

http://img216.imageshack.us/img216/2594/designmj2.jpg
http://img216.imageshack.us/img216/designmj2.jpg/1/w640.png

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

http://img410.imageshack.us/img410/4258/sepatutnyafs5.jpg
http://img410.imageshack.us/img410/sepatutnyafs5.jpg/1/w640.png

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 byputrisakura at 12-2-2009 01:40 AM ]

slier81 Publish time 12-2-2009 01:25 AM

bukan foeah la

foreach la

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

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

putrisakura Publish time 12-2-2009 01:28 AM

Balas #5 slier81\ catat

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 byputrisakura at 12-2-2009 01:33 AM ]

slier81 Publish time 12-2-2009 01:40 AM

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

ko letak kod ko kt cni

putrisakura Publish time 12-2-2009 01:41 AM

<?

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

echo $jumlah;
?>

slier81 Publish time 12-2-2009 01:52 AM

Balas #8 putrisakura\ catat

sory my mistake lol
<?

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

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

}

echo $jumlah;
?>

putrisakura Publish time 12-2-2009 01:55 AM

Balas #9 slier81\ catat

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?:L

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

slier81 Publish time 12-2-2009 01:57 AM

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 Publish time 12-2-2009 02:00 AM

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 printdate("d"); ?> / <?php printdate("m"); ?> / <?php printdate("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 Publish time 12-2-2009 02:27 AM

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

try kod yg ni



<?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 printdate("d"); ?> / <?php printdate("m"); ?> / <?php printdate("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">Transaction</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):?>
            <?$jumlah=0;
               while($row_Recordset3 = mysql_fetch_assoc($Recordset3)):
               $jumlah+=$row_Recordset3['transaction'];
               ?>
            
            <tr>
                <td><span class="style15"><?php echo $row_Recordset3['datepaid']; ?></span></td>
                <td><span class="style15"><?php echo $row_Recordset3['description']; ?></span></td>
                <td> Transaction</td>
                <td><span class="style15"><?php echo $row_Recordset3['transaction']; ?></span></td>
                <td>sdfsfsdfsfs </td>
               
                <td><?echo $jumlah;?></td>
            
          </tr>
          <?php endwhile;?>
         
          <?endif; ?>
         
         
          <?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>
          <?endif;?>
         
      </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);
?>

putrisakura Publish time 12-2-2009 12:36 PM

Balas #13 slier81\ catat

tak jadik jugak la.

jadik satu row je yg kuar.

putrisakura Publish time 12-2-2009 01:59 PM

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 :

http://img204.imageshack.us/img204/1738/jadikniaa6.jpg

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 dateis 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 Publish time 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



?>

putrisakura Publish time 13-2-2009 02:28 AM

Originally posted by BorderManager at 12-2-2009 11:05 PM http://mforum5.cari.com.my/images/common/back.gif

<?
$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 :

http://img11.imageshack.us/img11/8524/xjadikre8.jpg

putrisakura Publish time 13-2-2009 09:46 PM

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 110   Remain 10
Row 2    2   Would become 12
Row 3    4   Would become 16
Row 412   Would become28

Ada boleh kah?

BorderManager Publish time 14-2-2009 01:15 AM

<?
$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 Publish time 14-2-2009 08:12 PM

Balas #19 BorderManager\ catat

Still tak menjadi jugak.

View full version: camne nak kira data guna php