PHP - Rounding Values

Hi fellas,

Can anyone show me why my script is still rounding up / down?

printf ("<tr> %s Avg gun Ahit %%</td> %s %.2f %%</td></tr>\n",$tdo,$tdor,number_format($ahit/$fired*100, 3, '.', ''));

Do I have a syntax error as I cannot get my math equation to display more than 2 decimal places even though it's set to 3?

Any help or advice would be really great.

I am very new to PHP and programming in general. About 3 weeks into this.
I have this simple expression and some echo in my code.

    $x1 = $lat_b + $lat_a1;
    echo "<br>lat b: ".$lat_b;
    echo "<br>lat a1: ".$lat_a1;   
    echo "<br>x1: ".$x1;

$lat_b and $lat_a1 are derived from some xml extractions from a yahoo geocode api (that part works fine).

The results of the expression and echos above are as follows:

    lat b: 40.402866
    lat a1: 40.252590
    x1: 80

Why is $x1 rounding automatically on me?

Later, I substituted the expression above with  $x1 = 40.402866 + 40.252590 ; The new result (shown below) makes sense to me.

   lat b: 40.402866
   lat a1: 40.252590
   x1: 80.655456

Hi,

Having trouble rounding the output. I would need to be sure the output is not longer than 2 spaces after comma.
Any ideas?

My code
Code: [Select]
<script type="text/javascript">
$(document).ready(function() {
  $("<?php echo "#".$input_end_time; ?>").blur(function(){
   var start_time = $("<?php echo "#".$input_start_time; ?>").val();
   var end_time = $("<?php echo "#".$input_end_time; ?>").val();
  $.getJSON("include/timedifferencecalculation.php?s="+start_time+"&e="+end_time, function(data){
   var success = data.success;
    if (success == 1) {
     $("<?php echo "#".$input_difference; ?>" ).val(data.hours + " h " + data.minutes + " m ");
  if (data.hours + data.minutes/60 >= 6){
$("<?php echo "#".$hours_difference; ?>").val(data.hours + data.minutes/60 - 0.5);
}else { $("<?php echo "#".$hours_difference; ?>").val(data.hours + data.minutes/60); }
  }else { $("#message").text("Viga! " + data.reason); }
    })
    });
  });
</script>

Code: [Select]
This is before
$("<?php echo "#".$hours_difference; ?>").val(data.hours + data.minutes/60 - 0.5);

This is what im trying to get but its not working.
$("<?php echo "#".$hours_difference; ?>").val( round(data.hours + data.minutes/60 - 0.5), 2 );

Here is the number:



$GrandTotal = "68.835";
$Deposit = round($GrandTotal , 2) * .5;

echo $Deposit;



I am looking for: 68.84 but the function doesn't seem to work right.

Any help?

Bascially i add a couple numbers up and display the sum.

sometimes the number is something like this: 234.237

i want it to display : 234.24

i realize its needs "round()" in it but i dont know how to use it..

any help?

I need to round a number based on it's decimal. 3 or below should round down, 4 should round up to 5, 6 and 7 should round down to 5; 8 and 9 should round up to the next whole number.

The below is returning 3 from 2.16.
Code: [Select]
<?php
$a=2.16;
$i=round($a, 1);
$b=$i;

$i=explode(".", $a);
$decimal=$i[1];

if($decimal < 5){
$j=floor($b);
$i= $decimal > 3 ? $j + .5 : $j;
echo $i;
}
else{
$j=ceil($b);
$i= $decimal < 8 ? $j - .5 : $j;
echo $i;
}
?>

EDIT: The explode should have been on $i not $a.

Hey Everybody,

I was replying to someone elses question about number formatting and came up with a class that will format a number of any length with decimal or not, without rounding. It works perfectly, but after a comment by a noteworthy member my curiosity was aroused.

Is there an easier/faster/better way to achieve this??


My Object:

<?php

/*GHETTO NUMBER FORMATTER v1.0*/

class ghettoNumber {

private $input;
private $output;

public $whole;
public $decimal;
public $number;

function __construct($input){
$this->input = $input;
$this->output = $output;
$this->number = $number;
$this->whole = $whole;
$this->decimal = $decimal;
}

private function ghettoFormat(){

//Split number at the .(decimal)
$this->number = explode('.', $this->input);
//Define the whole number
$this->whole = $this->number[0];
//Format the whole number
$this->whole = number_format($this->whole, 0,'', ',');
//Define the decimal
$this->decimal = $this->number[1];
//Format the decimal
$this->decimal = rtrim($this->decimal, '0');

if(is_string($this->input)){
$this->output = $this->decimal != '' ? $this->whole.'.'.$this->decimal : $this->whole;
}
else{
$this->output = '<strong>ERROR:</strong> Input arg must be passed as type: <em>string</em>';
}

//Return result
return 'Original - '.$this->input.'<br>
  GhettoFormat - '.$this->output.'
<br><br>';

}

public function makeItGhetto(){
return $this->ghettoFormat();
}
}

?>


Sample Instantiation:

$ghettoFormat = new ghettoNumber('12565456565.123401201001210000');
                print $ghettoFormat->makeItGhetto();



I will reiterate my question once more...
Is there, in your opinion, a BETTER way to achieve this (number formatting w/o rounding)?

Thanks People,

E

$f15 = 0.345677 (output from sql data pull)

<?php echo number_format ($f15,3); ?>
 output = 0.345

<?php echo ltrim($f15,"0"); number_format ($f15,3); ?>
output = .345677

How do I combine these so that I am BOTH rounding the result AND trimming a leading zero?  Seems I can get one or the other, but not both.

Suggestions on the syntax?

Hello. This is my first post here. I am not an expert developer but I generally manage to do what is asked of me. However, now and then I'm stumped, like now...

I have an online database system for our company in which staff can enter JOB related data, this includes 2 dimensions which they enter in millimetres (mm).

Here's an example

$dimension1 might be entered as 850
$dimension2 might be entered as 1447
$square_metres is the value I need to calculate.

Firstly, I need to round both dimensions up to the next 100mm so the 850 in this example would become 900 and the 1447 would become 1500.

Once I've done that, I need to calculate the square metres (900mm x 1500mm / 1000 was my first thought) but that raised the second thing; adding a decimal point in the result. 900 x 1500 / 1000 = 1350 but I need the result to be 1.350

I know my way around basic PHP code but I'm no expert by any stretch.

If anyone can help me understand how to get this calculation done I would be hugely appreciative.

Thank you

Martin

HI. I have written a mysql database query to add up invoice totals. It seems to be automatilaly adding .01 to the result when I run a group by. Let me explain more ..   When I do a select on the field that I am adding up the result is $132.25 - the query is as follows select ttl_invoice_due from 65_it where st_id = 96011;   When I run the following query that uses sum and group by - the $132.25 becomes $132.26 - the sum query is   SELECT 65_st.job_compid, 65_client.uid_client,  65_client.comp_name, Sum(65_it.ttl_invoice_due) AS SumOftotal_due, Sum(65_it.ttl_invoice) AS SumOftotal_invoice, Sum(65_it.ttl_invoice_payments) AS SumOftotal_amnt_paid FROM 65_client INNER JOIN (65_st INNER JOIN 65_it ON 65_st.st_id = 65_it.st_id) ON 65_client.uid_client = 65_st.uid_client WHERE   65_st.uid_client = 1905 and 65_st.job_compid = 1 and 65_st.sales_date<=curdate() GROUP BY 65_st.job_compid, 65_client.uid_client HAVING (((Sum(65_it.ttl_invoice_due))<>0)) order by 65_client.comp_name;   The 65_it.ttl_invoice_due field is defined in the table as Double(12,2)   I dont know why the sum is returing $132.26 where it should be $132.25 as in the simple query ?.    

       

Dear All Members

here is my table data..

(4 Columns/1row in mysql table)

id                 order_no               order_date                  miles
310                001                   02-15-2020                MI,108.53
                                                                                     Oh,194.57
                                                                                     PA,182.22
                                                                                     WA,238.57

How to split(miles) single column into (state, miles) two columns and output like following 5 columns /4rows in mysql using php code.

(5 Columns in mysql table)
------------------------------------------------------------------------------------

id                  order_no              order_date              state      miles

310                001                   02-15-2020               MI          108.53

310                001                   02-15-2020              Oh          194.57

310                001                   02-15-2020              PA          182.22

310                001                   02-15-2020             WA          238.57
 

------------------my php code -----------

 

<?php
//invoice.php  
include('../includes/config.php');

if(isset($_POST["add"]))
{
$order_no=$_GET['order_no'];
$order_date=$_GET['order_date'];
$miles=$_POST['miles'];

$miles = explode("\r\n", $_POST["miles"]);
$newdata = "'" . implode("','", $_POST["miles"]) . "'";
$sql ="INSERT INTO tble_states_miles(order_no,order_date, miles) VALUES(:order_no, :order_date, :newdata)";

$query = $dbh->prepare($sql);
$query-> bindParam(':order_no', $order_no, PDO::PARAM_STR);
$query-> bindParam(':order_date', $order_date, PDO::PARAM_STR);
$query-> bindParam(':miles', $newdata, PDO::PARAM_STR);

$lastInsertId = $dbh->lastInsertId();
if($lastInsertId)
{
echo "<script type='text/javascript'>alert('Added Sucessfull!');</script>";
echo "<script type='text/javascript'> document.location = 'ifta_miles_calculationlist_added.php'; </script>";
}
else 
{
$error="Something went wrong. Please try again";
}

if($query->execute()) {

$sql = "update tis_invoice set flag='1' where order_no=:order_no";
$query = $dbh->prepare($sql);
$query-> bindParam(':order_no', $order_no, PDO::PARAM_STR);

$query->execute();

}
}
?>

----------------- my form code ------------------

 

 <?php
                   $order_no=$_GET['order_no'];
        $sql = "SELECT * from tis_invoice where order_no = :order_no";
        $query = $dbh -> prepare($sql);
        $query->execute(
  array(
   ':order_no'       =>  $_GET["order_no"]
  )
 );
        $result = $query->fetchAll();
        foreach($result as $row)
?>
    
                    <form method="post">
                        <table align="center" style="width: 55%">
                        <tr><td>Invoice Number</td></tr>
                        <tr><td><input type="text" name="order_no" value="<?php echo $row["order_no"]; ?>" readonly=""></td></tr>
                        <tr><td>Invoice Date</td></tr>
                        <tr><td><input type="text" name="order_no" value="<?php echo $row["order_date"]; ?>" readonly=""></td></tr>
                        <tr><td>
                               <textarea name="miles" class="form-control" rows="10" placeholder="" required></textarea>
                           </td></tr>
                           <tr><td>
                         
                            <input type="submit" name="add" class="btn btn-primary" value="Add" />
                       </td></tr></table>
                    </form>

-- Can any one help how to correct my code..present nothing inserted on table

 

Thank You

Edited February 8, 2020 by karthicbabu

Hi,

My company has 240+ locations and as such some users (general managers) cover multiple sites.  When I run a query to pull user information, when the user has multiple sites to his or her name, its adds the second / third sites to the next columns, rather than wrapping it inside the same table cell.  It also works the opposite way, if a piece of data is missing in the database and is blank, its pull the following columns in.  Both cases mess up the table and formatting.  I'm extremely new to any kind of programming and maybe this isn't the forum for this question but figured I'd give it a chance since I'm stuck.

The HTML/PHP code is below:

<table id="datatables-column-search-select-inputs" class="table table-striped" style="width:100%">

                                        <thead>

                                            <tr>

                                                <th>ID</th>

                                                <th>FirstName</th>

                                                <th>LastName</th>

                                                <th>Username</th>

                                                <th>Phone #</th>

                                                <th>Location</th>

                                                <th>Title</th>

                                                <th>Role</th>

                                                <th>Actions</th>

                                            </tr>

                                        </thead>

                                        <tbody>

                                            <?php

                                            //QUERY TO SELECT ALL USERS FROM DATABASE

                                            $query = "SELECT * FROM users";

                                            $select_users = mysqli_query($connection,$query);

                                            

                                            // SET VARIABLE TO ARRAY FROM QUERY

                                            while($row = mysqli_fetch_assoc($select_users)) {

                                                $user_id = $row['user_id'];

                                                $user_firstname = $row['user_firstname'];

                                                $user_lastname = $row['user_lastname'];

                                                $username = $row['username'];

                                                $user_phone = $row['user_phone'];

                                                $user_image = $row['user_image'];

                                                $user_title_id = $row['user_title_id'];

                                                $user_role_id = $row['user_role_id'];

                                            

                                                // POPULATES DATA INTO THE TABLE

                                                echo "<tr>";

                                                echo "<td>{$user_id}</td>";

                                                echo "<td>{$user_firstname}</td>";

                                                echo "<td>{$user_lastname}</td>";

                                                echo "<td>{$username}</td>";

                                                echo "<td>{$user_phone}</td>";

                                            

                                                //PULL SITE STATUS BASED ON SITE STATUS ID

                                                $query = "SELECT * FROM sites WHERE site_manager_id = {$user_id} ";

                                                $select_site = mysqli_query($connection, $query);

                                                while($row = mysqli_fetch_assoc($select_site)) {

                                                    $site_name = $row['site_name'];

                                                    echo "<td>{$site_name}</td>";

                                                }

                                                echo "<td>{$user_title_id}</td>";

                                                echo "<td>{$user_role_id}</td>";

                                                echo "<td class='table-action'>

                                                    <a href='#'><i class='align-middle' data-feather='edit-2'></i></a>

                                                    <a href='#'><i class='align-middle' data-feather='trash'></i></a>

                                                    </td>";

                                                //echo "<td><a href='users.php?source=edit_user&p_id={$user_id}'>Edit</a></td>";

                                                echo "</tr>";

                                            }   

                                            ?>

 

                                            <tr>

                                                <td>ID</td>

                                                <td>FirstName</td>

                                                <td>LastName</td>

                                                <td>Username</td>

                                                <td>Phone #</td>

                                                <td>Location</td>

                                                <td>Title</td>

                                                <td>Role</td>

                                                <td class="table-action">

                                                <a href="#"><i class="align-middle" data-feather="edit-2"></i></a>

                                                <a href="#"><i class="align-middle" data-feather="trash"></i></a>

                                                </td>

                                            </tr>

                                        </tbody>

                                        <tfoot>

                                            <tr>

                                                <th>ID</th>

                                                <th>FirstName</th>

                                                <th>LastName</th>

                                                <th>Username</th>

                                                <th>Phone #</th>

                                                <th>Location</th>

                                                <th>Title</th>

                                                <th>Role</th>

                                            </tr>

                                        </tfoot>

                                    </table>

Hi all,

I'm a first time poster here and I would really appreciate some guidance with my latest php challenge! I've spent the entire day googling and reading and to be honest I think I'm really over my head and need the assistance of someone experienced to advise the best way to go!

I have a multi dimensional array that looks like (see below); the array is created by CodeIgniter's database library (the rows returned from a select query) but I think this is a generic PHP question as opposed to having anything to do with CI because it related to working with arrays.

I'm wondering how I might go about searching the array below for the key problem_id and a value equal to a variable which I would provide. Then, when it finds an array with a the matching key and variable, it outputs the other values in that part of the array too.

For example, using the sample data below. How would you recommend that I search the array for all the arrays that have the key problem_id and the value 3 and then have it output the value of the key problem_update_date  and the value of the key problem_update_text. Then keep searching to find the next occurrence?

Thanks in advance, as above, I've been searching really hard for the answer and believe i'm over my head!

Output of print_r($updates);

CI_DB_mysql_result Object
(
    [conn_id] => Resource id #30
    [result_id] => Resource id #35
    [result_array] => Array
        (
        )

    [result_object] => Array
        (
        )

    [current_row] => 0
    [num_rows] => 5
    [row_data] => 
)


Output of print_r($updates->result_array());

Array
(
    [0] => Array
        (
            [problem_update_id] => 1
            [problem_id] => 3
            [problem_update_date] => 2010-10-01
            [problem_update_text] => Some details about a paricular issue
            [problem_update_active] => 1
        )

    [1] => Array
        (
            [problem_update_id] => 4
            [problem_id] => 3
            [problem_update_date] => 2010-10-01
            [problem_update_text] => Another update about the problem with an ID of 3
            [problem_update_active] => 1
        )

    [2] => Array
        (
            [problem_update_id] => 5
            [problem_id] => 4
            [problem_update_date] => 2010-10-12
            [problem_update_text] => An update about the problem with an ID of four
            [problem_update_active] => 1
        )

    [3] => Array
        (
            [problem_update_id] => 6
            [problem_id] => 4
            [problem_update_date] => 2010-10-12
            [problem_update_text] => An update about the problem with an ID of 6
            [problem_update_active] => 1
        )

    [4] => Array
        (
            [problem_update_id] => 7
            [problem_id] => 3
            [problem_update_date] => 2010-10-12
            [problem_update_text] => Some new update about the problem with the ID of 3
            [problem_update_active] => 1
        )

)

Hi all,

Just curious why this works:

Code: [Select]
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE){
$import="INSERT into $prodtblname ($csvheaders1) values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]')";
}
And this does not:

$headdata_1 = "'$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]'";
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE){
$import="INSERT into $prodtblname ($csvheaders1) values($headdata_1)";
}it puts $data[#'s] in the database fields instead of the actual data that '$data[0]','$data[1]'... relates to.

I wrote a script to create the values in $headdata_1 based on the number of headers in $csvheaders1 but can't seem to get it working in the sql statement.

Thanks