How to enable Oracle Connection to PHP on XAMPP (on Windows)

1. Install XAMPP on your Windows machine. We were using the latest one v5.6.14 (you can download the same from here) on Windows XP.

2. Extract InstantClient to C:\instantclient_<version_no> folder (You can download the same from here)

3. Open system setting at Start Menu > My Computer (right click on the icon) > Select Properties > Advanced Tabs > Environment Variables.

4. Add to ‘System Variables’ by clicking ‘New’ button and insert the following values:

a. Variable Name : PATH

b. Variable Value : C:\instantclient_<version_no>

5. Click OK to accept new modification.

6. Open C:\xampp\php\php.ini by using notepad/any other text editor.

7. Find string oci8 and remove the ; symbol at the beginning of the string line.

8. Save and Exit.

9. Restart Apache server to accept new modification on xampp.


To Check if Oracle connection support is loaded or not-

1. Open web browser.

2. In the address section type http://localhost/xampp

3. Once page load, select phpinfo() menu from the link on the left section of the page.

4. Try to find string OCI8 by using the search function of your browser(or by using CTRL+F).

5. If there is string found on OCI in your phpinfo() page. Then you can start connection to your oracle database.


PHP code to connect to Oracle

1. Open notepad/your text editor

2. Type following code:



If (!conn)

  echo “Failed to connect to Oracle”;


  echo “Succesfully connected with Oracle DB”;


3. Save and exit the text files as : connection.php(All Files Category) at C:\xampp\htdocs\

4. Once saved, please open browser and enter URL http://localhost/connection.php

5. If you see Text stating “Successfully connected with Oracle DB“ , then you are good to go.


Ref: stackoverflow

Which are some best Android apps which are very helpful for knowledge?

Answer by Upasana Sharma:

Here are my favorite apps that I use directly or via their service to keep myself up-to-date!

  1. Quora – Android Apps on Google Play
  2. TED – Android Apps on Google Play
  3. Google News & Weather – Android Apps on Google Play
  4. Duolingo: Learn Languages Free – Android Apps on Google Play (great app if you are interested in learning new languages)
  5. Khan Academy – Android Apps on Google Play (if you want to brush up your mathematical skills, it has problems from easy level to advanced level. I am still learning 🙂 )
  6. Amazon Kindle – Android Apps on Google Play (I prefer reading ebooks, hence I sync them on kindle app on Android device)
  7. Google Translate – Android Apps on Google Play (you never know when you might need them, I use them in sync with Duolingo)
  8. YouTube – Android Apps on Google Play (again its all about what content you are following)
  9. Moneycontrol Markets on Mobile – Android Apps on Google Play (if you are interested in market updates, this is a good one)


Which are some best Android apps which are very helpful for knowledge?

Do we need knowledge of Angular.js, Node.js for Android Applications Development?

Answer by Upasana Sharma:

Android development, or basically any kind of mobile development will involve the client end coding.

In case of Android, if you are planning to develop the app in native language of Android SDK, you will have to learn/work in Java.

If you are planning to develop the app using hybrid platforms like Phonegap, Titanium, etc you will have to work with HTML/CSS/JS. You can use AngularJS to give your app an MVC structure.

If your app intends to connect to your server to get/post some data, the server side APIs will need to be created separately. This could be any server side language, Java/JSP, ASP.NET ,  PHP or Node.JS, etc

If you plan to work with Node.JS to create the server side APIs, over there too AngularJS might be used depending on your server side application architecture.

Hence for starting with Android development, you do not need to learn Node.JS/AngularJS. It depends on which track you are focusing on.

Do we need knowledge of Angular.js, Node.js for Android Applications Development?

importing mysql data dump via command line

Recently we had to import a db dump (.sql) file of size 346MB.

Yes there are tweaks to do the same via phpmyadmin to increase post limit, timeout time, upload size etc.

However doing it command line seemed like a better option

Here is the command to import the database

mysql -u your_user -p your_db_name < sql_filename.sql

This works irrespective of the dump size.

Cheers to command line!

How can we reset the autoincrement value of primary key in a mysql table

Now while testing we keep on adding rows to tables. But once we need to put in some real data, the primary key index is no longer the initial value like an empty table.
Suppose we did 30 test entries. Even if we delete them, the next items being added start from index 31.

Here is the fix to make it start from 1 again.


We can actually set it to any value we require.

Hope it helps. Cheers!

Change wpadminbar (top bar) color of wordpress admin panel

So here is how we can change the wordpress adminbar (top bar color).

We need to add the following to functions.php. I added them to the end of the file.

add_action('wp_head', 'change_bar_color');
add_action('admin_head', 'change_bar_color');
function change_bar_color() {

Source : Link

Android emulator – switch to landscape mode

    ctrl+fn+F11 on Mac to change the landscape to portrait and vice versa.
    left-ctrl+F11on Windows 7.
    ctrl+F11on Linux.

For Mac users, you only need to use the fn key if the setting “Use all F1, F2 etc. keys as function keys” (under System Preferences -> Keyboard) is checked.

left-ctrl+F11on Windows 7 It works fine in Windows 7 for android emulator to change the landscape orientation to portrait and vice versa.

This just saved my day!

Source : Stackoverflow

Solution : Cordova Jquery Ajax calls not working @Android4.x

On Cordova 5.x , for the android platform a plain ajax call does not work

It does not give any detailed error

readystate: 0
status : 0
errortext : error



Things are changing.

After doing research on the issue and trying out different options, I came across this.

1. You need to install the cordova whitelist plugin (this is not available for ios currently though)

cordova plugin add cordova-plugin-whitelist

2. In config.xml


in place of the old, tag.

And bam, all the ajax calls are working properly.

Note: You will need to add the following to your html files in the section.

<meta http-equiv="Content-Security-Policy" content="default-src *; style-src 'self' 'unsafe-inline'; script-src 'self' 'unsafe-inline' 'unsafe-eval'"/>

else you will get the following error message while running the app.

“No Content-Security-Policy meta tag found. Please add one when using the cordova-plugin-whitelist plugin.”

Hope it helps somebody facing similar issues.