PHP mysqli_connect() function is used to connect with MySQL database using MySQLi or Procedural way.
Popular Post: Php
The CREATE DATABASE statement is used to create a database in MySQL using Using MySQLi and PDO.
In this tutorial, you will learn how to create Table using CREATE TABLE statement into your MySQL database from PHP scripts using MySQLi and PDO.
In this tutorial, you will learn how to INSERT data into your MySQL database from PHP scripts using MySQLi and PDO.
In Php, if you want to get the ID of the last inserted/updated record immediately you can use mysqli_insert_id() query.
In PHP, you can insert multiple records into MySQL Database mysqli_multi_query() function. Multiple SQL statements must be executed with the mysqli_multi_query() function.
A prepared statement is a feature used to execute the same SQL statements repeatedly with high efficiency. Prepared statements are very useful against SQL injections.
The MySQL Select query is used to etrieve data from from MySQL database table. This statement can be used with the WHERE or without Where clause.
The MySQL WHERE Clause is used to filter only those records that are fulfilled by a specific condition given by the user in a table of MySQL database.
The ORDER BY Clause can be used along with the SELECT statement to sort the data of specific fields in in ascending or descending order.
The MySQL DELETE query is used to delete existing records in a table in a MySQL database. This statement is typically used with the WHERE clause.
The MySQL UPDATE query is used to update existing records in a table in a MySQL database. This statement is typically used with the WHERE clause.
In Php, MySQL LIMIT clause that is used to specify the number of records to return. The LIMIT clause mainly used for multi page results or pagination for large database.
XML Parser is used to read and update, create and manipulate an XML document. In PHP two major types of XML parsers (Tree-Based Parsers, Event-Based Parsers).
The simple XML parser is used to parse Name, attributes and textual content if you know the XML document structure or layout.
The following example shows, How to get the data from xml. Simple XML GET, XML Get has used to get the node values from xml file.
To read and update - create and manipulate - an XML document, you will need an XML parser. There are two basic types of XML parsers - Tree-based parser, Event-based parser.
The built-in DOM parser makes it possible to process XML documents in PHP. The PHP DOM library allows you to manage HTML and XML after you upload your script into a new PHP DOMDocument.
Ajax is an acronym for Asynchronous Javascript and XML. It is used to communicate with the server without refreshing the web page using Java Script, Html, Php.
In this tutorial, you will learn to access information from a database using Ajax and PHP. AJAX is a new technique for creating more interactive web applications.