PHP - Moved: Sorting A Table By Calculated Variable

Hi to All,

I am performing calculation which i echo it in the input form to insert it to DB table
The calculation works fine when i submit the form but the it does not correct calculation to the DB.
it seems that the isert to database is done before the calculation and I can't figure a way around it.

Because i'm submitting to the same page, the calculation populate in the input form correctly but it insert Zero to the database table instead of correct calculation populated in the input field to DB table

You could see from the line 114 to 116 that, i'm performing some calculations and echo it at line 128 and line 128 in the input form value field.

Please any help on how to do this...All the function in the code is in another file and it works fine...so the only program is that the calculated value is not inserted as expected

Here is the code

<?php
include 'core/initForMainLogPage.php';


if(isset($_GET['empId']) && !empty($_GET['empId'])){

//delete employee here
$empId=$_GET['empId'];
grabEmpId($empId);
}
?>

<?php
if(logged_in()){
$data=user_dataManager('username');
$usernameData=$data['username'];
}else{
header('Location: index.php');
}
?>
<?php include 'includes/adminHeadAll.php';?>

<header>
<?php include 'includes/managerMenu.php';?>  
</header>
<div class="container">
<br/>
<h3>Pay Employee</h3>
<?php
$error=array();
$errorAll='';
$leave="";
if(isset($_POST['empId']) && isset($_POST['name']) && isset($_POST['date']) && isset($_POST['basicSalary'])
&& isset($_POST['leave']) && isset($_POST['salaryPerDay']) && isset($_POST['leaveDeduct']) 
&& isset($_POST['netSalary'])){
$empId=htmlentities(mysql_real_escape_string($_POST['empId']));
$name=htmlentities(mysql_real_escape_string($_POST['name']));
$date=htmlentities(mysql_real_escape_string($_POST['date']));
$basicSalary=htmlentities(mysql_real_escape_string($_POST['basicSalary']));
$leave=htmlentities(mysql_real_escape_string($_POST['leave']));
$salaryPerDay=htmlentities(mysql_real_escape_string($_POST['salaryPerDay']));
$leaveDeduct=htmlentities(mysql_real_escape_string($_POST['leaveDeduct']));
$netSalary=htmlentities(mysql_real_escape_string($_POST['netSalary']));



//checking for the validity of data entered
if(empty($leave) || empty($date)){
$error[]='Pleave leave or date field is empty.';
}else{

if(preg_match('/[0-9]/',$leave)==false){
$error[]='Leave should only contain numbers'; 
}

if(empId($empId)===false){
$error[]="This employee is not recoganize by the system and can not be paid,he may need to register first.";
}

}

if(!empty($error)){
$errorAll= '<div class="error"><ul><li>'.implode('</li><li>',$error).'</li></ul></div>';


}else{
//this funciton insert into database
payrollData($name,$empId,$date,$basicSalary,$leave,$salaryPerDay,$leaveDeduct,$netSalary);
echo '<p class="pa">Payment made successfully.&nbsp;&nbsp;&nbsp;<a href="employees-salary-report.php">See Payment Records</a></p>';
}


}//end isset


?>

<div class="tableWrap">
<form action="" method="post" >
<div class="styletable"><table cellpadding="" cellspacing="" border="0">
<?php
$query=mysql_query("SELECT 
			  empId,name,level,company.compId,company.levelOne,company.levelTwo,
			  company.levelThree,company.levelFour,company.levelFive
			   FROM employee JOIN company ON company.compId=1 WHERE empId='$empId' LIMIT 1");


while($row=mysql_fetch_array($query)){
  $empId=$row['empId'];
  $name=$row['name'];
  $levelEmp=$row['level'];
  $levelOne=$row['levelOne'];
  $levelTwo=$row['levelTwo'];
  $levelThree=$row['levelThree'];
  $levelFour=$row['levelFour'];
  $levelFive=$row['levelFive'];
  
  if($levelEmp==1){
	  $levelPay=$levelOne;
  }elseif($levelEmp==2){
	  $levelPay=$levelTwo;
  }elseif($levelEmp==3){
	  $levelPay=$levelThree;
  }elseif($levelEmp==4){
	  $levelPay=$levelFour;
  }elseif($levelEmp==5){
	  $levelPay=$levelFive;
  }
  


//making calculations here

$basicSalary=$levelPay * 30;
$leaveDeduct=$leave * $levelPay;
$netSalary=$basicSalary - $leaveDeduct;
}


?>
<tr><td>Employee ID: </td><td><input type="text" name="empId" readonly="readonly" value="<?php if(isset($empId)){echo $empId;}?>"></td></tr>
<tr><td>Employee: </td><td><input type="text" name="name" readonly="readonly" value="<?php if(isset($name)){ echo $name;}?>"></td></tr>
<tr><td>Date: </td><td><input type="text" id="Date" class="picker" name="date"></td></tr>

<tr><td> Basic Salary: </td><td><input type="text" name="basicSalary" readonly="readonly" value="<?php echo $basicSalary;?>"></td></tr>
<tr><td> No. Of Absent: </td><td><input type="text" name="leave" class="input" value=""></td></tr>
<tr><td> Salary Per Day:</td><td><input type="text" name="salaryPerDay" readonly="readonly" value="<?php echo $levelPay;?>"></td></tr>
<tr><td> Deduction For Absentee:</td><td><input type="text" name="leaveDeduct" readonly="readonly" value="<?php echo $leaveDeduct;?>"></td></tr>
<tr><td> Net Salary:</td><td><input type="text" name="netSalary" readonly="readonly" value="<?php echo $netSalary;?>"></td></tr>
<tr><td> </td><td><input type="submit" value="Submit Pay" class="submit" name="pay"></td></tr>
</table></div>

</form>
<?php



?>
</div>
<br />
<?php echo $errorAll; ?>
<p>Manage the monthly salary details of your employee along with the allowances, deductions, etc. by just entering their leave</p>
</div> 
<?php include 'includes/footerAll.php';?>  

<script type="text/javascript" src="js/jquery.js"></script>
<script type="text/javascript" src="js/jquery-ui.js"></script>
<script type="text/javascript" src="js/ui.js"></script>
</body>
</html>

Is it possible to sort a table of mysql data, by using a variable?

I'm trying this:

Code: [Select]
<?php

$result = mysql_query("SELECT * FROM members ORDER BY '$totalpower'");
        echo "<table border='1' cellpadding='10'>";
               echo "<tr> 
<th>Rank</th> 
<th>Username</th> 
</tr>";

while($row = mysql_fetch_array($result))
  {
  
                echo "<tr>";
                echo '<td> </td>';
                echo '<td>' . $row['Username'] . '</td>';
                echo "</tr>"; 
  }
        echo "</table>";
?>
It display's a list of username's but not in the correct power order.

$totalpower is defined:

Code: [Select]
<?php

//power calculations

        $result = mysql_query("SELECT * FROM members WHERE Username='$_SESSION[Username]'")                 
        or die(mysql_error());       
        while($row = mysql_fetch_array( $result )) {   
            $power1 = $row['ounit1'] * 50;
$power2 = $row['ounit2'] * 70;
$power3 = $row['ounit3'] * 110;
$power4 = $row['ounit4'] * 200;
$power5 = $row['ounit5'] * 150;
$power6 = $row['ounit6'] * 300;
$power7 = $row['ounit7'] * 500;
$power8 = $row['ounit8'] * 450;
$power9 = $row['ounit9'] * 650;
$power10 = $row['ounit10'] * 350;
$power11 = $row['ounit11'] * 600;
$power12 = $row['ounit12'] * 1000;

$dpower1 = $row['dunit1'] * 50;
$dpower2 = $row['dunit2'] * 70;
$dpower3 = $row['dunit3'] * 110;
$dpower4 = $row['dunit4'] * 200;
$dpower5 = $row['dunit5'] * 150;
$dpower6 = $row['dunit6'] * 300;
$dpower7 = $row['dunit7'] * 500;
$dpower8 = $row['dunit8'] * 450;
$dpower9 = $row['dunit9'] * 650;
$dpower10 = $row['dunit10'] * 350;
$dpower11 = $row['dunit11'] * 600;
$dpower12 = $row['dunit12'] * 1000;

$dbase = $row['baselevel'] * 3000;
        }

$offencepower = $power1+$power2+$power3+$power4+$power5+$power6+$power7+$power8+$power9+$power10+$power11+$power12;
$defencepower = $dpower1+$dpower2+$dpower3+$dpower4+$dpower5+$dpower6+$dpower7+$dpower8+$dpower9+$dpower10+$dpower11+$dpower12+$dbase;
$totalpower = (($offencepower+$defencepower)/ 100 * 30) + $offencepower+$defencepower;

?>
Also how do I add auto numbers in the left column e.g 1. 2. 3. 4.

Thanks in advance.

I got myself wrapped up in something I can't get figured.
 
In the following code, I would like to order the list of properties ("<div class="property">") by the "$pr_street" variable.   Any help is appreciated. Thanks,
 

<?php
/////////////// SEO ///////////////
$keywords = "";
$description = "";
/////////////// DB Connection ///////////////////
include('../includes/connect.php');
include('../includes/login.php');


if(isset($_GET['delete'])){
	$del_id = $_GET['delete'];
	$sel_del_imgs_q = "SELECT * FROM pr_imgs WHERE pr_id = '$del_id'";
	$pr_img_del_result = mysqli_query($db, $sel_del_imgs_q);
	while($pr_del_imgs = mysqli_fetch_array($pr_img_del_result)){
		$pr_del_img_id[] = $pr_del_imgs['pr_img_id'];
		$pr_del_img_path_xl[] = $pr_del_imgs['pr_img_path_xl'];
		$pr_del_img_path_l[] = $pr_del_imgs['pr_img_path_l'];
		$pr_del_img_path_m[] = $pr_del_imgs['pr_img_path_m'];
		$pr_del_img_path_s[] = $pr_del_imgs['pr_img_path_s'];
		$pr_del_img_path_xs[] = $pr_del_imgs['pr_img_path_xs'];
	}
	for($i = 0; $i < count($pr_del_img_id);$i++){
		if(!empty($pr_del_img_path_xl[$i])){
			unlink('..'.$pr_del_img_path_xl[$i]);
		}
		if(!empty($pr_del_img_path_l[$i])){
			unlink('..'.$pr_del_img_path_l[$i]);
		}
		if(!empty($pr_del_img_path_m[$i])){
			unlink('..'.$pr_del_img_path_m[$i]);
		}
		if(!empty($pr_del_img_path_s[$i])){
			unlink('..'.$pr_del_img_path_s[$i]);
		}
		if(!empty($pr_del_img_path_xs[$i])){
			unlink('..'.$pr_del_img_path_xs[$i]);
		}
	}
	$dir_to_remove = dirname(getcwd()).'/images/properties/'.$del_id;
	rmdir($dir_to_remove);
	$delete_query = "DELETE property, pr_imgs FROM property LEFT OUTER JOIN pr_imgs ON property.pr_id = pr_imgs.pr_id WHERE property.pr_id = '$del_id'";
	$deleted = mysqli_query($db, $delete_query);
	if($deleted){
		header('Location:index.php');
		//print $delete_query;	
	}
}

$sel_pr_type = 1; // 1 = For Rent Residential, 2 = For Rent Commercial, 3 = For Sale

$pr_sel_query = "SELECT * FROM property LEFT OUTER JOIN pr_imgs ON property.pr_id = pr_imgs.pr_id AND pr_imgs.pr_img_count = '0' ORDER BY property.pr_live DESC, property.pr_modified DESC";
$result = mysqli_query($db,$pr_sel_query);
while($pr_row = mysqli_fetch_array($result)){
	$pr_id[] = $pr_row[0];
	$pr_type[] = $pr_row['pr_type'];
	$pr_live[] = $pr_row['pr_live'];
	$pr_title[] = $pr_row['pr_title'];
	$pr_street[] = $pr_row['pr_street'];
	$pr_city[] = $pr_row['pr_city'];
	$pr_state[] = $pr_row['pr_state'];
	$pr_zip[] = $pr_row['pr_zip'];
	$pr_price[] = $pr_row['pr_price'];
	$pr_bedroom[] = $pr_row['pr_bedroom'];
	$pr_bathroom[] = $pr_row['pr_bathroom'];
	$pr_size[] = $pr_row['pr_size'];
	$pr_img_path_s[] = $pr_row['pr_img_path_s'];
}

include('../includes/head.php'); 
include('../includes/header.php'); 

ob_end_flush(); // ob_start() in /includes/login.php
?>
<div class="content">
  <div class="hldr">
  <?php if($loggedin){ ?>
    <div class="left">
    <h2><a href="/admin/">Admin</a></h2>
        <?php for($i = 0; $i < count($pr_id); $i++){ 
			if($pr_live[$i] == 1){
				$islive[$i] = ' &bull; <span class="live">Live</span>';
			}
		?>
		<div class="property">
        	<div class="thumb"><a href="/property_details.php?property=<?php print $pr_id[$i]; ?>"><img src="<?php print $pr_img_path_s[$i]; ?>" width="100" height="100" /></a></div>
            <div class="details">
           	  <h4><a href="/property_details.php?property=<?php print $pr_id[$i]; ?>"><?php print $pr_title[$i]; ?></a></h4>
                <ul>
                	<li>Bedroom: <?php print $pr_bedroom[$i]; ?> &bull; Bathroom: <?php print $pr_bathroom[$i]; ?></li>
                    <li class="adrs"><?php print $pr_street[$i].', '.$pr_city[$i].', '.$pr_state[$i].' '.$pr_zip[$i]; ?></li>
                    <li>Price: $<?php print $pr_price[$i]; ?> 4 &bull; Size: <?php print $pr_size[$i]; ?> sq ft</li>
                    <li><a href="/admin/add-property.php?edit=<?php print $pr_id[$i]; ?>">EDIT</a> &bull; <a href="/admin/index.php?delete=<?php print $pr_id[$i]; ?>" class="red" onclick="return confirm('Are you sure you want to deletet this Property?');">DELETE</a><?php print $islive[$i]; ?></li>
                </ul>
            </div>
		</div>
        <?php } ?>
    </div>
    <div class="right">
      <div class="sidebarHome">
	   <div class="sidebarHome">
    	  <p><strong><a href="/admin/">Admin Home</a></strong></p>
    	  <p><strong><a href="add-property.php">Add Property</a></strong></p>
    	  <p><strong><a href="for-rent-res.php">Edit Properties for Rent - Residential</a></strong></p>
    	  <p><strong><a href="for-rent-com.php">Edit Properties for Rent - Commercial</a></strong></p>
    	  <p><strong><a href="for-sale.php">Edit Properties for Sale </a></strong></p>
    	  <p><strong><a href="index.php?logout=1">Log Out </a></strong></p>
	    </div>
    </div>
    <div class="clear">&nbsp;</div>
  </div>
<?php }else { ?>
	<div class="fullpage">
    	<div class="login">
        <?php print $error_msg; ?>
    	<form method="post" action="index.php">
        	<label>Username:</label>
        	<input type="text" name="user" class="txt" />
            <label>Password:</label>
            <input type="password" name="pass" class="txt" /><br />
            <input type="submit" name="login" value="Login" class="submit" />
            </form>
        </form>
        </div>
    </div>
<?php } ?>
</div>
<?php include('../includes/footer.php'); ?>

This topic has been moved to PHP Applications.

http://www.phpfreaks.com/forums/index.php?topic=317320.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=306094.0