บันทึกข้อมูลลงฐานข้อมูล

<?php
$id =$_POST[id];
$password        =$_POST[password];
$title =$_POST[title];
$name =$_POST[name];

$sql ="select * from member where id='$id' ";
$result=mysql_query($sql) or die(mysql_error());
$num=mysql_num_rows($result);

if($num > 0)
{
die("<script>
alert('รหัสประจำตัวซ้ำ');
history.back();
</script>");
}

$sql ="insert into member(id,password,title,name,profilepic)
values('$id','$password','$title','$name','$filename')";
$result=mysql_query($sql) or die(mysql_error());
redirect('index.php')
?>

SQL Create table

CREATE TABLE `student` (
  `id` varchar(5) NOT NULL,
  `password` varchar(20) NOT NULL,
  `title` varchar(10) NOT NULL,
  `name` varchar(50) NOT NULL,
  `surname` varchar(50) NOT NULL,
  `birthdate` date NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='เก็บข้อมูลนักเรียน';

--
-- dump ตาราง `student`
--

INSERT INTO `student` VALUES ('33333', '333', 'sss', 'wrwwr', 'rrw', '2015-08-19');