Updating wordpress theme from database

February 3, 2017
Here I am sharing, how you can update theme from database. Step 1: Go to database and browse the “wp_options” table and try to locate “template” and “stylesheet” in “option_name” fields. You can also run below query: SELECT * FROM wp_options WHERE option_name IN ("template","stylesheet") see the screen shot below: Step 2: In result you can observe the ...
Read more..

Setting netbeans as my default PHP IDE on ubuntu

January 3, 2017
Whenever I am trying to open any PHP file, it does not show NetBeans option in “open with” in Ubuntu. I did following changes to achieve this: Step 1: Go to the following location: cd /usr/share/applications/ Step 2: locate netbeans.desktop file ls -al | grep netbeans Step 3: update the netbeans.desktop file vim netbeans Exec=/bin/sh "/usr/local/netbeans-8.0.2/bin/netbeans" %U You just need to add “%U” ...
Read more..

How to make applications start on Ubuntu startup

December 3, 2016
I just wanted to open firefox whenever I start the Ubuntu. It is little different then window operating system. I am showing here how you can add firefox to launch  whenever we start the Ubuntu. Step 1 : From Dash open “Startup Applications” like below: Step 2 : On “Startup Applications” popup click “Add” button, which allow you ...
Read more..

Mysql error due to reserve words in query.

October 18, 2016
Sometime it happens, you create field name or table name with reserve keywords in mysql. And than try to run query using that keyword, you will get some SQL syntax error like below: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to ...
Read more..

Mysql Event scheduler

September 18, 2016
I have already posted a blog (Event Scheduler an alternative to cronjob) with different advantages of Even scheduler over cron job, here I am sharing how you can configure MySql server to enable or disable scheduler and writing a sample event scheduler. You can check with below query as your server is up for event scheduler ...
Read more..

Angularjs Ajax pagination

July 3, 2016
Sharing below how you can implement AJAX pagination using angularJS. As I am in the learning phase of angular i get fascinate after implementing something new which i don’t know. So I thought for noting it down, which will help someone out there. Steps 1: Create a HTML file as “test.html” and copy the below code. Little explanation ...
Read more..

Multiple Google Map on single page with marker and click event

April 22, 2016
Sharing below how we can create multiple google map in a single html page with marker and click event. I have added click event to show more detail about the marker like description, but we can also add different functionality like navigating to different page or zoom in or zoom out etc,. Just copy and past the ...
Read more..

How to convert Base64 string from IOS to image in PHP

March 31, 2016
Today I learn how you can store images in folder, posted using IOS or Android application to PHP server. APP need to registered a user and I am able to get and insert all user data pass using JSON format except profile image. APP sending image data as string encoding in base 64 which is looking something like below: APP converted image ...
Read more..

angularjs – ng-repeat – custom data sorting using dropdown

March 3, 2016
Today I learn how to sort data binded using ng-repeat. I am setting multiple values one for “expression” and one for “reverse” but no need for that insead you can just “-“(negative) in expression value and data get sorted reversely so simple. I facing this issue because I need to provide sorting using dropdown instead clicking ...
Read more..

Setting file editor in Core FTP

February 25, 2016
You can easily edit your files using different IDE in core FTP. Follow below steps to change/update/add editor for your server files. – First connect to server files using Core FTP. – Go to the “File Associations” in Manage menu item. You will get a screen like below: – Add the extension and select executable (as which IDE ...
Read more..