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

Layar Biru versi PHP Bagian 1 (file prefil_dbf.php)

file config.php <?php $db_uname = 'root'; $db_passwd = ''; $db_name = 'layar_biru'; //database yang dipilih $db_host = 'localhost'; $xbase_dir = 'D:\ACADEMIC\htdocs\layar_biru\files'; $die_on_mysql_error = false; // when investigating errors, set this to true $from_encoding=""; //Encoding of database, e.g. CP866 or empty, if convert is not required     file prefil.dbf   <?php include "config.php";            // please copy the config.sample.php and edit the correct fields include "classes/XBase/Table.php"; include "classes/XBase/Column.php"; include "classes/XBase/Record.php"; include "classes/DBFhandler.php"; use XBase\Table;  // Initializing vars ini_set( 'memory_limit', '2048M' ); set_time_limit( 0 ); $time_start = time(); $files = scandir($xbase_dir) or die ("Error! Could not open directory '$xbase_dir'."); $conn = new mysqli($db_host,...

FPDF dengan CodeIgniter

Cetak Surat Keputusan Controller: <?php //File in controller named surat_keputusan.php defined('BASEPATH') OR exit('No direct script access allowed'); class Cetak_surat_keputusan extends CI_Controller { public function __construct()     {         parent::__construct();         $this->load->helper('url');         $this->load->database();                $this->db->select();         $this->db->from('surat.config_sk');                $query = $this->db->get();                 return $query->result();             } public function index() {      ...

Instal font baru di FPDF.

1. buka url www.fpdf.org/makefont 2. pilih ttf yang akan dimasukkan. sebaiknya pindahkan file ttf dari c:/windows/font ke folder lain. karena C: adalah windows. 3. Upload dan generate. 4. Donwload nama font.php dan font.z copykan ke folder fpdf/font. <?php require( 'fpdf.php' ); $pdf = new FPDF (); $pdf -> AddFont ( 'Calligrapher' , '' , 'calligra.php' ); $pdf -> AddPage (); $pdf -> SetFont ( 'Calligrapher' , '' , 35 ); $pdf -> Write ( 10 , 'Enjoy new fonts with FPDF!' ); $pdf -> Output (); ?>