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