Muncul Pesan Warning: odbc_exec(): supplied resource is not a valid saat Insert Data ke SQL Server
Saya sudah berhasil mengkoneksikan ke SQL Server,namun saat saya INSERT data muncul pesan Warning: odbc_exec(): supplied resource is not a valid ODBC-Link resource in C:\xampp\htdocs\phpCon\index.php on line 17.
Saya menggunakan XAMPP php versi 7.3.2 dan SQL Server 2012
Mohon bantuannya kak.
connect.php
index.php
Outputnya :
Saya menggunakan XAMPP php versi 7.3.2 dan SQL Server 2012
Mohon bantuannya kak.
connect.php
<?php $serverName = "DESKTOP-2P6S23P"; //serverName\instanceName // Since UID and PWD are not specified in the $connectionInfo array, // The connection will be attempted using Windows Authentication. $connectionInfo = array( "Database"=>"LatihanDB"); $conn = sqlsrv_connect( $serverName, $connectionInfo); if( $conn ) { echo "Connection established.<br />"; }else{ echo "Connection could not be established.<br />"; die( print_r( sqlsrv_errors(), true)); }
index.php
<?php include("connect.php"); function getData() { $data = array(); $data[1] = $_POST['nama']; $data[2] = $_POST['nim']; return $data; } if (isset($_POST['insert'])) { $info = getData(); $insert = "INSERT INTO [tbl_mahasiswa] ([id] ,[nama] ,[nim]) VALUES ('$info[1]','$info[2]')"; $result = odbc_exec($conn, $insert); } ?> <!DOCTYPE html> <html lang="en"> <head> <title>Example</title> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css"> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script> <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd/popper.min.js"></script> <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script> </head> <body> <div class="jumbotron text-center"> <h1>Coba</h1> <p>Lorem ipsum dolor sit amet consectetur adipisicing elit. Alias eius illum non.!</p> <form method="POST"> <div class="form-group"> <label for="nama">Nama:</label> <input type="text" class="form-control" id="nama" name="nama"> </div> <div class="form-group"> <label for="nim">NIM:</label> <input type="text" class="form-control" id="nim" name="nim"> </div> <button type="submit" class="btn btn-warning" style="color: #fff;" name="insert">Submit</button> </form> </div> </body> </html>
Outputnya :

19 Kontribusi 0 Poin
atau respon:
Jawaban
Belum ada Jawaban, jadi yang pertama
Login untuk gabung berdiskusiPertanyaan Lainnya
Top Kontributor
- @ahanafi
813 Kontribusi 551 Poin
- @Nandar
647 Kontribusi 204 Poin
- @dianarifr
642 Kontribusi 316 Poin
- @Saputroandhi
509 Kontribusi 162 Poin
- @dodipsitorus
412 Kontribusi 145 Poin