SyntaxFix

[php] Inserting data to table (mysqli insert)

Okay, of course the question has been answered, but no-one seems to notice the third line of your code. It continuosly bugged me. 

    <?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

     <?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.

Examples related to php

• I am receiving warning in Facebook Application using PHP SDK • Pass PDO prepared statement to variables • Parse error: syntax error, unexpected [ • Preg_match backtrack error • Removing "http://" from a string • How do I hide the PHP explode delimiter from submitted form results? • Problems with installation of Google App Engine SDK for php in OS X • Laravel 4 with Sentry 2 add user to a group on Registration • php & mysql query not echoing in html with tags? • How do I show a message in the foreach loop?

Examples related to database

• Implement specialization in ER diagram • phpMyAdmin - Error > Incorrect format parameter? • Authentication plugin 'caching_sha2_password' cannot be loaded • Room - Schema export directory is not provided to the annotation processor so we cannot export the schema • SQL Query Where Date = Today Minus 7 Days • MySQL Error: : 'Access denied for user 'root'@'localhost' • SQL Server date format yyyymmdd • How to create a foreign key in phpmyadmin • WooCommerce: Finding the products in database • TypeError: tuple indices must be integers, not str

Examples related to mysqli

• phpMyAdmin ERROR: mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO) • mysqli_real_connect(): (HY000/2002): No such file or directory • mysqli_connect(): (HY000/2002): No connection could be made because the target machine actively refused it • Call to a member function fetch_assoc() on boolean in <path> • How can I enable the MySQLi extension in PHP 7? • Fatal error: Call to a member function bind_param() on boolean • Warning: mysqli_select_db() expects exactly 2 parameters, 1 given in C:\ • How to check if a row exists in MySQL? (i.e. check if an email exists in MySQL) • Object of class mysqli_result could not be converted to string in • mysqli::query(): Couldn't fetch mysqli

Examples related to sql-insert

• In Oracle SQL: How do you insert the current date + time into a table? • SQL Error: ORA-01861: literal does not match format string 01861 • "Insert if not exists" statement in SQLite • Column count doesn't match value count at row 1 • Inserting data to table (mysqli insert) • SQL Insert into table only if record doesn't exist • C# with MySQL INSERT parameters • How to speed up insertion performance in PostgreSQL • "column not allowed here" error in INSERT statement • Inserting multiple rows in mysql