How to display errors for my MySQLi query

Question

I am using the following script to process a form to add info to my website  The problem I am having is when I submit the form nothing gets submitted to the database  and there are no errors  How can I add error reporting to my query    lt  php if  isset   POST  itemdescription       itemdescription     POST  itemdescription    else   itemdescription        if  isset   POST  itemnumber       itemnumber     POST  itemnumber    else   itemnumber        if  isset   POST  sellerid       sellerid     POST  sellerid    else   sellerid        if  isset   POST  purchasedate       purchasedatepre     POST  purchasedate    date   DateTime  createFromFormat  D F d  Y    purchasedatepre   purchasedate   date  Y-m-d  strtotime  purchasedatepre    else   purchasedatepre        purchasedate        if  isset   POST  otherinfo       otherinfo     POST  otherinfo    else   otherinfo        if  isset   POST  numberofitems       numberofitems     POST  numberofitems    else   numberofitems        if  isset   POST  numberofitemsused       numberofitemsused     POST  numberofitemsused    else   numberofitemsused        if  isset   POST  isitdelivered       isitdelivered     POST  isitdelivered    else   isitdelivered        if  isset   POST  price       price     POST  price    else   price          itemdescription   str replace            itemdescription     itemnumber   str replace            itemnumber     sellerid   str replace            sellerid     otherinfo   str replace            otherinfo     include  connectmysqli php      mysqli query  db  INSERT INTO stockdetails   itemdescription   itemnumber   sellerid   purchasedate   otherinfo   numberofitems   isitdelivered   price   VALUES    itemdescription    itemnumber    sellerid    purchasedate    otherinfo    numberofitems    numberofitemsused    isitdelivered    price          header  Location  stockmanager php  amp key    key     gt

User · Answer

mysqli error     As in    sql    Your SQL statement here    result   mysqli query  conn   sql  or trigger error  Query Failed  SQL   sql - Error    mysqli error  conn   E USER ERROR     Trigger error is better than die because you can use it for development AND production  it s the permanent solution

User · Answer

Just simply add or die mysqli error  db    at the end of your query  this will print the mysqli error    mysqli query  db  INSERT INTO stockdetails   itemdescription   itemnumber   sellerid   purchasedate   otherinfo   numberofitems   isitdelivered   price   VALUES    itemdescription    itemnumber    sellerid    purchasedate    otherinfo    numberofitems    numberofitemsused    isitdelivered    price     or die mysqli error  db      As a side note I d say you are at risk of mysql injection  check here How can I prevent SQL injection in PHP   You should really use prepared statements to avoid any risk

[php] How to display errors for my MySQLi query?

Examples related to php

Examples related to mysql

Examples related to mysqli