KING

database ER diagram

• 
• some change in the database relationship
• 
• we have
  • T_ADMIN
  • T_USER
  • T_USER_CLASS
  • T_PROJECT
  • T_PRO_LEVEL
  • T_PROJECT_STATISTICS
  • T_TASK
  • T_SUBTASK
  • T_MATERIAL
  • T_CUSTOMER

• Table structure
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

  database insertion

• database connection

1
2

$conn = mysql_connect("localhost","pengbin","pengbin");
mysql_select_db("pengbin_db", $conn);

• database insertion

1
2

$sql = "insert into T_CUSTOMER (CustomerName, CustomerAddress, Notes, Active) values ('$_POST[name]','$_POST[address]','$_POST[note]','$_POST[Active]')";
mysql_query($sql, $conn);