php 复选框 数据库,使用PHP在MySQL数据库中存储多个复选框数据

首先创建数据库：

create table employee(id int(10) not null, name varchar(20), hobbie varchar(20),

worked varchar(20), primary key(id));之后创建一个像这样的html页面：

Untitled Document

Name:

Which you do you want to likes?

Books

Movies

Sports

Games

Travelling

worked:

之后我们做了mysql connect.php

$server="localhost";

$user="root";

$password="";

$database="empcheckbox";

$link=mysql_connect($server,$user,$password) or die("the connection is terminated please check me!".mysql_error());

mysql_select_db($database,$link);

?>之后我们必须创建一个check.php就好了

if(isset($_POST['submit']))

{

$name=mysql_real_escape_string($_POST['Name']);

$worked=mysql_real_escape_string($_POST['Worked']);

$hobb= $_POST['Hobbies'];

if(empty($hobb))

{

echo("

You didn't select any any hobby.

\n");

}

else

{

$N = count($hobb);

echo("

You selected $N Hobbies(s): ");

for($i=0; $i < $N; $i++)

{

$var1=$hobb[$i];

include ('connect.php');

$table = "INSERT INTO employee (name, hobbies, worked) ".

"VALUES ('$name', '$var1', '$worked')";

mysql_query($table) or die(mysql_error());

$inserted_fid = mysql_insert_id();

mysql_close();

}

echo "successfully uploaded!..";

}

}

else

{

echo "error please check ur code";

}