PHP help Ekka one

[wmdpwijerathne]

Yaluwane mekai wenna one
row wise ena data column wise pennan one

........
$sqlstate="SELECT branch,sum(depriciation_amount),catogary,sum(tcost) FROM depriciation
inner join newassest on depriciation.Current_code = newassest.current_code
WHERE depriciation_year_month between '$date' and '$date2'
group by catogary,branch;";

} //identyfy from the button click
else {
$sqlstate="SELECT * FROM depriciation limit 1 "; //
}

$result=mysql_query($sqlstate,$con) or die ("SQL Error".mysql_error());
$rownumber=mysql_num_rows($result);
if($rownumber>0){

.......
......
.......
<div id="table">
<table class="table table-hover table-bordered" width=90%/>

<th>Catogary</th>
<th>Branch</th>
<th>Total Cost</th>
<th>Depricition Amount</th>
<th>Book Vaule</th>


</tr>

<?php
while ($record=mysql_fetch_assoc($result)){

echo ("<tr>");
$cat=$record["catogary"];
$bat=$record["branch"];
echo ('<td >'.$cat.'</td>');---- table row date
echo ('<td>'.$bat.'</td>'); --- table row date
$tc= $record["sum(tcost)"];
$tccost = $tc ;
echo ('<td align="right">'.$tc.'</td>'); - table row date
echo ('<td align="right">'.$record["sum(depriciation_amount)"].'</td>'); -- table row date


$de =$record["sum(depriciation_amount)"];
$bv =$tccost - $de;
$bv=number_format($bv, 2);
echo ('<td align="right">'.$bv.'</td>'); -- table row date

Dana display wena widiya

mata mekai wenna one -- forget the total cost and deprecation

 

[vdilshan]

Oyata enna ona widiyath danna

 

[Ni7uPuL]

Branch walata unique ID ekak thiyanawada? Thiyanawanam wade karaganna puluwan.

 

[blackcatcyb]

query 2k gahanna.
1. branch tika ganna name and branch_id
2. ea branch id eken anith details tika ganna (Land, Office_equepment etc...).

 

[wmdpwijerathne]

Branch walata unique ID ekak thiyanawada? Thiyanawanam wade karaganna puluwan.

Thiyenawa Machan

 

[AloneGuy90]

Muuta help ekak diyan kawruhari

 

[kavindagk]

meke widiyata isselama VIEW ekak hadagena PHP walin e VIEW call karanne

http://stackoverflow.com/questions/1241178/mysql-rows-to-columns

 

[blackcatcyb]

function getBranchDetails(){
$sql = "SELECT branch_id,branch_name FROM branch_table"
$result = mysqli_query($link, $sql);
$branch_arr = array();
$i=0;
while ($row = mysqli_fetch_assoc($result)) {
$branch_arr[$i]['branch_name'] = $row['branch_name'];
$branch_arr[$i]['branch_data'] = getBranchData($row['branch_id']);
}
return $branch_arr;
}

function getBranchData($br_id){
$sql = "SELECT sum(depriciation_amount) AS amt,catogary,sum(tcost ) AS cost FROM branch_table WHERE branch_id = ".br_id."";
$result = mysqli_query($link, $sql);
$data_arr = array();
while ($row = mysqli_fetch_assoc($result)) {
$data_arr['amt'] = $row['amt'];
$data_arr['catogary'] = $row['catogary'];
$data_arr['cost'] = $row['cost'];
}
return $data_arr;
}

 

[shiran987]

Yaluwane mekai wenna one
row wise ena data column wise pennan one

........
$sqlstate="SELECT branch,sum(depriciation_amount),catogary,sum(tcost) FROM depriciation
inner join newassest on depriciation.Current_code = newassest.current_code
WHERE depriciation_year_month between '$date' and '$date2'
group by catogary,branch;";

} //identyfy from the button click
else {
$sqlstate="SELECT * FROM depriciation limit 1 "; //
}

$result=mysql_query($sqlstate,$con) or die ("SQL Error".mysql_error());
$rownumber=mysql_num_rows($result);
if($rownumber>0){

.......
......
.......
<div id="table">
<table class="table table-hover table-bordered" width=90%/>
<th>Branch</th> // meka mehemama thiyenawa.
<th>Catogary</th> // mee tika ain karala, for each loop eken ena data methanata add karanawa.

<th>Total Cost</th>
<th>Depricition Amount</th>
<th>Book Vaule</th>


</tr>

<?php
while ($record=mysql_fetch_assoc($result)){

echo ("<tr>");
$cat=$record["catogary"];// meka wenuwata for each loop ekak use karala, eka <th> tag ekata use karanda barida ?
$bat=$record["branch"];
echo ('<td >'.$cat.'</td>');---- table row date
echo ('<td>'.$bat.'</td>'); --- table row date
$tc= $record["sum(tcost)"];
$tccost = $tc ;
echo ('<td align="right">'.$tc.'</td>'); - table row date
echo ('<td align="right">'.$record["sum(depriciation_amount)"].'</td>'); -- table row date


$de =$record["sum(depriciation_amount)"];
$bv =$tccost - $de;
$bv=number_format($bv, 2);
echo ('<td align="right">'.$bv.'</td>'); -- table row date

Dana display wena widiya

mata mekai wenna one -- forget the total cost and deprecation

Podi idea ekak uda mark kara. red color eken high light karala. try karala balapan.

ehemath nattam thawa widiyak puluwan, issella table head tika standard format ekata hadala, ekata adala data tika query ekakin db eken call karala display karanda.

me thiyeenne, oya wagema case ekakta liyapu code kallak, HR related project ekaka, employees lawa display kanda pawichchi karapu ekak. oney nam balala idea ekak ganin.

https://goo.gl/LA8RVi

 

[wmdpwijerathne]

Thank you