Assignment: Set A Q.2 Solution

Write a PHP script to accept account details (account number, account type and balance). Store these details in the account table and display an appropriate message.

Index.html

          <html>
  <body>
    <form action="backend.php" method="post">
      <input type="number" name="ano" placeholder="Account Number">
      <br><br>
      <select name="atype" >
        <option value="">Select Account Type</option>
        <option value="saving">Saving</option>
        <option value="current">Current</option>
      </select>
      <br><br>
      <input type="number" name="abal" placeholder="Account Balance">
      <br><br><br>
      <input type="submit">
    </form>
  </body>
</html>

Backend.php

          <?php
  $ano=$_POST['ano'];
  $abal=$_POST['abal'];
  $atype=$_POST['atype'];

  $conn=mysql_connect("localhost","root","");
    if(!$conn)
      {
        echo"Not connected to database";
      }

  $sd=mysql_select_db("seta");
  if(!$sd)
  {
    echo"Not selected database";
  }

  $query=mysql_query("insert into account
                        values($ano,'$atype',$abal);
                      ");
    if(!$query)
    {
      echo"Not inserted the record";
    }
    else{
      echo"Inserted record";
    }
                      
?>