If you have used the query builder in yii 2.0.8 framework then to get the raw sql generated use the below statement. $query->andFilterWhere() ->andFilterWhere() ->andFilterWhere(); // This is echo the…
We can get the SQL query from DB sql query in Laravel 5 $dataQuery = DB::table(‘sometable’) ->select(‘sometable.column1′, ‘sometable.column2′, ‘sometable.column3′, ‘sometable.column4′, ‘sometable.column5′); $dataQuery->toSql(); // this will give you the actual query…
Normally we fetch the data as below $dataresult = DB::table(‘sometable’) ->select(‘sometable.column1’, ‘sometable.column2’, ‘sometable.column3’, ‘sometable.column4’, ‘sometable.column5’) ->get(); Now if we want to get the actaul query from $dataresult using $dataresult->toSql(); //…
You check the time from the command line (run date), and find that the timezone is set to UTC or some other timezone. How do you get this changed? To…
If your cron job timing does’t match with the server time zone for example. You have set the cron to run at 12:30 PM, but when you see the cron…
RewriteCond %{HTTPS} off # First rewrite to HTTPS: # Don’t put www. here. If it is already there it will be included, if not # the subsequent rule will catch…
$url = trim($url); $url = preg_replace(“/^(http:\/\/)*(www.)*/is”, “”, $url); $url = preg_replace(“/\/.*$/is”, “”, $url); return $url; Vinod RamVinod Ram has been in Software Industry since 2006 and has experience of over…
You can use the open source ffmpeg program to convert a media file from low quality to high quality format # /fullpath/to/ffmpeg/ffmpeg -i source.mp4 -c:v libx264 -crf 19 destinationfile.flv OR…
You can use the open source ffmpeg program to convert a media file from one format to another. Below is an exmple: # /fullpath/to/ffmpeglibrary/ffmpeg -i InputFile.FLV OutputFile.mp3 There are various…
You can use the open source ffmpeg program to extract a frame to use as a thumbnail for a video. Below is an exmple: # /fullpath/to/ffmpeglibrary/ffmpeg -i InputFile.FLV -vframes 1…