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

Tutsplanet

Free Technical and Blogging Resources

  • Home
  • Web Hosting
  • Programming
  • Plugins
  • Write For US
  • News
  • About Us
  • Snippets
You are here: Home / Programming / Difference between Laravel’s raw SQL functions

Difference between Laravel’s raw SQL functions

Feb 11, 2021 by Editorial Staff

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

Filed Under: Programming Tagged With: Laravel

Primary Sidebar




Quick Links

  • A Simple YouTube Video Downloader Script in PHP
  • The 50 Most Useful jQuery Plugins for Frontend Development
  • Base64 Decode Online
  • Base64 Encode Online

Subscribe

* indicates required

Share

   

Hot topics

  • A Simple YouTube Video Downloader Script in PHP 248 views
  • Replace “\n” with new line characters, using Notepad++ 246 views
  • Add FTP/SFTP in Visual Studio Code 160 views
  • Open a URL in a new tab using JavaScript 136 views
  • Using Third-Party Libraries in Codeigniter 134 views
  • Hierarchical Tree view Category Example in Laravel 129 views
  • Upload Multiple Images and Store in Database using PHP and MySQL. 121 views
  • Laravel Image Intervention Tutorial With Example 110 views
  • How to change PHP version on MAMP – Mac OSX 101 views
  • Spout, an awesome library for reading and writing in Excel. 99 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 © 2021 · TutsPlanet Gene Theme on Genesis Framework · Powered By BunnyCDN