Skip to main content

Posts

Showing posts with the label php

Membuat GetToken

Buatlah file live.php pada server. Bisa di localhost:8082 maupun di htdocs. <?php require_once('../lib/nusoap.php');   $ns = "http://localhost/ws/live.php"; //$ns = "http://localhost:8082/ws/live.php"; $server = new soap_server; $server->configureWSDL('WSPDDIKTI', $ns); $server->wsdl->schemaTargetNamespace = $ns; if(!isset($HTTP_RAW_POST_DATA)){     $HTTP_RAW_POST_DATA = file_get_contents("php://input"); } //function_search_data function GetToken ($username,$password){     $conn     = mysqli_connect("localhost","root","","users");     $query    = $conn->query("SELECT token FROM user_token WHERE username ='$username' AND password = '$password'");         while($row = mysqli_fetch_assoc($query))         {     return json_encode($row);     } } //registrasi fungsi ke server $server->register(" GetToken "...
Post a Comment
Read more

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"),                                 ...
Post a Comment
Read more

Kode Import DBF to POSTGRE

<!DOCTYPE html> <html> <head>   <title>Progress Bar</title> </head> <body> <!-- Progress bar holder --> <link rel="stylesheet" href="progress/bootstrap.min.css"> <div id="progress" class="progress-bar progress-bar-striped active" style="width:500px;border:1px solid #000;"></div> <!-- Progress information --> <div id="information" style="width"></div> </br> <?php @include "config-postgre.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...
Post a Comment
Read more

Import dari XLS ke PHP

Download excel_reader2.php <?php ini_set("display_errors",0); require_once 'excel_reader2.php'; define('DB_SERVER', 'localhost'); define('DB_USERNAME', 'root'); define('DB_PASSWORD', ''); define('DB_DATABASE', 'simpeg'); $connection = mysqli_connect(DB_SERVER,DB_USERNAME,DB_PASSWORD,DB_DATABASE); $data = new Spreadsheet_Excel_Reader("sks20161.XLS"); echo "Total Sheets in this xls file: ".count($data->sheets)."<br /><br />"; $html="<table border='0'>"; for($i=0;$i<count($data->sheets);$i++) // Loop to get all sheets in a file. { if(count($data->sheets[$i][cells])>0) // checking sheet not empty { echo "Sheet $i:<br /><br />Total rows in sheet $i  ".count($data->sheets[$i][cells])."<br />"; for($j=1;$j<=count($data->sheets[$i][cells]);$j++) // loop ...
Post a Comment
Read more