开发者

Custom PDO Class Fails Quietly

开发者 https://www.devze.com 2023-02-13 14:16 出处:网络
For some reason, this custom PDO class fails to write to the database.It simply quietly fails - no error message thrown.A very similar custom PDO class (ReadPDO) works wonderfully for reading from the

For some reason, this custom PDO class fails to write to the database. It simply quietly fails - no error message thrown. A very similar custom PDO class (ReadPDO) works wonderfully for reading from the database. The SQL statement generated works fine when it's queried to the DB through PHPMyAdmin. I've double-checked the user permissions, and everything seems in order.

I suspect I'm misunderstanding how something works. Any ideas?

// Creates a write-only PDO, using config settings from inc_default.php 
class WritePDO extends PDO{

    public function __construct(){
        //Pull global DB settings
        global $db;
        global $write_host;
        global $write_username;
        global $write_password;

        try{
            parent::__construct("mysql:dbname={$db};host={$write_host}", $write_username, $write_password);
        } catch (PDOException $e){
            echo 'Connection failed: ' . $e->getMessage();
        }
    }
}

private function updatePlayer(){
    $conn = new WritePDO();
    $sql = "UPDATE {$this->hvz_db}
        SET 
        hvz_bitten      ='{$this->hvz_bitten}',
        hvz_died        ='{$this->hvz_died}',
        hvz_feedCode    ='{$this->hvz_feedCode}',
        hvz_status      ='{$this->hvz_status}',
        hvz_feeds       ='{$this->hvz_feeds}',
        hvz_lastFed     ='{$this->hvz_lastFed}',
        hvz_ozOpt       ='{$this->hvz_ozOpt}',
        hvz_parent      ='{$this->hvz_parent}'
        WHERE users_id  ={$this->id}";
    $query = $conn->exec($sql);
}

The SQL it spit开发者_如何转开发s out is as follows:

UPDATE hvz_2011_spring SET hvz_bitten ='', hvz_died ='', hvz_feedCode ='NOMNOM', hvz_status ='Human', hvz_feeds ='0', hvz_lastFed ='', hvz_ozOpt ='0', hvz_parent ='' WHERE users_id =1


are you sure the sql is correct?

The exec doesn't send any error message.

Try doing var_dump($conn->errorInfo()); after $conn->exec($sql);

/Emil

0

精彩评论

暂无评论...
验证码 换一张
取 消