How to connect php with mysql
Reading databases is easy, you must have at least basic notions of SQL to start extracting the information stored in your tables. The execution of queries with PDO always follows…
Simplify PDO connection to Mysql with a PHP class
In this tutorial I am going to encapsulate the functionality of the PDO class in a php class of my own. Why am I doing this? Well, to make my…
How to close the PDO connection from PHP
The connection to the database through PDO is usually my favorite, because I love being able to connect to different DBMS with the same methodology. But there is a little…
SQL Triggers tutorial with simple examples
We'll see what are database TRIGGERShow they can help us maintain the integrity of our database and how to create them with SQL step by step. Content What is an…
Meaning of back-end or front-end development
Back-end and Front-end, two terms that refer to developers, usually web developers, and who have specific skills. What makes you apt to call yourself with one term or another? Let's…
Dynamic web paging and http_build_query
In this tutorial you will learn how to make a simple web paging but efficient. A simple implementation that will simplify your life when creating your web applications. Content What…
How to Retrieve and Insert Arrays in the Database Effectively
In this tutorial I am going to explain how to store Arrays in a database regardless of their complexity. With what I am going to explain to you next, you…
3 correct methods of connecting to MySQL database with php
When we embark on web projects that are made up of dynamic pages, it is inevitable to read and write data, store it and achieve persistence, and this is generally…
How to escape quotes, backslashes or special characters in SQL or PHP
It is usually a case to enter special characters in SQL right?, but don't worry! I have prepared this special article about introducing rare characters in SQL, where I explain…
Examples of simple stored procedures
In this article I will show the how stored procedures work (STORED PROCEDURES) using several examples in SQL. The examples will be helpful and I will explain them step by…