Codeigniter -> function using empty_table

Question

I am trying to empty the tables but I was wondering have I got the function correct?

Model:

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();
}

Error:

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

DELETE FROM `companyDetails,hostingDetails,layoutDetails`

jmic · Accepted Answer · 2012-04-09 00:48:49Z

11

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

Apparently you can't do this

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

Instead you will have to call empty_table three times:

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

You can always hack CodeIgniter DB_active_rec.php file so that it fits your needs.

answered Apr 9, 2012 at 0:48

jmic

8972 gold badges10 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Shivendra Kr. Sahu Over a year ago

What if I don't want to delete the auto increment value?

The Alpha · Accepted Answer · 2012-04-09 00:53:01Z

0

In your controller you have to load the model first (if it's not auto loaded)

$this->load->model('quote'); // Assuming your model name is 'quote'

before you use the function from that model as you used in your controller as follows

$data['companyContact'] = $this->quote->getCompanyDetails()->companyContact;

and load the view at last, after all code has been executed even after following line

$this->quote->removeQuote();

Just checked in CI doc empty_table doesn't accept multiple table names.

edited Apr 9, 2012 at 0:53

answered Apr 9, 2012 at 0:32

The Alpha

147k30 gold badges294 silver badges313 bronze badges

4 Comments

jmic Over a year ago

maybe he first loaded it in his __construct (), is there really a method called empty_tables () in the Database class of CodeIgniter?

Jess McKenzie Over a year ago

I have got my model auto loaded and please see here: codeigniter.com/user_guide/database/active_record.html#delete

jmic Over a year ago

Ok, didn't know about that! but please show us your error log

The Alpha Over a year ago

Does empty_table accepts multiple table names, i didn't see it in the doc ?

joash · Accepted Answer · 2019-05-06 19:16:18Z

0

SOLUTION ONE

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

SOLUTION TWO

 function emptytablesbycomma($stringoftables) {
            $array_tablenames = explode(",", $stringoftables);
            if (!empty($array_tablenames)) {
                foreach ($array_tablenames as $tablename) {
                    $this->db->truncate($tablename);
                }
            }
        }

Usage

$stringoftables='companyDetails,hostingDetails,layoutDetails';
$this->emptytablesbycomma($stringoftables);

answered May 6, 2019 at 19:16

joash

2,3492 gold badges28 silver badges31 bronze badges

Comments

Shivendra Kr. Sahu · Accepted Answer · 2023-04-06 13:13:04Z

0

$tablelist = array("companyDetails,hostingDetails,layoutDetails");
        foreach ($tablelist as $able) {
            $this->db->truncate($able);
        }

answered Apr 6, 2023 at 13:13

Shivendra Kr. Sahu

1,5482 gold badges9 silver badges13 bronze badges

Collectives™ on Stack Overflow

Codeigniter -> function using empty_table

4 Answers 4

1 Comment

4 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related