SQL

Db Browser for SQLite

How to Manage SQLite Database on PC without Browser Extensions

Most Software platforms and IDES do not provide a database schema for SQLite database, they force you to create and manage database programmatically.  This tends to be tedious and time-consuming. Under this article, am going to illustrate one the easiest ways of managing SQLite database with an interface on a computer without a browser extension. …

How to Manage SQLite Database on PC without Browser Extensions Read More »

Fetching data from database using MySQL select in PDO

MySQL select statement or clause is used to select data from MySQL database. Under this walkthrough, we are going to apply MySQL select statement using PDO. SELECT clause of MySQL is one of the most commonly used clauses, especially when fetching data from MySQL database. Fetching data from table using MySQL select in PDO First …

Fetching data from database using MySQL select in PDO Read More »

How to use MySQL INSERT statement using PDO prepared statements

MySQL INSERT INTO Statement is used to INSERT data or records into a table. However, in this tutorial, we will not only insert data into a table but also use PDO prepared statements. This tutorial will get you going on how to use MySQL INSERT statement using PDO. How to apply MySQL INSERT statement using …

How to use MySQL INSERT statement using PDO prepared statements Read More »

Introduction to PHP MySQL prepared statements using PDO

With PHP, you can connect and manipulate databases using PHP MySQL prepared statements. Under this walkthrough, we are going to learn how to use PHP MySQL prepared statements in PDO. PDO stands for PHP DATA OBJECT, where it’s used to execute SQL prepared statements with high efficiency. Introduction to MySQL Prepared Statements using PDO As …

Introduction to PHP MySQL prepared statements using PDO Read More »