prettyscripts

PHP: SFTP with phpseclib and ssh key #webdevelopment

First you’ll need download / install phpseclib.

Here’s how to connect to the server with ssh key with this library:

[php highlight=”8,11″] use phpseclib\Crypt\RSA; use phpseclib\Net\SFTP;

$sftp = new SFTP($host); // connect to host

// get the key $key = new RSA(); $key->loadKey(file_get_contents($keyfile));

// connect to server $sftp->login($user, $key);

// now do your sftp operations [/php]

Yii2: Auto-expand Parent Menu #webdevelopment #yii

When you have multi-level menu and when a submenu item is selected, you want the parent to auto expand and set as active.

This is one thing I wish I had gone through the documentation before spending hours extending the widget to achieve this. Because it’s already implemented by the framework!

All you need to do is to set activeParents property to true.

Yii2: GridView inline editing with Editable Column #yii2 #webdevelopment

Inline editing provides a quicker way to update data without navigating away from the page. However the built-in GridView does not provide this capability. Thankfully there are 3rd party solutions. One that I use is Krajee’s GridView which has Editable Column to serve this purpose.

There’s a tutorial on setting up the grid to allow inline editing.

Here are some coding templates that I often use.

Yii2: Infinite scrolling with GridView and ListView #yii #webdevelopment

This is one combo that I use frequently in my Yii2 projects. When the page is scrolled to the end, next set of data is retrieved and displayed automatically without the need to click the pagination link and without waiting for the page to load. This improves user experience.

Note that if you have huge amount of data, you still have to wait during the initial page load. But with infinite scrolling…

MsSQL: Find Foreign Key References

Found via this source, this will list all foreign key relations in the database: [sql] SELECT obj.name AS FK_NAME, sch.name AS [schema_name], tab1.name AS [table], col1.name AS [column], tab2.name AS [referenced_table], col2.name AS [referenced_column] FROM sys.foreign_key_columns fkc INNER JOIN sys.objects obj ON obj.object_id = fkc.constraint_object_id INNER JOIN…

php: list months between 2 dates

Based on code:

[php highlight=”3-5″] function list_months($start, $end) { $period = new DatePeriod( (new DateTime($start))->modify(‘first day of this month’), DateInterval::createFromDateString(‘1 month’), (new DateTime($end))->modify(‘first day of next month’) ); $month = []; foreach ($period as $dt) { $month[] = $dt->format(‘Ym’); } r…

Yii2: Authorization without RBAC #webdevelopment #yii2

While RBAC allows you to define collection of permissions for your application, sometimes you just want something simpler to control access to certain pages. The simplest way to define your own access rule without using RBAC is to make use of $matchCallback property when definining Access Control rules.

In behaviors() function in Controller or Module:

(more…)

Yii2: Posting Data via Link #webdevelopment #yii2

This seems to be undocumented (or not so well documented) at the moment. Yii2 provides special supports which allows you to post data via clicking a link.

[php highlight=”3,4″] <?= Html::a(‘Text’, [ [‘/controller/action’], ‘data-method’ => ‘POST’, ‘data-params’ => [ ‘param1’ => 1, ‘param2’ => 2, ], ]) ?> [/php]

Note:

Line 3: Specifying the method, eg…

WordPress: Extra content with Simple Fields #wordpress #webdev

WordPress allows adding extra content to your post or page contents with custom fields. This is useful if the the content is simple text value. You can still use it for other types of data such as image and radio buttons. But it’d be nice if there’s a nice user interface to simplify the process, to allow different types of input and to validate the input.

(more…)

Yii2: Processing jQuery Ajax #webdev #yii #jquery

This is skeleton code example on posting form data in JSON format processing by Yii’s controller action. Although this example uses Yii, the code can be easily adaped to pure PHP code.

(more…)

Yii2: Include View Specific JavaScript #webdev #yii2

To include JavaScript for specific action, either the JavaScript code or file is to be registered in view file.

Method 1: Register JavaScript File

(more…)

Yii2: Ajax Gridview #yii2 #webdevelopment

Want to navigate through the grids or trying to sort and filter data without waiting for the entire page to load?

You need yii\widgets\Pjax and wrap it around GridView.

(more…)

one of the things that's not supported in internet explorer. the css 'position: fixed;'

it works in IE7 and after. but not in older versions. thought people should upgrade their browser, there are still users limited to the older version. (why don't you use firefox???!!!)

when working on a symfony - doctrine project, i run 'symfony doctrine:build-all' command all the time. when it's run, the collation / encoding is changed to something that wasn't used when the database was created.

eg, the database was created with utf8_general_ci. when the task is run, it's changed to latin1_swedish_ci.

unlike propel task, when this doctrine task is run, database is dropped and re-created. hence system default is used. it seems that you can't set default collation for database in symfony / doctrine.

i run into this problem when testing out symfony V1.2 and now it's still happening in V1.3 beta.

the problem was reported. this can be fixed by hacking the file 'path/to/symfony/lib/plugins/sfDoctrinePlugin/lib/database/sfDoctrineDatabase.class.php'. go to line 84 and replace:

if (is_string($value)) { if (defined('Doctrine::'.strtoupper($stringName).'_'.strtoupper($value))) { $value = constant('Doctrine::'.strtoupper($stringName).'_'.strtoupper($value)); } else { $value = strtoupper($value); } }

in 'path/to/project/config/databases.yml':

all: doctrine: class: sfDoctrineDatabase param: dsn: 'mysql:host=localhost;dbname=mydb' username: user password: password attributes: default_table_collate: utf8_general_ci default_table_charset: utf8

run 'symfony doctrine:build-all' again. the tables should be created with the correct encoding.

until this is fixed, you have to hack this code everytime symfony is upgraded.