Inserting data to table mysqli insert

Question

I ve been looking at this code for a while now and I can t see where the problem is  I have been reading the whole of StackOverflow and still can t see where my error is     lt  php  mysqli connect  localhost   root      web table    mysql select db  web table   or die mysql error      if  mysqli connect errno         echo  Failed to connect to MySQL      mysqli connect error       echo   lt p gt  Connection Successful    mysqli query  INSERT INTO web formitem  ID  formID  caption  key  sortorder  type  enabled  mandatory  data  VALUES  105  7  Tip izdelka  6   producttype 6  42  5  1  0  0       echo   lt p gt Insert successfull      gt    The error is somewhere in line 13  thats mysqli query  insert     I tried to help myself with http   www w3schools com php php mysql insert asp but it s not helping me much

User · Accepted Answer

Warning  Never ever refer to w3schools for learning purposes  They have so many mistakes in their tutorials   According to the mysqli query documentation  the first parameter must be a connection string    link   mysqli connect  localhost   root      web table     mysqli query  link  INSERT INTO web formitem   ID    formID    caption    key    sortorder    type    enabled    mandatory    data   VALUES  105  7   Tip izdelka  6     producttype 6   42  5  1  0  0     or die mysqli error  link      Note  Add backticks   for column names in your insert query as some of your column names are reserved words

User · Answer

Okay  of course the question has been answered  but no-one seems to notice the third line of your code  It continuosly bugged me         lt  php     mysqli connect  localhost   root      web table        mysql select db  web table   or die mysql error       for some reason  you made a mysqli connection to server  but you are trying to make a mysql connection to database To get going  rather use          link   mysqli connect  localhost   root      web table           mysqli select db   link    web table    or die        or for where i began        lt  php  connection   mysqli connect  localhost   root      web table                 global  connection     global connection to databases - kill it once you re done   or just query with a  connection parameter as the other argument like above  Get rid of that third line

User · Answer

In mysqli query first parameter should be connection your sql statement  so   connetion name mysqli connect  localhost   root      web table   or die mysqli error     mysqli query  connection name  INSERT INTO web formitem  ID  formID  caption  key  sortorder  type  enabled  mandatory  data  VALUES  105  7  Tip izdelka  6   producttype 6  42  5  1  0  0       but best practice is   connetion name mysqli connect  localhost   root      web table   or die mysqli error      sql statement  INSERT INTO web formitem  ID  formID  caption  key  sortorder  type  enabled  mandatory  data  VALUES  105  7  Tip izdelka  6   producttype 6  42  5  1  0  0    mysqli query  connection name  sql statement

[php] Inserting data to table (mysqli insert)

Examples related to php

Examples related to database

Examples related to mysqli

Examples related to sql-insert