-1

I have 3 tables in my database tbl1, tbl2 and tbl3.

My HTML form

<form action="" method="post">
<input type="text" class="form-control" id="department" name="department" placeholder="Enter Name" required>
<input type="text" class="form-control" id="cost" name="cost" placeholder="Enter Name" required>
   <select class="custom-select" name="roles" id="inputGroupSelect01 status">
                    <option selected>Choose...</option>
                    <option value="Available">Available</option>
                    <option value="Repair">Repair</option>
                    <option value="Checked Out">Checked Out</option>

                  </select>

ADD USER

My question is if the user chose Available then the entire form data should go to tbl1, if the value is disposed then tbl2, if its checked out then tbl3.

How can i do it?

Dharman
  • 26,923
  • 21
  • 73
  • 125
abululiwa
  • 63
  • 1
  • 1
  • 7
  • Isn't 'disposed' simply a synonym for 'available' !?! That said, it would seem more sensible to have one table instead of three. – Strawberry Feb 23 '20 at 08:19
  • There is no need to declare `value` attributes in your options if they are identical to the text value. Please research and try something BEFORE posting a question. – mickmackusa Feb 23 '20 at 09:30

1 Answers1

0

First of all your from need to have a submit button to send data to server side

<form action="" method="post">
    <input type="text" class="form-control" id="department" name="department" 
     placeholder="Enter Name" required>
    <input type="text" class="form-control" id="cost" name="cost" 
     placeholder="Enter Name" required>
    <select class="custom-select" name="roles" id="inputGroupSelect01 status">
        <option selected>Choose...</option>
        <option value="Available">Available</option>
        <option value="Repair">Repair</option>
        <option value="Checked Out">Checked Out</option>                     
    </select>
    <button type="submit">
        save data
    </button>
</form>

Assume that your form submitted correctly to server side, you can use switch case for this case to check which option is selected and then save form data to related table:

<?php 
switch($_POST['roles']) {
    case 'Available':
         // insert form data in tbl1
        break;
    case 'Repair':
         // insert form data in tbl2
        break;
    case 'Checked Out':
         // insert form data in tbl3
        break; 
    default:
        echo 'no role selected';
        break;
}
?>
ArashShiri
  • 70
  • 5