<?php
    require_once 'conn.php';

    if($_POST['txt_name']){
        $name = $_POST['txt_name'];

        $conn->query("INSERT INTO `member` VALUES('', '$name')");

        $query = $conn->query("SELECT * FROM `member` WHERE `name` = '$name'");
        $fetch = $query->fetch_array();

        foreach($_POST['skill'] as $val){
            $skill = addslashes($val);
            $conn->query("INSERT INTO `skill` VALUES('', '$skill', '$fetch[mem_id]')");
        }

        echo "Data Inserted";
    }


?>