HOME | PHP Tutorial | CSS
facebook icon
AgerNic.com
WEB DEVELOPER SITE, HTML, CSS, PHP
PHP Tutorial

PHP forms
HTML Tutorial

CSS Tutorial

PHP mysqli_query() Function - mysqli query


The mysqli_query() function performs a query against the database.

PHP mysqli query result - example


Syntax: The basic syntax of the mysqli query;
mysqli_query(connection, query, resultmode);

Example 1:
<?php
$conn=mysqli_connect("localhost", "user", "password", "databbase");
// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL:". mysqli_connect_error();
  }
// Perform queries 
mysqli_query($conn,"SELECT * FROM users");
mysqli_query($conn,"INSERT INTO users (FirstName, LastName, email, password) 
VALUES ('Nicky','Lauda',' NickyL@yahoo.com', 'gyars225%ABER')");
mysqli_close($conn);
?>

Note: Be careful when you are deleting records in a table!

mysqli query, select database mysqli PHP mysqli_query() Function - mysqli query - sql tutorial

2583. SQL SELECT INTO - SQL Tutorial

http://www.sql-tutorial.net/SQL-SELECT-INTO.asp

2817. PL/SQL Tutorial
We provide you with a comprehensive PL/SQL tutorial to help you learn PL/SQL quick and fun.
http://www.zentut.com/plsql-tutorial/

881. MySQL Tutorial
MySQL Tutorial for Beginners - Learn MySQL in simple and easy steps starting from basic to advanced concepts with examples including database programming clauses command functions administration queries and usage along with PHP in simple steps. This tuto
https://www.tutorialspoint.com/mysql/index.htm

2567. SQL Cheat Sheet - SQL Tutorial

http://www.sql-tutorial.net/SQL-Cheat-Sheet.asp

3284. PHP mysqli_query() Function - mysqli query, sql tutorial
PHP mysqli_query() Function - mysqli query sql tutorial
https://www.agernic.com/sql-tutorial/php-mysqli_query-function-database-mysqli.html

2571. SQL DISTINCT - SQL Tutorial

http://www.sql-tutorial.net/SQL-DISTINCT.asp

Your add here
PHP printf() function

PHP wordwrap() function

PHP lcfirst() function

PHP ltrim() function

PHP trim() function

PHP strtolower() function

PHP explode() function

PHP str_repeat() function

PHP ucfirst() function

PHP empty() Function

PHP rtrim() function

PHP substr() function

PHP define() function

PHP count() Function

PHP md5() function

PHP strip_tags() function

HTML Tutorial - Tags and attributes
SQL WHERE AND & OR multiple conditions
CSS font color
How do I get PHP errors to display - PHP error_reporting()
CSS Text Size
CSS Margin, top, bottom, left, righ, auto