I want to add numeric values of two text boxes in php mysql

Question

I want to add values of two text boxes and store both textbox values,sum into mysql database table using php as the code below

        <?php
    //Include Database
    include 'db.php';
    $data = new Databases;
    $msg = '';
    if(isset($_POST["submit"]))
    {
     $insert_data = array(
     'first' => mysqli_real_escape_string($data->con, $_POST['first']),
     'Second' => mysqli_real_escape_string($data->con, $_POST['Second']),
     );
     if($data->insert('sum', $insert_data))
     {
     $msg = "Inserted Data Successfully!";
     }
    }
    ?>

    <?php
    if(isset($msg))
    {
     echo $msg;
    }
    ?>

try it insted of array $insert_data = $_POST['first'] + $_POST['Second']; — Ahmed Ginani
– Ahmed Ginani, Commented Apr 26, 2017 at 6:12
where you want to store sum....in column first or second or there is third column with heading sum in mysql database ? — Dr M L M J
– Dr M L M J, Commented Apr 26, 2017 at 6:13

PHP Dev · Accepted Answer · 2017-04-26 06:17:03Z

2

try this one instead of array.

  $sum = $_POST['first'] + $_POST['Second'];
  if($data->insert('sum',$sum)){
   $msg = "Inserted Data Successfully!";
  }else{
   $msg = "Inserted Data Successfully!";
  }

answered Apr 26, 2017 at 6:17

PHP Dev

5034 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Aman Kumar · Accepted Answer · 2017-04-26 06:13:56Z

0

Example Below

 if(isset($_POST["submit"]))
    {
        $first => mysqli_real_escape_string($data->con, $_POST['first']);
        $second => mysqli_real_escape_string($data->con, $_POST['Second']);
        $insert_data = $first + $second ; // sum of two number
        if($data->insert('sum', $insert_data))
        {
            $msg = "Inserted Data Successfully!";
        }
    }

answered Apr 26, 2017 at 6:13

Aman Kumar

4,5573 gold badges21 silver badges40 bronze badges

Comments

xcution · Accepted Answer · 2017-04-26 06:15:03Z

0

<?php
//Include Database
include 'db.php';
$data = new Databases;
$msg = '';

if(isset($_POST["submit"])) {

    $first = $_POST['first'];
    $Second = $_POST['Second'];

    $total =  $first+$Second;

    $insert_data = array('total' => mysqli_real_escape_string($data->con, $total));

    if($data->insert('sum', $insert_data)) {
        $msg = "Inserted Data Successfully!";
    }

}

if(isset($msg)) {
    echo $msg;
}

?>

answered Apr 26, 2017 at 6:15

xcution

915 bronze badges

Comments

Dr M L M J · Accepted Answer · 2017-04-26 06:16:56Z

0

Can try : Assuming you have three columns in mysql table viz. 'first', 'second' and 'sum'

<?php
//Include Database
include 'db.php';
$data = new Databases;
$msg = '';
if(isset($_POST["submit"]))
    {
     $first =mysqli_real_escape_string($data->con, $_POST['first']);
     $second = mysqli_real_escape_string($data->con, $_POST['Second']);
     $sum = $first+$second;

    $insert_data = array(
       'first' => $first,
       'Second' => $second,
       'sum' => $sum
     );
    $inserted = $data->insert('sum', $insert_data);
    if ($inserted)
     {
      $msg = "Inserted Data Successfully!";
     }
}
?>

<?php
if(isset($msg))
{
 echo $msg;
}
?>

answered Apr 26, 2017 at 6:16

Dr M L M J

2,3875 gold badges21 silver badges41 bronze badges

1 Comment

Vijay Over a year ago

Thankq Dr Manish Joshi

Collectives™ on Stack Overflow

I want to add numeric values of two text boxes in php mysql

4 Answers 4

Comments

Example Below

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Example Below

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related