Category archive
General Posting
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 but this will not give the result with actual data va
Read articleNormally 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(); // it will not work The solution for thi
Read articleYou 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 change this you have to have root access to the server. There are a series of time zone files located at /usr/share/zoneinfo. Select the appropriate […]
Read articleIf 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 log the time show say 3:40 PM. So to run your cron job as per your time zone Say if you are in India, your […]
Read articleHow to validate and restrict unwanted character for mobile or phone number field using jquery $(document).ready(function () { $(‘#mobile’).keyup(function () { var $th = $(this); $th.val($th.val().replace(/[^0-9]/g, function (str) { return ”; })); }); });
Read articleHow to validate and restrict unwanted character for zipcode or pincode field using jquery $(document).ready(function () { $(‘#pincode’).keyup(function () { var $th = $(this); $th.val($th.val().replace(/[^0-9]/g, function (str) { return ”; })); }); });
Read articleHow to validate and restrict unwanted character for name field using jquery $(document).ready(function () { $(‘#name’).keyup(function () { var $th = $(this); $th.val($th.val().replace(/[^a-zA-Z0-9 \`]/g, function (str) { return ”; })); }); });
Read articleIf your site is developed in Drupal and your URL looks like this: If your site URL looks like this: http://[domain name OR IP Address]/~[accountname]/anyFolder/ Example http://example.com/~xyzaccount/somefolder/ http://xxx.xxx.xxx.xxx/~xyzaccount/somefolder/ Then you need to set RewriteBase!in your .htaccess file that
Read articleRewriteCond %{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 it. RewriteRule .* https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301] # Now, rewrite any request to the wrong domain to use www. RewriteCond %{HTTP_HOST} !^www\. Rewrit
Read article$url = trim($url); $url = preg_replace(“/^(http:\/\/)*(www.)*/is”, “”, $url); $url = preg_replace(“/\/.*$/is”, “”, $url); return $url;
Read articleYou can use the open source ffmpeg program to convert a media file from low quality to high quality format [shellprompt]# /fullpath/to/ffmpeg/ffmpeg -i source.mp4 -c:v libx264 -crf 19 destinationfile.flv OR [shellprompt]# /fullpath/to/ffmpeg/ffmpeg -i source.mp4 -c:v libx264 -ar 22050 -crf 28 destinationfile.flv Parame
Read articleYou can use the open source ffmpeg program to convert a media file from one format to another. Below is an exmple: [shellprompt]# /fullpath/to/ffmpeglibrary/ffmpeg -i InputFile.FLV OutputFile.mp3 There are various other options you can use to specify the attribute of the output file. Here are few of the examples code h
Read article