php mysqli 预处理操作数据库

用到的sql表

create table `student_01` (`id` int(11) not null auto_increment,  `name` varchar(255) character t utf8 collate utf8_unicode_ci default null comment '名字',  `kecheng` varchar(255) character t utf8 collate utf8_unicode_ci default null,  `score` varchar(255) character t utf8 collate utf8_unicode_ci default null,  `other_id` int(11) default null,  primary key (`id`) using btree,  key `aaaa` (`other_id`) using btree) engine=innodb auto_increment=10 default chart=latin1 row_format=compact;

输入变量的数据处理

//输入变量的数据处理//输入变量的过程如下:// 01) 预备(解析)语句  02) 绑定变量 03) 赋值到绑定变量 04) 执行预备语句$conn = mysqli_connect('127.0.0.1', 'afei2', '123456', 'test');$conn->query("t names utf8mb4");$stmt = $conn->prepare("inrt into student_01(name, kecheng, score,other_id) values (?, ?, ?, ?)");$s时间流逝的诗句tmt->bind_param('ssdi',$name, $kec个人能力介绍heng, $score,$other_id);//第一个参数是指定类型$name = '大飞';$kecheng = '数学';$score = 75;$other_id = 1;$stmt->execute();$name = '大飞02';$kecheng = '语文';$score = 60;$other_id = 1;$stmt->execute();$stmt->clo();

绑定变量获取的例子

//绑定变量获取的例子//输出变量的过程如下:// 01) 预备(解析)语句   02) 执行预备语句   03) 绑定输出夸父逐日原文及翻译变量  04) 把数据提取到输出变量中$conn = mysqli_connect('127.0.0.1', 'afei2', '123456', 'test');$conn->query("t names utf8mb4");$stmt = $conn->prepare("lect id,name,kecheng,score from student_01");$stmt->bind_result($id, $name,$kecheng,$score);//这里定义的变量$stmt->execute();print内蒙古人事信息考试网 蚂蚁和蝈蝈教学反思"<table  border='1' >" . php_eol;print "<tr><th>id</th><th>姓名</th><th>课程</th><th>分数</th></tr>" . php_eol;while ($stmt->fetch()) {    print "<tr><td>$id</td><td>$name</td><td>$kecheng</td><td>$score</td></tr>" . php_eol;}print "</table>" . php_eol;$stmt->clo();