Guest User

Untitled

a guest
Jun 21st, 2018
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.64 KB | None | 0 0
  1. <?php
  2.  
  3. $dbms = 'mysql'; //数据库类型
  4. $dbName = 'ibos425'; //使用的数据库
  5. $user = 'root'; //数据库连接用户名
  6. $pwd = 'root'; //数据库连接密码
  7. $host = 'localhost'; //数据库主机名
  8. $dsn = "$dbms:host=$host;port=33060;dbname=$dbName";
  9. try{
  10. $pdo = new PDO($dsn,$user,$pwd); //初始化一个PDO对象,就是创建了数据库连接对象$pdo
  11. $query = "DELETE FROM `ibos425`.`deng_crm_lead`;"; //需要执行的sql语句
  12. $res=$pdo->exec($query); //执行语句并返回受影响行数
  13. echo "数据添加成功,受影响行数为: " . $res;
  14. }catch(Exception $e){
  15. die("Error!:".$e->getMessage() . '<br>');
  16. }
Add Comment
Please, Sign In to add comment