PHP - One Very Simple Question About Php And Decimals

Hi - To me, this doesn't make sense.   My Order form uploads product weights in an array . If I echo out those weights they are fine ie 25.25

However, when I try to update the DB for some reason, the for loop strips out all but the first digit, so 25.25 becomes '2' or indeed if I had entered 9999999 it just '9' is entered in to the DB.

I have tried using number_format to pre-process the decimals, - but I get an error saying you can not use it in a write format.

Many Thanks to anyone who can help with this  !!


PS - I have abbreviated the below code for clarity:

Code: [Select]
$weight = $_POST['weight'];

        for ($i = 0; $i < $numloops ; $i++)

      {
       $sql ="
UPDATE `confirmedorder`
SET orderid = '$orderid[$i]', weight='$weight[$i]',status='finished', ordervalue='$ordervalue'
WHERE customerid = $customerid
";
$this->db->query($sql);
}

I want to find the first sentence in a string without counting decimals. Here is the code I have, but I still want it to display the decimals, but I don't want it to count as the end of a sentence.

$content = "This is my test string which is 3.5% of what I'm trying to do. This is only a test.";

Code: [Select]
function first_sentence($content)
 {
if(preg_match('/[0-9]+\.[0-9]/', $content, $num)) {
$number = "$num[0]";
$content = ereg_replace("$number","", $content);
}
preg_match('/^.*[^\s](\.|\?|\!)/U', $content, $match);
$string = $match[0];

$title_count = strlen($match[0]);
if($title_count > "6"){
return "$match[0]";
}
else {
$content2 = ereg_replace("$match[0]","", $content);
preg_match('/^.*[^\s](\.|\?|\!)/U', $content2, $step);
return "$match[0] $step[0]";
}}
Currently this is what it displays: This is my test string which is % of what I'm trying to do.
This is what I want it to display: This is my test string which is 3.5% of what I'm trying to do.

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

Ok so say I have php do some calculations for me

Code: [Select]

$Value1 = 300;
$Value2 = 100000;
$FirstRatio = $Value1 / $Value2;

$Value3 = 8000;
$Value4 = 6000000;
$SecondRatio = $Value3 / $Value4;


$FirstRatio = 0.003
$SecondRatio = 0.0013

How would I go about doing these calculations and then sorting $FirstRatio and $SecondRatio and then it would take the highest ratio ($FirstRatio) and it would echo the value?

Lets say I have:

$var=5;

What would an output look like to get me:

1<br>
2<br>
3<br>
4<br>
5<br>

Im at a complete loss!


Thanks!

what does the # symbol do in php(e.x index.php?cat=1#privacy)? How can i use it? From what i 've seen you use it for changing a whole div without reloading the page like tabs..

if someone can help me out with this, its quite simple but I can't seem to get it to work..

Basically, this is the code I have for now, the issue is if I have 0 product or items, I don't want the sorting option to show up on the page,    from the code below, what line can I add tosay that if there is no products in a category, not to show the SORT feature.

thanks in advance if anyone can help.


{if isset($orderby) AND isset($orderway)}
<!-- Sort products -->
{if isset($smarty.get.id_category) && $smarty.get.id_category}
   {assign var='request' value=$link->getPaginationLink('category', $category, false, true)}
{elseif isset($smarty.get.id_manufacturer) && $smarty.get.id_manufacturer}
   {assign var='request' value=$link->getPaginationLink('manufacturer', $manufacturer, false, true)}
{elseif isset($smarty.get.id_supplier) && $smarty.get.id_supplier}
   {assign var='request' value=$link->getPaginationLink('supplier', $supplier, false, true)}
{else}
   {assign var='request' value=$link->getPaginationLink(false, false, false, true)}
{/if}
<form id="productsSortForm" action="{$request|escape:'htmlall':'UTF-8'}">
   <select id="selectPrductSort" onchange="document.location.href = $(this).val();">
      <option value="{$link->addSortDetails($request, $orderbydefault, $orderwaydefault)|escape:'htmlall':'UTF-8'}" {if $orderby eq $orderbydefault}selected="selected"{/if}>{l s='--'}</option>
      {if !$PS_CATALOG_MODE}
      <option value="{$link->addSortDetails($request, 'price', 'asc')|escape:'htmlall':'UTF-8'}" {if $orderby eq 'price' AND $orderway eq 'asc'}selected="selected"{/if}>{l s='Price: lowest first'}</option>
      <option value="{$link->addSortDetails($request, 'price', 'desc')|escape:'htmlall':'UTF-8'}" {if $orderby eq 'price' AND $orderway eq 'desc'}selected="selected"{/if}>{l s='Price: highest first'}</option>
      {/if}
      <option value="{$link->addSortDetails($request, 'name', 'asc')|escape:'htmlall':'UTF-8'}" {if $orderby eq 'name' AND $orderway eq 'asc'}selected="selected"{/if}>{l s='Product Name: A to Z'}</option>
      <option value="{$link->addSortDetails($request, 'name', 'desc')|escape:'htmlall':'UTF-8'}" {if $orderby eq 'name' AND $orderway eq 'desc'}selected="selected"{/if}>{l s='Product Name: Z to A'}</option>
      {if !$PS_CATALOG_MODE}
      <option value="{$link->addSortDetails($request, 'quantity', 'desc')|escape:'htmlall':'UTF-8'}" {if $orderby eq 'quantity' AND $orderway eq 'desc'}selected="selected"{/if}>{l s='In-stock first'}</option>
      {/if}
   </select>
   <label for="selectPrductSort">{l s='Sort by'}</label>
</form>
<!-- /Sort products -->
{/if}

Hi, I'm working on a product page and I got it to list all the products in one column of a table, but when I add a second column it just duplicates the first column.  What do I need to change? 

Code: [Select]
<?php
require_once("functions.php"); 
?> 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<style type="text/css">
td {
border-top-style: solid;
border-right-style: solid;
border-bottom-style: solid;
border-left-style: solid;
border-top-color: #30C;
border-right-color: #30C;
border-bottom-color: #30C;
border-left-color: #30C;
}
</style>
</head>

<body>
<form action="" method="post" name="catalog">
<?php 

DatabaseConnection();  

  $query = "SELECT * FROM treats";
        $result_set = mysql_query($query) or die(mysql_error());

        $output = "<table>";
        while ($row = mysql_fetch_array($result_set))
        {
            $output .= (" 
<tr>
<td width=\"400px\">" . $row['product_title']."<br /> ".$row['product_Description']."<br />" .$row['price'] . "<br />  Quantity: <input name=\"quantity\" type=\"text\" size=\"2\" /> </td>  
<td width=\"400px\">" . $row['product_title']."<br /> ".$row['product_Description']."<br />" .$row['price'] . "<br />  Quantity: <input name=\"quantity\" type=\"text\" size=\"2\" /> </td>  
</tr>
");
        }
        $output .= "</table>";
        echo $output;
?>   
</form>
</body>
</html>

I can't figure out why im getting an error with this code.

if ($notif = mysql_query("SELECT * FROM notifications_1 WHERE recieverid='". $_SESSION['id']."' ORDER BY read ASC, id DESC") or die (mysql_error())); {

Code: [Select]
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'read ASC, id DESC' at line 1

Hi, I am trying to convert a php function into perl and need to understand the following line in red :        function pagination($query, $per_page = 10,$page = 1, $url = '?'){       
     $query = "SELECT COUNT(*) as `num` FROM {$query}";
     $row = mysql_fetch_array(mysql_query($query));
     $total = $row['num'];
        $adjacents = "2";      $page = ($page == 0 ? 1 : $page); 
     $start = ($page - 1) * $per_page;        
  
     $prev = $page - 1;       
     $next = $page + 1;
        $lastpage = ceil($total/$per_page);
     $lpm1 = $lastpage - 1;
     
     $pagination = "";
     if($lastpage > 1)
     {  .........................................     What will be the output of this line above in red.   Thank you very much. Regards. Tonya

hello all I'm VERY new to php and I just have a simple question

how do I bold the output text of this string

echo $row['name']."<BR>";

Hello there fellow programmers,

I was just wondering if there was any difference between doing this:

Code: [Select]
echo "Say Something Here";
and this

Code: [Select]
echo "Say ";
echo "Something ";
echo "Here";
Thank you in advance.

Notice: I am aware of the fact that they will output the same thing, my question is regarding resources.

Hello everyone! I am a new user and I have a simple question. How do I set a password for a user to log in to my site with PHP? I have no MySQL database just a iOS code/host app. I know this isn’t secure but only me and my friends are on the site. Any help is appreciated. 

Hello to everyone

I would like to ask for this simple question.. Im trying to put if and else condition on my php code. However this condition is not working..

Code: [Select]
if($file == #3#){
echo "No results found";
}else{ echo "results has been found"; }
This variable $file is the result after i used an API.. If the API does not see any results they would return #3# as the result. This means they returned a transaction code of 3 which you can see here http://developer.textapp.net/WebService/TransactionCodes.aspx means that there was nothing to return.

The condition does not function well even if i make 3 or #3# as part of the condition. Can you help me guys?

thanks

I've seen this,
Code: [Select]
<?php } ?>
in a lot of scripts at the very end of the script. What does this piece of code do?