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

name

username

department

phone


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
 
phpMyAdmin_1

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 »