Jijo K Jose

Personal Website

Archive for August, 2012

August 29th, 2012

PHP, Programming

No Comments »

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

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

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

Last updated by Jijo K Jose at July 23, 2013.