PHPEveryday.com PHP and Web Development Tutorial
What are you looking for?


Table of Content
Learn CodeIgniter Framework Tutorial

Learn CodeIgniter Basic
CI Framework
CI Installation
CI MVC
CI Parameter
CI GET
CI Database Config
CI Database
CI Show All Data
CI Show a Data
CI GET Data

Learn CodeIgniter Form
CI Skeleton
CI Structure
CI Layout
CI Menu
CI Text
CI Centralizing
CI CSS
CI HTML
CI Form Code
CI HTML Style
CI Table
CI Insert Data
CI Table Library
CI Table List
CI URL Helper
CI Single Data
CI Form Parameters
CI Updating Data
CI Deleting Data

CodeIgniter: Preparing Database


CodeIgniter Step By Step Tutorial: After set database configuration,we will learn about showing data from database in CodeIgniter. But, before that, we prepare a database for practice. This post create a database named "codeigniter" and a table named "hello". We use phpMyAdmin for easy.

  1. Open your phpmyadmin.
  2. Enter database name "codeigniter" in create new database field.
  3. Click Create button. Your database will be created.

    codeigniter database creating use phpmyadmin

  4. Create new table by entering name of new table at create new table field.
  5. Enter number of fields.
  6. Click Go button.
  7. Enter name of field, type, and length
  8. Choose auto increment and check primary key for primary key field.
  9. Click Save button.

    codeigniter - table creating use phpmyadmin

  10. Now, we insert data. Click Insert tab.
  11. Enter data.
  12. Click Go for saving.

    codeigniter database - insert data use phpmyadmin



Series this article:
CodeIgniter: Introduction to CodeIgniter Framework
CodeIgniter: Installation
CodeIgniter: Creating First Application at CodeIgniter
CodeIgniter: Creating and Sending Parameters Between Controller and View
CodeIgniter: Getting Parameters From GET
CodeIgniter: Setting Database Configuration
CodeIgniter: Preparing Database
CodeIgniter: Showing Simple All Data
CodeIgniter: Showing Simple One Data
CodeIgniter: Choosing a Data From GET


Tag: CodeIgniter, framework, database, phpmyadmin Category: PHP Framework Post : January 24th 2008 Read: 9,719 Bookmark and Share

blog comments powered by Disqus


Database Tutorial
  • Learn PHP MySQL
  • Learn PHP ADOdb
  • Learn PHP Data Object/PDO
  • Learn PHP XML
  • Learn PHP SimpleXML
Security Tutorial
  • Learn PHP Security
  • Learn HTTP Authentication
  • Learn PHPSecureSite
Framework Tutorial
  • Learn CodeIgniter
  • Learn Joomla
  • Learn Smarty
  • Learn Zend Framework
Template Tutorial
  • Learn Joomla Template
  • Learn WordPress Template
API Tutorial
  • Learn Facebook
JS Framework Tutorial
  • Learn MooTools
  • Learn JQuery
AJAX Tutorial
  • Learn AJAX in 10 Minutes
  • Learn AJAX Client Side
  • Learn AJAX PHP
  • Learn AJAX Remote Server
  • Learn AJAX Repetitive
  • Learn AJAX MySQL
  • Learn AJAX Grid
Web Services Tutorial
  • Learn Web Services NuSOAP
  • Learn Web Services WSDL
  • Learn Web Services WSDL Array
  • Learn Web Services .NET Grid
  • Learn Web Services WDDX
Package Post
  • Joomla Intro
  • Joomla Component
  • Joomla Module
  • Joomla MVC
  • Joomla MVC Backend
  • PostNuke Intro
  • Zend Framework Intro
  • Zend Framework Action
  • Zend Framework Database
  • Zend Framework Registry
  • Zend Framework Config
  • Zend Framework Login
  • Zend Framework Session
  • PHP Array Tips
  • PHP File Tips
  • PHP Email
  • PHP Ms Excel
  • PHP Pattern
  • PHP SMS
  • Flash Database
  • PHP Multitier
  • jQuery Introduction
  • jQuery Selectors
  • Portable Web Server
  • Web Mobile Intro
  • Drupal Installation
  • Drupal Configuration