php - Codeigniter -> 使用 empty_table 的函数

Question

我正在尝试清空表格，但我想知道我的功能是否正确？

型号:

public function removeQuote()
    {
        $this->db->empty_table('companyDetails,hostingDetails,layoutDetails');
    }

Controller :

public function submit()
{
        $data['companyContact'] = $this->quote->getCompanyDetails()->companyContact;

        $this->load->view('submit',$data);

        $this->quote->removeQuote();
}

错误:

Table '_quote.companyDetails,hostingDetails,layoutDetails' doesn't exist

DELETE FROM `companyDetails,hostingDetails,layoutDetails`

Answer 1

/**
 * Empty Table
 *
 * Compiles a delete string and runs "DELETE FROM table"
 *
 * @param   string  the table to empty
 * @return  object
 */
public function empty_table($table = '')

显然你不能这样做

$this->db->empty_table('companyDetails,hostingDetails,layoutDetails');

相反，您必须调用 empty_table 三次:

$this->db->empty_table('companyDetails');
$this->db->empty_table('hostingDetails');
$this->db->empty_table('layoutDetails');

您可以随时破解 CodeIgniter DB_active_rec.php 文件，使其满足您的需求。