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

Token_Model

<?php defined('BASEPATH') OR exit('No direct script access allowed'); class Token_model extends CI_Model { public function __construct() { parent::__construct(); $this->load->library('session'); $this->load->helper('url'); } public function token_feeder() { $username = '*****'; $password = '*****'; $data_sesi=array( 'username'=>$username, 'password'=>$password, 'sudah_login'=>true, ); $this->session->set_userdata($data_sesi); $username=$this->session->userdata('username'); $password=$this->session->userdata('password'); $mytoken = array('act'=>'GetToken', 'username'=>$username, 'password'=>$password); $payload = json_encode($mytoken); $ch = curl_init('http://192.168.30.99:8082/ws/live2.php'); curl_setopt($ch, CURLOPT_RETURNTRANS...

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,...