Data Submit with php mysql
$q1 = $_POST['q1']; $q1r = $_POST['q1_r']; $q1a = $_POST['q1_a']; $q1b = $_POST['q1_b']; $q1c = $_POST['q1_c']; $table_name2 = "teacherID_".$id."_model_test"; $sql = "INSERT INTO teacherID_1_model_test (user_name, user_pass, email) VALUES ( '$value1', '$value2', '$value3')"; /* all colum name have to diclear and all value also diclear even though table has permission to accept null value */ if( mysqli_query($dbconn, $sql) === TRUE){ echo "Record submitted"; }else{ echo "Record submitted"; }