prettyscripts @prettyscripts - Tumblr Blog

PHP: SFTP with phpseclib and ssh key

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]

View On WordPress

#ftp #PHP

Yii2: Auto-expand Parent Menu

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.

View On WordPress

#menu #Yii2

Yii2: GridView inline editing with Editable Column

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.

View On WordPress

#GridView #inline edit #PHP #Yii2

Yii2: Infinite scrolling with GridView and ListView

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…

View On WordPress

#Ajax #jQuery #PHP #Yii2

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…

View On WordPress

#Foreign Keys #SQL

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…

View On WordPress

#date #PHP

Yii2: Authorization without RBAC

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

View On WordPress

#PHP #Yii2

Yii2: Posting Data via Link

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…

View On WordPress

#Javascript #PHP #Yii2

WordPress: Extra content with Simple Fields

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

View On WordPress

#custom fields #plugin #WordPress

Yii2: Processing jQuery Ajax

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

View On WordPress

#Ajax #jQuery #PHP

Yii2: Include View Specific JavaScript

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

View On WordPress

#Javascript #view #Yii #Yii2

Yii2: Ajax Gridview

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

View On WordPress

#Ajax #grid #Yii #Yii2

lightbox problem. top: using evopress skin. bottom: using foundation framework based skin.

news: missing contents

website is currently unavailable. please check back later.

css and ie: fixed position

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???!!!)

to cater for these users, there's a fix.

#ie #css #position #fixed

css and html list

everything you need to know styling your list in a single article.

#html #css #list #menu

symfony: doctrine build-all and table collation

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.

update: you still need to do this in V1.4rc1.

#symfony #doctrine

Trending Blogs

Recently Viewed Blogs

prettyscripts