PHP

<?php
require 'vendor/autoload.php';
 
$sms = 'Contoh kirim OTP dengan NUSASMS';
$encodedSms = rawurlencode($sms);
$username = 'USERNAME_api';
$password = 'PASSWORD';
$phoneNumber = '08xxxxxxxxxx';
 
// kirim SMS
$client = new \GuzzleHttp\Client();
$url = "http://api.nusasms.com/api/v3/sendsms/plain?user=$username&password=$password&SMSText=$encodedSms&GSM=$phoneNumber&otp=Y";
$response = $client->request('GET', "$url");
$contents = $response->getBody()->getContents();
var_dump($contents);

$url = "http://api.nusasms.com/api/v3/sendsms/plain?user=$username&password=$password&SMSText=$encodedSms&GSM=$phoneNumber";

<?php
// index.php
require 'vendor/autoload.php';
 
// login MySQL
$DB_SERVER = "localhost";
$DB_USER = "USER";
$DB_PASSWORD = "PASSWORD";
$DB_NAME = "tutorial";
$mysqli = new mysqli("$DB_SERVER","$DB_USER","$DB_PASSWORD","$DB_NAME");
 
if ($mysqli->connect_errno) {
  echo "Errno: " . $mysqli->connect_errno . "\n";
  echo "Error: " . $mysqli->connect_error . "\n";
  exit;
}
 
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
 
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
 
// buat nama sheetnya
$sheet->setTitle('Sheet 1');
// nama kolom dibaris pertama
$sheet->setCellValue('A1', 'Provinsi');
$sheet->setCellValue('B1', 'Jumlah Penduduk');
$sheet->setCellValue('C1', 'Diupdate');
 
// timestamp
$tz = 'Asia/Jakarta';
$dt = new DateTime("now", new DateTimeZone($tz));
$timestamp = $dt->format('Y-m-d G:i:s');
 
$formatTanggal = \PhpOffice\PhpSpreadsheet\Shared\Date::PHPToExcel($timestamp);
$data = mysqli_query($mysqli,"select provinsi,jumlah from datapenduduk");
// mulai dari baris kedua
// baris pertama untuk nama kolom
$row = 2;
while($record = mysqli_fetch_array($data))
{
    $sheet->setCellValue('A'.$row, $record['provinsi']);
    $sheet->setCellValue('B'.$row, $record['jumlah']);
    $sheet->setCellValue('C'.$row, $formatTanggal);
    $row++;
}
 
// format tanggal di kolom C 
$spreadsheet->getActiveSheet()->getStyle('C')
    ->getNumberFormat()
    ->setFormatCode(
        \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_DATETIME
    );
 
$writer = new Xlsx($spreadsheet);
// set header agar file di download
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header("Content-Transfer-Encoding: Binary");
header('Content-disposition: attachment; filename="Jumlah Penduduk Indonesia.xlsx"');
header('Cache-Control: max-age=0');
$writer->save("php://output");
?>

header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header("Content-Transfer-Encoding: Binary");
header('Content-disposition: attachment; filename="Jumlah Penduduk Indonesia.xlsx"');
header('Cache-Control: max-age=0');
$writer->save("php://output");

$writer->download('jumlah penduduk indonesia.xlsx');

<?php
// subdomain yang diijinkan
$allowedSubdomain = ['email', 'ftp', 'payment'];
$subdomain = explode('.web.jaranguda.com', $_SERVER['HTTP_HOST']);
 
if(in_array($subdomain[0], $allowedSubdomain)) {
    echo "<b>$subdomain[0]</b> allowed!";
} else {
    echo "<b>$subdomain[0]</b> rejected! not in whitelist domain!";
}
 
var_dump($_SERVER['HTTP_HOST']);

<?php
 
require 'vendor/autoload.php';
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
 
// validasi
if(empty($_FILES['fileexcel']['tmp_name'])) {
    exit("Tidak ada file diupload");
}
 
$file = pathinfo($_FILES['fileexcel']['name']);
 
// ekstensi yang diijinkan
$allowedExtension = ['xlsx', 'xls'];
if(! in_array($file['extension'],$allowedExtension)) {
    exit("Galat! file extension yang diijinkan .xlsx .xls");
 
}
 
$DB_SERVER = "localhost";
$DB_USER = "USER";
$DB_PASSWORD = "PASSWORD";
$DB_NAME = "tutorial";
$mysqli = new mysqli("$DB_SERVER","$DB_USER","$DB_PASSWORD","$DB_NAME");
 
if ($mysqli->connect_errno) {
  echo "Errno: " . $mysqli->connect_errno . "\n";
  echo "Error: " . $mysqli->connect_error . "\n";
  exit;
}
 
$reader = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx();
$reader->setReadDataOnly(true);
// lokasi file excel dari file yang di upload
$spreadsheet = $reader->load($_FILES['fileexcel']['tmp_name']);
 
$worksheet = $spreadsheet->getActiveSheet();
$rows = $worksheet->toArray();
 
// hapus baris pertama
unset($rows[0]);
 
$tz = 'Asia/Jakarta';
$dt = new DateTime("now", new DateTimeZone($tz));
$timestamp = $dt->format('Y-m-d G:i:s');
 
$hitungSukses = 0;
$hitungGagal = 0;
 
foreach ($rows as $key => $value) {
    $query = "INSERT INTO contact VALUES (null, '$value[0]', '$value[1]', '$value[2]', '$value[3]', '$timestamp')";
    echo "$query" . "<br>";
    $result = $mysqli->query($query);
    if($result) {
        $hitungSukses++;
    } else {
        $hitungGagal++;
        var_dump(mysqli_error($mysqli));
    }
}
 
echo "<hr>";
echo "Sukses: " . $hitungSukses . "<br>";
echo "Gagal: " . $hitungGagal;

composer require phpoffice/phpspreadsheet

<?php
 
require 'vendor/autoload.php';
 
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
 
$DB_SERVER = "localhost";
$DB_USER = "USER";
$DB_PASSWORD = "PASSWORD";
$DB_NAME = "tutorial";
$mysqli = new mysqli("$DB_SERVER","$DB_USER","$DB_PASSWORD","$DB_NAME");
 
if ($mysqli->connect_errno) {
  echo "Errno: " . $mysqli->connect_errno . "\n";
  echo "Error: " . $mysqli->connect_error . "\n";
  exit;
}
 
$reader = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx();
$reader->setReadDataOnly(true);
// lokasi file excel
$spreadsheet = $reader->load("/home/tommy/Documents/belanja.xlsx");
 
$worksheet = $spreadsheet->getActiveSheet();
$rows = $worksheet->toArray();
 
// hapus baris pertama
unset($rows[0]);
 
$tz = 'Asia/Jakarta';
$dt = new DateTime("now", new DateTimeZone($tz));
$timestamp = $dt->format('Y-m-d G:i:s');
 
$hitungSukses = 0;
$hitungGagal = 0;
 
foreach ($rows as $key => $value) {
    // format tanggal
    $date = \PhpOffice\PhpSpreadsheet\Shared\Date::excelToDateTimeObject($value[5])->format('Y-m-d');
    $query = "INSERT INTO excel VALUES (null, '$value[0]', '$value[1]', '$value[2]', '$value[3]', '$value[4]', '$date', '$timestamp')";
    $result = $mysqli->query($query);
    if($result) {
        $hitungSukses++;
    } else {
        $hitungGagal++;
    }
}
 
echo "Sukses: " . $hitungSukses . "<br>";
echo "Gagal: " . $hitungGagal;

<?php
// parsing-xml.php
$xmlurl = file_get_contents("http://localhost:9900/kurs.xml");
$xml = simplexml_load_string($xmlurl, "SimpleXMLElement", LIBXML_NOCDATA);
var_dump($xml);

class SimpleXMLElement#1 (1) {
  public $rate =>
  array(12) {
    [0] =>
    class SimpleXMLElement#2 (3) {
      public $matauang =>
      string(3) "AUD"
      public $beli =>
      string(9) " 9,276.00"
      public $jual =>
      string(9) " 9,757.00"
    }
    [1] =>
    class SimpleXMLElement#3 (3) {
      public $matauang =>
      string(3) "GBP"
      public $beli =>
      string(9) "17,033.00"
      public $jual =>
      string(9) "17,581.00"
    }
    [2] =>
    class SimpleXMLElement#4 (3) {
      public $matauang =>
      string(3) "CAD"
      public $beli =>
      string(9) "10,343.00"
      public $jual =>
      string(9) "10,879.00"
    }
    [3] =>
    class SimpleXMLElement#5 (3) {
      public $matauang =>
      string(3) "CNY"
      public $beli =>
      string(8) "1,790.43"
      public $jual =>
      string(8) "2,148.52"
    }
    [4] =>
    class SimpleXMLElement#6 (3) {
      public $matauang =>
      string(3) "EUR"
      public $beli =>
      string(9) "15.420.00"
      public $jual =>
      string(9) "16,068.00"
    }
    [5] =>
    class SimpleXMLElement#7 (3) {
      public $matauang =>
      string(3) "HKD"
      public $beli =>
      string(8) "1,663.62"
      public $jual =>
      string(8) "1,839.98"
    }
    [6] =>
    class SimpleXMLElement#8 (3) {
      public $matauang =>
      string(3) "JPY"
      public $beli =>
      string(6) "130.76"
      public $jual =>
      string(6) "137.89"
    }
    [7] =>
    class SimpleXMLElement#9 (3) {
      public $matauang =>
      string(3) "NZD"
      public $beli =>
      string(8) "8,699.00"
      public $jual =>
      string(8) "9,183.00"
    }
    [8] =>
    class SimpleXMLElement#10 (3) {
      public $matauang =>
      string(3) "SGD"
      public $beli =>
      string(9) " 9,966.00"
      public $jual =>
      string(9) "10,429.00"
    }
    [9] =>
    class SimpleXMLElement#11 (3) {
      public $matauang =>
      string(3) "SEK"
      public $beli =>
      string(8) "1,439.00"
      public $jual =>
      string(8) "1,497.00"
    }
    [10] =>
    class SimpleXMLElement#12 (3) {
      public $matauang =>
      string(3) "CHF"
      public $beli =>
      string(9) "14,149.00"
      public $jual =>
      string(9) "14,709.00"
    }
    [11] =>
    class SimpleXMLElement#13 (3) {
      public $matauang =>
      string(3) "USD"
      public $beli =>
      string(9) "13,982.00"
      public $jual =>
      string(9) "14,474.00"
    }
  }
}

<?php
 
$xmlurl = file_get_contents("http://localhost:9900/kurs.xml");
$xml = simplexml_load_string($xmlurl, "SimpleXMLElement", LIBXML_NOCDATA);
$kursBeli = [];
$kursJual = [];
foreach ($xml->rate as $data) {
    $kursBeli[] = $data->beli;
    $kursJual[] = $data->jual;
}
 
echo $kursBeli[0];
// 9,276.00

<?php
// parsing-xml.php
$xmlurl = file_get_contents("http://localhost:9900/kurs.xml");
$xml = simplexml_load_string($xmlurl, "SimpleXMLElement", LIBXML_NOCDATA);
$json = json_encode($xml);
$array = json_decode($json, TRUE);
var_dump($array);