Archive for August, 2012

How to import csv data into the database using php


To download code – Click Here

Step 1

Create a database db_test and add one table named test with the following fields





Read more »

Install phpMyAdmin in Ubuntu 12.04

phpMyAdmin allows you to manage MySQL Servers easily from any popular web browser. Instead of connecting to MySQL server from the command line or console every time you wish to make a change, use your web browser and connect to it, then make the change there. It will allow you edit, drop, modify database tables and data within your browser.

Most online hosts will make this available to you when managing websites or blogs online. It’s a very efficient and reliable tool to manage your WordPress blog database.

Step 1
To get started, press Ctrl + Alt + T on your keyboard to open the terminal. When it opens, run the commands below to install it.
sudo apt-get install phpMyAdmin

Step 2
Then choose the web server you want to associate with this tool. It will mostly be apache2

Read more »

How to update ubuntu software


Method 1: Ubuntu software update using command line
apt-get is the command-line tool for handling packages, updating package and installing patches under Ubuntu Linux. All you have to do is type the following two command to update all installed software to latest version.
Open terminal and type the following two commands:
$ sudo apt-get update
$ sudo apt-get upgrade

Read more »