Skip to main content

Webservice CRUD Mysqli

<?php
require_once "../lib/nusoap.php";
$server = new soap_server();
$server->configureWSDL("Mahasiswa UII","urn:akademik");

if(!isset($HTTP_RAW_POST_DATA)){
    $HTTP_RAW_POST_DATA = file_get_contents("php://input");
}

//function_view_all_data
function dataMahasiswa($data){
    $conn = mysqli_connect("localhost","root","","ws");
    $results = $conn->query("SELECT nim, nama, alamat FROM mahasiswa");
    $ArrayHasil = [];
    while ($result = mysqli_fetch_array($results,MYSQLI_ASSOC)) {
        $ArrayHasil[] = $result ;
    }
    return json_encode($ArrayHasil);
}

//function_search_data
function cariMahasiswa($id){
    $conn = mysqli_connect("localhost","root","","ws");
    $results = $conn->query("SELECT nim, nama, alamat FROM mahasiswa WHERE nim ='$id' ");
    $ArrayHasil = [];
    while ($result = mysqli_fetch_array($results,MYSQLI_ASSOC)) {
        $ArrayHasil[] = $result ;
    }
    return json_encode($ArrayHasil);
}

//function_input_data
function insertMahasiswa($nim,$nama,$alamat){
    $conn = mysqli_connect("localhost","root","","ws");
    $nim_input = $nim;
    $nama_input = $nama;
    $alamat_input = $alamat;   
   
    $sql = "REPLACE INTO `mahasiswa` (`nim`, `nama`, `alamat`) VALUES ('$nim', '$nama', '$alamat')";
   
        if($results=mysqli_query($conn, $sql)){
            return "Employee inserted";
        }else{
            return "data not inserted";
        }

}
//function_update_data
function updateMahasiswa($nim,$nama,$alamat){
    $conn = mysqli_connect("localhost","root","","ws");
    $nim_input = $nim;
    $nama_input = $nama;
    $alamat_input = $alamat;
   
    $sql = "UPDATE `mahasiswa` set `nama`='$nama', `alamat`='$alamat' WHERE `nim` = '$nim'";
            if($results=mysqli_query($conn, $sql)){
            return "Employee inserted";
        }else{
            return "data not inserted";
        }
}   
//registrasi fungsi ke server
$server->register("dataMahasiswa",
                                    array("nim"=>"xsd:string", "nama"=>"xsd:string", "alamat"=>"xsd:string"),
                                    array("return"=>"xsd:string"),
                                    "urn:akademik",
                                    "urn:akademik#insertMahasiswa",
                                    "rpc",
                                    "encoded",
                                    "Carga todos los vehículos"
                  );
$server->register("cariMahasiswa",array("id"=>"xsd:int"),
                                    array("return"=>"xsd:string"),
                                    "urn:akademik",
                                    "urn:akademik#cariMahasiswa",
                                    "rpc",
                                    "encoded",
                                    "Carga todos los vehículos"
                  );
$server->register("insertMahasiswa",
                                    array("nim"=>"xsd:string", "nama"=>"xsd:string", "alamat"=>"xsd:string"),
                                    array("return"=>"xsd:string"),
                                    "urn:akademik",
                                    "urn:akademik#insertMahasiswa",
                                    "rpc",
                                    "encoded",
                                    "Carga todos los vehículos"
                  );
$server->register("updateMahasiswa",
                                    array("nim"=>"xsd:string", "nama"=>"xsd:string", "alamat"=>"xsd:string"),
                                    array("return"=>"xsd:string"),
                                    "urn:akademik",
                                    "urn:akademik#updateMahasiswa",
                                    "rpc",
                                    "encoded",
                                    "Carga todos los vehículos"
                  );
                 
$server->service($HTTP_RAW_POST_DATA);
===

<?php
require_once "../lib/nusoap.php";
$client = new nusoap_client("http://localhost/051001/mysqli/ws.php?wsdl");
?>

<form id='form_cari' method="POST">
    Cari Nomor Mahasiswa :</br><input id='cari_nim' name='nim_cari' required />
                               <input type='submit' id='submit_cari' value='Cari'/>
</form>
</br>

<form id='form_input' method="POST">
<table>
    <tr><td>Nomor Mahasiswa :<td><input id='input_nim' name='nim' required /></tr>
    <tr><td>Nama Mahasiswa  :<td><input name='nama' required /></tr>
    <tr><td>Alamat Asal     :<td><input name='alamat' required /></tr>
    <tr>
    <td><input type='submit' value='Simpan'/></td>
    </tr>
</table>
</form>

<form id='form_data' method="POST">
    <input type='hidden' id='data' name='data' />
    <input type='submit' value='View Data'/>
</form>


<?php
//input
if(isset($_POST['nim']) and isset ($_POST['nama']) and isset ($_POST['alamat']) ){
    $conn     = mysqli_connect("localhost","root","","ws");
    $nim     = mysqli_real_escape_string($conn, $_POST['nim']);
    $nama     = mysqli_real_escape_string($conn, $_POST['nama']);
    $alamat = mysqli_real_escape_string($conn, $_POST['alamat']);

    //bisa and isset     */
    $mahasiswa_1 = $client->call("insertMahasiswa",array("nim"=>"$nim","nama"=>"$nama","alamat"=>"$alamat"));

    }
?>

<?php
//cari
if(isset($_POST['nim_cari'])) {
    $nim_cari = $_POST['nim_cari'];
    $mahasiswa_1 = $client->call("cariMahasiswa",array("id"=>"$nim_cari"));
    $mahasiswa_1 = json_decode($mahasiswa_1);

    foreach ($mahasiswa_1 as $mhs) {

     /* echo     "<td>".$mhs->nim."</td>
                 <td> ".$mhs->nama."</td>
                 <td>".$mhs->alamat." "."</td>";
        } */

    echo "<form id='form_edit' method='POST'>
    <table>
    <tr><td>Nomor Mahasiswa :<td><input value='".$mhs->nim."' name='update_nim'/></tr>
    <tr><td>Nama Mahasiswa  :<td><input value='".$mhs->nama."' name='update_nama'/></tr>
    <tr><td>Alamat Asal     :<td><input value='".$mhs->alamat."' name='update_alamat'/></tr>
    <tr>
    <td><input type='submit' value='Update'/></td>
    </tr>
    </table>
    </form>";
    }   


}
?>

<?php
//view_data
if(isset($_POST['data'])) {
    $data = $_POST['data'];   
    $mahasiswa_1 = $client->call("dataMahasiswa",array("data"=>"071002239"));
    $mahasiswa_1 = json_decode($mahasiswa_1);

        echo "<table border='1' width='100%'><tr><th>Nomor Induk Mahasiswa</th><th>Nama Mahasiswa</th><th>Alamat</th></tr>";
        foreach ($mahasiswa_1 as $mhs) {
            echo "<tr>";
            echo     "<td>".$mhs->nim."</td>
                     <td> ".$mhs->nama."</td>
                     <td>".$mhs->alamat." "."</td>";
            echo "</tr>";           
        }
        echo "</table>";

        }

//update
if(isset($_POST['update_nim']) and isset ($_POST['update_nama']) and isset ($_POST['update_alamat']) ){
    $conn     = mysqli_connect("localhost","root","","ws");
    $nim     = mysqli_real_escape_string($conn, $_POST['update_nim']);
    $nama     = mysqli_real_escape_string($conn, $_POST['update_nama']);
    $alamat = mysqli_real_escape_string($conn, $_POST['update_alamat']);

    //bisa and isset     */
    $mahasiswa_1 = $client->call("updateMahasiswa",array("nim"=>"$nim","nama"=>"$nama","alamat"=>"$alamat"));
    }
?>

Comments

Popular posts from this blog

Menggenerate nomor id

<?php //config $database = "dopo"; $tabel = "po"; $kolom_generate ="id"; $kolom_referensi = "id"; /* Database connection start */ $servername = "localhost"; $username = "root"; $password = ""; $dbname = $database; $mysqli = mysqli_connect($servername, $username, $password, $dbname) or die("Connection failed: " . mysqli_connect_error()); $q1 = "select * from $tabel order by $kolom_referensi DESC"; /* Database connection end */ echo '<table>'; // connect to the database // number of results to show per page $per_page = 10000; // figure out the total pages in the database if ($result = $mysqli->query($q1)) { if ($result->num_rows != 0) { $total_results = $result->num_rows; // ceil() returns the next highest integer value by rounding up value if necessary $total_pages = ceil($total_results / $per_page); // check if the 'page' variab...

CRUD dengan vue.js

pada tutorial kali ini kita akan belajar cara menampilkan data mengunakan  Vue JS  di framework  Codeigniter,  di dutorial sebelumnya kita sudah mempelajari cara Crud mengunakan Vue JS dan Codeigniter, kalian bisa lihat tutorialnya disini  CRUD CODEIGNITER DAN VUE JS  . kali ini kita akan mencoba menampilkan data yang ada pada database dengan framwork codeigniter dan vue js, untuk koneksi database di codeigniter adalah : <?php defined('BASEPATH') OR exit('No direct script access allowed'); $active_group = 'default'; $query_builder = TRUE; $db['default'] = array(     'dsn'    => '',     'hostname' => 'localhost',     'username' => 'root',     'password' => 'root',     'database' => 'civue',     'dbdriver' => 'mysqli',     'dbprefix' => '',     'pconnect' => FALSE,     ...