Yii2 how to set custom value for checkbox in gridview widget
In Yii2, while you use gridview widget to display your table data, for performing any operation on the record by selecting the checkbox, gridview assign the value of the first…
Validate checkbox array and prefill with selected value on validation error in laravel 5
Say for example you have your checkbox field code in your twig file as below:- @foreach ($serviceList as $servloop) <div class=”checkbox”> <label> <input type=”checkbox” name=”services” value=”{{$servloop->service_id}}” {{ ( is_array(old(‘services’)) &&…
How to wrap data column in Gridview widget in yii or yii2 framework
The column which you want to wrap should be added the property called “contentOptions” where you can apply the css property to suits your needs and requirements as below. ,…
How to get raw sql query in yii or yii2 framework
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…
how to get sql query from facade DB::table in laravel 5
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(); //…
Set widget label from action file in symfony 1.4
In Action File ========================================================== $this->form = new youFormclassname(); To set individual Label $this->form->getWidget(‘widgetname’)->setLabel(‘widget Custom label’); To set multiple field label $this->form->getWidgetSchema()->setLabels(array( ‘field_name_1’ => ‘Field 1 Custom Lable’, ‘field_name_2’ => ‘Field…
Symfony 1.4 generate url for current application and environment
$sf_request->getUriPrefix().$sf_request->getRelativeUrlRoot().$sf_request->getPathInfoPrefix() Vinod RamVinod Ram has been in Software Industry since 2006 and has experience of over 16 years in Software Development & Project Management domain specialised majorly in LAMP stack…
configure database using propel
$ ./symfony configure:database --name=propel --class=sfPropelDatabase "mysql:host=localhost;dbname=dbname" username userpassword Vinod RamVinod Ram has been in Software Industry since 2006 and has experience of over 16 years in Software Development & Project…
Self join criteria in symfony
For Example : SELECT tbl1.id FROM tbl1 a LEFT JOIN tbl1 b ON a.somecolumnname = b.somecolumn ORDER BY a.somecolumn DESC The criteria would be as follow $c=new Criteria(); $c->addAlias(‘a’, ‘tbl1’);…