PHP - Round Of Into Two Decimal Places

Hi there.

I am trying to display numbers if they have the numbers like:

number_format($price,2)

This gives us two decimal places i.e 7.23

Now thats fine, I would like to round the last two decimal places. I would like to make it 7.25, (rounding it from 7.23 to 7.25)

Similarly making:

12.44 to 12.45
33.18 to 33.20
52.13 to 52.15

So actually rounding the last two places. Coz obviously customers won't be able to pay 52 dollars 13 cents. So therefore rounding the last cent's (decimal part) making it to 52.15

Thank you.

All comments and feedback are welcomed.


(d

Hi

I am using Zen-Cart to which I have made significant changes.  Two years ago I managed to change the Products Sort Order from Integer to Decimal(5,2) to store books such as 1, 1.5, 1.75, 2 etc.  Regrettably we had a major server issue and I also lost the new coding.  Having restored everything else whenever we enter a book series number such as 1.5 it only stores as 1.

To date the zen-Cart forums have been unable to offer a solution so I am reaching out to see if anyone else can advise me of how to get this working again please.

 

Thanks in advance

Owen

 

This topic has been moved to PHP Regex.

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

For every search, I get ZERO RESULTS, and I don't understand what I'm doing wrong.

Code: [Select]
<?php
require('places_class.php');

$types = $_POST['type'];
$location = $_POST['place'];
$radius = $_POST['radius'];

$gplaces = New GooglePlaces;
$gplaces->SetLocation("$location");
$gplaces->SetRadius($radius);
$gplaces->SetTypes("$types");
$results = $gplaces->Search();

print_r($results);
?>

That's when the form is submitted, I checked the variables, and they are echoing out correctly.

Then I thought I'd hard-code the values in, same results
Code: [Select]
<?php
require('places_class.php');

$gplaces = New GooglePlaces;
$gplaces->SetLocation("40.5267,81.4778");
$gplaces->SetRadius(50);
$gplaces->SetTypes("food");
$results = $gplaces->Search();

print_r($results);
?>

Here is the class
Code: [Select]
<?php
class GooglePlaces
{
private $APIKey = "";
 
public $OutputType = "json";  //either json, xml or array
 
public $Errors = array();
 
private $APIUrl = "https://maps.googleapis.com/maps/api/place";
private $APICallType = "";
 
private $IncludeDetails = false; 
 
//all calls
private $Language = 'en';  //optional - https://spreadsheets.google.com/pub?key=p9pdwsai2hDMsLkXsoM05KQ&gid=1
 
//Search
private $Location;   //REQUIRED  - This must be provided as a google.maps.LatLng object.
private $Radius;   //REQUIRED  
private $Types;   //optional - separate tyep with pipe symbol  http://code.google.com/apis/maps/documentation/places/supported_types.html  
 
private $Name;   //optional
 
//Search, Details, 
private $Sensor = 'false'; //REQUIRED - is $Location coming from a sensor? like GPS?
 
//Details & Delete
private $Reference;
 
//Add
private $Accuracy;
 
public function Search()
    {
$this->APICallType = "search";
 
return $this->APICall();
}
 
public function Details()
    {
$this->APICallType = "details";
 
return $this->APICall();
}
 
public function Checkin()
    {
$this->APICallType = "checkin-in";
 
return $this->APICall();
}
 
public function Add()
    {
$this->APICallType = "add";
 
return $this->APICall();
}
 
public function Delete()
    {
$this->APICallType = "delete";
 
return $this->APICall();
}
 
 
public function SetLocation($Location)
{
$this->Location = $Location;
}
public function SetRadius($Radius)
{
$this->Radius = $Radius;
}
public function SetTypes($Types)
{
$this->Types = $Types;
}
public function SetLanguage($Language)
{
$this->Language = $Language;
}
public function SetName($Name)
{
$this->Name = $Name;
}
public function SetSensor($Sensor)
{
$this->Sensor = $Sensor;
}
public function SetReference($Reference)
{
$this->Reference = $Reference;
}
public function SetAccuracy($Accuracy)
{
$this->Accuracy = $Accuracy;
}
public function SetIncludeDetails($IncludeDetails)
{
$this->IncludeDetails = $IncludeDetails;
}
 
private function CheckForErrors()
{
if(empty($this->APICallType))
{
$this->Errors[] = "API Call Type is required but is missing.";
}
if(empty($this->APIKey))
{
$this->Errors[] = "API Key is is required but is missing.";
}
 
if(($this->OutputType!="json") && ($this->OutputType!="xml") && ($this->OutputType!="json"))
{
$this->Errors[] = "OutputType is required but is missing.";
}
 
 
 
}
 
 
 
private function APICall()
{
$this->CheckForErrors();
 
if($this->APICallType=="add" || $this->APICallType=="delete")
{
$URLToPostTo = $this->APIUrl."/".$this->APICallType."/".$this->OutputType."?key=".$this->APIKey."&sensor=".$this->Sensor;
 
if($this->APICallType=="add")
{
$LocationArray = explode(",", $this->Location);
$lat = trim($LocationArray[0]);
$lng = trim($LocationArray[1]);
 
$paramstopost[location][lat] = $lat;
$paramstopost[location][lng] = $lng;
$paramstopost[accuracy] = $this->Accuracy;
$paramstopost[name] = $this->Name;
$paramstopost[types] = explode("|", $this->Types);
$paramstopost[language] = $this->Language;
}
if($this->APICallType=="delete")
{
$paramstopost[reference] = $this->Reference;
}
 
$result = json_decode($this->CurlCall($URLToPostTo,json_encode($paramstopost)));
$result->errors = $this->Errors;
return $result;
 
}
 
if($this->APICallType=="search")
{
$URLparams = "location=".$this->Location."&radius=".$this->Radius."&types=".$this->Types."&language=".$this->Language."&name=".$this->Name."&sensor=".$this->Sensor;
}
if($this->APICallType=="details")
{
$URLparams = "reference=".$this->Reference."&language=".$this->Language."&sensor=".$this->Sensor;
}
if($this->APICallType=="check-in")
{
$URLparams = "reference=".$this->Reference."&language=".$this->Language."&sensor=".$this->Sensor;
}
 
 
$URLToCall = $this->APIUrl."/".$this->APICallType."/".$this->OutputType."?key=".$this->APIKey."&".$URLparams;
 
$result = json_decode(file_get_contents($URLToCall),true);
 
$result[errors] = $this->Errors;
 
if($result[status]=="OK" && $this->APICallType=="details")
{
foreach($result[result][address_components] as $key=>$component)
{
if($component[types][0]=="street_number")
{
$address_street_number = $component[short_name];
}
if($component[types][0]=="route")
{
$address_street_name = $component[short_name];
}
if($component[types][0]=="locality")
{
$address_city = $component[short_name];
}
if($component[types][0]=="administrative_area_level_1")
{
$address_state = $component[short_name];
}
if($component[types][0]=="postal_code")
{
$address_postal_code = $component[short_name];
}
}
 
$result[result][address_fixed][street_number] = $address_street_number;
$result[result][address_fixed][address_street_name] = $address_street_name;
$result[result][address_fixed][address_city] = $address_city;
$result[result][address_fixed][address_state] = $address_state;
$result[result][address_fixed][address_postal_code] = $address_postal_code;
}
return $result;
 
}
 
private function CurlCall($url,$topost)
{
$ch = curl_init(); 
curl_setopt($ch, CURLOPT_URL, $url); 
curl_setopt($ch, CURLOPT_HEADER, FALSE);  
curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE); 
curl_setopt($ch, CURLOPT_POSTFIELDS, $topost);
$body = curl_exec($ch); 
curl_close($ch); 
 
return $body;
 
}
 
}
?>

And yes, I do have the correct API Key, I just took it out

Can anybody see what the issue is?

how do i make a leaderboard that is capable of handling equal scores from a particular result?

we use following points allocations:
winner: 5pts
second: 3pts
third: 2pts
fourth: 1pt

however, if 2nd and 3rd have tied scores, i would like to combine their point allocations together and divide by 2, i.e. (3+2)/2=2.5points each.

initial query for competition ranking:

$q_lastcomp = "SELECT p.p_id, p.p_surname, p.p_forename, p.p_handicap, r.r_id, rp.rp_score, rp.rp_handicap, (rp.rp_score-rp.rp_handicap) as net_score ";
$q_lastcomp .= "FROM dan_roundplayed rp, dan_round r, dan_player p ";
$q_lastcomp .= "WHERE r.r_id = rp.rp_rid ";
$q_lastcomp .= "AND p.p_id = rp.rp_pid ";
$q_lastcomp .= "AND r.r_id = 6 ";
$q_lastcomp .= "ORDER BY net_score";
$r_lastcomp = mysql_query($q_lastcomp) or die(mysql_error());


i then loop through this resultset in this order (top down), and do some more calculations to adjust the players golf handicaps based on these results too. basically, if there are 4 players, the winner has beaten 3 others, second has beaten 2 others, down to last place who has beaten no-one.
the number of players you have beaten is multiplied by 10% of their handicap (not precisely this value, but something like it and makes easier to explain), then this adjustment is subtracted from the handicap to make a new handicap for the next comp.

this works fine, so long as no-one is tied. but if 2nd and 3rd tie, then both players have effectively only beaten 1 other player (last placed). so i would want both to do "hcap - (1*(hcap*0.1))" for their handicap adjustment calculations.
in my current code, even though they were tied, 2nd would have: "hcap - (2*(hcap*0.1))"
3rd would have: "hcap - (1*(hcap*0.1))"

my current loop code is:

    $total_players = mysql_num_rows($r_lastcomp);
    
    $i = 1;
    while($row = mysql_fetch_array($r_lastcomp)){
        echo "<br>";
        $round_hcap = round($row[p_handicap]);
        SWITCH ($round_hcap){
            CASE $round_hcap >= 0 AND $round_hcap <= 19:
                $multiplier = 0.1;
                break;
            CASE $round_hcap >= 20 AND $round_hcap <= 29:
                $multiplier = 0.2;
                break;
            CASE $round_hcap >= 30 AND $round_hcap <= 39:
                $multiplier = 0.3;
                break;
            CASE $round_hcap >= 40 AND $round_hcap <= 49:
                $multiplier = 0.4;
                break;
        }
        $hcap_reduce = ($total_players-$i)*$multiplier;
        $new_hcap = $row[p_handicap]-(($total_players-$i)*$multiplier);
        $sqlstr = "INSERT INTO dan_handicap VALUES (". $row[p_id]. ",". $row[r_id]. ",". $row[p_handicap]. ",". $i. ",";
        $sqlstr .= $total_players. ",". $hcap_reduce. ",". $new_hcap. ");";
        $sqlstr2 = "UPDATE dan_player SET p_handicap = ". $new_hcap. " WHERE p_id = ". $row[p_id]. ";";
        echo $sqlstr. "<br>";
        echo $sqlstr2. "<br>";
        $i++;
    }


can anyone help with this please?

my initial thoughts are i am going to need a drastic adjustment to the initial query add in position number in the comp, i.e. this would produce
posn | name | score
1 | winner | 10
2 | tied 2nd | 8
2 | tied 2nd | 8
4 | last place | 5

the second section of code could then use this "position number" for the multiplier part of the calculations.

apologies for the length of the post, but this covers the whole requirements.

regards

jingo_man

hello guys, im creating a search result page that uses pagination, and im trying to figure out how many total pages their are going to be in my links with the page numbers. this is probably something really simple, ive been writing scripts for the last few hours and have a bit of a headache, any help would be appreciated here's the coding and the results i want:


<?php

$per_page = 10;
$rows = mysql_query("SELECT COUNT(*) FROM articles WHERE text LIKE $string"); // this will return 31
$pages = $rows / $per_page; // returns 3.1
$total_pages = round($pages); // returns 3, want to round 3.1 up to 4 here

?>

hi know who to round a number to the nearest whole number,

if i use

echo round(9.5); it echo's 10
and if i use
echo round(9.2); it echo's 9

i want it so it always rounds up?

can anyone help?

cheers matt

Hello

It's about exception handling...

I have two if statements, one inside the other. And I want to throw an exception from each, if one of them is FALSE. What "technique" should I use? I think throwing same exception with the same message within two if's is a bit messy.

like:
if $x is true
  //go to 2nd if:
  if $y is true
     return value
  if $y is false: throw exception "Invalid number"
if $x is false: throw exception "Invalid number"

Thanks,

Code: [Select]
$newrating = round($imageinfo['rating'],2);
this outputs:

4.49

in my db rating is

4.4884   


all i need is the 4.... would i use some type of preg_replace or something just to grab the first 1 before the decimal? (all  i need is the first number before the decimal)

I need to take a time and convert so it is rounded up or down to the nearest 0 or 5.

Code: [Select]
function roundMe ($time, $upDown) {

  if($upDown==1) {
     //round up
  } else {
     //round down
  }

  return $x;

}

echo roundMe("16:22", 1); // returns 16:25
echo roundMe("16:22", 0); // returns 16:20
echo roundMe("16:25", 1); // returns 16:25
echo roundMe("16:59", 1); // returns 17:00
echo roundMe("16:59", 0); // returns 16:55

I am trying to output only 40 of the latest files uploaded on the database server.

But when I am trying to see the files uploaded on the server I am getting this error:

Warning: round() expects parameter 2 to be long, string given in C:\wamp\www\mshare\lista.php on line 8 Call Stack

The code:
Code: [Select]
<?php

function bytestostring($size, $precision = 0) {
    $sizes = array('YB', 'ZB', 'EB', 'PB', 'TB', 'GB', 'MB', 'kB', 'B');
    $total = count($sizes);

    while($total-- && $size > 1024) $size /= 1024;
    return round($size, $precision)." ".$sizes[$total];
}




echo '<div class="header">40 last uploaded files:</div>';


$sql = "SELECT * FROM filer order by id desc limit 40";
$q = mysql_query($sql);

echo '<table style="width: 100%;">';

while ($r = mysql_fetch_array($q)) {

$i++;

$id = $r['id'];
$filnamn = $r['name'];
$filtyp = explode("/", $r['type']);
$filtyp = ucwords($filtyp[0]);
if($filtyp == "") {
$filtyp = "Unkown";
}
$filstorlek = bytestostring($r['size'], "");

$a = $i%2; 

echo'<tr><td class="lista">';

echo ''.$i.'. <td class="lista">'.$filnamn.'<td class="lista">'.$filtyp.' <td class="lista">'.$filstorlek.' <td class="lista"><a href="download.php?id='.$id.'"'.$a.'"><img src="download-icon.jpg" class="imagedow"></a>';




}

echo "</table>";

?>

I am new to PHP coding so you guys just know.

i have a price i want to add 10%-15% to the base price and that the result

will be rounded to 9 in the ones digit place.

for example

85 +15%=97.7
$result=99

117+15%=134.55
$result = 139

played with round() and ceil()

This works
echo $data3['value'];

But this doesn't
echo round($data3['value'], 2);

Can someone please advise me as to what I am doing wrong?

HOw to get the AVERAGE of my entire database?

$query = "SELECT ROUND(AVG(scores)) FROM table";

Thanks!
Bickey 

Hey guys,

I use the code below to add a corners to an image and it works great but when i add a border to the image it add a square.... any ideas how i can add a border to the rounded image?

<?php
$image_file = $_GET['src'];
$corner_radius = isset($_GET['radius']) ? $_GET['radius'] : 20; // The default corner radius is set to 20px
$topleft = (isset($_GET['topleft']) and $_GET['topleft'] == "no") ? false : true; // Top-left rounded corner is shown by default
$bottomleft = (isset($_GET['bottomleft']) and $_GET['bottomleft'] == "no") ? false : true; // Bottom-left rounded corner is shown by default
$bottomright = (isset($_GET['bottomright']) and $_GET['bottomright'] == "no") ? false : true; // Bottom-right rounded corner is shown by default
$topright = (isset($_GET['topright']) and $_GET['topright'] == "no") ? false : true; // Top-right rounded corner is shown by default
$imagetype=strtolower($_GET['imagetype']);
$backcolor=$_GET['backcolor'];
$endsize=$corner_radius;
$startsize=$endsize*3-1;
$arcsize=$startsize*2+1;

if (($imagetype=='jpeg') or ($imagetype=='jpg')) {
$image = imagecreatefromjpeg($image_file);
} else {
if (($imagetype=='GIF') or ($imagetype=='gif')) {
$image = imagecreatefromgif($image_file);
} else {
$image = imagecreatefrompng($image_file);
}
}


$size = getimagesize($image_file);
// Top-left corner
$background = imagecreatetruecolor($size[0],$size[1]);
imagecopymerge($background, $image, 0, 0, 0, 0, $size[0], $size[1], 100);
$startx=$size[0]*2-1;
$starty=$size[1]*2-1;
$im_temp = imagecreatetruecolor($startx,$starty);
imagecopyresampled($im_temp, $background, 0, 0, 0, 0, $startx, $starty, $size[0], $size[1]);
$bg = imagecolorallocate($im_temp, hexdec(substr($backcolor,0,2)),hexdec(substr($backcolor,2,2)),hexdec(substr($backcolor,4,2)));
$fg = imagecolorallocate($im_temp, hexdec(substr($forecolor,0,2)),hexdec(substr($forecolor,2,2)),hexdec(substr($forecolor,4,2)));

if ($topleft == true) {
imagearc($im_temp, $startsize, $startsize, $arcsize, $arcsize, 180,270,$bg);
imagefilltoborder($im_temp,0,0,$bg,$bg);
}

// Bottom-left corner
if ($bottomleft == true) {
imagearc($im_temp, $startsize, $starty-$startsize,$arcsize, $arcsize, 90,180,$bg);
imagefilltoborder($im_temp,0,$starty,$bg,$bg);
}

// Bottom-right corner
if ($bottomright == true) {
imagearc($im_temp, $startx-$startsize, $starty-$startsize,$arcsize, $arcsize, 0,90,$bg);
imagefilltoborder($im_temp,$startx,$starty,$bg,$bg);
}

// Top-right corner
if ($topright == true) {
imagearc($im_temp, $startx-$startsize, $startsize,$arcsize, $arcsize, 270,360,$bg);
imagefilltoborder($im_temp,$startx,0,$bg,$bg);
}


$newimage = imagecreatetruecolor($size[0],$size[1]);
imagecopyresampled($image, $im_temp, 0, 0, 0, 0, $size[0],$size[1],$startx, $starty);

// Output final image
header("Content-type: image/png");
imagepng($image);
imagedestroy($image);
imagedestroy($background);
imagedestroy($im_temp);
?>