Skip to content

Instantly share code, notes, and snippets.

View whaone79's full-sized avatar

whaone79

View GitHub Profile
@whaone79
whaone79 / testsql.php
Created January 18, 2016 02:11
Mengakses SQL Server 2008R2 dari PHP, silahkan lihat di : http://w4w417.wordpress.com/2016/01/08/mengakses-sql-server-2008r2-dari-php/
<?php
echo "Mengakses SQL Server : ";
$serverName = "192.168.0.5\sql2008r2";
$connectionOptions = array('Database'=>'RETAIL', 'UID'=>'sqluser', 'PWD'=>'12345');
$conn = sqlsrv_connect( $serverName, $connectionOptions);
if( $conn === false )
{
@whaone79
whaone79 / Home.php
Last active March 10, 2019 10:20
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/
<?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 ";
@whaone79
whaone79 / database.php
Last active January 18, 2016 02:04
Mengkoneksikan PHP ke Microsoft SQL Server di Linux menggunakan FreeTDS, silahkan lihat di : http://w4w417.wordpress.com/2016/01/14/mengkoneksikan-php-ke-microsoft-sql-server-di-linux-menggunakan-freetds/
<?php
$db['default']['hostname'] = "sqlserver";
$db['default']['username'] = "sa";
$db['default']['password'] = "Server123";
$db['default']['database'] = "Asset_Mgr";
$db['default']['dbdriver'] = "mssql";
$db['default']['dbprefix'] = "";
$db['default']['pconnect'] = TRUE;
$db['default']['db_debug'] = FALSE;