Sometimes we all need to insert multiple rows into our database. Data can come from various sources like feeds, excel sheets etc.
So how to do that?
Goal: Insert multiple rows in efficient way.
How to select rows which doesn’t exist in other table in SQL
StandardWe all are familiar with selecting the rows which has common data in multiple tables. And yes using joins are the most popular solution among the developers.
Now question is how to select rows which doesn’t exists in other tables.
lets say there are two tables employee and department.
How to call a php function if function name is given as string
StandardSometimes we require to call a function with the name given as string variable. I wanted it. Just wondering how to do that in PHP? Here are the methods:
We have one inbuilt function to solve this purpose 1.call_user_func and another way is 2. Using function name as variable.
Configure apache php server to point location another then htdocs or www
StandardObviously! we can point apache server to pick our code files from another location other then www or htdocs. Also we can configure the url for our project folder.
Lets take a look how.
Step 1. Look for the file httpd.conf (this can be found under your apache installation folder inside conf directory)
How to deploy web app on Heroku using GitHub
StandardHow to traverse the flex dictionary
StandardHi Guys!
Sometimes we might need to go through all the values from a action script dictionary.
Here is very simple example.
How to dock google chrome developer console to right hand side of the browser
StandardHi Guys,
Most of the web developers might wonder about how to move google chrome developer console from default position(bottom) to right hand side. Especially when we develop something for mobile and when we need to keep our screen portrait and need to see console all the time for error and all.
Something like this…
How to get selected text from textarea/text input in Ext JS
StandardHi Guys!
Here I am going to explain about getting selected text string from a EXTJS/HTML textarea/textinput.
We need to write two different code for IE based browsers and rest of all.
In ExtJS first we need to select dom element of textarea and that can be done using inputEl.dom.
TECH ON RIA - Shubham's Blog 