Php: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
(→API) |
||
(8 intermediate revisions by the same user not shown) | |||
Line 8: | Line 8: | ||
echo $host; | echo $host; | ||
?> | ?> | ||
<?php | <?php | ||
echo $_SERVER['SERVER_NAME']; | echo $_SERVER['SERVER_NAME']; | ||
echo $_SERVER['REQUEST_URI']; | |||
echo $_SERVER['HTTP_HOST']; | |||
?> | ?> | ||
== Koneksi == | == Koneksi == | ||
Line 16: | Line 19: | ||
== API == | == API == | ||
web [[API]] | web [[API]] | ||
<h3>GET</h3> | |||
<?php | |||
include 'lib.php'; | |||
$sql = "SELECT propinsi, kabupaten_kota, kecamatan, npsn, sekolah, alamat_jalan FROM sekolah WHERE `propinsi` LIKE '%Jawa Timur%' AND `kabupaten_kota` LIKE '%sidoarjo> | |||
$result = mysqli_query($koneksipendidikan, $sql); | |||
$data = array(); | |||
while ($absen = mysqli_fetch_array($result)) { | |||
$data[] = array( | |||
'propinsi' => $absen['propinsi'], | |||
'kabupaten_kota' => $absen['kabupaten_kota'], | |||
'kecamatan' => $absen['kecamatan'], | |||
'npsn' => $absen['npsn'], | |||
'sekolah' => $absen['sekolah'], | |||
'alamat_jalan' => $absen['alamat_jalan'] | |||
); | |||
} | |||
$json_data = json_encode($data); | |||
echo $json_data; | |||
?> | |||
<h3>POST</h3> | |||
<h3>UPDATE</h3> | |||
<h3>DELETE</h3> |
Latest revision as of 13:28, 11 May 2024
PHP
- Contoh menampilkan ip address server
<?php $command = 'ip addr show eth0 | grep -oP "inet \K[\d.]*"'; $ipaddr = shell_exec($command); $host = trim($ipaddr); echo $host; ?>
<?php echo $_SERVER['SERVER_NAME']; echo $_SERVER['REQUEST_URI']; echo $_SERVER['HTTP_HOST']; ?>
Koneksi
Database
API
web API
GET
<?php include 'lib.php'; $sql = "SELECT propinsi, kabupaten_kota, kecamatan, npsn, sekolah, alamat_jalan FROM sekolah WHERE `propinsi` LIKE '%Jawa Timur%' AND `kabupaten_kota` LIKE '%sidoarjo> $result = mysqli_query($koneksipendidikan, $sql); $data = array(); while ($absen = mysqli_fetch_array($result)) { $data[] = array( 'propinsi' => $absen['propinsi'], 'kabupaten_kota' => $absen['kabupaten_kota'], 'kecamatan' => $absen['kecamatan'], 'npsn' => $absen['npsn'], 'sekolah' => $absen['sekolah'], 'alamat_jalan' => $absen['alamat_jalan'] ); } $json_data = json_encode($data); echo $json_data; ?>