Skip to main content

Webservice Webclient with Mysqli

1) Example Get Data
server.php

<?php
require_once "../lib/nusoap.php";
$server = new soap_server();
$server->configureWSDL("mi primer ws","urn:mundopccmb");

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

function dataMahasiswa($id){
    $conn = mysqli_connect("localhost","root","","ws");
    $vehiculos = $conn->query("SELECT nim,nama,alamat FROM mahasiswa ");
    $ArrVehiculos = [];
    while ($vehiculo = mysqli_fetch_array($vehiculos,MYSQLI_ASSOC)) {
        $ArrVehiculos[] = $vehiculo ;
    }
    return json_encode($ArrVehiculos);
}

$server->register("dataMahasiswa",array("id"=>"xsd:int"),
                                    array("return"=>"xsd:string"),
                                    "urn:mundopccmb",
                                    "urn:mundopccmb#dataMahasiswa",
                                    "rpc",
                                    "encoded",
                                    "Carga todos los vehĂ­culos"
                  );

$server->service($HTTP_RAW_POST_DATA);


client.php:

<?php

require_once "../lib/nusoap.php";

$client = new nusoap_client("http://localhost/051001/mysqli/server.php?wsdl");
$vehiculos = $client->call("dataMahasiswa",array("id"=>10));
$vehiculos = json_decode($vehiculos);

echo "<table>";
foreach ($vehiculos as $vehiculo) {
    echo     "<td>".$vehiculo->nim."</td>
             <td> ".$vehiculo->nama."</td>
             <td>".$vehiculo->alamat." "."</td>";
}
echo "</table>";


2) Example Input Data

server_input.php

<?php
require_once "../lib/nusoap.php";
$server = new soap_server();
$server->configureWSDL("mi primer ws","urn:mundopccmb");

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

function insertMahasiswa($nim,$nama,$alamat){
    $conn = mysqli_connect("localhost","root","","ws");
    $sql = "INSERT INTO `mahasiswa` (`nim`, `nama`, `alamat`) VALUES ('$nim', '$nama', '$alamat')";
/*     $vehiculos = $conn->query($sql); */
    $vehiculos=mysqli_query($conn, $sql);
        if($$vehiculos==true){
            return "Employee inserted";
        }else{
            return "data not inserted";
        }

}

$server->register("insertMahasiswa",
                                    array("nim"=>"xsd:string", "nama"=>"xsd:string", "alamat"=>"xsd:string"),
                                    array("return"=>"xsd:string"),
                                    "urn:mundopccmb",
                                    "urn:mundopccmb#insertMahasiswa",
                                    "rpc",
                                    "encoded",
                                    "Carga todos los vehĂ­culos"
                  );

$server->service($HTTP_RAW_POST_DATA);


client_input.php

<?php
require_once "../lib/nusoap.php";
$client = new nusoap_client("http://localhost/051001/mysqli/server_input.php?wsdl");
?>
<form method="POST">
Nomor Mahasiswa :<input name='nim' required />
Nama Mahasiswa  :<input name='nama' required />
Alamat Asal     :<input name='alamat' required />
<input type='submit' value='simpan'/>

<?php

if(isset($_POST['nim']) and isset ($_POST['nama']) and isset ($_POST['alamat']) ){
$nim = $_POST['nim'];
$nama =$_POST['nama'];
$alamat = $_POST['alamat'];
//bisa and isset     */
$vehiculos = $client->call("insertMahasiswa",array("nim"=>"$nim","nama"=>"$nama","alamat"=>"$alamat"));

}

?>

Comments

Popular posts from this blog

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() {      ...

Preview PDF di Modal Bootstrap dengan Ajax

//preview pdf in line function preview_surat_keputusan(no) { $('#form')[0].reset(); $('.form-group').removeClass('has-error'); $('.help-block').empty(); $.ajax({ url : "<?php echo site_url('surat_keputusan/ajax_preview/')?>/" + no, type: "GET", dataType: "JSON",     success: function(data)     {     //paramater yang akan ditampilkan di modal         $('[name="no"]').val(data.no);         $('[name="ns"]').val(data.ns);         $('[name="thts"]').val(data.thts);         $('[name="pdf"]').val("http://localhost/dosdm/document/sm/pdf/"+data.thts+"-SK-"+data.ns+".pdf");         var link_base =  "http://localhost/dosdm/document/sm/pdf/"+data.thts+"-SK-"+data.ns+".pdf" ;             $('#pdf_view').attr('src', link_base);      ...

Hack File .xlsb

For first you must create a backup copy of your Workbook!!! Then you have to rename the XLSB file with ZIP extension. Test.XLSB => Test.ZIP             Opening your ZIP file using a compression software (e.g. WinRar) I can see the content of the file, structured in folders Inside the folder xl you can find a binary file named vbaProject.bin. Extract it on your desktop and edit it using a text editor. In my case I used Notepad++. Using the Find function of your editor, you must search the text DPB And replace the DPB string with DPx Then save the vbaProject.bin and replace this file inside the .ZIP File, renaming then .ZIP file in XLSB. Reopening the XLSB file using Excel, you will get an error message: you have to answer Yes to this error message. Then  Save , Close and Reopen your XLSB file. Now, if you go to VBA Editor (ALT + F11), you ca...