GeezerVison is showing github.com — php/db.php at main · linuxrun1/php

Expand file tree

db.php

Copy path

More file actions

Latest commit

History

53 lines (48 loc) · 1.65 KB

db.php

Copy path

File metadata and controls

53 lines (48 loc) · 1.65 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

<?php

date_default_timezone_set("Asia/Jakarta");

error_reporting(-1);

ini_set('display_errors', 1);

//MySQL Connection Database

$conn = mysqli_connect($_SERVER['MYSQLHOST'].':'.$_SERVER['MYSQLPORT'],$_SERVER['MYSQLUSER'],$_SERVER['MYSQLPASSWORD'],$_SERVER['MYSQLDATABASE']) or die(mysqli_error());

$site = "https://url.vhost.my.id";

//Text Random

function loh($n) {

$characters = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';

$randomString = '';

for ($i = 0; $i < $n; $i++) {

$index = rand(0, strlen($characters) - 1);

$randomString .= $characters[$index];

}

return $randomString;

}

//Script Rest Api Url Shortener Database

if (@$_GET['key'] === 'fw'){

$a = loh(10);

$longUrl = @$_POST['longUrl'];

$shortUrl = $site.'/'.$a;

if(!empty($longUrl)){

$sql = "INSERT INTO url (longUrl, shortUrl, code, view) VALUES('".$longUrl."','".$shortUrl."','".$a."','0')";

$simpan = mysqli_query($conn, $sql);

if($simpan){

$arr = array(

'longUrl' => $longUrl,

'shortUrl' => $shortUrl,

'code' => $a,

'view' => '0'

);

echo json_encode($arr, JSON_UNESCAPED_SLASHES);

}

} else {

$arr = array(

'error' => 'failed',

'longUrl' => $longUrl,

'shortUrl' => $shortUrl,

'code' => $a,

'view' => '0'

);

echo json_encode($arr, JSON_UNESCAPED_SLASHES);

}

}else{

echo "No auth key";

}