PHP - Dealing With Negative Numbers

Hi all

I am adding some positive and negative numbers.

But i am getting strange output. Can anyone help me

Here is the code.

Code: [Select]
$sum=7.50+6.45+12.90+12.00+13.00+0.61+32.00+4.00+27.00+18.00+10.88+129.50+92.94-100.00-38.25+76.80-305.33;
echo "<br>Total: ".$sum;

Basically i have to get Total is 0

but i am getting total is 5.6843418860808E-14

Can anyone help me out Please

This topic has been moved to JavaScript Help.

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

Aside from money_format(), is there another way to use "()" instead of "-" for negative numbers?

Actually, using money_format() would be best for me but I've read somewhere that list of locale differ from server to server. Unfortunately, I cannot identify the list of locale supported on the server I'm using (Heliohost) since system('locale -a') is disabled.

Thanks in advance!

So if I have this code (while working on my local machine )...
Code: [Select]
for ($i=1; $i<=15; $i++) {
if ($timelimit == $i) {
${"time".$i}="selected='selected'";
}
}

<select name="timelimit">
<option value="1" <?php echo $time1;?>>1</option>
<option value="2" <?php echo $time2;?>>2</option>
<option value="3" <?php echo $time3;?>>3</option>
<option value="4" <?php echo $time4;?>>4</option>
<option value="5" <?php echo $time5;?>>5</option>
<option value="6" <?php echo $time6;?>>6</option>
<option value="7" <?php echo $time7;?>>7</option>
<option value="8" <?php echo $time8;?>>8</option>
<option value="9" <?php echo $time9;?>>9</option>
<option value="10" <?php echo $time10;?>>10</option>
<option value="11" <?php echo $time11;?>>11</option>
<option value="12" <?php echo $time12;?>>12</option>
<option value="13" <?php echo $time13;?>>13</option>
<option value="14" <?php echo $time14;?>>14</option>
<option value="15" <?php echo $time15;?>>15</option>
</select>
When I view the select menu in the browser, all but one of the options says "Notice:  Undefined variable: time1 in C:\wamp\www\yyyyyy\create.php on line 112".

It doesn't say this if I publish everything to the internet.

So the question is, should I put code in to eliminate those Notices, or does it not matter.   In other words, if I add this snippet below to declare all the other variables, it eliminates all the Notices. But is this necessary/good practice to do?..
Code: [Select]
for ($i=1; $i<=15; $i++) {
${"time".$i}="";
}

Hi

I found a tutorial on dealing with databases he http://www.phpfreaks.com/tutorial/php-basic-database-handling

It's great, except that I need it to do more than just a name; I need first, last, dob and email. I have it figured out how to order, insert and delete, but can someone help me figure out how to do the updating?

The tutorial creates an array called cname and loops through it to do the update, but when I add more fields, it only holds the last fileds (emails in this case)

I just need to be able to update all the fields for each user instead of just the name. Sounds easy but I've gotten nowhere

Everything I have tried is posted below.

Any help? Thanks

Code: [Select]
// INSERT: if we have a name to add...
if($_POST['fname']) {   
// little bit of cleaning...   
$fname = mysql_real_escape_string($_POST['fname']);
$lname = mysql_real_escape_string($_POST['lname']);
$dob = mysql_real_escape_string($_POST['dob']);
$email = mysql_real_escape_string($_POST['email']);
// check for previous entry
$sql_check = "SELECT id FROM test WHERE fname='$fname' AND lname='$lname'";
$res_check = mysql_query($sql_check, $conn) or trigger_error("SQL", E_USER_ERROR);
if (mysql_num_rows($res_check) == 1) {
while ($row = mysql_fetch_assoc($res_check)) {
$id = $row['id'];
}
// update
$sql = "UPDATE test SET Current=1 WHERE id='$id'";
$res = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);
} else {
// insert new name into table   
$sql = "INSERT INTO test (id, fname, lname, dob, email) VALUES ('', '$fname', '$lname', '$dob', '$email')";   
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);
}
} // end if
// UPDATE: if we have name(s) to change...
if($_POST['udata']) {   
/*
// for each name to change...   
foreach ($_POST['udata'] as $input => $v) {
echo "$input = $v<br />";
$sql = "UPDATE test SET ";
foreach ($v as $id => $value) {
echo "$id = $value<br />";
}
$sql .= "WHERE ...";
}
echo "<hr />$sql<hr />";
print_r($_POST['udata']);
*/

for ($i = 0; $i < count($_POST['udata']['fname']); $i++) {
$fname = $_POST['udata']['fname'][$i];
echo "$i = $fname<br />";
}

/*
foreach($_POST['cname'] as $cid => $cname) {     
// little bit of cleaning...     
$id = mysql_real_escape_string($cid);     
$fname = mysql_real_escape_string($cname);
$lname = mysql_real_escape_string($cname);
$dob = mysql_real_escape_string($cname);
$email = mysql_real_escape_string($cname);
// update name in the table       
$sql = "UPDATE test SET fname = '$fname', lname='$lname', dob='$dob', email='$email' WHERE id = '$id'";     
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);   
} // end foreach
*/
} // end if         
// DELETE: if we have a name to delete...
if($_GET['id']) {   
// little bit of cleaning...   
$id = mysql_real_escape_string($_GET['id']);   
// delete name from table   
$sql = "UPDATE test SET Current=0 WHERE id= '$id'";   
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);
} // end if
// ORDERBY: if one of the links was clicked..
if ($_GET['orderby']) {   
// make an aray of allowed names   
$allowed = array('id','fname', 'lname', 'dob', 'email');   
// bit of cleaning...   
$order = mysql_real_escape_string($_GET['orderby']);   
// is it a valid column name? yes: use it. no: default to 'id'   
$order = (in_array($order, $allowed))? $order : "id";
// if no link clicked, default to 'id'
} else {   
$order = "id";
} // end else
// SELECT: get the list of names from database
$sql = "SELECT id, fname, lname, dob, email FROM test WHERE Current=1 ORDER BY $order";
//$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);
$result = mysql_query($sql, $conn) or die(mysql_error());
/**** end deal with the database ****/
/**** list everything out ****/
// list columns
echo "<form action = '{$_SERVER['PHP_SELF']}' method = 'post'>\r\n";
echo "<table border = '1'>\r\n";
echo "<tr>\r\n";     
echo "<td><a href = '{$_SERVER['PHP_SELF']}?orderby=id'>id</a></td>\r\n";     
echo "<td><a href = '{$_SERVER['PHP_SELF']}?orderby=fname'>fname</a></td>\r\n";   
echo "<td><a href = '{$_SERVER['PHP_SELF']}?orderby=lname'>lname</a></td>\r\n";   
echo "<td><a href = '{$_SERVER['PHP_SELF']}?orderby=dob'>dob</a></td>\r\n";     
echo "<td><a href = '{$_SERVER['PHP_SELF']}?orderby=email'>email</a></td>\r\n";   
echo "<td>delete</td>\r\n";   
echo "</tr>\r\n";
// loop through list of names
while ($list = mysql_fetch_assoc($result)) {
echo "<tr>\r\n";     
echo "<td>{$list['id']}</td>\r\n";     
echo "<td><input type = 'text' name = 'udata[fname][{$list['id']}]' value = '{$list['fname']}' />\r\n";
echo "<td><input type = 'text' name = 'udata[lname][{$list['id']}]' value = '{$list['lname']}' />\r\n";
echo "<td><input type = 'text' name = 'udata[dob][{$list['id']}]' value = '{$list['dob']}' />\r\n";
echo "<td><input type = 'text' name = 'udata[email][{$list['id']}]' value = '{$list['email']}' />\r\n";
echo "<td><a href = '{$_SERVER['PHP_SELF']}?id={$list['id']}'>delete</a></td>\r\n";   
echo "</tr>\r\n";
} // end while
// list input box for adding new entry
echo "<tr>";     
echo "<td bgcolor = 'gray'></td>\r\n";     
echo "<td><input type = 'text' name = 'fname' /></td>\r\n"; 
echo "<td><input type = 'text' name = 'lname' /></td>\r\n";
echo "<td><input type = 'text' name = 'dob' /></td>\r\n";
echo "<td><input type = 'text' name = 'email' /></td>\r\n";
echo "<td bgcolor = 'gray'></td>\r\n";   
echo "</tr><tr>\r\n";     
echo "<td></td>\r\n";
echo "<td align = 'center'><input type = 'submit' value = 'submit' /></td>\r\n";     
echo "<td></td>\r\n";
echo "</tr></table></form>\r\n";
/**** end list everything out ****/