Why I am getting an error when using w3school tutorial? [duplicate]

by

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)");

Note: Add backticks ` for column names in your insert query as some of your column names are reserved words.

More Related Contents:

  1. Inserting data to table (mysqli insert) [duplicate]
  2. Mysql No connection could be made because the target machine actively refused it
  3. Fatal error: Call to undefined function mysqli_result()
  4. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  5. Mysqli multiple row insert, simple multi insert query [duplicate]
  6. Is it ” RTSi6+yxLwIW7KsnoehVDA== ” md5? or How to get original string? [closed]
  7. save user images in MYSQL database by which method? [closed]
  8. How to change mysql to mysqli?
  9. Best way to INSERT many values in mysqli?
  10. Call to a member function bind_param() on a non-object [duplicate]
  11. MySQLi prepared statements error reporting [duplicate]
  12. Warning: mysqli_connect(): (HY000/1045): Access denied for user ‘username’@’localhost’ (using password: YES)
  13. Build SELECT query with dynamic number of LIKE conditions as a mysqli prepared statement
  14. Importing CSV data using PHP/MySQL
  15. mysqli_query() expects parameter 1 to be mysqli, object given
  16. Use one bind_param() with variable number of input vars
  17. Using Mysqli bind_param with date and time columns?
  18. PHP UPDATE prepared statement
  19. SELECT * FROM in MySQLi
  20. PDO::PARAM for type decimal?
  21. Generating a single Entity from existing database using symfony2 and doctrine
  22. How to execute raw queries with Laravel 5.1?
  23. Mysqli throws “Warning: mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, boolean given” [duplicate]
  24. Is mysqli extension enabled in this php configuration?
  25. MySQL and PHP – insert NULL rather than empty string
  26. Is mysqli_real_escape_string safe?
  27. mysql injection damages?
  28. Using Prepared Statement, how I return the id of the inserted row?
  29. Is there any way to print the actual query that mysqli->execute() makes?
  30. When should I close a database connection in PHP?

Leave a Comment