Labels: queries

Start with LBS applications In today's mobile Internet in full swing, various LBS (Location Based Services) should

When we perform daily SQL queries, we often use additional constraints such as LIMIT and ORDER BY to filter the result set, so that the returned results meet our expectations

After the MySQL database client successfully establishes a connection with the server and completes user authentication, it can send SQL statements to interact with the server: Next, let's come together

Introduction to jQuery The core API of JavaScript is designed simply, but due to the incompatibility between browsers, the API of the client is too complex

In the last tutorial, Xuejun introduced you how to interact with MySQL database through PHP's built-in MySQL extension. Today, let's take a look at another PHP

basic operation We can get object property values through. or [] (JavaScript objects are associative arrays, so you can access properties through square brackets): var a...

Version 5.6 background management needs to be filtered, and the paging needs to be carried with the query parameters There is a date query I put all the parameters into one $where, b

Interface/Type Query in PHP In PHP, we can use the type operator instanceof to determine whether a variable belongs to an instance of a specified class or interface

brief introduction For more instructions on the use of the repository, please stamp the repository document address here laravel-reposito...

What is Eloquent ORM? Laravel's Eloquent ORM provides a beautiful and concise ActiveRecord implementation

Problem elicitation In this tutorial, we have learned how to perform various queries in the Eloquent model class, but

summary Eloquent is an ActiveRecord ORM framework. The full name of ORM is Object Relational Map

In the last tutorial, we implemented simple add, delete, change and query operations through the query builder. In daily development, more complex query statements are often involved, such as join query, sub query, row

Through the warm-up of the previous tutorials, we have connected to the database, created the data table, and filled in the data. Next, we will add or delete the database in the Laravel application

brief introduction Laravel makes it very simple to connect different databases and add, delete, modify, and query databases, whether using native SQL, query builder, or Eloq