[ASK] CodeIgniter + Stored Procedure SQL Azure

Beranda
Komunitas
Tech
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

Urutan

Terbaru

Terlama

Komentar yang asik ya

Komunitas Pilihan