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…
How 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(//g, function (str) { return…
How 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(//g, function (str) { return ”;…
How 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(//g, function (str) { return ”; })); });…
If your site is developed in Drupal and your URL looks like this: If your site URL looks like this: http:///~/anyFolder/ Example http://example.com/~xyzaccount/somefolder/ http://xxx.xxx.xxx.xxx/~xyzaccount/somefolder/ Then you need to set RewriteBase!in…
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…