Print query before inserting (NOT EXECUTING) in Codeigniter Framework

Question

I want to print query before inserting in database in CODEIGNITER.

PHP CODE :

    $data['prices'] = $prices;
    $data['countryID'] = '0';
    $data['userTypeID'] = $roleType;
    $data['districtDivisionID'] = '0';
    $data['userTypeValue'] = $userTypeValue;
    $data['receiverUserTypeID'] = $receiverUserType;
    $this->db->insert('db_DevicePrices', $data);

Does this answer your question? Echo query before execution and without execution in codeigniter Active Record — Prabhjot Singh Kainth
– Prabhjot Singh Kainth, Commented Dec 11, 2019 at 5:51
@ Devsi Odedra it is working with $this->db->get(); not for inserting. I have already check it. — Sandeep K.
– Sandeep K., Commented Dec 11, 2019 at 5:52
@Prabhjot Singh Kainth i have already check this. But no solution get. — Sandeep K.
– Sandeep K., Commented Dec 11, 2019 at 5:54

quachtinh761 · Accepted Answer · 2019-12-11 06:16:25Z

2

please use insert_string, please take a look at following example.

$data = array( 
        'name'  = >  $_POST['name'] , 
        'groupname'= >  $_POST['groupname'], 
        'age'   = >  $_POST['age']
);
$this-> db->insert_string('tbl_user', $data);

Refer to this link

answered Dec 11, 2019 at 6:16

quachtinh761

2341 silver badge8 bronze badges

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

Comments

Rajdip Chauhan · Accepted Answer · 2019-12-11 06:18:29Z

1

You can use $this->db->insert_string() for print insert query before inserting data in database

Example:

$data = array('prices' => $prices, 'countryID' => 0, 'userTypeID' => $roleType,'districtDivisionID'=>0,'userTypeValue'=>$userTypeValue,'receiverUserTypeID'=>$receiverUserType);
$str = $this->db->insert_string('db_DevicePrices', $data);

Refer this link

Hope this will help you.

answered Dec 11, 2019 at 6:18

Rajdip Chauhan

3452 silver badges11 bronze badges

Collectives™ on Stack Overflow

Print query before inserting (NOT EXECUTING) in Codeigniter Framework

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related