how to insert same data in different table based on checkbox ? mysql php

Question

I want to insert data in multiple table

I have two tables > recharge, due_user

recharge table has

>> ID - MOBno-  AMount - Network

due_user has

>> ID - userID - MOBno - Amount - NETWORK

in my form I have checkbox which will ask userID only if I click checkbox.

now insertion of data procedure would be .

if unchecked

 data > ID - mobno - Amount- Network

will be inserted in Recharging table if checked

 data > ID-  userID -  mobile - amount - Network

will go both table Recharge and Due_user table but user id will we goes into only due usertable

Bart · Accepted Answer · 2016-03-24 10:41:52Z

1

Let's say your checkbox looks like this

<input type="checkbox" name="isUserId" />

Then in php

<?php
    //here goes your recharge table insert
    if(isset($_POST['isUserId'])){
        //and here due user table insert
    }
?>

answered Mar 24, 2016 at 10:41

Bart

1,2682 gold badges12 silver badges15 bronze badges

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

1 Comment

i want to insert data in both tabe .. in recharge list without userid and in due user list with user id