Laravel Put

2; How to create hashed password in Laravel 4. Change it if necessary. js already set up out of the box. You didn't need to change your routes at all. Laravel is currently at version 5. In this tutorial, I will show you how to add a custom PHP class in Laravel 5. This is awesome for troubleshooting or when you are building the logic in your application. Note: This tutorial is only relevant for Laravel 5. You will then test the authentication using Postman. Laravel is prominently a server-side PHP framework, whereas React is a client-side. As a standard practice of creating an CRUD application there are certain actions in like update and delete which requires the method submitted to the server url to be either PUT/PATCH (to modify the resource) and DELETE (for deleting the resource). If PHP packages are a set of legos, Laravel is the best way to put them together. Learning Laravel 5 shows you a fastest way to learn developing web applications using Laravel 5 PHP framework How to import Excel file in Laravel 5 and insert the data in the database | Learning Laravel. Laravel 5- Insert data into MySQL database- Database and Model The very first thing we have to do is creating a database for our web application. We will create a few site pages (home, about, projects, contact). php but we highly recommend you to use the clean and standard extension. Let's learn how to create a HTML form, create an AJAX request and more. The Forge API allows you to create and interact with servers and sites on Laravel Forge through a simple REST API. example file to. Each class contains at least a rules() method which returns an array of rules and an authorize() method which returns a boolean of whether or not the user is authorized to perform their request. Is there a Blade or Laravel extension for DW to highlight syntax? Can't find. Access you new site to make sure you. Specialized group for PHP Laravel Framework Developers. We can follow any of the options to overcome this situation. I don't know if I'm even close to the answer, I don't know Laravel as I mentioned and I haven't even used a MVC framework before, so keep that in mind when reading my posts here. Routing is one of the essential concepts in Laravel. $ laravel new datatables If you're using homestead, add datatables. The Autocomplete widgets provides suggestions while you type into the field. Multiple DB Connections in Laravel A while ago, I answered on this SO question about using 2 database connections. Use laravel relationship model. query , or even fire and catch your own. LaravelのRESTfulなルーティングにたいして、フォームからPUTやDELETEメソッドでリクエストを発行する必要がある。このときformタグのmethodにPUTやDELETEを指定しても、HTML formがそもそもこれらの. The App/Http/Controller Directory The [code ]Http[/code] directory contains your controllers, middleware, and form requests. Tokenizer PHP Extension. Here is a table of the pages that we will use and the layouts that they will use. Laravel makes API authentication a breeze using Laravel Passport, which provides a full OAuth2 server implementation for your Laravel Passport application in a matter of minutes. Here is a table of the pages that we will use and the layouts that they will use. Built on top of the world's finest PHP framework, Laravel, making it easy for everyone to install and maintain on any cloud platform. php rest laravel-5 share | improve this question. Now, to install Laravel use the following command:. When dealing with time consuming resource intensive tasks, most PHP developers are tempted to choose the "quick hack route. Syntax for Laravel get last inserted Id. In answering that, I did some investigation which I'll write up here. Laravel offers all of this out of the box. This feature has been around since laravel 4. 3, I’ve seen many cases where Eloquent’s relations and their underlying query builders are not used efficiently. This package is created to handle server-side works of DataTables jQuery Plugin via AJAX option by using Eloquent ORM, Fluent Query Builder or Collection. In this tutorial, we have considered how useful Laravel Eloquent is and how you can utilize to improve your code. Laravel's database query builder provides a convenient, fluent interface to creating and running database queries. io Lumen Mail Meetups Mix Packages Queues Requests Security Session Socialite Spark Testing Valet Validation Views. This above code will start Laravel service. Standalone button. This Article was first published here: How to avoid duplicates when you insert hundreds of thousands of entries into the same MySQL table Web Development Laravel Mysql Php Continue the discussion. 1 laravel php laravel 5 laravel 4 laravel with laravel tutorial framework laravel laravel eloquent Laravel 5. First, a random token is placed in your user's session. Laravel is an open source web framework for PHP developers that encourages the use of the model-view-controller (MVC) pattern. In this laravel 5. Using Repository Pattern in Laravel 5 These days there is a lot of buzz about software design patterns, and one of the most frequently asked questions is "How can I use some pattern with some technology ". Now, to install Laravel use the following command:. 3? in the previews lessons, we have learn about Create localization for Multiple languages and Authentication Login & Registration Form + Bootstrap. Learn Laravel in simple and easy steps starting from basic to advanced concepts by creating your first to-do application with basic CRUD functionality. For this article i would be using the Laravel 5. If you are looking for a new PHP framework to try, you should give Laravel a try. You will then test the authentication using Postman. Laravel : Best Practices aims to put together all the resources and best practices in using the Laravel Framework. Do I have to put all my business logic inside the model files? via Chebli Mohamed Publié par. Laravel doc says controller just routes the http requests and does the validation. Laravel 5 uses a package called DotEnv that stores sensitive information in. A key concern when writing our own queries is protecting our application from SQL injection attacks. We'd like to thank these amazing companies for supporting us. A session variable is used to store some information or some data about user or anything you want to access on all pages of an application. We can follow any of the options to overcome this situation. 6 Image Upload Tutorial with Example. If PHP packages are a set of legos, Laravel is the best way to put them together. complete example of insert data into mysql database with php laravel 5 framework. Listen to native events, like illuminate. php rest laravel-5 share | improve this question. For installing the Laravel, the following command you have to type: composer create-project laravel/laravel - prefer -dist. Store the token in a "meta" tag at the top of your root view file (layouts/app. Let's hope this one gets accepted. In this video I’ll show you just how easy it is to use HTML 5 storage to store values for your website or your web application. The App/Http/Controller Directory The [code ]Http[/code] directory contains your controllers, middleware, and form requests. It provides an easier and expressive way to create, edit, and compose images and supports currently the two most common image processing libraries GD Library and Imagick. Each time the same computer requests a page with a browser, it will send the cookie too. This method is responsible for retrieving our Cruds from the backend and will target the index action of our Laravel controller, thus using the GET endpoint /api/cruds. The PSR-7 standard specifies interfaces for HTTP messages, including requests and responses. We cater to the most unique purposes with seamless integrations to save businesses time, money, and manpower. (where the data is put into the job and onto a queue. Here is a table of the pages that we will use and the layouts that they will use. Laravel is regarded as one of the most popular PHP frameworks available. Implemented purely in PHP, with no external dependencies (except GD2 if needed). How to Insert values into database using. 2; Postman is. Laravel offers all of this out of the box. Laravel is an open source PHP framework that provides a set of tools and resources to build modern PHP applications. The SQL INSERT INTO Statement. you can find many of example of laravel , laravel 5. In assignment value expressions in the ON DUPLICATE KEY UPDATE clause, you can use the VALUES(col_name) function to refer to column values from the INSERT portion of the INSERT ON DUPLICATE KEY UPDATE statement. Laravel Insert Data into Mysql Database Table. 3 to develop the RESTful API project. 8 rest authentication api example, we would love to share with you how to create rest full api in laravel 5. The datasource is a simple JavaScript array, provided to the widget using the source-option. The Laravel query builder uses PDO parameter binding to protect your application against SQL injection attacks. Models are mostly used to interact with the database using Eloquent ORM. If you are looking for a new PHP framework to try, you should give Laravel a try. com Toggle navigation. 5 offers support for reCAPTCHA, an. It is possible to write the INSERT INTO statement in two ways. " Create your own RESTful API with Laravel, step by step, from development to production. Hi, i just deployed my laravel project to digital ocean. Multiple DB Connections in Laravel A while ago, I answered on this SO question about using 2 database connections. A few times I encountered a situation - a store() or update() method with Request parameter, but I needed to add some additional value to the request before calling Eloquent functions. OpenSSL PHP Extension. Authentication. Backpack for Laravel Monthly Newsletter Subscribers Email Forms Backpack for Laravel Monthly Newsletter We send an email every month, detailing new features, breaking changes and such. Build consistent APIs with Laravel & Angular package. In assignment value expressions in the ON DUPLICATE KEY UPDATE clause, you can use the VALUES(col_name) function to refer to column values from the INSERT portion of the INSERT ON DUPLICATE KEY UPDATE statement. Due to Laravel's built-in model functionality, just by creating an empty model class, Laravel will assume that this model is associated with a database table named cars. Laravel helps make the process easy using resource controllers. Put() method in HTTP Session. DataTables Table plug-in for jQuery Advanced tables, instantly. Thousands of digital studios and freelancers all over the world love October for its simplicity, flexibility and modern design. 5 LTS uses Mailable classes. There's a package called Laravel Collective which makes easy form building. The book begins with a thorough introduction to Vue. Create a directory called Mylibs in app directory along with your class, Ex: Common. Laravel 5 Tutorial - How we can use Get() method in HTTP Session, Put() method and Remove() Method HTTP Session in laravel 5. You will then test the authentication using Postman. env files which are loaded as PHP environment variables at runtime. It also has excellent documentation and an active community offering tips and writing articles like this one. (where the data is put into the job and onto a queue. Laravel is a free, open-source PHP web application framework. Laravel offers all of this out of the box. Syntax for Laravel get last inserted Id. Resource Controllers can make life much easier and takes advantage of some cool Laravel routing techniques. This above code will start Laravel service. Access you new site to make sure you. Voyager is a Laravel Admin Package that includes BREAD(CRUD) operations, a media manager, menu builder, and much more. Laravel 5- Insert data into MySQL database The database is the backbone of any web development. The Artisan Employment Connection. Listen to native events, like illuminate. The laravel-cors package allows you to send Cross-Origin Resource Sharing headers with Laravel middleware configuration. Laravel 2 was released in September 2011, bringing various improvements from the author and community. 3? in the previews lessons, we have learn about Create localization for Multiple languages and Authentication Login & Registration Form + Bootstrap. 2 and still exists in laravel 5. Sounds complicated but it just means your sensitive credentials go into these files while the rest of your config remains in the standard config files. ” Don’t deny it! We’ve all used. you can use it and get last ID of inserted record in laravel application. " Create your own RESTful API with Laravel, step by step, from development to production. This does not work (switching order does not help). Finally, by implementing ShouldQueue, Laravel will automatically put this notification inside a queue to be executed in the background, which will speed up the response. js Want to send a DELETE request when outside of a form? This will handle the form-creation bits for you dynamically, similar to the Rails implementation. The Missing Laravel Admin. Thanks, - Topic in the Web Development forum contributed by jaspertan. Deploy Your Website Using Laravel and Git You can't be a successful web developer without using some sort of deployment workflow for your websites. PHP Laravel Framework Developers has 17,009 members. Mbstring PHP Extension. MySQL is the most popular database management system used with PHP and PHP frameworks. Multiple DB Connections in Laravel A while ago, I answered on this SO question about using 2 database connections. Laravel has a great implementation of the many to many relationship pattern, so let's check it out now!. In this post I'd like to give a quick explanation of what CORS is and how you can use the package. Creating Your Own PHP Helpers in a Laravel Project December 08, 2017 / Paul Redmond Laravel provides many excellent helper functions that are convenient for doing things like working with arrays, file paths, strings, and routes, among other things like the beloved dd() function. 8 rest authentication api example, we would love to share with you how to create rest full api in laravel 5. php rest laravel-5 share | improve this question. He also developed Laravel apps and APIs, as well as AngularJS apps. We believe development must be an enjoyable, creative experience to be truly fulfilling. We can insert the record using the DB facade with insert method. Build CRUD / SPA. 5 Laravel 5. Change it if necessary. But how is PATCH any different? I haven't worked with this before I met Laravel. 5 LTS uses Mailable classes. Thanks to Laravel’s form-model binding, this is a piece of cake. below code works fine for the first time, but when i refresh it changes inserted records again. If you use the Form::open method with POST , PUT or DELETE the CSRF token will be added to your forms as a hidden field automatically. Laravel code may not have to change when making schema changes or performance updated to the database. How to use PUT/PATCH and DELETE method in Laravel 5. Finally, I give this book 4-stars because the name is a little misleading. LaraJobs is built and maintained by UserScape, creators of HelpSpot. Laravel passport authenticate users and do not maintain session. Wanna learn about AJAX in Laravel 5? Check out our Laravel 5 Cookbook. Some of the features of Laravel are a modular packaging system with a dedicated dependency manager, different ways for accessing relational databases. All seed classes are stored under the database/seeds directory. Veamos como actualizar o editar tareas de nuestra base de datos con Eloquent de Laravel 5. Ever since Laravel 5. LaraJobs connects talented Laravel developers with the companies who hire them. Insert Data into Myql Database Table using Laravel. Laravel offers an elegant implementation of the observer pattern that you may use throughout your applications. i hope u can help. After we have some understading of Laravel application/folder structure and about Artisan CLI, we can now move forward to create our basic CRUD (Create, Read, Update, Delete) application in Laravel. you can use it and get last ID of inserted record in laravel application. With the rise of mobile development and JavaScript frameworks, using a RESTful API is the best option to build a single interface between your data and your client. Luckily, Laravel's query builder has the tools we need to safely run such queries. The Missing Laravel Admin. This makes sense because. Whereas the existing Collection class wraps a native array, the new LazyCollection class wraps a native iterator, while still providing most of the methods that we know and love from a regular collection. Laravel is prominently a server-side PHP framework, whereas React is a client-side. Today, we'll go through the steps necessary to get a fully functioning CRUD application using resource controllers. 0 introduces Form Requests, which are a special type of class devoted to validating and authorizing form submissions. hi to all, can anyone help me how to use select_last_id on laravel. A key concern when writing our own queries is protecting our application from SQL injection attacks. url_prefix string The url prefix to this package. For installing the Laravel, the following command you have to type: composer create-project laravel/laravel - prefer -dist. If you use the Form::open method with POST , PUT or DELETE the CSRF token will be added to your forms as a hidden field automatically. Laravel makes it easy to protect your application from cross-site request forgeries. InfyOm Laravel Generator which supports Laravel API, Scaffold, CRUD, Test Case, Swagger Docs and Auth generator. Veamos como actualizar o editar tareas de nuestra base de datos con Eloquent de Laravel 5. The control panel is built on standardized patterns and principles just like the API. We can follow any of the options to overcome this situation. Add laravel to your hosts file located on Windows 10 at C:\Windows\System32\drivers\etc\hosts. How to insert multiple rows in database Laravel 5? If you want to create multiple records at time using laravel eloquent, then you can do it using "insert()" of laravel eloquent. 8 rest authentication api example, we would love to share with you how to create rest full api in laravel 5. Due to Laravel's built-in model functionality, just by creating an empty model class, Laravel will assume that this model is associated with a database table named cars. Laravel Tutorial for Beginner: Create your First To-Do App in Laravel 5. Laravel Pug also registers the. you can find many of example of laravel , laravel 5. Laravel is a very popular open-source PHP framework aimed at easy development of applications. Luckily, Laravel's query builder has the tools we need to safely run such queries. Laravel helps make the process easy using resource controllers. Learning Laravel 5 shows you a fastest way to learn developing web applications using Laravel 5 PHP framework How to import Excel file in Laravel 5 and insert the data in the database | Learning Laravel. Put() method in HTTP Session. In this article I’m going to walk you through the steps required to build a REST API with Laravel. You can send request data, set an authenticated user, and set session and header data using a fluent API. You can quickly devise your Eloquent queries, then just return the result and see if you get the results you expect. This Article was first published here: How to avoid duplicates when you insert hundreds of thousands of entries into the same MySQL table Web Development Laravel Mysql Php Continue the discussion. Collect all information on Laravel session with syntax and Example, Set variable, Get variable, Storing array,Setting value & Retrieving value from Session Home "Learn More Step By Step" Tutorialsplane. If you still have some more questions about Laravel caching, feel free to write your comments below. Launch your Laravel infrastructure on Vapor and fall in love with the scalable simplicity of serverless. Laravel has a great implementation of the many to many relationship pattern, so let’s check it out now!. File uploads are one of the vital pieces in most web projects, and Laravel has awesome functionality for that, but information is pretty fragmented, especially for specific cases. LaraJobs is built and maintained by UserScape, creators of HelpSpot. 1 with Datatables Quick Starter. Several of our students have requested that the installation procedure for Laravel Homestead on Windows be shown as well. Learn Laravel in simple and easy steps starting from basic to advanced concepts by creating your first to-do application with basic CRUD functionality. Hi, i just deployed my laravel project to digital ocean. " Create your own RESTful API with Laravel, step by step, from development to production. But how is PATCH any different? I haven't worked with this before I met Laravel. In this tutorial, we have considered how useful Laravel Eloquent is and how you can utilize to improve your code. Step by Step guide to build rest api in laravel application using passport authentication in laravel applications. Intervention Image is an open source PHP image handling and manipulation library. Laravel includes an easy method of seeding your database with test data using seed classes. I was able to get the Apache splash page to show but as soon as I point my virtual host to my laravel public folder I get file permission errors in apache2 logs. How to Insert Data into Mysql Database in Laravel. In assignment value expressions in the ON DUPLICATE KEY UPDATE clause, you can use the VALUES(col_name) function to refer to column values from the INSERT portion of the INSERT ON DUPLICATE KEY UPDATE statement. 6 Laravel 5. js already set up out of the box. env inside your project root and fill the database information. Also Retrace is a powerful tool for tracing performance of applications built in PHP. Recently we released laravel-cors. php file and create the. Laravel is a very popular open-source PHP framework aimed at easy development of applications. How to change be right back message on Laravel; How to put Laravel in maintenance mode; Laravel 5. The first way specifies both the column names and the values to be inserted:. To make Postman work with POST/PUT requests In addition to checking for the CSRF token as a POST parameter, the Laravel VerifyCsrfToken middleware will also check for the X-CSRF-TOKEN request header. Laravel is regarded as one of the most popular PHP frameworks available. 3 to develop the RESTful API project. To understand the all CRUD (Create, Read, Update, Delete) operations with Laravel, we will use simple student management system. Several of our students have requested that the installation procedure for Laravel Homestead on Windows be shown as well. Due to Laravel's built-in model functionality, just by creating an empty model class, Laravel will assume that this model is associated with a database table named cars. You will then test the authentication using Postman. Let's begin by creating a new Laravel project. Laravel PUT Requests: Updating Only Specific Fields. Laravel gave us seeding (not a new concept). 0 introduces Form Requests, which are a special type of class devoted to validating and authorizing form submissions. Build consistent APIs with Laravel & Angular package. Laravel's fill method offers an even easier way to accomplish this and allows for database entries to be set to empty strings if that is desireable. Here is a table of the pages that we will use and the layouts that they will use. If you would like to obtain an instance of a PSR-7 request, you will first need to install a few libraries. (windows wont let you do it, so you have to open your console cd your project root directory and run mv. Do I have to put all my business logic inside the model files? via Chebli Mohamed Publié par. Change it if necessary. You can also check out our latest tutorials for Laravel!!. so, we need to fire a push notification on every android device when admin insert any new product from laravel application. To understand the all CRUD (Create, Read, Update, Delete) operations with Laravel, we will use simple student management system. (where the data is put into the job and onto a queue. We can set up a GET call with window. We’ll copy over the create form, although a better practice would be to extract this to a partial of some sort. Multiple DB Connections in Laravel A while ago, I answered on this SO question about using 2 database connections. 4 MySQL Node. Scaling Laravel is a video course about setting up your Laravel application to scale, and building a server infrastructure that will scale with your application's needs. DataTables Table plug-in for jQuery Advanced tables, instantly. When testing route with PUT/PATCH method in POSTMAN, you are most likely to get this problem of not receiving your parameters sent out from POSTMAN. It is created by Taylor Otwell. In today article “Create Admin Panel with Laravel Backpack Part 2” we will talk about how to create a quick and powerful admin panel. 4 Laravel 5. If PHP packages are a set of legos, Laravel is the best way to put them together. The book begins with a thorough introduction to Vue. This course include classes for the recent Laravel versions: All the Laravel 5. Visit Laravel's Documentation for more details about creating a new project then onfigure your site. Prefer to use React instead? Then you are in the right place, as we’ll be looking at how to use React in a Laravel application. How to Insert values into database using. LaraJobs is built and maintained by UserScape, creators of HelpSpot. The first way specifies both the column names and the values to be inserted:. This tutorial will guide you through the implementation of JSON Web Token (JWT) authentication in a Laravel application. Multiple DB Connections in Laravel A while ago, I answered on this SO question about using 2 database connections. Prefer to use React instead? Then you are in the right place, as we'll be looking at how to use React in a Laravel application. Insert Data into Myql Database Table using Laravel. Laravel: "Trying to get property of non-object" wh how to insert taskId in to file table in Laravel 5 Web middleware does not get executed (Laravel 5. The control panel is built on standardized patterns and principles just like the API. Laravel 7 For managing dependencies, Laravel uses composer. Active 1 year, 1 month ago. More than 1 year has passed since last update. DataTables Table plug-in for jQuery Advanced tables, instantly. How to insert multiple rows in database Laravel 5? If you want to create multiple records at time using laravel eloquent, then you can do it using "insert()" of laravel eloquent. I strongly discourage to use stored procedures to do this kind of calculation, better to do them into the application code. 1 and lower. Mcrypt PHP Extension. you can also fine all code for copy and paste from our blog. Using Summernote WYSIWYG editor with Laravel Summernote is a WYSIWYG (What You See Is What You Get) style editor which offers lots of nifty features such as pasting images from clipboard, interactive text editing, easy server integration and it has all the features for standard HTML formatting. You end up in the CLI pretty often when hacking on Laravel projects - a typical workflow in Laravel involves creating controllers or models, creating and running migrations, running queue workers. If anything, the Laravel documentation now seems to encourage dependency injection over facades. We often need to store the user data into our database and further retrieve the data a. LaraJobs is built and maintained by UserScape, creators of HelpSpot. How to import Excel File in Laravel and Insert Data in the Database So, now look at your database students table, How to import Excel File in Laravel and Insert Data in the Database Great !! That's Work. we have needed some it last inserted ID in laravel application. You don’t need to know SQL or any other complex query language - all your requests can be described visually, very easily, and in (almost) natural language. In Laravel, migrations are built into the framework; they can be executed, via the Artisan command-line utility. js PHP7 PHP Code Snippets php Tutorials. This tutorial will guide you through the implementation of JSON Web Token (JWT) authentication in a Laravel application. Do I have to put all my business logic inside the model files? via Chebli Mohamed Publié par. get, as the Axios library has been aliased as a property of the window object in the default Laravel frontend setup. In this video I’ll show you just how easy it is to use HTML 5 storage to store values for your website or your web application. Here is a quick look at some of these new features: We'll be building a simple character listing app with. This is awesome for troubleshooting or when you are building the logic in your application. First, let say in your hosting server (VPS, or shared hosting…whatever), you have. In this tutorial, I will show you how to add a custom PHP class in Laravel 5. Laravel is a web application framework with expressive, elegant syntax. i hope u can help. Use laravel relationship model. I already uninstalled the laravel on my Development stack, because I am. Laravel includes an easy method of seeding your database with test data using seed classes. I strongly discourage to use stored procedures to do this kind of calculation, better to do them into the application code. Installing Laravel and Composer on a cPanel Server Laravel is a free, open-source PHP web framework intended for the development of web applications. You can check out PHP on Google Cloud Platform (GCP) to get an overview of PHP and learn ways to run PHP apps on GCP. both PUT and PATCH are directed to update method in the controller. Barnes In recent years, tagging systems have become a popular way of categorizing items, and you can find them in almost every app. If you want to have have a global overview of CORS workflow, you can browse this image. Installing Laravel and Composer on a cPanel Server Laravel is a free, open-source PHP web framework intended for the development of web applications. 5 By tgugnani Laravel 2 Comments As a standard practice of creating an CRUD application there are certain actions in like update and delete which requires the method submitted to the server url to be either PUT / PATCH (to modify the resource) and DELETE (for deleting the resource). In this laravel 5. Laravel : Best Practices aims to put together all the resources and best practices in using the Laravel Framework. you can use it and get last ID of inserted record in laravel application. Using this generator developer can generator Laravel Test Cases, Swagger Docs, Swagger annotations, API Documentation (API Docs), CRUD From Existing table and Scaffold from existing database. Laravel Facades 01 February 2018 on Laravel. This Article was first published here: How to avoid duplicates when you insert hundreds of thousands of entries into the same MySQL table Web Development Laravel Mysql Php Continue the discussion. We often need to store the user data into our database and further retrieve the data a. Let's learn how to create a HTML form, create an AJAX request and more. To make Postman work with POST/PUT requests In addition to checking for the CSRF token as a POST parameter, the Laravel VerifyCsrfToken middleware will also check for the X-CSRF-TOKEN request header. When testing route with PUT/PATCH method in POSTMAN, you are most likely to get this problem of not receiving your parameters sent out from POSTMAN. Many to Many relationships are everywhere out in the wild. There are a few benefits to handling database interactions with ajax. A while back, if I needed dummy data for my local application environment — it involved importing a database partial of an existing site, or modifying MySQL's sakila database, or just some funky way to get data.