Saturday, August 24, 2019

Laravel - Working With Database

Laravel has made processing with database very easy. Laravel currently supports following 4 databases −
  • MySQL
  • Postgres
  • SQLite
  • SQL Server
The query to the database can be fired using raw SQL, the fluent query builder, and the Eloquent ORM. To understand the all CRUD (Create, Read, Update, Delete) operations with Laravel, we will use simple student management system.

Connecting to Database

Configure the database in config/database.php file and create the college database with structure in MySQL as shown in the following table.
Database: College
Table: student
Column NameColumn DatatypeExtra
Idint(11)Primary key | Auto increment
Namevarchar(25)
We will see how to add, delete, update and retrieve records from database using Laravel in student table.
Sr.No.Record & Description
1Insert Records
We can insert the record using the DB facade with insert method.
2Retrieve Records
After configuring the database, we can retrieve the records using the DB facade with select method.
3Update Records
We can update the records using the DB facade with update method.
4Delete Records
We can delete the record using the DB facade with the delete method.

No comments:

Post a Comment

No String Argument Constructor/Factory Method to Deserialize From String Value

  In this short article, we will cover in-depth the   JsonMappingException: no String-argument constructor/factory method to deserialize fro...