glink-website/result.php

<?php
session_start();
require_once 'db.inc.php';
require_once 'rand_string.inc.php';

ini_set('display_errors', 1);

$session = init_cass_db();

$url = $_POST["url"];

if (isset($_POST["restricted"])) {
	$is_geo = 1;
} else {
	$is_geo = 0;
}

if ($is_geo == 1) {
	$radius = $_POST["radius"];

	$latitude = $_POST["latitude"];
	$latitude = doubleval($latitude);

	$longitude = $_POST["longitude"];
	$longitude = doubleval($longitude);
}

$matches = preg_match('/^http(s)*:\\/\\/[a-zA-Z0-9\\-]+(\\.[a-zA-Z0-9\\-]+)+[\\/_#a-zA-Z0-9=?\\-]*$/',$url);
if (($matches == 0) || ($matches == false)) {
	printf("The URL entered was invalid. Please try again.");
	return;
}

$shortlink = $_POST["glink"];

if (isset($_POST["ttl"])) {
	$ttl = $_POST["ttl"];
} else {
	$ttl = 0;
}

if ($shortlink != '') {
	$matches_shortlink = preg_match('/^[a-zA-Z]+$/',$shortlink);
	if (($matches_shortlink == 0) || ($matches_shortlink == false)) {
	        printf("The GLink entered was invalid. The GLink can only contain letters. Please try again.");
	        return;
	}
} else {
	/* generate a random shortlink */
	gen_shortlink:
		$rand_string = gen_rand_shortlink(6);  /* the function is defined at the start of this file */
		$shortlink = $rand_string;

		/* Check if shortlink is already taken by querying the database */
		$statement = $session->prepare('SELECT url FROM data WHERE shortlink=? ALLOW FILTERING');
		$result = $session->execute($statement,array('arguments' => array($shortlink)));

		if ($result->count() != 0) {
			goto gen_shortlink;
		}

}

//$statement = new Cassandra\SimpleStatement('SELECT name FROM data WHERE id=5');

$statement = $session->prepare('SELECT url FROM data WHERE shortlink=? ALLOW FILTERING');
$options = array('arguments' => array($shortlink));
$result = $session->execute($statement,$options);

if ($result->count() != 0) {
	printf('That GLink is already taken. Please try another one.');
	exit;
}


$statement = $session->prepare('INSERT INTO data (id, url, shortlink, is_geo, radius, latitude, longitude, user, purgatory, hell, when_created) VALUES (now(),?,?,?,?,?,?,?,false, false, toTimestamp(now())) USING TTL ?;');

if ($is_geo == 1) {
	$options = array($url,$shortlink,boolval($is_geo),intval($radius), $latitude, $longitude, $_SESSION['user'], intval($ttl));
} else {
	$options = array($url,$shortlink,boolval($is_geo),null,null,null,$_SESSION['user'],intval($ttl));
}

$result = $session->execute($statement,array('arguments' => $options));

//$stringRepresentation= json_encode($result[0]);

//printf("%s\n\n\n",$stringRepresentation);

//foreach($result as $row) {
//	if (is_null($row)) {
//		printf('Unsuccessful');
//	} else {
		printf('Successful: The URL you entered was: %s and your GLink is: https://glink.zip/%s', $url,$shortlink);
//	}
//}
//printf('Done');

?>