[ASK] CodeIgniter + Stored Procedure SQL Azure

Beranda

...

Programmer Forum
[ASK] CodeIgniter + Stored Procedure SQL Azure

publishfare

16-11-2016 04:10

[ASK] CodeIgniter + Stored Procedure SQL Azure

Hai gan, mau tanya, ane lg bikin code php sbb :
- framework codeigniter
- web server running di localhost
- stored procedure disimpen di SQL azure
- koneksi db udah ok, udah di tes pake coding plain php udah bisa konek n execute query
- nah pas mau panggil store procedure yg disimpen di sql azure, hasilnya selalu null

Spoiler for code:

$sqlcmd = "exec dbo.lp_sp_login @LoginName='".$user."',@Password='".$password."',@NMCID=99";
$query = $this->db->query($sqlcmd);
var_dump($query);

Spoiler for output:

object(CI_DB_sqlsrv_result)#17 (9) { ["scrollable"]=> string(8) "buffered" ["conn_id"]=> resource(5) of type (SQL Server Connection) ["result_id"]=> resource(8) of type (SQL Server Statement) ["result_array"]=> array(0) { } ["result_object"]=> array(0) { } ["custom_result_object"]=> array(0) { } ["current_row"]=> int(0) ["num_rows"]=> NULL ["row_data"]=> NULL }

Salahnya dimana ya gan? Thanks before

nona212 memberi reputasi

2.5K

Kutip

Balasan

Komentar yang asik ya

Mari bergabung, dapatkan informasi dan teman baru!

Programmer Forum

20.2KThread•4.4KAnggota

Urutkan

Terlama

Komentar yang asik ya