Skip to content

Vinod Ram Blog

Creative, Informative and Entertaining Stuff for everyone

Vinod Ram Blog

Creative, Informative and Entertaining Stuff for everyone

  • Home
  • Web Stories
  • Get in touch
  • About
    • Home
    • PHP
    • Page 2
MVC PHP web development yii yii2

How to get raw sql query in yii or yii2 framework

Vinod Ram November 15, 2017 0 Comments

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…

Laravel Mysql PHP web development

how to get sql query with data binding from facade DB::table in laravel 5

Vinod Ram October 7, 2017 0 Comments

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…

Laravel MVC PHP web development

how to get sql query from facade DB::table in laravel 5

Vinod Ram October 7, 2017 0 Comments

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(); //…

linux PHP web development

How to Change Timezone in CentOS

Vinod Ram February 2, 2016 0 Comments

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…

linux PHP web development

Timezone issue with cron

Vinod Ram February 2, 2016 0 Comments

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…

htaccess Setting PHP rewrite rule web development

Force HTTPS url with .htaccess

Vinod Ram July 30, 2015 0 Comments

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…

PHP web development

Get domain name from url

Vinod Ram January 30, 2014 2 Comments

$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…

ffmpeg linux PHP web development

create high quality video using ffmpeg

Vinod Ram November 23, 2013 0 Comments

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…

ffmpeg linux PHP web development

convert video from one format to another using ffmpeg

Vinod Ram November 23, 2013 0 Comments

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…

ffmpeg PHP web development

create video thumbnail using ffmpeg

Vinod Ram November 23, 2013 0 Comments

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…

Posts navigation

1 2 3 4

« Previous Page — Next Page »

Tags

amazon amazon on strike 2024 Anita Bryant Australia bitcoin content Cricket date date validation David Dobrik Death in Paradise delivery Staff donald trumph form validation France gateway timeout Hollywood htaccess javascript jquery Karate laravel Melbourne Cricket Ground microsoft movie Muay Thai Murielle Hilaire netflix ninja form Notre-Dame fire online Shopping Paris php-fpm Singer squid game Stardom suspense Sydney Sweeney thriller usa politics validation website development wordpress yii2 youtuber

Archives

You Missed

General Knowledge International News

Microsoft Makes OpenAI’s $200/Month AI Free for All Copilot Users

General Knowledge International News

अमेरिका-चीन व्यापार युद्ध बढ़ा: नए टैरिफ और जवाबी उपायों से वैश्विक बाजार में उथल-पुथल

International News

Dick Button The Trailblazer Who Revolutionised Figure Skating

Hollywood International News

Selena Gomez was criticised for posting a tearful video on Instagram

Vinod Ram Blog

Creative, Informative and Entertaining Stuff for everyone

Copyright © All rights reserved | Blogus by Themeansar.

  • Terms and Condition
  • Disclaimer
  • Privacy Policy
  • Get in touch