• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Tutsplanet

Tutsplanet

Free Technical and Blogging Resources

  • Home
  • Web Hosting
  • Programming
  • Plugins
  • Twitter Trends
  • Tools
  • About Us

Programming TagsLaravel

Difference between Laravel’s raw SQL functions

Feb 11, 2021 Editorial Staff

Share
Tweet
Share

Laravel comes with a lot of helper functions to interact with Database efficiently . There are Eloquent which composes an ORM model, and helps to write expressive relations and queries. But some cases that’s not enough, we have to have some raw queies need to write to achieve the results. So in this article  we are discussing difference between Laravel’s raw SQL functions.

DB::raw()

This generates a raw query which means “non-sanitized” string. Laravel wrote a beautiful warning message in the docs, as it might cause security issues if don’t use it wisely.

DB::select()

This method is intended for simple selects.

DB::select(DB::raw('select * from customers'));

DB::statement()

This method is very useful when running queires other than CRUD, like alter a table field or disable forieng key checks etc.

DB::statement('SET FOREIGN_KEY_CHECKS=0');
DB::statement('ALTER TABLE THIS FIELD');

DB::unprepared()

This will help you to run a query that cannot be run prepared. This is not documented in Laravel docs, but we can see it declared in the code.


Editorial Staff

Editorial Staff at Tutsplanet is a dedicated team to write various tutorials about subjects like Programming, Technology and Operating Systems.

View all posts by Editorial Staff

Primary Sidebar

Quick Links

  • Top 21 Website Ideas To Make Money Online in 2021
  • A Simple YouTube Video Downloader Script in PHP
  • The 50 Most Useful jQuery Plugins for Frontend Development
  • Replace “\n” with new line characters, using Notepad++
  • Using Third-Party Libraries in Codeigniter
  • Upload Multiple Images and Store in Database using PHP and MySQL.
  • Hierarchical Tree view Category Example in Laravel
  • Laravel Image Intervention Tutorial With Example
  • How to import sql file in MySQL database using PHP?
  • Free VAT Calculator Online

Subscribe

* indicates required

Search Here

Share

   

Hot topics

  • Replace “\n” with new line characters, using Notepad++ 57 views
  • How to enter new line in Microsoft Teams? 38 views
  • Open a URL in a new tab using JavaScript 28 views
  • A Simple YouTube Video Downloader Script in PHP 25 views
  • Laravel WhereHas() Eloquent Example 22 views
  • How to change PHP version on MAMP – Mac OSX 18 views
  • How to Create PDF File From HTML Form Using Fpdf? 17 views
  • PHP: Implode () with quotes 15 views
  • Simple PHP Shopping Cart 15 views
  • Get Uploads Directory Path in WordPress 14 views

Categories

  • Design & Development
  • Drupal
  • Facebook
  • General
  • How To
  • ios
  • Javascript
  • Linux
  • Magento
  • Marketing
  • News
  • PHP
  • Plugins
  • Programming
  • Snippets List
  • Social Media
  • Softwares
  • Themes
  • Tips
  • Wordpress
  • YouTube

Copyright © 2022 · Planet on Genesis Framework · Powered By BunnyCDN . Network wallpapernoon.com