$mysqli = new mysqli("localhost","root","root","test");
$sql = "insert into book (bookn,bookp,booka,addr)
values(?,?,?,?)";
//预处理
$stmt = $mysqli -> prepare($sql);
$stmt->bind_param("siss",$bookn,$bookp,$booka,$addr);
$bookn = "计算机科学导论";
$bookp = 11;
$booka = "王玲";
$addr = "清华大学出版社";
$stmt->execute();
$bookn = "建筑给水排水工程(第5版)";
$bookp = 10;
$booka = "王增长";
$addr = "中国建筑工业出版社";
$stmt -> execute();
echo($stmt -> insert_id ."<br>");
echo($stmt -> affected_rows);
分类
- .net (22)
- adf (11)
- android (3)
- article (236)
- astronomy (1)
- block chain (8)
- C# Code (9)
- c/c++ (2)
- cache (8)
- cloud (2)
- consensus (3)
- css (2)
- cve (1)
- db (55)
- digest (1)
- english (1)
- finance (2)
- go (3)
- gps (2)
- hardware (1)
- html (2)
- http (2)
- info (19)
- iot (1)
- it (3)
- java (30)
- javascript (6)
- jsp (2)
- linux (76)
- mail (14)
- math (1)
- message (8)
- mood (4)
- mq (2)
- network (22)
- php (9)
- protocol (4)
- push/pull (2)
- python (5)
- rpc (2)
- search (4)
- servlet (1)
- space (24)
- storage (15)
- technologys (103)
- templete (1)
- virtual machine (7)
- web server (37)
- windows (12)
-
近期文章
其他操作
链接