$diff = Carbon::parse( $start_date )->diffInDays( $end_date );
Here is what the above code is Doing:
1. We’re creating a new Carbon instance from the start_date string.
2. We’re calling the diffInDays() method on the Carbon instance, passing in the end_date string.
3. We’re assigning the result to the $diff variable.
// Retrieve the first task $task = Task::first(); $newTask = $task->replicate(); $newTask->project_id = 16; // the new project_id $newTask->save(); Here is what the above code is Doing: 1. Retrieve the first task 2. Create a new instance of the Task model 3. Set the project_id to the new project_id 4. Save the new task The…
use Illuminate\Database\Eloquent\Builder; // Retrieve posts with at least one comment containing words like code%… $posts = Post::whereHas(‘comments’, function (Builder $query) { $query->where(‘content’, ‘like’, ‘code%’); })->get(); // Retrieve posts with at least ten comments containing words like code%… $posts = Post::whereHas(‘comments’, function (Builder $query) { $query->where(‘content’, ‘like’, ‘code%’); }, ‘>=’, 10)->get(); Here is what the above…
Str::limit($string) Here is what the above code is Doing: 1. We’re using the Str::limit() method to limit the length of the string to 20 characters. 2. We’re using the Str::words() method to limit the string to only 3 words. 3. We’re using the Str::of() method to convert the string to an instance of the Illuminate\Support\Str…
Here is what the above code is Doing: 1. First, we create a connection to the MySQL database. 2. Then, we select the database. 3. After that, we create a SQL query as a string. 4. Then, we execute the SQL query using the mysql_query() function. 5. After that, we get the number of rows…
Here is what the above code is Doing: 1. The LOAD DATA INFILE statement tells MySQL to read the file. 2. The INTO TABLE statement tells MySQL where to put the data. 3. The FIELDS TERMINATED BY statement tells MySQL how to separate the fields. 4. The LINES TERMINATED BY statement tells MySQL how to…
// Need to increase or set client_max_body_size in your nginx config file. http { #… client_max_body_size 100m; #… } // Restart nginx Here is what the above code is Doing: 1. We’re importing the Flask class from the flask module. An object of this class will be our WSGI application. 2. Next we create an…