Get Last Executed Query in Laravel

 Last Query in Laravel

DB::enableQueryLog();
$product = Product::get();
$query = DB::getQueryLog();
dd($query);

1. \DB::enableQueryLog();
2. $list = \DB::table("categories")->get();
3. $query = \DB::getQueryLog();
4. print_r(end($query));

Best leading PHP frameworks in 2019

The top 10 PHP frameworks

Here’s a list of the best PHP frameworks, based on popularity and ability to facilitate application development.

1. Laravel
2. Symfony
3. CodeIgniter
4. Zend
5. CakePHP
6. FuelPHP
7. Yii 2
8. Phalcon
9. Slim
10. PHPixie

1. Laravel

If frameworks were people, Laravel would probably be the king. If you want to code beautiful designs, you’re looking for Laravel since it’s positioned as the go-to PHP framework for web artisans.

The reason for its wide popularity boils down to ease of use and virtually no learning curve. And despite that, it’s a framework developer use for some serious work. So it may seem like a simple tool at first, but it’s a beast when it comes to producing concrete work.

2. Symfony

When it comes to developing large-scale enterprise projects, Symfony makes a perfect choice amongst the PHP frameworks. Its ecosystem is a huge one, with a big set of reusable components and an active community of developers. The components serve the purpose of completing diverse tasks such as for creation, the configuration of objects, authentication, routing, templating, and much more. These components are being used to power up projects such as Drupal, Laravel, PHPBB, PIWIk, and OROCRM.

3. CodeIgniter

CodeIgniter is one of the oldest frameworks but is simple and powerful. It can easily be installed and requires minimal user configuration. It works perfectly on almost all shared and dedicated hosting platforms. CodeIgniter isn’t entirely based on the MVC framework. Models and Views are optional, but Controller classes are a must. Another strength of CodeIgniter is speed. It runs faster with database tasks in comparison to other frameworks. CodeIgniter is well documented and a good framework to start with for PHP beginners.

Delete Documents in MongoDB Collection

Delete Methods

MongoDB provides the following methods to delete documents of a collection:

db.collection.remove({})	Delete a single document or all documents that match a specified filter.
db.collection.deleteOne({})	Delete at most a single document that match a specified filter even though multiple documents may match the specified filter.
db.collection.deleteMany({})	Delete all documents that match a specified filter.

Eg:-  db.users.deleteMany({ status : "A" })

      db.users.deleteOne( { status: "D" } )

      db.getCollection('Users').find({$and:[{"cid":2}, {"created-at":{ "$gte" : new ISODate("2018-01-22")}} ]})

Tax benefit on Home Loan

Tax benefit on Home Loan (Principal Amount)

The amount paid as Repayment of Principal Amount of Home Loan by an Individual/HUF is allowed as tax deduction under Section 80C of the Income Tax Act. The maximum tax deduction allowed under Section 80C is Rs. 1,50,000.

This tax deduction is the total of the deduction allowed under Section 80C and includes amount invested in PPF Account, Tax Saving Fixed Deposits, Equity Oriented Mutual funds, National Savings Certificate etc.

This tax deduction under Section 80C is available on payment basis irrespective of the year for which the payment has been made. The Amount paid as Stamp Duty & Registration Fee is also allowed as tax deduction under Section 80C even if the Assessee has not taken Loan.

However, tax benefit of home loan under this section for repayment of principal part of the home loan is allowed only after the construction is complete and the completion certificate has been awarded. No deduction would be allowed under this section for repayment of principal for those years during which the property was under construction.

TAX BENEFIT ON HOME LOAN (INTEREST AMOUNT)

Tax Benefit on Home Loan for payment of Interest is allowed as a deduction under Section 24 of the Income Tax Act. As per Section 24, the Income from House Property shall be reduced by the amount of Interest paid on Home Loan where the loan has been taken for the purpose of Purchase/ Construction/ Repair/ Renewal/ Reconstruction of a Residential House Property.

The maximum tax deduction allowed under Section 24 of a self-occupied property is subject to a maximum limit of Rs. 2 Lakhs (increased in Budget 2014 from 1.5 Lakhs to Rs. 2 Lakhs).

In case the property for which the Home Loan has been taken is not self-occupied, no maximum limithas been prescribed in this case and the taxpayer can take tax deduction of the whole interest amount under Section 24.

Publishing your android App to Google Play Store

Publishing your app

$ cordova plugin rm cordova-plugin-console

$ cordova build --release android

This will generate a release build based on the settings in your config.xml. Your Ionic app will have preset default values in this file, but if you need to customize how your app is built, you can edit this file to fit your preferences. Check out the config.xml file documentation for more information.

Next, we can find our unsigned APK file in platforms/android/build/outputs/apk. In our example, the file was platforms/android/build/outputs/apk/HelloWorld-release-unsigned.apk. Now, we need to sign the unsigned APK and run an alignment utility on it to optimize it and prepare it for the app store. If you already have a signing key, skip these steps and use that one instead.

Let’s generate our private key using the keytool command that comes with the JDK. If this tool isn’t found, refer to the installation guide:

$ keytool -genkey -v -keystore my-release-key.keystore -alias alias_name -keyalg RSA -keysize 2048 -validity 10000



You’ll first be prompted to create a password for the keystore. Then, answer the rest of the nice tools’s questions and when it’s all done, you should have a file called my-release-key.keystore created in the current directory.

Note: Make sure to save this file somewhere safe, if you lose it you won’t be able to submit updates to your app!

To sign the unsigned APK, run the jarsigner tool which is also included in the JDK:

$ jarsigner -verbose -sigalg SHA1withRSA -digestalg SHA1 -keystore my-release-key.keystore HelloWorld-release-unsigned.apk alias_name



This signs the apk in place. Finally, we need to run the zip align tool to optimize the APK. The zipalign tool can be found in /path/to/Android/sdk/build-tools/VERSION/zipalign. For example, on OS X with Android Studio installed, zipalign is in ~/Library/Android/sdk/build-tools/VERSION/zipalign:

$ zipalign -v 4 HelloWorld-release-unsigned.apk HelloWorld.apk



Now we have our final release binary called HelloWorld.apk and we can release this on the Google Play Store for all the world to enjoy!

(There are a few other ways to sign APKs. Refer to the official Android App Signing documentation for more information.)

keytool -genkey -v -keystore acharyasri-key.keystore -alias acharyasri -keyalg RSA -keysize 2048 -validity 10000

jarsigner -verbose -sigalg SHA1withRSA -digestalg SHA1 -keystore acharyasri-key.keystore platforms/android/build/outputs/apk/android-release-unsigned.apk acharyasri

zipalign -v 4 E:/MobileApps/aacharya/android/build/outputs/apk/android-release-unsigned.apk Acharyasri.apk

Google Play Store

Now that we have our release APK ready for the Google Play Store, we can create a Play Store listing and upload our APK.

To start, you’ll need to visit the Google Play Store Developer Console and create a new developer account. Unfortunately, this is not free. 




Git - Create New Branch from Upstream

rath@rath-1:~/www/Pjct$ git checkout master

rath@rath-1:~/www/Pjct$ git fetch upstream master

rath@rath-1:~/www/Pjct$ git rebase upstream/master

Then from smart git UI F7 create new Branch

CodeIgniter Remove index.php By .htaccess

Steps To Remove index.php using .htaccess:-

Step:-1  Open the file config.php located in application/config path.  Find and Replace the below code in config.php  file.

//  Find the below code

$config['index_page'] = "index.php"

//  Remove index.php

$config['index_page'] = ""

Step:-2  Go to your CodeIgniter folder and create .htaccess  file.

Path:
Your_website_folder/
application/
assets/
system/
user_guide/
.htaccess <--------- this file
index.php
license.txt

Step:-3  Write below code in .htaccess file

<IfModule mod_rewrite.c>
RewriteEngine On
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ index.php/$1 [L]
</IfModule>

Step:-4  In some cases the default setting for uri_protocol does not work properly. To solve this issue just open the file config.php located in application/configand then find and replace the code as:

//  Find the below code

$config['uri_protocol'] = "AUTO"

//  Replace it as

$config['uri_protocol'] = "REQUEST_URI" 

---