-
Notifications
You must be signed in to change notification settings - Fork 0
/
base标准.txt
30 lines (28 loc) · 1.22 KB
/
base标准.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
<?php
session_start();
header("Content-Type:text/html;charset=utf-8");
$pd='0';
$qx='0';
$pdo = new PDO("mysql:host=localhost;dbname=phpmysql","root","");
if($pdo -> exec("insert into biao1(link)values('1');")){
echo "数据库插入成功!";
$pdo -> exec("delete from biao1 where link='1';");
}
//create table user1(name char(20),pwd int,email char(20),qx char(20));
//create table user1(id int,name char(20),pwd int,email char(20),qx char(20),primary key (id));
//ALTER TABLE `test` CHANGE `id` `id` INT(11) NOT NULL AUTO_INCREMENT;
//mysql_query("set names 'GBK' ");说是解决乱码
//create table user1(id int,name char(20),pwd int,qx char(20),primary key (id));
//create table liuyan1(id int,name char(20),qx char(20),content char(50),primary key (id));
//create table liuyan1(id int,name char(20),qx int,content char(50),primary key (id))charset utf8;
// ljx模板:
// CREATE TABLE `message` (
// `id` int(1) NOT NULL auto_increment,
// `user` char(25) NOT NULL ,
// `title` char(50) NOT NULL,
// `content` char() NOT NULL,
// `lastdate` date NOT NULL,
// PRIMARY KEY (`id`)
// ) ENGINE=InnoDB DEFAULT CHARSET=gbk AUTO_INCREMENT=1;
//<script>alert();location.href='xxx.php'</script>;
?>