Query error: Column cannot be null - Invalid query

Question

im use code php in method get to post in column 'tr_no_hp' like

$nomorhp = $this->input->get('nomor_hp');

but after i try to insert in database column cant be null. how to fix this problems

this my controllers code

$nomorhp = $this->input->get('nomor_hp');
$data = array(
                    'us_id' => $this->user->us_id,
                    'sv_id' => $voucher->sv_id,
                    'op_id' => $voucher->op_id,
                    'tr_id_plgn' => $nomor,
                    'tr_no_hp' => $nomorhp,


                );

                 $this->db->insert('transaksi', $data);
                 $trx_id =$this->db->insert_id();

and i got this eror code

Query error: Column 'tr_no_hp' cannot be null - Invalid query: INSERT INTO `transaksi`

thanks

What type is the tr_no_hp column? What PHP version are you running? — atymic
– atymic, Commented Sep 7, 2019 at 2:33
can u tell me more detail code default value of 'tr_no_hp' column to NULL — yagami cell
– yagami cell, Commented Sep 7, 2019 at 5:29
in your database this 'tr_no_hp' column has not default value null and $nomorhp = $this->input->get('nomor_hp'); your this code get nothing check what data sending — Nurbek Boymurodov
– Nurbek Boymurodov, Commented Sep 7, 2019 at 6:26

Lets-c-codeigniter · Accepted Answer · 2019-09-07 06:29:59Z

1

Assign default value of 'tr_no_hp' column to NULL in phpmyadmin

answered Sep 7, 2019 at 6:29

Lets-c-codeigniter

7142 gold badges7 silver badges19 bronze badges

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

Comments

atymic · Accepted Answer · 2019-09-07 02:43:19Z

0

You can either modify you tables to allow null (but this might break other things) or set a default value.

For example:

$nomorhp = $this->input->get('nomor_hp') ?: ''; // Default to empty string

answered Sep 7, 2019 at 2:43

atymic

3,1481 gold badge15 silver badges26 bronze badges

Collectives™ on Stack Overflow

Query error: Column cannot be null - Invalid query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related