PHP + ADODB不思考

Question

大家好，我尝试用PHP和ADODB编写页面，db-engine是mysql。我想添加到mysql的新记录和显示表。有人知道这段代码出了什么问题吗？

index.php

<?php 
    require('./engine.php');
    $lz = new zakupy;
    $lz->pokaz();
?>

engine.php

<?php 
include('adodb/adodb.inc.php');

class zakupy {

    function __construct($dbuser,$dbpass,$dbname,$dbhost)
        { 
            $db = ADONewConnection('mysql');
            $db->debug = true;
            $this-> $db->Connect($dbhost,$dbuser,$dbpass,$dbname);
        }

    function dodaj($name)
        {
            $rs = $db->Execute('insert into zakupy values(null,\''.$name.'\',\'N\');');
        }

    function pokaz(): void
    {
        $rs = $db->Execute('select * from zakupy');
        print "<pre>";
        print_r($rs->GetRows());
        print "</pre>";
    }
}

?>

Answer 1

如默认的sql语法：

Insert into tbl (colname1, colname2, colname3) VALUES ('val1', 'val2', 'val3')

并且您的$db必须是一个类变量

class zakupy {

private $db = null;

  function __construct($dbuser,$dbpass,$dbname,$dbhost){ 
        $this->db = ADONewConnection('mysql');
       ...
  }