Code Clusterpoint

<?php
// config
$accountId = 102193;
$database = 'URLS';
// Note: Replace 'api-eu' with 'api-us', if you are connecting to US cloud!
$url = 'https://api-us.clusterpoint.com/v4/' . $accountId . '/' . $database;
$userPassword = 'marun2@gmail.com:capitalism';

// More about INSERT: https://www.clusterpoint.com/docs/?page=Insert
if (isset($_POST['new_URL'])) {
// insert new URL item
$doc = array(
'URL' => $_POST['URL'],
'text' => $_POST['text'],
'timestamp' => time(),
);

$ch = curl_init();
// https://api-eu.clusterpoint.com/v4/ACCOUNT_ID/DATABASE_NAME[ID]     -  Insert single document with explicit ID
curl_setopt($ch, CURLOPT_URL, $url); //  In this case document ID is automatically generated by system.
curl_setopt($ch, CURLOPT_USERPWD, $userPassword);
curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "POST");
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS, json_encode($doc));
$response = curl_exec($ch);
$errorMsg = curl_error($ch);
if ($errorMsg) {
var_dump($errorMsg);
}
curl_close($ch);

die(); // AJAX request, just kill it.
}


// More about UPDATE: https://www.clusterpoint.com/docs/?page=Update
if (isset($_POST['update_id'])) {

$query = 'UPDATE URLS["' . addslashes($_POST['update_id']) . '"] SET text = "' . addslashes($_POST['text']) . '", URL = "' . addslashes($_POST['URL']) . '"';

$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url . '/_query');
curl_setopt($ch, CURLOPT_USERPWD, $userPassword);
curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "POST"); // or use PATCH request  https://www.clusterpoint.com/docs/?page=Update
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS, $query);
$response = curl_exec($ch);
$errorMsg = curl_error($ch);
if ($errorMsg) {
var_dump($errorMsg);
}
curl_close($ch);

die(); // AJAX request, just kill it.
}


if (isset($_POST['delete_id'])) {
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url . '['.$_POST['delete_id'].']');
curl_setopt($ch, CURLOPT_USERPWD, $userPassword);
curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "DELETE");
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
$response = curl_exec($ch);
$errorMsg = curl_error($ch);
if ($errorMsg) {
var_dump($errorMsg);
}
curl_close($ch);
die(); // AJAX request, just kill it.
}


// More about QUERY: https://www.clusterpoint.com/docs/?page=Query
$ch = curl_init();
$ocs = "";
$query = "SELECT _id,text,URL,timestamp FROM URLS ORDER BY timestamp DESC LIMIT 0,300";
if (isset($_GET['occupation-id']))
{
$ocs = $_GET['occupation-id'];
$query = "SELECT _id,text,URL,timestamp FROM URLS WHERE CONTAINS('" . $ocs . "') ORDER BY timestamp DESC LIMIT 0,300";
}
//$query = 'SELECT text,URL,COUNT(URL),timestamp FROM URLS WHERE text.CONTAINS("*'.addslashes($_GET['occupation-id']).'*") LIMIT 0,200';
// More info: https://www.clusterpoint.com/docs/?page=Matching_Documents_with_WHERE
curl_setopt($ch, CURLOPT_URL, $url . '/_query'); // We added _query here!
curl_setopt($ch, CURLOPT_USERPWD, $userPassword);
curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "POST");
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS, $query);
$response = json_decode(curl_exec($ch));
$errorMsg = curl_error($ch);
if ($errorMsg) {
var_dump($errorMsg);
}
curl_close($ch);
$URLS = array();
$inc = 0;
foreach ($response->results as $document) {
$inc++;
//$btnUpdate = '<button onclick="updateItem(\'' . $document->_id . '\',' . $inc . ')">update</button> ';
$btnDelete = '<button onclick="deleteItem(\"' . (string)$document->_id . '\")">delete</button>';
$URLOutput = "Link number:" . $inc . ": <a target=_blank href=\"" . (string)$document->URL . "\">" . (string)$document->URL . "</a><br>";
$DOCID = "Doc id:" . (string)$document->_id . "<br>";
//$URLInput = '<input type="text" style="background-color:lightgreen;" readonly size="120" name="URL[]" value="' . (string)$document->URL . '" id="URL_' . $inc . '"> ';
//$textInput = '<br><input type="text" name="text[]" id="text_' . $inc . '" value="' .(string)$document->text . '">';
$textOutput = '<p style="color:brown"><i>' .(string)$document->text . '</i></p>';
$mytimestamp = 'Date added: ' . date('Y-m-d H:i',(string)$document->timestamp);
//$URLS[] = '<li>  ' . $URLInput . $textInput . $btnUpdate . $btnDelete . '</li>';
$URLS[] = '<li>' . $URLOutput . $DOCID . $textOutput . $mytimestamp . $btnDelete . '</li>';
}

// More about Aggregation: https://www.clusterpoint.com/docs/?page=Aggregation_with_GROUP_BY
/*
$ch = curl_init();
$query = 'SELECT URL, COUNT(URL) AS count FROM URLS GROUP BY priority ORDER BY priority DESC';
curl_setopt($ch, CURLOPT_URL, $url . '/_query'); // We added _query here!
curl_setopt($ch, CURLOPT_USERPWD, $userPassword);
curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "POST");
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS, $query);
$response = json_decode(curl_exec($ch));
$errorMsg = curl_error($ch);
if ($errorMsg) {
var_dump($errorMsg);
}
curl_close($ch);

$stats = array();
foreach ($response->results as $document) {
$stats[] = '<li>' . $document->count . ' tasks with priority: ' . $document->priority . ' </li>';
}
*/
?>
<!doctype html>
<head>
<meta charset="utf-8">
<title>LinkColumbus the writers block solver</title>
<!-- <link rel="import" href="../statcounter-include.html"> Inline include-->
<!-- Start of StatCounter Code for BBEdit (Mac) -->
<script type="text/javascript">
//<![CDATA[
var sc_project=10656646;
var sc_invisible=0;
var sc_security="6f5323f6";
var scJsHost = (("https:" == document.location.protocol) ?
"https://secure." : "http://www.");
document.write("<sc"+"ript type='text/javascript' src='" +
scJsHost+
"statcounter.com/counter/counter_xhtml.js'></"+"script>");
//]]>
</script>
<noscript><div class="statcounter"><a title="hit counter"
href="http://statcounter.com/" class="statcounter"><img
class="statcounter"
src="http://c.statcounter.com/10656646/0/6f5323f6/0/"
alt="hit counter" /></a></div></noscript>
<!-- End of StatCounter Code for BBEdit (Mac) -->
<a target=_blank href="http://statcounter.com/p10656646/?guest=1">View My Stats</a>
<!--Start of Zopim Live Chat Script-->
<script type="text/javascript">
window.$zopim||(function(d,s){var z=$zopim=function(c){z._.push(c)},$=z.s=
d.createElement(s),e=d.getElementsByTagName(s)[0];z.set=function(o){z.set.
_.push(o)};z._=[];z.set._=[];$.async=!0;$.setAttribute("charset","utf-8");
$.src="//v2.zopim.com/?3OEmwjPqSV4goKBnrct9k32AQkWeres8";z.t=+new Date;$.
type="text/javascript";e.parentNode.insertBefore($,e)})(document,"script");
</script>
<!--End of Zopim Live Chat Script-->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.3/jquery.min.js"></script>
<style type="text/css">
body {
width: 800px;
margin: 0 auto;
}

ul {
list-style: none;
padding: 0;
}

ul li {
border: 1px solid gray;
padding: 5px
}
/*input[type="text"] {
width: 400px;
}*/
</style>
<link rel="stylesheet" href="//code.jquery.com/ui/1.11.4/themes/smoothness/jquery-ui.css">
<script src="//code.jquery.com/jquery-1.10.2.js"></script>
<script src="//code.jquery.com/ui/1.11.4/jquery-ui.js"></script>
<style>
#occupation-label {
display: block;
}
</style>
<script>
$(function() {
var occupations = [
{
value: "copywriter",
label: "copywriter",
},
{
value: "Hollywood",
label: "Hollywood",
},
{
value: "All audiences",
label: "All audiences",
},
{
value: "medical professional",
label: "medical professional",
},
{
value: "graphic designer",
label: "graphic designer",
},
{
value: "legal professional",
label: "legal professional",
},
{
value: "MBA professor",
label: "MBA professor",
},
{
value: "Human Rights Watch activist",
label: "Human Rights Watch activist",
},
{
value: "Silicon Valley Investor",
label: "Silicon Valley Investor",
},
];
$( "#occupation-id" ).autocomplete({
minLength: 0,
source: occupations,
focus: function( event, ui ) {
$( "#occupation-id" ).val( ui.item.label );
$( "#occupation-id" ).val( ui.item.value );
return false;
},
select: function( event, ui ) {
$( "#occupation-id" ).val( ui.item.label );
$( "#occupation-id" ).val( ui.item.value );
return false;
}
})
})();
</script>
</head>
<body>
<h2>What if you could peek into other people's manually curated bookmarks? <a href="URLS.php">LinkColumbus</a></h2>
<h3>Testers wanted! Please test out this small webpage in your smartphones. My contact email is marun2@gmail.com</h3>
<h5><p>Data is stored in clusterpoint.com MongoDB NOSQL database JSON document store as a scalable cluster with redundant servers and 10 shards. They have two separate datacenters available US-Dallas, Texas and EU-Riga, Latvia. They have a gratuitous 10 GB free cloud database free to those who are starting with DbAAS (database as a service). This is somewhat like Amazon RDS so is nothing new but the innovation is making this accessible to you and me. This application is based on the following software technologies: PHP, REST, JSON, Web services, jQuery, HTML5/CSS.
When you create Cloud account you choose which of servers to use (for data storage and retrieval) - US or EU.
Database is distributed among shards and replicated on replicas to increase performance and ensure fault tolerance and durability.
</p></h5>
<img src="gears.png">
<p>The idea machine has twentyfour gears. Or a hundred other peoples' bookmarks to start with. So starts the journey of solving writers block.</p>
<p>Mainly intended to be use for copywriters to solve writers block. How to use it: Use it as a springboard_of_ideas for what to write. Dont hit the writers block. Search for "informal writing" if you are trying to brainstorm up something to write about informal writing and you will find a paul graham article. OR as usual, you can navigate all the links by just choosing copywriter and click Search.</p><br>
<form action="URLS.php" method="get">
Choose an occupation(simply press down arrow when inside the textbox): OR search like you do google.<br>
<input id="occupation-id" value="<? echo @$_GET['occupation-id'] ?>" name="occupation-id">
<button type="submit">Search</button>
</form>
<br><br><br>
<b>Here are <? echo count($URLS) ?> search results for <? echo (@$_GET['occupation-id'] == '' ? "all":@$_GET['occupation-id']) ?><br>
<ul>
<?php echo implode('', $URLS) ?>
</ul>
<ul>
<li>
<p>Add new bookmark: Please double check before adding. If you mistakenly add something, click delete on what you added.</p>
<input type="text" size="90" style="background-color:yellow;" name="new_URL" value="" id="new_URL" placeholder="URL"/><br>
<Textarea name="new_text" style="background-color:yellow;" rows=4 cols=90 value="" id="new_text" placeholder="Text"></textarea>
<button onclick="createItem()">Add</button>
</li>
</ul>

<script type="text/javascript">
function createItem() {
$.post('', {
new_URL: true,
URL: $('#new_URL').val(),
text:     $('#new_text').val()
},
function () {
alert('Item created!');
location.reload();
});
}

function updateItem(docId, fieldsId) {
$.post('', {
update_id: docId,
text:      $('#text_' + fieldsId).val(),
URL:  $('#URL_' + fieldsId).val()
},
function () {
alert('Item updated!');
location.reload();
});
}

function deleteItem(_id) {
$.post('', { delete_id: _id },
function () {
alert('Item deleted!');
location.reload();
});
}
</script>
</body>
</html>
<!--
.autocomplete( "instance" )._renderItem = function( ul, ui.item.value ) {
return $( "<li>" )
.append( "<a>" + ui.item.label + "<br>" + "</a>" )
.appendTo( ul );
};
-->