Databases

How To Order Query Results in Laravel Eloquent — step-by-step Programming tutorial on Progressive Robot

How To Order Query Results in Laravel Eloquent

In a previous part of this series, you learned how to obtain database records using the all() method from within an Eloquent model, sorting the resulting collection with the sortDesc() method. In this guide, you’ll learn how to use the orderBy() method to sort results in the database query itself, which offers more flexibility and performance to order query results at the database level.

Read more
How To Use the PDO PHP Extension to Perform MySQL Transactions in PHP on Ubuntu 18.04 — step-by-step Linux tutorial on Progressive Robot

How To Use the PDO PHP Extension to Perform MySQL Transactions in PHP on Ubuntu 18.04

A MySQL transaction is a group of logically related SQL commands that are executed in the database as a single unit. Transactions are used to enforce ACID (Atomicity, Consistency, Isolation, and Durability compliance in an application. This is a set of standards that govern the reliability of processing operations in a database. In this tutorial, you will use the PDO PHP Extension, which provides an interface for working with databases in PHP, to perform MySQL transactions.

Read more
Como Gerenciar um Banco de Dados SQL — step-by-step Databases tutorial on Progressive Robot

Como Gerenciar um Banco de Dados SQL

Os bancos de dados SQL vêm instalados com todos os comandos necessários para adicionar, modificar, excluir e consultar seus dados. Este guia de consulta rápida fornece uma referência para alguns dos comandos SQL mais usados. **Como…

Read more
CHAT