0

Dear all, I would really appreciate your help and assistance with a bug i'm facing in myphpadmin Mysql table.

I have a table which is named as total amount. I also have a front end php. interface where i do my data entry from. When I enter for example (100000) it displays as its is, but I'm facing difficulty when i have to check my totals because i want when ever i eneter (100000) it should automatically display or store my data as (100,000) or if im entering an amount ( 54600) fifty four thousand six hundred it should diplay it ( 54,600) so the confusion doesn't occur in reading the amounts. I'm going to paste the coding of my php page and if you think there is anything i need to make changes from dreamweaver i will do that accordingly. thank you ! i really appreciate the effort. Thanks!

<script language="javascript" src="calendar/calendar.js"></script>
<script type="text/javascript">
function vali()
{
var x=document.forms["form11"]["photo"].value;
if (x==null || x=="")
  {
  alert("Please Select BPV PDF");
  return false;
  }
}
</script>
<script type="text/javascript">
function summall()
{
var a = eval(document.form11.amount0.value);
var b = eval(document.form11.amount1.value);
var c = eval(document.form11.amount2.value);
var d = eval(document.form11.amount3.value);
var e = eval(document.form11.amount4.value);
f = a + b;
g = f + c;
h = g + d;
i = h + e;
document.form11.tammount.value = i;
}
</script>
<link href="default.css" rel="stylesheet" type="text/css" />
        <h2>Add BPV. 
</h2>
<div class="box">
  <form name="form11" method="post" action="bpvadded.php" enctype="multipart/form-data" onsubmit="return vali()" >
  <table width="100%" border="1" bordercolor="#99CC00">
    <tr>
      <td><table width="100%" border="0">
        <tr>
          <td colspan="2"><h3>Link Document Path: </h3></td>
          <td colspan="6"> </td>
          </tr>
        <tr>
          <td colspan="8"><input type="hidden" name="size" value="3500000" />
              <input type="file" name="photo" /></td>
        </tr>
        <tr>
          <td colspan="8"><table width="100%" border="0">
            <tr>
              <td width="12%">BPV #</td>
              <td width="13%"><input name="bpv" type="text" id="bpv" size="8"/></td>
              <td width="12%">Bank Name </td>
              <td width="11%"><select name="bname" id="bname" onchange="return (MM_jumpMenuadm('parent',this,0,this.selectedIndex))">
                <option selected="selected" value="section/0">- Select -</option>
                <?php 
            include("includes/DB.php"); 
    $tbl_name="bank"; // Table name
    $con = mysql_connect("$host", "$username", "$password");
    mysql_select_db("$db_name")or die("cannot select DB");
    $sql="SELECT * from $tbl_name";
    $result=mysql_query($sql) or die(mysql_error());
    while($row = mysql_fetch_array($result))
        echo '<option value="'.$row['bname'] .'">'.$row['bname'] .'</option>';
    mysql_close($con);
?>
              </select></td>
              <td width="15%">Account No </td>
              <td width="37%" colspan="3"><input name="acno" type="text" id="acno" size="8" /></td>
              </tr>
            <tr>
              <td>Cheque No</td>
              <td><input name="chq" type="text" id="chq" size="8" /></td>
              <td>Paid to </td>
              <td><input name="paidto" type="text" id="paidto" size="8" /></td>
              <td>Date:</td>
              <td colspan="3"><label>
                <?php
                    require_once('calendar/classes/tc_calendar.php');
                      $myCalendar = new tc_calendar("dateff", true, false);
                      $myCalendar->setIcon("calendar/images/iconCalendar.gif");
                      //$myCalendar->setDate(date('d'), date('m'), date('Y'));
                      $myCalendar->setPath("calendar/");
                      $myCalendar->setYearInterval(2000, 2015);
                      $myCalendar->dateAllow('2000-01-01', '2015-01-01');
                      $myCalendar->setDateFormat('j F Y');
                      //$myCalendar->setHeight(350);
                      //$myCalendar->autoSubmit(true, "form1");
                      $myCalendar->setAlignment('left', 'bottom');
                      //$myCalendar->setSpecificDate(array("2011-04-01", "2011-04-04", "2011-12-25"), 0, 'year');
                      //$myCalendar->setSpecificDate(array("2011-04-10", "2011-04-14"), 0, 'month');
                      //$myCalendar->setSpecificDate(array("2011-06-01"), 0, '');
                      $myCalendar->writeScript();
                      ?>
              </label></td>
              </tr>
            </table></td>
          </tr>
        <tr>
          <td width="12%"> </td>
          <td width="13%"> </td>
          <td width="12%"> </td>
          <td width="11%"> </td>
          <td width="8%"> </td>
          <td colspan="3"> </td>
          </tr>
        <tr>
          <td> </td>
          <td> </td>
          <td> </td>
          <td> </td>
          <td> </td>
          <td colspan="3"> </td>
          </tr>
        <tr>
          <td>Project Code </td>
          <td><select name="prjcode0" id="prjcode0" onchange="return (MM_jumpMenuadm('parent',this,0,this.selectedIndex))">
            <option selected="selected" value="section/0">- Select -</option>
            <?php 
            include("includes/DB.php"); 
    $tbl_name="projects"; // Table name
    $con = mysql_connect("$host", "$username", "$password");
    mysql_select_db("$db_name")or die("cannot select DB");
    $sql="SELECT * from $tbl_name";
    $result=mysql_query($sql) or die(mysql_error());
    while($row = mysql_fetch_array($result))
        echo '<option value="'.$row['code'] .'">'.$row['code'] .'</option>';
    mysql_close($con);
?>
          </select></td>
          <td>Budget Code</td>
          <td><select name="budjetcode0" id="budjetcode0" onchange="return (MM_jumpMenuadm('parent',this,0,this.selectedIndex))">
            <option selected="selected" value="section/0">- Select -</option>
            <?php 
            include("includes/DB.php"); 
    $tbl_name="bcodes"; // Table name
    $con = mysql_connect("$host", "$username", "$password");
    mysql_select_db("$db_name")or die("cannot select DB");
    $sql="SELECT * from $tbl_name";
    $result=mysql_query($sql) or die(mysql_error());
    while($row = mysql_fetch_array($result))
        echo '<option value="'.$row['account'] .'">'.$row['account'] .'</option>';
    mysql_close($con);
?>
          </select></td>
          <td>Desc</td>
          <td width="17%"><input name="desc0" type="text" id="desc0" size="8" /></td>
          <td width="14%">Amount </td>
          <td width="13%"><input name="amount0" type="text" id="amount0" value="0" size="8" /></td>
        </tr>
        <tr>
          <td>Project Code </td>
          <td><select name="prjcode1" id="prjcode1" onchange="return (MM_jumpMenuadm('parent',this,0,this.selectedIndex))">
            <option selected="selected" value="section/0">- Select -</option>
            <?php 
            include("includes/DB.php"); 
    $tbl_name="projects"; // Table name
    $con = mysql_connect("$host", "$username", "$password");
    mysql_select_db("$db_name")or die("cannot select DB");
    $sql="SELECT * from $tbl_name";
    $result=mysql_query($sql) or die(mysql_error());
    while($row = mysql_fetch_array($result))
        echo '<option value="'.$row['code'] .'">'.$row['code'] .'</option>';
    mysql_close($con);
?>
          </select></td>
          <td>Budget Code</td>
          <td><select name="budjetcode1" id="budjetcode1" onchange="return (MM_jumpMenuadm('parent',this,0,this.selectedIndex))">
            <option selected="selected" value="section/0">- Select -</option>
            <?php 
            include("includes/DB.php"); 
    $tbl_name="bcodes"; // Table name
    $con = mysql_connect("$host", "$username", "$password");
    mysql_select_db("$db_name")or die("cannot select DB");
    $sql="SELECT * from $tbl_name";
    $result=mysql_query($sql) or die(mysql_error());
    while($row = mysql_fetch_array($result))
        echo '<option value="'.$row['account'] .'">'.$row['account'] .'</option>';
    mysql_close($con);
?>
          </select></td>
          <td>Desc</td>
          <td><input name="desc1" type="text" id="desc1" size="8" /></td>
          <td>Amount </td>
          <td><input name="amount1" type="text" id="amount1" value="0" size="8" /></td>
        </tr>
        <tr>
          <td>Project Code </td>
          <td><select name="prjcode2" id="prjcode2" onchange="return (MM_jumpMenuadm('parent',this,0,this.selectedIndex))">
            <option selected="selected" value="section/0">- Select -</option>
            <?php 
            include("includes/DB.php"); 
    $tbl_name="projects"; // Table name
    $con = mysql_connect("$host", "$username", "$password");
    mysql_select_db("$db_name")or die("cannot select DB");
    $sql="SELECT * from $tbl_name";
    $result=mysql_query($sql) or die(mysql_error());
    while($row = mysql_fetch_array($result))
        echo '<option value="'.$row['code'] .'">'.$row['code'] .'</option>';
    mysql_close($con);
?>
          </select></td>
          <td>Budget Code</td>
          <td><select name="budjetcode2" id="budjetcode2" onchange="return (MM_jumpMenuadm('parent',this,0,this.selectedIndex))">
            <option selected="selected" value="section/0">- Select -</option>
            <?php 
            include("includes/DB.php"); 
    $tbl_name="bcodes"; // Table name
    $con = mysql_connect("$host", "$username", "$password");
    mysql_select_db("$db_name")or die("cannot select DB");
    $sql="SELECT * from $tbl_name";
    $result=mysql_query($sql) or die(mysql_error());
    while($row = mysql_fetch_array($result))
        echo '<option value="'.$row['account'] .'">'.$row['account'] .'</option>';
    mysql_close($con);
?>
          </select></td>
          <td>Desc</td>
          <td><input name="desc2" type="text" id="desc2" size="8" /></td>
          <td>Amount </td>
          <td><input name="amount2" type="text" id="amount2" value="0" size="8" /></td>
        </tr>
        <tr>
          <td>Project Code </td>
          <td><select name="prjcode3" id="prjcode3" onchange="return (MM_jumpMenuadm('parent',this,0,this.selectedIndex))">
            <option selected="selected" value="section/0">- Select -</option>
            <?php 
            include("includes/DB.php"); 
    $tbl_name="projects"; // Table name
    $con = mysql_connect("$host", "$username", "$password");
    mysql_select_db("$db_name")or die("cannot select DB");
    $sql="SELECT * from $tbl_name";
    $result=mysql_query($sql) or die(mysql_error());
    while($row = mysql_fetch_array($result))
        echo '<option value="'.$row['code'] .'">'.$row['code'] .'</option>';
    mysql_close($con);
?>
          </select></td>
          <td>Budget Code</td>
          <td><select name="budjetcode3" id="budjetcode3" onchange="return (MM_jumpMenuadm('parent',this,0,this.selectedIndex))">
            <option selected="selected" value="section/0">- Select -</option>
            <?php 
            include("includes/DB.php"); 
    $tbl_name="bcodes"; // Table name
    $con = mysql_connect("$host", "$username", "$password");
    mysql_select_db("$db_name")or die("cannot select DB");
    $sql="SELECT * from $tbl_name";
    $result=mysql_query($sql) or die(mysql_error());
    while($row = mysql_fetch_array($result))
        echo '<option value="'.$row['account'] .'">'.$row['account'] .'</option>';
    mysql_close($con);
?>
          </select></td>
          <td>Desc</td>
          <td><input name="desc3" type="text" id="desc3" size="8" /></td>
          <td>Amount </td>
          <td><input name="amount3" type="text" id="amount3" value="0" size="8" /></td>
        </tr>
        <tr>
          <td>Project Code </td>
          <td><select name="prjcode4" id="prjcode4" onchange="return (MM_jumpMenuadm('parent',this,0,this.selectedIndex))">
            <option selected="selected" value="section/0">- Select -</option>
            <?php 
            include("includes/DB.php"); 
    $tbl_name="projects"; // Table name
    $con = mysql_connect("$host", "$username", "$password");
    mysql_select_db("$db_name")or die("cannot select DB");
    $sql="SELECT * from $tbl_name";
    $result=mysql_query($sql) or die(mysql_error());
    while($row = mysql_fetch_array($result))
        echo '<option value="'.$row['code'] .'">'.$row['code'] .'</option>';
    mysql_close($con);
?>
          </select></td>
          <td>Budget Code</td>
          <td><select name="budjetcode4" id="budjetcode4" onchange="return (MM_jumpMenuadm('parent',this,0,this.selectedIndex))">
            <option selected="selected" value="section/0">- Select -</option>
            <?php 
            include("includes/DB.php"); 
    $tbl_name="bcodes"; // Table name
    $con = mysql_connect("$host", "$username", "$password");
    mysql_select_db("$db_name")or die("cannot select DB");
    $sql="SELECT * from $tbl_name";
    $result=mysql_query($sql) or die(mysql_error());
    while($row = mysql_fetch_array($result))
        echo '<option value="'.$row['account'] .'">'.$row['account'] .'</option>';
    mysql_close($con);
?>
          </select></td>
          <td>Desc</td>
          <td><input name="desc4" type="text" id="desc4" size="8" /></td>
          <td>Amount </td>
          <td><input name="amount4" type="text" id="amount4" value="0" size="8" /></td>
        </tr>
        <tr>
          <td colspan="2"> </td>
          <td colspan="6"> </td>
        </tr>
        <tr>
          <td colspan="2"> </td>
          <td> </td>
          <td> </td>
          <td> </td>
          <td> </td>
          <td>Total Amount</td>
          <td><input name="tammount" type="text" id="tammount" size="8"  onfocus='summall()';/></td>
        </tr>
        <tr>
          <td colspan="2"> </td>
          <td colspan="6"> </td>
        </tr>
        <tr>
          <td colspan="2"> </td>
          <td colspan="6"> </td>
        </tr>
        <tr>
          <td colspan="2"> </td>
          <td> </td>
          <td> </td>
          <td> </td>
          <td> </td>
          <td> </td>
          <td><input type="submit" name="upload" title="Add data to the Database" value=" Add " class="login-btn"/></td>
        </tr>
      </table></td>
    </tr>
  </table>
</form>
</div>
2
Contributors
1
Reply
3
Views
5 Years
Discussion Span
Last Post by Dani
0

That's way too much code for me to read, but what you are going to want to do is store the integer by itself in the database, but on DISPLAY, when printing out the number, wrap it in the php number_format() function.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.