Category archive
Post related to PHP
We recently migrated our website to another hosting service running FPM/FastCGI . We noticed under the website CMS -> tools -> Site Health Status , that all our REST API calls were failing authentication. It appeared to turn the request into an request from an Anonymous user even though we passed Basic Authentication h
Read articleHow to reorder table rows using drag and drop and automatically save the sequence in database. Sample Table code start <table class=”table table-bordered” id=”tbl_1″> <thead> <tr> <th width=”25%”>Column1 Label</th> <th width=”25%”>Column2 Label</th> <th width=”25%”>Column3 Label</th> <th width=”25%”>Column4 Label</th>
Read articlePut the below code in youractivetheme.theme file /** * Implements hook_preprocess_HOOK(). */ function [theme]_preprocess_webform_confirmation(&$vars) { if ($vars[‘webform’]->id() == ‘put your webform id’) { // Set your custom message here $markup = t(‘Thank you for your feedback.’); $vars[‘message’][‘#markup’] = $marku
Read articleIn Yii2 Gridview normally to display the action button we have the following chunk of code $columns = [ [‘class’ => ‘yii\grid\SerialColumn’], ‘name’, ‘description:ntext’, ‘status’, [ ‘class’ => ‘yii\grid\ActionColumn’, ] ]; The output you see as below: Now you have a scenario, to show the edit button only when the “Zon
Read articleWhen you have access to the command line and you have the export large database, you will not be able to export from phpmyadmin. Hence mysql provide you handy method to export the database from the command line. Below are various options, you can use while exporting the database. ——databases – This allows you to [&hell
Read articleMany a times when you view the php version in the browser by displaying the phpinfo() information and the php version that is displayed when you see by typing the command “php -v” in the console or command prompt, You will notice that there is difference in the two. So how to set the php […]
Read articleIn 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 column retrieved from your the result set. But you need to set some different value to the checkbox, so to do that you can use […]
Read articleThe solution is very simple gunzip -r * This will extract all .gz file in the respective directory and sub directory and remove the .gz files as well.
Read articleFirst set your s3 bucket configuration in your .env file as below. S3_AWS_KEY=AKIAIDTXXXHUR7ABCDEF S3_AWS_SECRET=2XTTy0q8xxdaddffrtsfsdfdfgfhvcdsfsf S3_AWS_REGION=us-east-2 S3_AWS_BUCKET=BUCKET_NAME In your controller file add the following code to set the public property to the uploaded image. if (request()->hasFile(‘
Read articleThe 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. [ ‘attribute’ => ‘column name’, ‘format’ => ‘html’, ‘noWrap’ => false, ‘mergeHeader’=>true, ‘contentOptions’ => [‘style’ => ‘width: 50%; overflow: sc
Read articleIf 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([‘like’, ‘username’, $this->username]) ->andFilterWhere([‘like’, ’email_id’, $this->email]) ->andFilterWhere([‘registration_date’ => $this->register_date]); // This is echo the raw
Read articleWe 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 article
