Author: BrainBell

This tutorial describes how to parse an XML document or RSS feed that follows a known schema.

The type of character set used on the HTML page must match the character set used in the database table. In this tutorial, we’ll specify the utf-8 encoding for PHP, MySQL database, HTML page, and Notepad++ editor.

In this tutorial, you’ll learn how to retrieve, insert, update, and delete data using PDO’s query, prepare, and exec functions.

PDO (PHP Data Objects) defines a lightweight, consistent interface for accessing many different SQL databases in PHP. You can write and execute database queries with a single interface regardless of the particular database system we happen to be using at the time.

SQLite is a fast, efficient database system that offers a viable alternative to MySQL/MariaDb. In this tutorial, we’ll teach you: how to create a database and tables, insert and retrieve data and how to use prepared statements to insert form data.

Learn how to access data in Firebird from PHP.

Learn how to access data in Microsoft SQL Server from PHP.

This tutorial covers the essentials you need to know to use Oracle with PHP.

PHP supports PostgreSQL, the pg_connect() function is used to connect to a PostgreSQL database server. Once a connection has been established, SQL commands can be executed with the pg_query() function.

PHP allows developers to interact with databases in two ways: MySQLi (MySQL Improved) extension and PDO (PHP Data Objects) extension. In this tutorial we’ll discuss the MySQLi extension which provides both speed and feature benefits over the PDO version and is a good choice for MySQL (or MariaDB) specific development projects.