<?PHP
 
 
$db=mysql_connect($SERVER-URL, $username, $password); mysql_select_db($databasename, $db);
 
 
   function empty_str($str) {
      return ($str=="");
   }
 
 
   function db_query($sql) {
      return mysql_query($sql);
   }
 
   function db_get($result) {
      return mysql_fetch_array($result);
   }
 
 
echo "<form name='extra' action='#'>";
 
      // PREISE
      $sql = "SELECT prPrice,   prSpecialPrice,productID     FROM CoreCommerceProducts;";
      $result = mysql_query($sql);
      while($row = mysql_fetch_assoc($result)) {
         // CHECKEN OB ANGEBOT
         if($row['prSpecialPrice']=="0.0000" OR empty($row['prSpecialPrice'])){
            $value=$row['prPrice'];
         }
         else{
            $value=$row['prSpecialPrice'];
            }
 
         echo "<input type='hidden' id='preis_".$row['productID']."' value='".round($value,2)."' />"; // akID[47][atSelectOptionID]_5
      }
 
 
      // EXTRAS
       $sql = "SELECT * FROM atCoreCommerceProductAdjustmentSelectOptions;";
      $result = mysql_query($sql);
      while($row = mysql_fetch_assoc($result)) {
         echo "<input type='hidden' id='extra_akID[".$row['akID']."][atSelectOptionID]_".$row['ID']."' value='".$row['adjustmentValue']."' />"; // akID[47][atSelectOptionID]_5
      }
 
echo "<div id='myoutput'></div></form>";
 
?>
<script type="text/javascript">
function boxes() {
      var inputTags = document.getElementsByTagName('input');
      var checkboxCount = "";
      var summe = 0;
      var counter = 0;
      var produkt = "";
      for (var i=0, length = inputTags.length; i<length; i++) {
          if (inputTags[i].type == 'checkbox' && inputTags[i].checked==true) {
            checkboxCount=inputTags[i].id;
            summe = summe + parseFloat(document.getElementById("extra_"+checkboxCount).value);
            counter=1;
          }
      }
 
      produkt=document.getElementById('productID').value;
      summe = summe + parseFloat(document.getElementById("preis_"+produkt).value);
 
      summe = summe.toFixed(2).toLocaleString() + '€';
      summe=summe.replace('.','a'); // punkt in a
      summe=summe.replace(',','b'); // komma in b
      summe=summe.replace('a',','); //  a in komma
      summe=summe.replace('b','.'); //  b in punkt
 
      if(counter==1){
         document.getElementById('myoutput').innerHTML="<b>Summe:</b> " + summe;
      }
      else{
         document.getElementById('myoutput').innerHTML="";
         }
 
}
 
window.onclick = boxes;
</script>