如何通过sql在数据库表中插入多个变量？

Question

I want insert multiple variable as VALUES in my database table. here is my code

include 'database_connect.php';

$namef=  $_post["fnam"];
$lnamel= $_post["lnam"];
$addres= $_post["addres"];
$mail= $_post["email"];
$countr= $_post["countr"];
$db= $_post["do"];
$m= $_post["m"];
$pasword= $_post["pas"];

$insertSql= "INSERT INTO abcd(Id, First_name, Last_name, Address, Email, Country, Date_of_birth, Mobile_number, Password, Status) 
VALUES(NULL,'$namef', '$namel', '$addres', '$mail', '$countr', '$db', '$m', '$pasword', '0')";

if(mysql_query($insertSql))
    header("location: login_success.php");
else
    header("location: wrong_inf.php");

here only in Id and status field are inserted and all other fields are going empty even though i am giving some input in those inputs.

I don't know how to solve this.

Note:here Id is integer type and status is tinyint type and all other field is varchar type.

Answer 1

PHP Variables are case-sensitives

try

$namef=$_POST["fnam"];
$lnamel=$_POST["lnam"];

ETC....