PHP insert data into SQLite3 using stmt & bindParam/bindValue

I am trying to build a PHP form that reads and writes to a SQLite3 database. The reading part is done but the writing part is not working because my approach was all wrong. I have the code below that results in inserting a string wrapped json blob which is not correct. I need an experienced SQLite3 programmer to do this the correct way which would be a prepared statement would need to be created with the payload added to the statement via the Sqlite3 bindParam/bindValue . I would like to get this done today if possible. I need the array of data inserted into the db (db is attached) if (isset($_POST['send'])){ $newid = ("12345"); $utc = date("Y-m-d H:i:s"); $to = $_POST['to']; $from = $_POST['from']; $text = $_POST['text']; $array['params']['CMD'] = " MSG "; $array['params']['DIAL'] = 144178000; $array['params']['FROM'] = $from; $array['params']['OFFSET'] = 500; $array['params']['PATH'] = $to; $array['params']['SNR'] = -5; $array['params']['SUBMODE'] = 0; $array['params']['TDRIFT'] = 0; $array['params']['TEXT'] = $text; $array['params']['TO'] = $to; $array['params']['UTC'] = $utc; $array['params']['_ID'] = $newid; #$array['params']['type'] = STORE; #$array['params']['value'] = ""; $data = json_encode($array); $insert = $db->query("INSERT INTO inbox_v1 (blob) VALUES('".$data."'),("type"":""STORE")"); } The above code results in : {"params":{"CMD":" MSG ","DIAL":144178000,"FROM":"W5DMH","OFFSET":500,"PATH":"KD8PGB","SNR":-5,"SUBMODE":0,"TDRIFT":0,"TEXT":"test at 07:46 02-12-2020","TO":"KD8PGB","UTC":"2020-02-12 17:47:09","_ID":"12345","type":"STORE","value":""}} A correct entry would look like this (note the bracket locations) : {"params":{"CMD":" MSG ","DIAL":144178000,"FROM":"W5DMH","OFFSET":0,"PATH":"W5DMH","SNR":0,"SUBMODE":0,"TDRIFT":0,"TEXT":"test at 07:46 02-12-2020","TO":"KD8PGB","UTC":"2020-02-12 12:31:50","_ID":"12345"},"type":"STORE","value":""}