Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Laravel Application Development Cookbook
  • Table Of Contents Toc
Laravel Application Development Cookbook

Laravel Application Development Cookbook

By : Terry Matula
3.9 (10)
close
close
Laravel Application Development Cookbook

Laravel Application Development Cookbook

3.9 (10)
By: Terry Matula

Overview of this book

When creating a web application, there are many PHP frameworks from which to choose. Some are very easy to set up, and some have a much steeper learning curve. Laravel offers both paths. You can do a quick installation and have your app up-and-running in no time, or you can use Laravel's extensibility to create an advanced and fully-featured app.Laravel Application Development Cookbook provides you with working code examples for many of the common problems that web developers face. In the process, it will also allow both new and existing Laravel users to expand their knowledge of the framework.This book will walk you through all aspects of Laravel development. It begins with basic set up and installation procedures, and continues through more advanced use cases. You will also learn about all the helpful features that Laravel provides to make your development quick and easy. For more advanced needs, you will also see how to utilize Laravel's authentication features and how to create a RESTful API.In the Laravel Application Development Cookbook, you will learn everything you need to know about a great PHP framework, with working code that will get you up-and-running in no time.
Table of Contents (18 chapters)
close
close
Laravel Application Development Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
1
Index

Querying using raw SQL statements


Laravel provides many ways to access our database. If we have existing queries that we've used before, or if we need something a bit more complicated, we can use raw SQL to access our database.

Getting ready

For this recipe, we'll be using the table created in the Creating data tables using migrations and schema recipe.

How to do it...

To complete this recipe, follow these steps:

  1. In the command prompt, create a migration so we can add some data:

    php artisan migrate:make add_data_to_shows_table
    
  2. In our app/database/migrations directory, find a file similar to 2012_01_01_222551_add_data_to_shows_table.php, and add some data using raw SQL:

    class AddDataToShowsTable {
    
        /**
         * Make changes to the database.
         *
         * @return void
         */
        
    public function up()
        {
            $sql = 'INSERT INTO shows (name, rating, actor)
                VALUES (?, ?, ?)';
            $data1 = array('Doctor Who', '9', 'Matt Smith');
            $data2 = array('Arrested Development...
CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Laravel Application Development Cookbook
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon