errorInfo;
echo $e->getMessage();
}
}
protected function error($e,$sql){
die("Database Error.
SQL was '$sql'
Error was ".$e->getMessage());
}
}
global $dbh;
$dbcon = new Connection();
$uri = $_SERVER['REQUEST_URI'];
echo "Initial request uri is ".$uri."
";
$sql = "select text_value from metadatavalue where metadata_field_id = 25 and resource_id = (select resource_id from metadatavalue where metadata_field_id = 72 and text_value = ?)";
$uri = "http://upetd.up.ac.za".$uri;
if(substr($uri,-1) != "/"){
$uri .= "/";
}
echo "Rebuilt uri used for query is ".$uri."
";
$data = array($uri);
$sth = $dbh->prepare($sql);
try {
$sth->execute($data);
$row = $sth->fetch();
$sth->closeCursor();
} catch (PDOException $e) {
die($e->getMessage());
}
$newuri = $row[0];
echo "newuri = $newuri";
if($newuri == ""){
$newuri = "https://repository.up.ac.za";
} else {
$newuri = substr($newuri, 21);
$newuri = "https://repository.up.ac.za/handle".$newuri;
}
$dbcon = null;
echo "Redirecting to ".$newuri;
header("location:".$newuri);
?>