<?php require 'pdo_config.php'; $dsn = "{$dbType}:host={$host};dbName={$dbName}}"; // Create data source try{ $pdo = new PDO ($

There is no problem with the database connection. The execution of $pdo->exec($sql) should have data but it does not take effect.-PHP Chinese Network Q&A

Article Topic Learning Download Q&A Programming Dictionary Game Recent Updates

简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)

There is no problem with the database connection. The execution of $pdo->exec($sql) should have data but it does not take effect.

PHP小白 2019-05-29 17:38:39

1126

<?php

require 'pdo_config.php';
$dsn = "{$dbType}:host={$host};dbName={$dbName}}";// 创建数据源
try{	
    $pdo = new PDO ($dsn,$userName,$password);   
    $sql = "update student set grade=80 where id=7";
       $num = $pdo->exec($sql);//返回受影响的记录数量
       if($num>0){
    	print '成功添加';
    }else{
    	print '不成功';
    }
   
}
catch(PDOexception $e){
    die('操作失败'.$e->getMessage());
}