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](https://stackoverflow.com/questions/9010128/echo-query-before-execution-and-without-execution-in-codeigniter-active-record) — Prabhjot Singh Kainth, Dec 11 '19 at 05:51
@ Devsi Odedra it is working with $this->db->get(); not for inserting. I have already check it. — Sandeep K., Dec 11 '19 at 05:52
@Prabhjot Singh Kainth i have already check this. But no solution get. — Sandeep K., Dec 11 '19 at 05:54
@Prabhjot Singh Kainth There are no error display. and also data is not inserting, so far i will search for print query function. — Sandeep K., Dec 11 '19 at 05:55

score 2 · Accepted Answer · answered Dec 11 '19 at 06:16

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

score 1 · Answer 2 · answered Dec 11 '19 at 06:18

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.

Print query before inserting (NOT EXECUTING) in Codeigniter Framework

2 Answers2