October 2013 archive

Stripe Payment Gateway Implementation

Stripe Payment Gateway Implementation: Steps to Implement: Download the stripe package(stripe). Extract that into the web accessible folder. Create an account in stripe using this url: https://manage.stripe.com/login After Created the account get the test secret key and test publishable key from your stripe account using this url: https://manage.stripe.com/account/apikeys Now in config.php file change the “testSecretKey” …

Continue reading

Permanent link to this article: https://blog.openshell.in/2013/10/stripe-payment-gateway-implementation/

Yii & google map integration

Now the yii and google map integration become easy with this super extension JQUERY-MAP. Extension url : http://www.yiiframework.com/extension/jquery-gmap/

Permanent link to this article: https://blog.openshell.in/2013/10/yii-google-map-integration/

YII Upload the file to FTP server

The below function used to upload the local file to remote directory. [php] /** * Upload the file in ftp directory * @param string $localFilePath * @param string $remoteFilePath . * @return boolean */ public function CopyFileToFtpBucketDir($localFilePath, $remoteFilePath) { <strong><em>//Credential are configured in main.php</em></strong> $ftpSource = Yii::app()-&gt;params[‘ftpSource’]; $ftpUserName = Yii::app()-&gt;params[‘ftpUserName’]; $ftpPassword = Yii::app()-&gt;params[‘ftpPassword’]; <em><strong>// set …

Continue reading

Permanent link to this article: https://blog.openshell.in/2013/10/yii-upload-the-file-to-ftp-server/

How to retrieve the last record in each group using mysql

In single SQL query itself we can retrieve the last record in each group. It will help us to perform action better, faster and simpler. In this post I will explain about you how to do it. Here is my table structure for your reference. [sql] desc post_status; +—————-+————-+——+—–+———+—————-+ | Field | Type | Null …

Continue reading

Permanent link to this article: https://blog.openshell.in/2013/10/how-to-retrieve-the-last-record-in-each-group-using-mysql/