SQL Insert into Select Query Example

Guys you are trying to insert data from one of your existing table to another existing table or same table in mysql you can use SQL Insert into Select Query. The following query will explain

You can add where clause too,


How to Upload Image With Custom Resize in PHP

In this article we have explained about how to upload an image with resize using simple php script. Save image as your width and height.


Read More

How to Create Custom Helper in Codeigniter

In this  article we have explained about how to create custom Helper in Codeigniter. Helper is a group of functions but it is not a class.

Read More

Predict illegal words from the content in codeigniter

To avoid the illegal words in your content as you are using codeigniter provide word_censor functions.Here we are brief explain about this function. First you mention what are the words are you going to skip from the content. Those values are maintain your table.


Read More

Get latitude and longitude values from your address

When you are integrating google maps for locations you may need to know their latitude and longitude values. In that time pass your address through maps.google.com for api request.It returns the values as json output. The values are stored into database. So next time you can search the location in table. If it is not found you can send api request and store it.Why we are store the values in database because to avoid of frequent usage this is free api even it has some limit of access. when we frequent request the server doesn’t respond immediately. So that’s why we store the values.

In php: