Skip to main content


Showing posts from May, 2017


How to connect remote DB from localhost using PhpMyAdmin

Connecting to a remote database from localhost can be done in many ways. Here I am going to explain a very simple way to do so. That is, connecting a remote database using phpmyadmin in the local server. To do so you need to follow the simple steps given below, Note: Hope you guys have server installed in your local machine Xampp, Wamp etc. I am using xampp for the tutorial.
1.Open the XAMPP control panel. You can open it from the Xampp directory. (eg: C:\xampp ->xampp-control) 2.Click on the Config button on the right side of Apache and select PhpMyAdmin ( from the dropdown list. 3.Now you need to add the connection details in the document just before the php closing tag in the following format. Eg: $i++; $cfg['Servers'][$i]['host'] = ''; //provide hostname and port if other than default $cfg['Servers'][$i]['user'] = '';//user name for your remote server $cfg['Servers'][$i]['password'] = '';//pass…

How To Download Videos or Audio From Streaming Websites

Most video sites operate on streaming algorithms. These algorithms only allow the online streaming of videos and prevent the downloading of videos to your disk or memory. Although, downloading videos from these kind of sites are breaking the rules. But there are lot of ways to do so. 
In the case of YouTube, it allows you to save videos for offline streaming. But it doesn't allows to download the videos to local drive or memory. But there are lot of methods which let you to download videos or just extract the audio and save them to your local drive or memory. The simplest way you can do this is by removing three letters from the video URL. For example a YouTube video URL will look like this . Now remove the letters 'ube' from the word 'youtube' on the link and hit 'enter'. This will take you to a new website called ''. This site allows you to download the video or just the audio of the video as an…

Asus Zenfone Live Launched In India At Rs. 9,999

Asus has launched a new device in the ZenFone series called the ZenFone Live. The main feature of this smartphone is it comes with the worlds first real time beautification technology for live streaming videos. Company's new live beautification app called BeautyLive is used for this real time beautification. So this smartphone is mainly aimed at those who like shooting videos on social medias.
The device comes with a 5MP front camera with LED Flash, auto focus, 1.4 micrometer pixel size and 82 degree wide angle lens. It sports a 13MP rear camera with f/2.0 aperture lens and pixel master technology. 
The ZenFone Live comes with a 5-inch HD IPS display with 2.5D glass at a resolution of 1280×720 pixels. It also has a Bluelight filter for eye protection. The device is powered by a quad-core Qualcomm Snapdragon processor coupled with 2GB of RAM. It comes with 16GB of internal storage which can be expanded upto 128GB.
The connectivity options of this device include 4G VoLTE, WiFi 802.…

Xiaomi Redmi 4 :Second flash sale on Amazon is scheduled on 30th May at 12pm

The Chinese smartphone maker Xiaomi is continuing their success in Indian smartphone market with its latest device Redmi 4, successor to the Redmi 3S series. The device had its first flash sale today on Today Amazon witnessed record sale of Redmi 4. On its first flash sale 2,50,000 units of Redmi 4 has been sold within 8 minutes of the sale, Amazon India confirmed. 
Amazon has announced the date of second flash sale. The next sale is scheduled to be on 30th May 12PM. Amazon India is also providing a lot of launch offers to boost the sales. Offers include up to Rs. 5000 off on flights and hotel bookings on goibibo, 45GB free data for 5 months from Vodafone and Rs. 200 promotion credit for Kindle books on Kindle app. Also on the accessories the Mi cases for redmi 4 starts at Rs, 349 and Mi headphones will start at Rs 599.
Key features of the device are 5inch 720p HD displayFront 2.5D curved glass13MP rear camera with PDAF5MP front cameraSnapdragon 435 octa-core processor2GB/3G…

ZTE Nubia N1 Lite Launched In India At Rs. 6,999

ZTE sub-brand Nubia has launched an entry-level smartphone in India named Nubia N1 Lite. The N1 Lite was first unveiled at the MWC in February and it will be available from May 22 from the e commerce giant Amazon at a prize of 6,999.The device will be available in black color only.
The Nubia N1 Lite comes with a 5.5inch HD IPS display with 1280 x 720 pixels resolution. The device is powered by a 1.25GHz quad-core 64-bit MediaTek MT6737 processor coupled with 2GB of RAM. The phone also comes with 16GB of internal storage which can be expanded upto 32GB via a microSD card.
Camera on the Nubia device had been fantastic till now. Nubia Z11 mini is the best camera phone you can get under 20K in India. That shows how the Nubia cameras perform. Here the Nubia N1 Lite comes with an 8MP rear shooter with f/2.0 aperture and four element lens. It also has a LED flash. On the front the N1 Lite packs a 5MP camera with f/2.8 aperture, 84-degree wide angle lens and front flash. The smartphone also f…

Karbonn Aura Power 4G Plus with 4000mAh battery launched at Rs. 5,790

After the launch of Aura 4G smartphone last week Karbonn has now come up with an addition to its lineup called Aura Power 4G Plus. The main attraction of the new device is its battery. The Aura Power 4G Plus replaces the small 2150mAh battery in the Aura 4G by a large 4000mAh battery. This battery promises a stand by time of up to 400 hours and talk time of up to 16 hours.
The Karbonn Aura Power 4G Plus features 5-inch HD display with 720x1280 resolution. This dual SIM smartphone comes with 4G VoLTE support. The smartphone runs on the latest Android 7.0 Nougat and is powered by a 1.3GHz quad-core processor coupled with 1GB RAM. The device comes with an internal storage of 32GB which can be expanded upto 32GB using external microSD card. 
The smartphone features a 5-megapixel rear camera with dual-LED Flash and a 5-megapixel front-facing camera with LED flash. Connectivity options include Wi-Fi 802.11 b/g/n, Bluetooth 4.0, GPS and OTG support.
The Karbonn Aura Power 4G Plus is priced …

Vivo V5s with 20MP selfie camera is on for sale now at Rs 18,990

Vivo V5s, the successor to the V5 launched in November is on for sale in India at Rs. 18,990. This selfie smartphone was launched at an event in Gurugram earlier this month. Eventhough the phone was launched in two colors only the Matte Black variant of the device is available now. The Crown Gold colour variant will only become available starting May 20. The main attraction of this device is the 20MP front facing camera which makes the smartphone a selfie-centric one. 

The Vivo V5s has a 5.5inch IPS LCD display with a resolution of 1280x720 pixels. The display comes with a 2.5D Curved Glass, Gorilla Glass protection, and a pixel density of 267ppi. The phone is 7.6mm thick and features an all metal build. The device also features a fingerprint sensor on the home button. 

The device is powered by a 1.5GHz MediaTek MT6750 SoC coupled with 4GB of RAM. It comes with 32GB internal storage which is expandable upto 256GB using a microSD card. The dual SIM smartphone runs on Android 6.0 Marshmal…