Last active
March 10, 2019 10:20
-
-
Save whaone79/e19c945f03b0f62ba54f to your computer and use it in GitHub Desktop.
Mengakses SQL Server 2008R2 dari PHP menggunakan CodeIgniter, silahkan lihat di http://w4w417.wordpress.com/2016/01/09/mengakses-sql-server-2008r2-dari-php-menggunakan-codeigniter/
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
// Bagian yang perlu disesuaikan dengan konfigurasi SQL Server | |
$active_group = 'default'; | |
$query_builder = TRUE; | |
$db['default'] = array( | |
'dsn' => '', | |
'hostname' => '192.168.0.5\SQL2008R2', //hostname dan instance name dari SQL Server kita | |
'username' => 'sqluser', | |
'password' => '12345', | |
'database' => 'RETAIL', //nama database yang akan kita akses | |
'dbdriver' => 'sqlsrv', //nama driver yang kita pergunakan (sqlsrv untuk SQL Server 2008R2) | |
'dbprefix' => '', | |
'pconnect' => FALSE, | |
'db_debug' => FALSE, | |
'cache_on' => FALSE, | |
'cachedir' => '', | |
'char_set' => 'utf8', | |
'dbcollat' => 'utf8_general_ci', | |
'swap_pre' => '', | |
'encrypt' => FALSE, | |
'compress' => FALSE, | |
'stricton' => FALSE, | |
'failover' => array(), | |
'save_queries' => TRUE | |
); | |
?> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
defined('BASEPATH') OR exit('No direct script access allowed'); | |
class Home extends CI_Controller { | |
public function index() | |
{ | |
$this->db = $this->load->database('default', TRUE); | |
$sql = "select ITM_CD,ITM_NAME,PRICE from dbo.RETAIL_ITEM "; | |
$query = $this->db->query($sql); | |
if($query){ | |
if ($query->num_rows() > 0) | |
{ | |
foreach ($query->result_array() as $row) | |
{ | |
$items[] = $row; | |
} | |
$data['itemslist'] = $items; | |
} | |
} | |
$this->load->view('page',$data); | |
} | |
} | |
?> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<center>Daftar Item-item :</center> | |
<br> | |
<table width="800" align="center" cellpadding="2" cellspacing="1" border="1"> | |
<tr bgcolor="#DBDBDB"> | |
<td align="center">ITEM CODE</td> | |
<td align="center">ITEM NAME</td> | |
<td align="center">PRICE</td> | |
</tr> | |
<?php | |
foreach($itemslist as $line=>$item){ | |
?> | |
<tr> | |
<td style="padding-left:5px;"><?php echo $item['ITM_CD']; ?></td> | |
<td style="padding-left:5px;"><?php echo $item['ITM_NAME']; ?></td> | |
<td align="right" style="padding-right:5px;"><?php echo $item['PRICE']; ?></td> | |
</tr> | |
<?php | |
} | |
?> | |
</table> | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment