MIN SQL function
In this article I give you the answer you are looking for: How is the minimum calculated in SQL? or How do you use the MIN SQL function? Both questions…
SQL Introduction to BigQuery
As you already know, Google BigQuery uses Standard SQL statements to present the data that we request to the different databases with which we are working. This language shares much…
Complete HeidiSQL Guide
I have been working with SQL since 2010. I have moved between PostgreSQL, MySQL or MariaDB databases among others that I prefer not to remember. But the important thing is…
Avoid sql injection in PHP with PDO class
If we develop complex web applications, or at least with a constant use of database queries, we must be concerned about the security of our information, and therefore ensure the…
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…
- 1
- 2
- 3
- 4
- …
- 9
- Go to the next page