如何解决Yii中的错误CDbException？

我制作了一张名为“Customer”的表格，我想制作一个简单的Yii创建和查看应用程序。 以下是我在CustomerController.php中的一段代码：

class CustomerController extends Controller
{

    public $layout = '//layouts/column2';

    public function actionCreate()
    {

        $model = new Customer();

        $this->redirect(array('view', 'id' => $model->id));

        $this->render('create', array(
            'model' => $model,
        ));
    }

    public function actionView()
    {

        $model = new Customer();

        $result = $model->viewCustomer();

        foreach ($result as $row) {

            echo $row["title"];
            echo $row["fname"];
            echo $row["lname"];
            echo $row["addressline"];
            echo $row["town"];
            echo $row["zipcode"];
            echo $row["phone"];
        }

        $this->render('view', array(
            'model' => $this->$model(),
        ));
    }
}

这里是我的模型中名为Customer.php的代码

public function createCustomer()
{
    $connection = Yii::app()->db;
    $sql = "INSERT INTO Customer (title,fname,lname,addressline,town,zipcode,phone)VALUES(:title,:fname,:lname,:addressline,:town,:zipcode,:phone)";
    $command = $connection->createCommand($sql);
    $command->bindParam(":title", $title, PDO::PARAM_STR);
    $command->bindParam(":fname", $fname, PDO::PARAM_STR);
    $command->bindParam(":lname", $lname, PDO::PARAM_STR);
    $command->bindParam(":addressline", $addressline, PDO::PARAM_STR);
    $command->bindParam(":town", $town, PDO::PARAM_STR);
    $command->bindParam(":zipcode", $zipcode, PDO::PARAM_STR);
    $command->bindParam(":phone", $phone, PDO::PARAM_STR);
    $result = $command->execute();

    if ($result == 1) {
        return "ok";
    }

    public function viewCustomer()
    {
        $connection = Yii::app()->db;
        $sql = "Select * from Customer";
        $dataReader = $connection->createCommand($sql)->query();
        $dataReader->bindColumn(1, $title);
        $dataReader->bindColumn(2, $fname);
        $dataReader->bindColumn(3, $lname);
        $dataReader->bindColumn(4, $addressline);
        $dataReader->bindColumn(5, $town);
        $dataReader->bindColumn(6, $zipcode);
        $dataReader->bindColumn(7, $phone);
        $result = $dataReader->queryAll();
        return $result;
    }

}

但是，我总是有这样的错误：

CDbException CDbCommand未能执行SQL语句：CDbCommand未能准备SQL语句：SQLSTATE [HY000]：一般错误：1没有这样的表：Customer。 执行的SQL语句是：从客户选择*。

我的朋友说我没有得到价值。 我该如何解决这个问题？ 请帮助我们。 先谢谢你。 顺便说一下，我正在使用PDO。

---

我认为在编程方面你是新手，缺乏oops概念。 首先尝试理解哎呀的概念，比你能够轻松理解Yii。

现在我无法测试您的代码，但可能会提供给您建议。

你的控制器::

class CustomerController extends Controller
{

     public $layout='//layouts/column2';

     public function actionCreate()
     {

        $model = new Customer();

        $model = $model->find();

        if($model->id)
           $this->redirect(array('view','id'=>$model->id));

        $this->render('create',array(
           'model'=>$model,
       ));

    }

    public function actionView()
    {

     $model = new Customer();

     $result = $model->viewCustomer();    

     foreach ($result as $row) {

        echo $row["title"];
        echo $row["fname"];
        echo $row["lname"];
        echo $row["addressline"];
        echo $row["town"];
        echo $row["zipcode"];
        echo $row["phone"];
     }

     $this->render('view',array(
        'model'=>$model,
    ));
  }
}.

您的型号::

public function createCustomer()
{

     $connection = Yii::app()->db;

     $sql = "INSERT INTO Customer (title,fname,lname,addressline,town,zipcode,phone)VALUES(:title,:fname,:lname,:addressline,:town,:zipcode,:phone)";

    $command = $connection->createCommand($sql);

    $command->bindParam(":title",$this->title,PDO::PARAM_STR);

    $command->bindParam(":fname",$this->fname,PDO::PARAM_STR);

    $command->bindParam(":lname",$this->lname,PDO::PARAM_STR);

    $command->bindParam(":addressline",$this->addressline,PDO::PARAM_STR);

    $command->bindParam(":town",$this->town,PDO::PARAM_STR);

    $command->bindParam(":zipcode",$this->zipcode,PDO::PARAM_STR);

    $command->bindParam(":phone",$this->phone,PDO::PARAM_STR);

    $result =  $command->execute();

    if ($result == 1){

        return "ok";

    }
}

public function viewCustomer（）{

    $connection = Yii::app()->db;

    $sql = "Select * from Customer";

    $dataReader = $connection->createCommand($sql)->query();

    $dataReader->bindColumn(1,$this->title);

    $dataReader->bindColumn(2,$this->fname);

    $dataReader->bindColumn(3,$this->lname);

    $dataReader->bindColumn(4,$this->addressline);

    $dataReader->bindColumn(5,$this->town);

    $dataReader->bindColumn(6,$this->zipcode);

    $dataReader->bindColumn(7,$this->phone);

    $result = $dataReader->queryAll();

    return $result;

  }  

我希望我的代码中的更改能够正常工作。 如果您尝试使用CDbCriteria来获取您的记录和保存（）CActiveRecord函数以将记录保存到数据库中，那将是最好的。

链接地址: http://www.djcxy.com/p/60845.html

上一篇: How to fix the Error CDbException in Yii?

下一篇: Where to put sql queries in Yii (or any framework with ORM support)?