tag:blogger.com,1999:blog-2140783511966573973.post8760520692685326692..comments2023-05-13T21:51:00.982+07:00Comments on Mari Belajar...!!!: Konfigurasi Codeigniter 2.1.0 dengan SQL Server 2008Mari Belajarhttp://www.blogger.com/profile/06328739015959696311noreply@blogger.comBlogger66125tag:blogger.com,1999:blog-2140783511966573973.post-51778458977965486742017-12-13T10:38:42.953+07:002017-12-13T10:38:42.953+07:00A PHP Error was encountered
Severity: Warning
Me...A PHP Error was encountered<br /><br />Severity: Warning<br /><br />Message: require_once(C:/xampp/htdocs/dasar/system/database/drivers/sqlsvr/sqlsvr_driver.php): failed to open stream: No such file or directory<br /><br />Filename: database/DB.php<br /><br />Line Number: 140<br /><br /><br />Fatal error: require_once(): Failed opening required 'C:/xampp/htdocs/dasar/system/database/drivers/sqlsvr/sqlsvr_driver.php' (include_path='C:\xampp\php\PEAR') in C:\xampp\htdocs\dasar\system\database\DB.php on line 140Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2140783511966573973.post-1834539323533479472017-07-01T15:35:10.411+07:002017-07-01T15:35:10.411+07:00terima kasih gan sudah menjawab pertanyaan saya , ...terima kasih gan sudah menjawab pertanyaan saya , saya coba dulu :) Lejarsetiohttps://www.blogger.com/profile/00724248670929945791noreply@blogger.comtag:blogger.com,1999:blog-2140783511966573973.post-87977467379712961382017-06-22T09:29:04.078+07:002017-06-22T09:29:04.078+07:00error nya kayak gimana, untuk join + ada parameter...error nya kayak gimana, untuk join + ada parameter nya pake kayak gini aja<br /><br />function getData($id = null) {<br /> if($id == null){<br /> $result = $this->db->query("SELECT barang.*, satuan.nama_satuan <br /> FROM barang<br /> INNER JOIN satuan ON satuan.id_satuan = barang.id_satuan<br /> ORDER BY barang.nama_barang ASC");<br /> } else {<br /> $result = $this->db->query("SELECT barang.*, satuan.nama_satuan <br /> FROM barang<br /> INNER JOIN satuan ON satuan.id_satuan = barang.id_satuan<br /> WHERE barang.id_barang = ?", array($id)); // parameter $id di escape, biar aman dari SQL Injection<br /> }<br /> <br /> // kemungkinan error kalo ternyata g ada datanya, jd d cek dulu<br /> return ($result->num_rows() > 0)? $result->result_array() : null;<br />}Mari Belajarhttps://www.blogger.com/profile/06328739015959696311noreply@blogger.comtag:blogger.com,1999:blog-2140783511966573973.post-84652764931110585282017-06-21T10:18:16.878+07:002017-06-21T10:18:16.878+07:00iya udah bisa gan sudah pake script
function Geta...iya udah bisa gan sudah pake script <br />function Getall($id = null){<br /> $data = $this->db->select('*')->from('barang');<br /> //$data = $this->db->get->result_array();<br /><br /> $data = $this->db->get()->result_array();<br /><br /> return $data;<br /> //var_export($data);die();<br /> }<br />itu cuman bisa get satu table , seandanya saya mau join querynya seperti apa ya gan , soalnya pake script seperti di bawah error gan <br /><br />function getData($id = null) {<br /> if($id == null){<br /> $query = "SELECT barang.*, satuan.nama_satuan FROM barang <br /> INNER JOIN satuan ON satuan.id_satuan = barang.id_satuan<br /> ORDER BY nama_barang ASC";<br /> } else {<br /> $query = "SELECT barang.*, satuan.nama_satuan FROM barang <br /> INNER JOIN satuan ON satuan.id_satuan = barang.id_satuan<br /> WHERE barang.id_barang = '{$id}'";<br /> }<br /> $result = $this->db->query($query);<br /><br /> $data = $result->result_array(); <br /><br /> return $data;<br />Lejarsetiohttps://www.blogger.com/profile/00724248670929945791noreply@blogger.comtag:blogger.com,1999:blog-2140783511966573973.post-90519106711531597062017-06-21T09:00:54.760+07:002017-06-21T09:00:54.760+07:00itu masih ada kesalahan di model untuk query-nya. ...itu masih ada kesalahan di model untuk query-nya. silahkan d cekMari Belajarhttps://www.blogger.com/profile/06328739015959696311noreply@blogger.comtag:blogger.com,1999:blog-2140783511966573973.post-91378472131780899552017-06-20T15:58:07.498+07:002017-06-20T15:58:07.498+07:00Gan mau nanya kalau error spt di bawah ini kenpa y...Gan mau nanya kalau error spt di bawah ini kenpa ya , pake php 5.6 terima kasih <br /><br />A Database Error Occurred<br /><br />Error Number: 42000<br /><br />[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Must specify table to select from.<br /><br />SELECT *<br /><br />Filename: C:\xampp\htdocs\rumahku\system\database\DB_driver.php<br /><br />Line Number: 331<br />Lejarsetiohttps://www.blogger.com/profile/00724248670929945791noreply@blogger.comtag:blogger.com,1999:blog-2140783511966573973.post-63216331206827086992017-05-22T13:17:58.167+07:002017-05-22T13:17:58.167+07:00kalau bleh tau ini kenapa yah min??
Error Number:...kalau bleh tau ini kenapa yah min??<br /><br />Error Number: 1054<br /><br />Unknown column '1' in 'where clause'<br /><br />SELECT * FROM (`barang`) WHERE `kode` = 'A01' AND `1` IS NULL<br /><br />Filename: C:\xampp\htdocs\toko-online2\system\database\DB_driver.php<br /><br />Line Number: 331<br /><br />thankszezehttps://www.blogger.com/profile/03188835858050343791noreply@blogger.comtag:blogger.com,1999:blog-2140783511966573973.post-61125630175102352742017-04-28T02:26:47.179+07:002017-04-28T02:26:47.179+07:00gan mau tanya saya menggunakan xampp 1.7.0, cara s...gan mau tanya saya menggunakan xampp 1.7.0, cara seting ci gimana ya gan?Link no 7 erorrhttps://www.blogger.com/profile/11211662752475007737noreply@blogger.comtag:blogger.com,1999:blog-2140783511966573973.post-70296176856027870902017-03-16T09:08:34.670+07:002017-03-16T09:08:34.670+07:00sudah d restart apache/xampp nya?sudah d restart apache/xampp nya?Mari Belajarhttps://www.blogger.com/profile/06328739015959696311noreply@blogger.comtag:blogger.com,1999:blog-2140783511966573973.post-30746434669404499802017-03-16T09:07:30.933+07:002017-03-16T09:07:30.933+07:00kurang spasi gan pas where nya...
select * from ma...kurang spasi gan pas where nya...<br />select * from mahasiswa where nim = '123456'Mari Belajarhttps://www.blogger.com/profile/06328739015959696311noreply@blogger.comtag:blogger.com,1999:blog-2140783511966573973.post-31925338283279332582017-03-13T16:56:22.103+07:002017-03-13T16:56:22.103+07:00saya sudah konfigurasi database seperti yang mas k...saya sudah konfigurasi database seperti yang mas kasih, sudah copy file .dll ke xampp/php/ext, sudah install native client, tapi kenapa ya kok blank hasilnya ngga ada apa apa?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2140783511966573973.post-14748639507730086392017-03-12T13:27:12.973+07:002017-03-12T13:27:12.973+07:00Array
(
[0] => Array
(
...Array<br />(<br /> [0] => Array<br /> (<br /> [nim] => 1100929721<br /> [nama] => joko<br /> [alamat] => padan<br /><br /><br /> )<br /><br /> [1] => Array<br /> (<br /> [nim] => 11101006232<br /> [nama] => joko<br /> [alamat] => mbradur<br /> )<br /><br /> [2] => Array<br /> (<br /> [nim] => 123456<br /> [nama] => JOO<br /> [alamat] => anksjnfskdf<br /> )<br /><br />)<br /><br />pdhl, cm mau pgl 1 dataalfyanhttps://www.blogger.com/profile/09529722933670169189noreply@blogger.comtag:blogger.com,1999:blog-2140783511966573973.post-90241138204854253242017-03-12T13:24:46.207+07:002017-03-12T13:24:46.207+07:00A Database Error Occurred
Error Number: 1064
You...A Database Error Occurred<br /><br />Error Number: 1064<br /><br />You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '= '123456'' at line 1<br /><br />select * from mahasiswawhere nim = '123456'<br /><br />Filename: C:\xampp\htdocs\codeigniter\system\database\DB_driver.php<br /><br />Line Number: 331<br /><br />INI EROR Waktu mau edit data gan, gimana ya solusinya, semua langkah2 d atas sudah saya ikuti.alfyanhttps://www.blogger.com/profile/09529722933670169189noreply@blogger.comtag:blogger.com,1999:blog-2140783511966573973.post-69451064644055544062016-11-24T09:10:24.799+07:002016-11-24T09:10:24.799+07:00bisa, pakai alamat IP address dari komputer yg ter...bisa, pakai alamat IP address dari komputer yg terinstal sql server...Mari Belajarhttps://www.blogger.com/profile/06328739015959696311noreply@blogger.comtag:blogger.com,1999:blog-2140783511966573973.post-38077149880079753762016-11-23T14:20:47.267+07:002016-11-23T14:20:47.267+07:00mas mw tanya dong, klo akses sql server dari luar ...mas mw tanya dong, klo akses sql server dari luar bisa ga (maksudnya koneksi db dari server dengan nama domainnya) ?<br /><br />thanks,,, sutanethttps://www.blogger.com/profile/15775349401439439156noreply@blogger.comtag:blogger.com,1999:blog-2140783511966573973.post-61588140021454044332016-04-28T08:21:06.008+07:002016-04-28T08:21:06.008+07:00ya coba d buka config database di application/conf...ya coba d buka config database di application/config/database.php<br />cek apakah settinganya sudah benar apa belumMari Belajarhttps://www.blogger.com/profile/06328739015959696311noreply@blogger.comtag:blogger.com,1999:blog-2140783511966573973.post-15694041381302954362016-04-27T10:12:06.233+07:002016-04-27T10:12:06.233+07:00maaf kalo boleh tahu dibagian mananya yah gan
maaf kalo boleh tahu dibagian mananya yah gan<br />ibnuhttps://www.blogger.com/profile/13773981865875781133noreply@blogger.comtag:blogger.com,1999:blog-2140783511966573973.post-53130951457785308622016-04-27T10:11:22.500+07:002016-04-27T10:11:22.500+07:00oh dibagian mananya gan
klo blh tahuoh dibagian mananya gan<br />klo blh tahuibnuhttps://www.blogger.com/profile/13773981865875781133noreply@blogger.comtag:blogger.com,1999:blog-2140783511966573973.post-24367205504780293692016-03-21T08:46:23.707+07:002016-03-21T08:46:23.707+07:00servis mysql nya di jalankan dulu....servis mysql nya di jalankan dulu....Mari Belajarhttps://www.blogger.com/profile/06328739015959696311noreply@blogger.comtag:blogger.com,1999:blog-2140783511966573973.post-6961990917042053882016-03-18T12:07:00.162+07:002016-03-18T12:07:00.162+07:00mas bisa bantu ga,
sewaktu ke localhostnya, muncu...mas bisa bantu ga, <br />sewaktu ke localhostnya, muncul spt ini<br /><br />Fatal error: Call to undefined function mysql_connect() in C:\xampp\htdocs\belajar\config.php on line 19Anonymoushttps://www.blogger.com/profile/16640034944501633680noreply@blogger.comtag:blogger.com,1999:blog-2140783511966573973.post-4256060696785927502016-01-13T09:47:22.747+07:002016-01-13T09:47:22.747+07:00coba cek memory limit d php.ini nya...coba cek memory limit d php.ini nya...Mari Belajarhttps://www.blogger.com/profile/06328739015959696311noreply@blogger.comtag:blogger.com,1999:blog-2140783511966573973.post-65095889001335970212016-01-11T11:32:04.561+07:002016-01-11T11:32:04.561+07:00Bisa bantu error ini :
Fatal error: Allowed memor...Bisa bantu error ini :<br /><br />Fatal error: Allowed memory size of 1073741824 bytes exhausted (tried to allocate 513 bytes) in D:\xampp\htdocs\Test_SQL\system\database\drivers\sqlsrv\sqlsrv_driver.php on line 144<br /><br />kenapa ya ?<br /><br />terima kasihAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-2140783511966573973.post-51380793955249368932015-01-22T15:46:19.276+07:002015-01-22T15:46:19.276+07:00Ok... sama-sama Ok... sama-sama Mari Belajarhttps://www.blogger.com/profile/06328739015959696311noreply@blogger.comtag:blogger.com,1999:blog-2140783511966573973.post-47093952166667441092015-01-22T09:20:45.888+07:002015-01-22T09:20:45.888+07:00Sudah bisa mas, selain buat rule di firewall saya ...Sudah bisa mas, selain buat rule di firewall saya juga memberikan hakakses pada my sql agar dapat di akses oleh host komputer yang ada, dengan perintah GRANT ALL PRIVILEGES ON *.* TO ‘root’@’%’ IDENTIFIED BY ‘’ WITH GRANT OPTION; . akhirnya berhasil .. Terima Kasih atas sharing nyaKomarudinnoreply@blogger.comtag:blogger.com,1999:blog-2140783511966573973.post-80517316502378886372015-01-21T16:37:58.363+07:002015-01-21T16:37:58.363+07:00coba d cek apakah firewall os wind*ws sudah ada ru...coba d cek apakah firewall os wind*ws sudah ada rule untuk aplikasi apache pada port 8080, klo blum ada buat rule firewall dulu untuk aplikasi/program apache port 8080...Mari Belajarhttps://www.blogger.com/profile/06328739015959696311noreply@blogger.com