This way data will be shown inside a text field, which would be editable. I assume you want to update multiple records from single form. In that case validate form and false form after see old data in your form.…
I am currently working on a form, and have just recently added validation I have a form that the user fills out, and after it has been filled, I display validation message to the user, in a red box below…
Use Mail facade to send mail via send method. The send method contain three parameters. First parameter is your view blade file where you write your messages, second parameter is for passing array data to view and last one is…
Laravel 5.* introduces a simple syntax for lookups and updates based on the value of specific keys in your JSON columns. This operation is only supported on databases that support JSON columns. When updating a JSON column, you should use…
If you want to increment or decrement opration using update() method of laravel query builder then you also do that, i am showing you how to increment and decrement value of column in table by using increment(), and decrement(). Both…
ck Shared lock is, when more than one transaction is granted read access to a given record. One transaction gets shared lock on a record. DB::table(‘tbl_order’)->where(‘amount’, ‘>’, 100)->sharedLock()->get(); lockForUpdate You can use it, when reading to prevent the rows from…
If the table has an auto-incrementing id, use the insertGetId method to insert a record and then retrieve the ID. Many time user insert one record in table and find inserted id and this id insert another table. $insert_id =…
The orderBy method is used to sort the result-set in ascending or descending order. The first argument to the orderBy method should be the column you wish to sort by, while the second argument controls the direction of the sort…
The Where clause is used to extract only those records that fulfill a specified condition. The most basic call to where requires three arguments. The first argument is the name of the column. The second argument is an operator, which…
Sometimes you need to bind multiple queries then you can use union in laravel. If you use union then laravel query builder provide union method for mysql union. When you are doing big project or ERP level project then mostly…