Buat lah web "Hello World"
Buat Phonebook dengan model dan view dengan konten nama, alamat, no.hp, email, dan kelas
- Buat terlebih dahulu database untuk ditampilkan di dalam Phone Book. Lalu buat tabel dengan atribut nama, alamat, no.hp, email, dan kelas.(Gambar di paling bawah)
- Buka /xampp/htdocs/CodeIgniter-3.0.6/application/config/database.php lalu ganti dibagian paling bawah dengan root, password, dan nama databse yg telah kita buat
<?php defined('BASEPATH') OR exit('No direct script access allowed'); /* | ------------------------------------------------------------------- | DATABASE CONNECTIVITY SETTINGS | ------------------------------------------------------------------- | This file will contain the settings needed to access your database. | | For complete instructions please consult the 'Database Connection' | page of the User Guide. | | ------------------------------------------------------------------- | EXPLANATION OF VARIABLES | ------------------------------------------------------------------- | | ['dsn'] The full DSN string describe a connection to the database. | ['hostname'] The hostname of your database server. | ['username'] The username used to connect to the database | ['password'] The password used to connect to the database | ['database'] The name of the database you want to connect to | ['dbdriver'] The database driver. e.g.: mysqli. | Currently supported: | cubrid, ibase, mssql, mysql, mysqli, oci8, | odbc, pdo, postgre, sqlite, sqlite3, sqlsrv | ['dbprefix'] You can add an optional prefix, which will be added | to the table name when using the Query Builder class | ['pconnect'] TRUE/FALSE - Whether to use a persistent connection | ['db_debug'] TRUE/FALSE - Whether database errors should be displayed. | ['cache_on'] TRUE/FALSE - Enables/disables query caching | ['cachedir'] The path to the folder where cache files should be stored | ['char_set'] The character set used in communicating with the database | ['dbcollat'] The character collation used in communicating with the database | NOTE: For MySQL and MySQLi databases, this setting is only used | as a backup if your server is running PHP < 5.2.3 or MySQL < 5.0.7 | (and in table creation queries made with DB Forge). | There is an incompatibility in PHP with mysql_real_escape_string() which | can make your site vulnerable to SQL injection if you are using a | multi-byte character set and are running versions lower than these. | Sites using Latin-1 or UTF-8 database character set and collation are unaffected. | ['swap_pre'] A default table prefix that should be swapped with the dbprefix | ['encrypt'] Whether or not to use an encrypted connection. | | 'mysql' (deprecated), 'sqlsrv' and 'pdo/sqlsrv' drivers accept TRUE/FALSE | 'mysqli' and 'pdo/mysql' drivers accept an array with the following options: | | 'ssl_key' - Path to the private key file | 'ssl_cert' - Path to the public key certificate file | 'ssl_ca' - Path to the certificate authority file | 'ssl_capath' - Path to a directory containing trusted CA certificats in PEM format | 'ssl_cipher' - List of *allowed* ciphers to be used for the encryption, separated by colons (':') | 'ssl_verify' - TRUE/FALSE; Whether verify the server certificate or not ('mysqli' only) | | ['compress'] Whether or not to use client compression (MySQL only) | ['stricton'] TRUE/FALSE - forces 'Strict Mode' connections | - good for ensuring strict SQL while developing | ['ssl_options'] Used to set various SSL options that can be used when making SSL connections. | ['failover'] array - A array with 0 or more data for connections if the main should fail. | ['save_queries'] TRUE/FALSE - Whether to "save" all executed queries. | NOTE: Disabling this will also effectively disable both | $this->db->last_query() and profiling of DB queries. | When you run a query, with this setting set to TRUE (default), | CodeIgniter will store the SQL statement for debugging purposes. | However, this may cause high memory usage, especially if you run | a lot of SQL queries ... disable this to avoid that problem. | | The $active_group variable lets you choose which connection group to | make active. By default there is only one group (the 'default' group). | | The $query_builder variables lets you determine whether or not to load | the query builder class. */ $active_group = 'default'; $query_builder = TRUE; $db['default'] = array( 'dsn' => '', 'hostname' => 'localhost', 'username' => 'root', 'password' => '', 'database' => 'tugas_ci', 'dbdriver' => 'mysqli', 'dbprefix' => '', 'pconnect' => FALSE, 'db_debug' => (ENVIRONMENT !== 'production'), 'cache_on' => FALSE, 'cachedir' => '', 'char_set' => 'utf8', 'dbcollat' => 'utf8_general_ci', 'swap_pre' => '', 'encrypt' => FALSE, 'compress' => FALSE, 'stricton' => FALSE, 'failover' => array(), 'save_queries' => TRUE ); - Setelah itu, buat file controller di dalam folder /xampp/htdocs/CodeIgniter-3.0.6/application/controller lalu beri nama misal tes.php. Isi tes.php dengan:
<?php defined('BASEPATH') OR exit('No direct script access allowed'); class tes extends CI_Controller { /** * Index Page for this controller. * * Maps to the following URL * http://example.com/index.php/welcome * - or - * http://example.com/index.php/welcome/index * - or - * Since this controller is set as the default controller in * config/routes.php, it's displayed at http://example.com/ * * So any other public methods not prefixed with an underscore will * map to /index.php/welcome/<method_name> * @see https://codeigniter.com/user_guide/general/urls.html */ function __construct(){ parent::__construct(); $this->load->helper(array('url','form')); $this->load->model('table_model'); } function ndelok() { $data['pb'] = $this->table_model->index(); $this->load->view('tesview', $data); } } ?> - Untuk mengambil database yang telah kita buat, kita akan membutuhkan file model pada folder /xampp/htdocs/CodeIgniter-3.0.6/application/models. Lalu buatlah file php misal table_model.php dengan isi
<?php /** * */ class table_model extends CI_Model{ function __construct() { parent::__construct(); $this->load->database(); } function index(){ $ndelok = $this->db->get('mhs'); return $ndelok->result(); } } ?> - Lalu untuk menampilkan tabel beserta data yang ada di database, kita harus membuat file view pada folder /xampp/htdocs/CodeIgniter-3.0.6/application/view. Kemudian buat file php misal tesview.php
<!DOCTYPE html> <html> <head> <title>Tugas CI</title> </head> <h1>Hello World</h1> <h2>Phone Book</h2> <body> <table border="1" style="width:100%"> <tr> <td>Nama</td> <td>Alamat</td> <td>No.HP</td> <td>Email</td> <td>Kelas</td> </tr> <?php foreach ($pb as $ndelok){ ?> <tr> <td><?php echo $ndelok->Nama; ?></td> <td><?php echo $ndelok->Alamat; ?></td> <td><?php echo $ndelok->No_HP; ?></td> <td><?php echo $ndelok->Email; ?></td> <td><?php echo $ndelok->Kelas; ?></td> </tr> <?php } ?> </table> </table> </body> </html> - Save semua file lalu masukkan pada browser localhost/CodeIgniter-3.0.6/index.php/tes/ndelok
(Gambar untuk No.1)
