abstract:pdo方式 创建表 dml操作<?php header("Content-type: text/html; charset=utf-8"); $type = 'mysql'; $host = 'localhost'; $dbName =
pdo方式 创建表 dml操作
<?php header("Content-type: text/html; charset=utf-8"); $type = 'mysql'; $host = 'localhost'; $dbName = 'ufuturehk'; $charset = 'utf8'; $dsn = $type.':host='.$host.';dbname='.$dbName.';charset='.$charset; $user = 'root'; $pass = 'root'; try { $pdo = new PDO($dsn, $user, $pass); var_dump($pdo); //$pdo = null; } catch (PDOException $e) { echo($e->getMessage()); } $sql = "CREATE TABLE IF NOT EXISTS `cu_tbl_dev_data` ( `devsn` varchar(50) CHARACTER SET utf8 NOT NULL, `devRegionID` varchar(50) CHARACTER SET utf8 NOT NULL, `devname` varchar(100) CHARACTER SET utf8 DEFAULT NULL, `mAddTime` datetime DEFAULT NULL, `mUpdateTime` datetime DEFAULT NULL, `devID` tinyint(4) DEFAULT '0', PRIMARY KEY (`devsn`,`devRegionID`), UNIQUE KEY `devsn` (`devsn`), KEY `mNamw` (`devname`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;"; $pdo = new PDO($dsn, $user, $pass); //建表 $stmt = $pdo->prepare($sql); //执行建表语句 if ($stmt->execute()) { echo ('建表成功!'."<br>"); } else { echo(print_r($stmt->errorInfo(),true)); } //$pdo = null; $sql="INSERT INTO `cu_tbl_dev_data` (`devsn`, `devRegionID`, `devname`, `mAddTime`, `mUpdateTime`, `devID`) VALUES ('04A0B9554A28828C', '9B3E60753DF802FB', '04A', '2019-01-23 18:04:25', '2019-01-23 18:04:25', 8), ('112233445566', '35AB8984CAE158BD', '公司自动门', '2019-01-18 10:32:55', '2019-01-22 22:20:33', 1), ('31CB6B6E02BB68B7', '40886F65578FE0EA', '测31', '2019-01-28 10:49:23', '2019-01-30 18:44:18', 2)"; //$pdo = new PDO($dsn, $user, $pass); //建表 $stmt = $pdo->prepare($sql); //执行建表语句 if ($stmt->execute()) { echo ('写入成功!'. "<br>"); } else { echo(print_r($stmt->errorInfo(),true)); } // //$pdo = null; $sql="INSERT INTO `cu_tbl_dev_data` (`devsn`, `devRegionID`) VALUES (:mdevsn, :mdevRegionID)"; //$pdo = new PDO($dsn, $user, $pass); $mdevsn ="334455667788"; $mdevRegionID = "fB3E6D753DF802FB"; // $stmt = $pdo->prepare($sql); $stmt->bindParam(':mdevsn',$mdevsn,PDO::PARAM_STR,20); $stmt->bindParam(':mdevRegionID',$mdevRegionID,PDO::PARAM_STR,20); //执行建表语句 if ($stmt->execute()) { echo ('bindParam写入成功!'. "<br>"); } else { echo(print_r($stmt->errorInfo(),true)); } //update $sql="update `cu_tbl_dev_data` set `mUpdateTime`=:utime where `devsn`=:mdevsn and `devRegionID`=:mdevRegionID"; $mdevsn ="334455667788"; $mdevRegionID = "fB3E6D753DF802FB"; $utime = time(); $utime = date("Y-m-d H:i:s",time()+8*3600); // $stmt = $pdo->prepare($sql); $stmt->bindParam(':mdevsn',$mdevsn,PDO::PARAM_STR,20); $stmt->bindParam(':mdevRegionID',$mdevRegionID,PDO::PARAM_STR,20); $stmt->bindParam(':utime',$utime,PDO::PARAM_STR,20); var_dump($stmt); var_dump($pdo); //执行建表语句 if ($stmt->execute()) { echo ('bindParam update成功!'. "<br>"); } else { echo(print_r($stmt->errorInfo(),true)); } //delete $sql="delete from `cu_tbl_dev_data` where `devsn`=:mdevsn and `devRegionID`=:mdevRegionID"; $mdevsn ="334455667788"; $mdevRegionID = "fB3E6D753DF802FB"; $utime = time(); $utime = date("Y-m-d H:i:s",time()+8*3600); // $stmt = $pdo->prepare($sql); $stmt->bindParam(':mdevsn',$mdevsn,PDO::PARAM_STR,20); $stmt->bindParam(':mdevRegionID',$mdevRegionID,PDO::PARAM_STR,20); //$stmt->bindParam(':utime',$utime,PDO::PARAM_STR,20); var_dump($stmt); var_dump($pdo); //执行建表语句 if ($stmt->execute()) { echo ('bindParam dele成功!'. "<br>"); } else { echo(print_r($stmt->errorInfo(),true)); } ?>
Correcting teacher:韦小宝Correction time:2019-02-11 09:46:10
Teacher's summary:嗯!不错不错!写的很棒!pdo创建数据表并且对表操作 写的都很好!继续加油吧!