Laravel eloquent update return value update#
One downside is that this will execute the query and then get you the log. More Answer Laravel Eloquent - Update() function always return true Laravel 5.1 - Eloquent Relationships Update Function Laravel Eloquent Update Affected. To update the link with ID 1, run: docker-compose exec app php artisan link:update 1. To get around this, you can use the query log. Insights master laravel-tips/db-models-and-eloquent.md Go to file Cannot retrieve contributors at this time 2155 lines (1590 sloc) 62. For instance, you may want to create a digitalocean list for the links that point to the DigitalOcean website (that would correspond to items with IDs 1, 2, and 3 in the previous example output). DB::table('users')->where('id', '1')->update()->toSql() Įrror Call to a member function toSql() on int. If you try to print or dump a SQL statement on an update query, it will throw an error as query has already executed and it returns the number of rows that were affected by the update query. Select * from `users` where `id` = ? // vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:3788Īrray:1 [ // vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:3788
You can use dump method on it instead to get the query with bindings as well: DB::table('users')->where('id', '1')->dump() Description, Run an update statement against.
There is a ? in there in the query because the values are parameterized. query(string) query to execute in database bindings(array) values to bind with queries.
Laravel eloquent update return value for free#
If you do that and want to get the raw SQL query, you can use the toSql method: DB::table('users')->where('id', '1')->toSql() Insights New issue Laravel - update () function always return true 24775 Closed davidoskay opened this issue on 5 comments davidoskay commented on edited Laravel Version: 5.6 PHP Version: 7.2 Database Driver & Version: Mysql closed this as completed on Sign up for free to join this conversation on GitHub. Upon reading the documentation, you're supposed to run the query this way, for queries not returning any valuesĭB::statement('UPDATE table SET something = 1 WHERE id = 1') Īlso, I had used backticks `` for the original longer SQL statement so that seemed to have caused on issue.Īlternatively, I could do it without using eloquent models like: DB::table('users')->where('id', '1')->update() ValueError: PDO::prepare(): Argument #1 ($query) cannot be empty Eloquent Update Method return model Issue 13488 laravel/framework GitHub. This strategy won't return the updated name this will only return the data before update as you use find method before update.
A really small mistake - I wanted to run a MySQL update statement on laravel (no bindings, no parameters, no models) so I wrote this DB::update(`UPDATE table SET something = 1 WHERE id = 1`)
0 kommentar(er)
