Closes this connection
| public close ( boolean | string $connection = null ) : boolean | ||
| $connection | boolean | string | - If connection is not given, or FALSE then connection that would be selected for writes would be closed. In a single-node configuration, that is then the whole connection, but if you are connected to a replica set, close() will only close the connection to the primary server. |
| return | boolean | - Returns if the connection was successfully closed. |
public function disconnect()
{
if ($this->_connection) {
$this->_connection->close();
}
$this->_db = $this->_connection = NULL;
}
/**
* Destructor
*/
public function __destruct()
{
if (!empty($this->connection)) {
$this->connection->close(TRUE);
}
parent::__destruct();
}
function like($user, $id, $channel)
{
try {
$conn = new MongoClient();
$db = $conn->site;
$collection = $db->users;
$testquery = array('user_name' => $user);
$cursor = $collection->find($testquery);
if ($cursor->count() == 0) {
$info = array('user_name' => $user, '_id' => $id, 'likes' => 1);
$collection->insert($info);
$collection->update(array('user_name' => $user), array('$addToSet' => array('liked_channels' => $channel)));
echo "liked";
} else {
$collection->update(array('user_name' => $user), array('$inc' => array('likes' => 1)));
$collection->update(array('user_name' => $user), array('$addToSet' => array('liked_channels' => $channel)));
//$collection->update(array('user_name' => $user), array('$addToSet' => array('liked_channels' => $channel), '$setOnInsert' => array('$inc' => array('likes' => 1))), array('upsert' => true));
echo "liked";
}
$conn->close();
} catch (MongoConnectionException $e) {
echo 'Error connecting to MongoDB server';
} catch (MongoException $e) {
echo 'Error somewhere else with mongo';
}
//die('Error: ' . $e->getMessage()); }
exit;
}
public function getDb()
{
if (null === $this->_db) {
$options = $this->getOptions();
// caching ini file data
if (isset($options['host']) && isset($options['dbname'])) {
$url = $options['host'];
if (isset($options['port']) && $options['port']) {
$url .= ":" . $options['port'];
}
if (isset($options['username']) && $options['username']) {
$user = $options['username'] . ':';
if (isset($options['password']) && $options['username']) {
$user .= $options['password'];
}
$url = $user . "@" . $url;
}
$url = 'mongodb://' . $url;
$params = array("connect" => true);
if (isset($options['options']) && !empty($options['options'])) {
$params = $options['options'] + $params;
}
try {
$connection = new MongoClient($url, array('connect' => false) + $params);
$connection->connect();
$db = $connection->{$options}['dbname'];
$this->setDb($db);
\App::alarm()->restoreDBAlarmLog($options['dbname']);
} catch (MongoConnectionException $e) {
\App::log('Error connecting to MongoDB server: ' . $options['host']);
\App::alarm()->errorDBAlarmLog($url);
if ($connection) {
$connection->close(true);
}
throw $e;
} catch (\Exception $e) {
\App::log('Error: ' . $e->getMessage());
\App::alarm()->errorDBAlarmLog($url);
if ($connection) {
$connection->close(true);
}
throw $e;
}
}
}
return $this->_db;
}
function fetchDataFromDB($query)
{
$query['lrs._id'] = LRSID;
$connection = new MongoClient('mongodb://' . MDBHOST . ':' . MDBPORT, ['username' => MDBUSERNAME, 'password' => MDBPASSWORD, 'db' => MDBDB]);
//$connection = new MongoClient();
$db = $connection->selectDB(MDBDB);
$collection = $db->statements;
$cursor = $collection->find($query);
$connection->close();
return $cursor;
}
/**
* Forcefully closes a connection to the database,
* even if persistent connections are being used.
*
* [!!] This is called automatically by [\Gleez\Mango\Client::__destruct].
*/
public function disconnect()
{
if ($this->isConnected()) {
$connections = $this->connection->getConnections();
foreach ($connections as $connection) {
// Close the connection to Mongo
$this->connection->close($connection['hash']);
}
$this->db = $this->benchmark = null;
$this->connected = false;
}
}
function get_page($pageid)
{
global $config;
$connection = new MongoClient($config["database"]["connectionstring"]);
$connection->connect();
$blog = $connection->selectDB($config["database"]["dbname"]);
$pages = $blog->pages;
$page = $pages->findOne(array("_id" => $pageid));
$connection->close();
if (!is_null($page)) {
$page["content"] = Michelf\MarkdownExtra::defaultTransform($page["content"]);
}
return $page;
}
function getTreeHtmlStr()
{
$retArray = array();
array_push($retArray, '<ul id="tt" class="easyui-tree">');
try {
$mongo = new MongoClient('mongodb://nb403:27127/admin:admin');
$db = $mongo->onlineRegressionMonitor;
$collection = $db->prodVersionDetail;
$cursor = $collection->find();
$temp_arr = array();
foreach ($cursor as $doc) {
$prodName = $doc["prodName"];
$version = $doc["version"];
$tsList = $doc["tsList"];
if (count($tsList) == 0) {
continue;
}
if (!array_key_exists($prodName, $temp_arr)) {
$temp_arr[$prodName] = array();
}
$temp_arr[$prodName][$version] = $tsList;
}
foreach ($temp_arr as $prodName => $sub_arr) {
array_push($retArray, '<li data-options="attributes:{type:0}, state:\'closed\'">');
array_push($retArray, '<span>' . $prodName . '</span>');
array_push($retArray, '<ul>');
krsort($sub_arr);
foreach ($sub_arr as $version => $tsList) {
array_push($retArray, '<li data-options="attributes:{type:0}, state:\'closed\'">');
array_push($retArray, '<span>' . $version . '</span>');
array_push($retArray, '<ul>');
foreach ($tsList as $ts) {
array_push($retArray, '<li data-options="attributes:{diff_path:\'' . "{$prodName}:{$version}:{$ts}" . '\', type:1}">');
array_push($retArray, '<span>' . date("Y-m-d H:i:s", $ts) . '</span>');
array_push($retArray, '</li>');
}
array_push($retArray, '</ul>');
array_push($retArray, '</li>');
}
array_push($retArray, '</ul>');
array_push($retArray, '</li>');
}
$mongo->close();
} catch (MongoConnectionException $e) {
die($e->getMessage());
return;
}
array_push($retArray, '</ul>');
return implode("\n", $retArray);
}
/**
* Delete (remove)
*/
function mongoDelete($server, $db, $collection, $id)
{
try {
$conn = new MongoClient($server);
$_db = $conn->{$db};
$collection = $_db->{$collection};
$criteria = array('_id' => new MongoId($id));
$collection->remove($criteria, array('safe' => true));
$conn->close();
return array('success' => 'deleted');
} catch (MongoConnectionException $e) {
die('Error connecting to MongoDB server');
} catch (MongoException $e) {
die('Error: ' . $e->getMessage());
}
}
function list_get()
{
// establish connection to MongoDB server
$connection = new MongoClient();
// select database
$db = $connection->company;
// select collection
$collection = $db->persons;
// retrieve all items in collection
$cursor = $collection->find();
if ($cursor->hasNext()) {
echo json_encode(iterator_to_array($cursor));
}
// close connection
$connection->close();
}
// a new products collection object
$collection = $db->accounts;
// fetch all product documents
$cursor = $collection->find(array('userID' => $userID));
// How many results found
$num_docs = $cursor->count();
if ($num_docs > 0) {
// loop over the results
foreach ($cursor as $obj) {
echo '_id: ' . $obj['_id'] . "\n";
echo 'user ID: ' . $obj['userID'] . "\n";
echo 'company Name: ' . $obj['companyName'] . "\n";
echo 'project name: ' . $obj['projectName'] . "\n";
echo 'isVIP: ' . $obj['isVIP'] . "\n";
echo "\n";
}
$returnValue = "Success";
echo json_encode($returnValue);
} else {
// if no accounts are found, we show this message
$returnValue = "fail 1";
echo json_encode($returnValue);
}
// close the connection to MongoDB
$conn->close();
} catch (MongoConnectionException $e) {
// if there was an error, we catch and display the problem here
echo $e->getMessage();
} catch (MongoException $e) {
echo $e->getMessage();
}
/**
* Mongo list with sorting and filtering
*
* $select = array(
* 'limit' => 0,
* 'page' => 0,
* 'filter' => array(
* 'field_name' => 'exact match'
* ),
* 'regex' => array(
* 'field_name' => '/expression/i'
* ),
* 'sort' => array(
* 'field_name' => -1
* )
* );
*/
function mongoList($server, $db, $collection, $select = null)
{
try {
$conn = new MongoClient($server);
$_db = $conn->{$db};
$collection = $_db->{$collection};
$criteria = NULL;
// add exact match filters if they exist
if (isset($select['filter']) && count($select['filter'])) {
$criteria = $select['filter'];
}
// add regex match filters if they exist
if (isset($select['wildcard']) && count($select['wildcard'])) {
foreach ($select['wildcard'] as $key => $value) {
$criteria[$key] = new MongoRegex($value);
}
}
// get results
if ($criteria) {
$cursor = $collection->find($criteria);
} else {
$cursor = $collection->find();
}
// sort the results if specified
if (isset($select['sort']) && $select['sort'] && count($select['sort'])) {
$sort = array();
print_r($select);
foreach ($select['sort'] as $key => $value) {
$sort[$key] = (int) $value;
}
$cursor->sort($sort);
}
// set a limit
if (isset($select['limit']) && $select['limit']) {
if (MONGO_LIST_MAX_PAGE_SIZE && $select['limit'] > MONGO_LIST_MAX_PAGE_SIZE) {
$limit = MONGO_LIST_MAX_PAGE_SIZE;
} else {
$limit = $select['limit'];
}
} else {
$limit = MONGO_LIST_DEFAULT_PAGE_SIZE;
}
if ($limit) {
$cursor->limit($limit);
}
// choose a page if specified
if (isset($select['page']) && $select['page']) {
$skip = (int) ($limit * ($select['page'] - 1));
$cursor->skip($skip);
}
// prepare results to be returned
$output = array('total' => $cursor->count(), 'pages' => ceil($cursor->count() / $limit), 'results' => array());
foreach ($cursor as $result) {
// 'flattening' _id object in line with CRUD functions
$result['_id'] = $result['_id']->{'$id'};
$output['results'][] = $result;
}
$conn->close();
return $output;
} catch (MongoConnectionException $e) {
die('Error connecting to MongoDB server');
} catch (MongoException $e) {
die('Error: ' . $e->getMessage());
}
}
public function close()
{
$this->initialize();
return $this->mongo->close();
}
<?php
$i = 1;
foreach ($cursor as $doc) {
echo '<tr>';
echo '<td>' . $i++ . '</td>';
echo '<td>' . $doc["email"] . '</td>';
echo '<td class="center">' . $doc["message"] . '</td>';
echo '</tr>';
}
?>
<?php
$m->close();
?>
</tbody>
</table>
</div>
<!-- /.table-responsive -->
</div>
<!-- /.panel-body -->
</div>
<!-- /.panel -->
</div>
<!-- /.col-lg-12 -->
</div>
<!-- /.row -->
function attrs()
{
$this->load->library('POI');
$this->load->library('geo/*');
$this->load->model('POIModel');
$pois = POIModel::loadAll();
$con = new MongoClient();
$db = $con->pocketsail;
$tbl = $db->poi;
$tbl->remove([]);
$tbl->ensureIndex(['id' => 1, 'lat' => 1, 'lng' => 1, 'contact.type' => 1]);
foreach ($pois as $poi) {
// $id = $poi->id();
// $url = $poi->url();
// $name = $poi->name();
// $label = $poi->label();
// $nearId = $poi->nearId();
// $countryId = $poi->countryId();
// $cat = $poi->cat();
// $sub = $poi->sub();
// $userId = $poi->userId();
// $lat = $poi->lat();
// $lng = $poi->lng();
// $border = $poi->border();
// $rank = $poi->rank();
// $timestamp = $poi->timestamp();
$attrs = $poi->attrs();
$new = [];
$new['id'] = (int) $poi->id();
$new['url'] = (string) $poi->url();
$new['name'] = (string) $poi->name();
$new['label'] = (string) $poi->label();
$new['near'] = (string) $poi->nearName();
$new['country'] = (string) $poi->countryName();
$new['cat'] = (string) $poi->cat();
$new['sub'] = (string) $poi->cat();
$new['lat'] = (double) $poi->lat();
$new['lng'] = (double) $poi->lng();
if (gettype($attrs) === 'object') {
/**
* Description
*/
if (isset($attrs->description->details)) {
$new["description"] = $attrs->description->details;
}
/**
* Approach
*/
if (isset($attrs->approach)) {
$new['approach']['text'] = $attrs->approach->details;
$new['approach']['drying']['value'] = @$attrs->approach->drying->value;
$new['approach']['drying']['details'] = @$attrs->approach->drying->details;
}
/**
* Hazards
*/
if (isset($attrs->hazards->details)) {
$new['hazards']['val'] = $attrs->hazards->details;
}
/**
* Exposure
*/
if (isset($attrs->exposure)) {
// Wind
$winds = explode(",", @$attrs->exposure->wind);
if (count($winds) > 0 && $winds[0] != "") {
// echo "Specific, yet ";
// print_r($winds);
$new['exposure']['wind']['value'] = 'specific';
foreach ($winds as $wind) {
$new['exposure']['wind']['dir'][] = trim($wind);
}
} else {
$new['exposure']['wind']['value'] = 'na';
}
// Swell
$swells = explode(",", @$attrs->exposure->swell);
if (count($swells) > 0) {
$new['exposure']['swell']['value'] = 'specific';
foreach ($swells as $swell) {
$new['exposure']['swell']['dir'][] = trim($swell);
}
} else {
$new['exposure']['swell']['value'] = 'na';
}
}
/**
* Attractions & Nightlife
*/
if (isset($attrs->attractions->details)) {
$new['attractions'] = $attrs->attractions->details;
}
/**
* Nightlife
*/
if (isset($attrs->nightlife->details)) {
$new['nightlife'] = $attrs->nightlife->details;
}
/**
* Contact
*/
if (isset($attrs->contact->types)) {
$new['contact']['type'] = [];
$new['contact']['value'] = [];
for ($i = 0; $i < count($attrs->contact->types); $i++) {
$new['contact']['value'][] = $attrs->contact->values[$i];
$new['contact']['type'][] = $attrs->contact->types[$i];
}
}
/**
* Facilities
*/
if (isset($attrs->facilities->water->value)) {
$new['facilities']['water']['val'] = $attrs->facilities->water->value;
$new['facilities']['water']['details']['val'] = @$attrs->facilities->water->details;
}
if (isset($attrs->facilities->electricity->value)) {
$new['facilities']['electricity']['val'] = $attrs->facilities->electricity->value;
$new['facilities']['electricity']['details']['val'] = @$attrs->facilities->electricity->details;
}
if (isset($attrs->facilities->showers->value)) {
$new['facilities']['showers']['val'] = $attrs->facilities->showers->value;
$new['facilities']['showers']['details']['val'] = @$attrs->facilities->showers->details;
}
if (isset($attrs->facilities->toilets->value)) {
$new['facilities']['toilets']['val'] = $attrs->facilities->toilets->value;
$new['facilities']['toilets']['details']['val'] = @$attrs->facilities->toilets->details;
}
if (isset($attrs->facilities->waste->value)) {
$new['facilities']['waste']['val'] = $attrs->facilities->waste->value;
$new['facilities']['waste']['details']['val'] = @$attrs->facilities->waste->details;
}
if (isset($attrs->facilities->reception->value)) {
$new['facilities']['reception']['val'] = $attrs->facilities->reception->value;
$new['facilities']['reception']['details']['val'] = @$attrs->facilities->reception->details;
}
if (isset($attrs->facilities->customs->value)) {
$new['facilities']['customs']['val'] = $attrs->facilities->customs->value;
$new['facilities']['customs']['details']['val'] = @$attrs->facilities->customs->details;
}
if (isset($attrs->facilities->enquiries->value)) {
$new['facilities']['enquiries']['val'] = $attrs->facilities->enquiries->value;
$new['facilities']['enquiries']['details']['val'] = @$attrs->facilities->enquiries->details;
}
if (isset($attrs->facilities->laundry->value)) {
$new['facilities']['laundry']['val'] = $attrs->facilities->laundry->value;
$new['facilities']['laundry']['details']['val'] = @$attrs->facilities->laundry->details;
}
if (isset($attrs->facilities->wifi->value)) {
$new['facilities']['wifi']['val'] = $attrs->facilities->wifi->value;
$new['facilities']['wifi']['details']['val'] = @$attrs->facilities->wifi->details;
}
if (isset($attrs->facilities->disability->value)) {
$new['facilities']['disability']['val'] = $attrs->facilities->disability->value;
$new['facilities']['disability']['details']['val'] = @$attrs->facilities->disability->details;
}
if (isset($attrs->facilities->pets->value)) {
$new['facilities']['pets']['val'] = $attrs->facilities->pets->value;
$new['facilities']['pets']['details']['val'] = @$attrs->facilities->pets->details;
}
/**
* Sources
*/
if (isset($attrs->sources->details)) {
$sources = explode("\r\n", $attrs->sources->details);
foreach ($sources as $source) {
$new['sources'][] = trim($source);
}
}
/**
* Charts
*/
if (isset($attrs->charts->details)) {
$chartsStr = trim($attrs->charts->details, " .");
$charts = explode(",", $chartsStr);
foreach ($charts as $chart) {
$charts_and = $charts = explode(" and ", $chart);
foreach ($charts_and as $chart_and) {
$new['charts'][] = trim($chart_and, " .");
}
}
}
/**
* Anchoring info
*/
if (isset($attrs->anchoring)) {
$new['anchoring']['depth']['from'] = $attrs->anchoring->depth->from;
$new['anchoring']['depth']['to'] = $attrs->anchoring->depth->to;
$new['anchoring']['holding']['value'] = @$attrs->anchoring->holding->values;
$new['anchoring']['holding']['details'] = @$attrs->anchoring->holding->details;
$new['anchoring']['cost']['value'] = @$attrs->anchoring->price->value !== "";
$new['anchoring']['cost']['price'] = @$attrs->anchoring->price->value;
$new['anchoring']['cost']['currency'] = @$attrs->anchoring->price->currency;
$new['anchoring']['cost']['type'] = @$attrs->anchoring->price->type;
$new['anchoring']['cost']['details'] = @$attrs->anchoring->price->details;
$new['anchoring']['tax']['value'] = @$attrs->berthing->soujourn->value;
$new['anchoring']['tax']['currency'] = @$attrs->berthing->soujourn->currency;
$new['anchoring']['tax']['type'] = @$attrs->berthing->soujourn->type;
$new['anchoring']['tax']['details'] = @$attrs->berthing->soujourn->details;
}
/**
* Buoys mooring
*/
if (isset($attrs->mooring)) {
$new['mooring']['number']['val'] = $attrs->mooring->number->value;
$new['mooring']['number']['details']['val'] = @$attrs->mooring->number->details;
$new['mooring']['maxdraught']['val'] = $attrs->mooring->maxdraught->value;
$new['mooring']['maxdraught']['type']['val'] = $attrs->mooring->maxdraught->type;
$new['mooring']['maxdraught']['details']['val'] = @$attrs->mooring->maxdraught->details;
$new['mooring']['maxlength']['val'] = $attrs->mooring->maxlength->value;
$new['mooring']['maxlength']['type']['val'] = $attrs->mooring->maxlength->type;
$new['mooring']['maxlength']['details']['val'] = @$attrs->mooring->maxlength->details;
$new['mooring']['price']['val'] = @$attrs->mooring->price->value;
$new['mooring']['price']['currency']['val'] = @$attrs->mooring->price->currency;
$new['mooring']['price']['type']['val'] = @$attrs->mooring->price->type;
$new['mooring']['price']['details']['val'] = @$attrs->mooring->price->details;
$new['mooring']['soujourn']['val'] = @$attrs->mooring->soujourn->value;
$new['mooring']['soujourn']['currency']['val'] = @$attrs->mooring->soujourn->currency;
$new['mooring']['soujourn']['type']['val'] = @$attrs->mooring->soujourn->type;
$new['mooring']['soujourn']['details']['val'] = @$attrs->mooring->soujourn->details;
}
/**
* Berthing, mooring, anchoring
*/
if (isset($attrs->mba->details) && $attrs->mba->details !== '') {
$new['bma']['val'] = $attrs->mba->details;
}
/**
* Services
*/
if (isset($attrs->services->slipway->value)) {
$new['services']['slipway']['val'] = $attrs->services->slipway->value;
$new['services']['slipway']['details']['val'] = @$attrs->services->slipway->details;
}
if (isset($attrs->services->pumpout->value)) {
$new['services']['pumpout']['val'] = $attrs->services->pumpout->value;
$new['services']['pumpout']['details']['val'] = @$attrs->services->pumpout->details;
}
if (isset($attrs->services->repairs->value)) {
$new['services']['repairs']['val'] = $attrs->services->repairs->value;
$new['services']['repairs']['details']['val'] = @$attrs->services->repairs->details;
}
if (isset($attrs->services->travelift->value)) {
$new['services']['travelift']['val'] = $attrs->services->travelift->value;
$new['services']['travelift']['maxtonnage']['val'] = @$attrs->services->travelift->maxtonnage;
$new['services']['travelift']['details']['val'] = @$attrs->services->travelift->details;
}
if (isset($attrs->services->storage->value)) {
$new['services']['storage']['val'] = $attrs->services->storage->value;
$new['services']['storage']['details']['val'] = @$attrs->services->storage->details;
}
if (isset($attrs->services->divers->value)) {
$new['services']['divers']['val'] = $attrs->services->divers->value;
$new['services']['divers']['details']['val'] = @$attrs->services->divers->details;
}
/**
* Opening
*/
if (isset($attrs->opening)) {
$new['opening']['val'] = $attrs->opening->value;
$new['opening']['details']['val'] = @$attrs->opening->details;
if (isset($attrs->opening->everyday)) {
$new['opening']['everyday']['val'] = $attrs->opening->everyday->value;
$new['opening']['everyday']['from']['val'] = @$attrs->opening->everyday->from;
$new['opening']['everyday']['to']['val'] = @$attrs->opening->everyday->to;
}
if (isset($attrs->opening->somedays)) {
foreach (['mon', 'tue', 'wed', 'thu', 'fri', 'sat', 'sun'] as $day) {
$new['opening']['somedays'][$day]['val'] = $attrs->opening->somedays->{$day}->value;
$new['opening']['somedays'][$day]['from']['val'] = @$attrs->opening->somedays->{$day}->from;
$new['opening']['somedays'][$day]['to']['val'] = @$attrs->opening->somedays->{$day}->to;
}
}
}
/**
* Season
*/
if (isset($attrs->season)) {
$new['season']['val'] = $attrs->season->value;
$new['season']['details']['val'] = @$attrs->season->details;
$new['season']['from']['val'] = @$attrs->season->from;
$new['season']['to']['val'] = @$attrs->season->to;
}
/**
* Berthing info
*/
if (isset($attrs->berthing)) {
// Assistance
if (isset($attrs->berthing->assistance)) {
$new['berthing']['assistance']['val'] = $attrs->berthing->assistance->value;
} else {
$new['berthing']['assistance']['val'] = 'na';
}
$new['berthing']['assistance']['details']['val'] = @$attrs->berthing->assistance->details;
// Type
if (isset($attrs->berthing->type)) {
$new['berthing']['type']['val'] = $attrs->berthing->type->values;
} else {
$new['berthing']['type']['val'] = 'na';
}
$new['berthing']['type']['details']['val'] = @$attrs->berthing->type->details;
// Seaberths
if (isset($attrs->berthing->seaberths)) {
$new['berthing']['seaberths']['total']['val'] = $attrs->berthing->seaberths->total->value;
$new['berthing']['seaberths']['visitor']['val'] = $attrs->berthing->seaberths->total->value;
}
$new['berthing']['seaberths']['details']['val'] = @$attrs->berthing->seaberths->details;
// Dryberths
if (isset($attrs->berthing->dryberths)) {
$new['berthing']['dryberths']['val'] = $attrs->berthing->dryberths->value;
$new['berthing']['dryberths']['details']['val'] = @$attrs->berthing->dryberths->details;
}
// Maxdraught
if (isset($attrs->berthing->maxdraught)) {
$new['berthing']['maxdraught']['val'] = $attrs->berthing->maxdraught->value;
$new['berthing']['maxdraught']['type']['val'] = $attrs->berthing->maxdraught->type;
$new['berthing']['maxdraught']['details']['val'] = @$attrs->berthing->maxdraught->details;
}
// Maxlength
if (isset($attrs->berthing->maxlength)) {
$new['berthing']['maxlength']['val'] = $attrs->berthing->maxlength->value;
$new['berthing']['maxlength']['type']['val'] = $attrs->berthing->maxlength->type;
$new['berthing']['maxlength']['details']['val'] = @$attrs->berthing->maxlength->details;
}
// Price
if (isset($attrs->berthing->price)) {
if (isset($attrs->berthing->price->value)) {
$new['berthing']['price']['val'] = $attrs->berthing->price->value;
$new['berthing']['price']['currency']['val'] = $attrs->berthing->price->currency;
$new['berthing']['price']['type']['val'] = $attrs->berthing->price->type;
} else {
$new['berthing']['price']['val'] = 0;
$new['berthing']['price']['currency']['val'] = 'gbp';
$new['berthing']['price']['type']['val'] = 'm';
}
$new['berthing']['price']['details']['val'] = @$attrs->berthing->price->details;
}
// Soujourn
if (isset($attrs->berthing->soujourn)) {
if (isset($attrs->berthing->soujourn->value)) {
$new['berthing']['soujourn']['val'] = $attrs->berthing->soujourn->value;
$new['berthing']['soujourn']['currency']['val'] = $attrs->berthing->soujourn->currency;
$new['berthing']['soujourn']['type']['val'] = $attrs->berthing->soujourn->type;
} else {
$new['berthing']['soujourn']['val'] = 0;
$new['berthing']['soujourn']['currency']['val'] = 'gbp';
$new['berthing']['soujourn']['type']['val'] = 'person';
}
$new['berthing']['soujourn']['details']['val'] = @$attrs->berthing->soujourn->details;
}
}
}
//$new = json_decode(json_encode($new), TRUE);
$attributes = POI::fromPostData($new);
// print_r($attributes->toDoc());
// var_dump($tbl->insert($attributes->toDoc()));
// print_r($new);
// echo "<br /><br />";
}
$con->close();
}
****************************************************/
$email = $_POST["email"];
if ($email == "") {
die(" email cannot be empty");
}
$password = $_POST["password"];
if ($password == "") {
die("password cannot be empty");
}
$con = new MongoClient();
if ($con) {
$db = $con->{$users};
$selection = $db->{$myusers};
$document = array("email" => $email, "password" => $password);
$result = $selection->findOne($document);
if ($result) {
$success = "You are successully loggedIn";
$res = $selection->find($document);
foreach ($res as $doc) {
echo $doc["_id"] . "<br />";
echo $doc["name"] . "<br />";
echo $doc["username"] . "<br />";
}
} else {
die("user does not exi44st , or user / password is incorrect");
}
} else {
die("Mongo DB not installed");
}
$con->close();
$info = $_POST["infoWindow"];
/* Create object to store */
$marker = array('latitude' => $lat, 'longitude' => $long, 'incident' => $incident, 'notes' => $notes, 'time' => $time, 'date' => $date, 'info' => $info);
/* Standard options */
$uri = "mongodb://*****:*****@ds041581.mongolab.com:41581/echo";
$options = array("connectTimeoutMS" => 30000);
/* Create Mongo connection with URI and options*/
$client = new MongoClient($uri, $options);
/* Reference the proper database */
$db = $client->selectDB("echo");
/* Reference the proper collection */
$report = $db->reports;
// To insert a dict, use the insert method.
$report->insert($marker);
// Only close the connection when your app is terminating
$client->close();
// TWILIO API --------------------------------------------------------------------------------------------------
/* Send an SMS using Twilio. You can run this file 3 different ways:
*
* - Save it as sendnotifications.php and at the command line, run
* php sendnotifications.php
*
* - Upload it to a web host and load mywebhost.com/sendnotifications.php
* in a web browser.
* - Download a local server like WAMP, MAMP or XAMPP. Point the web root
* directory to the folder containing this file, and load
* localhost:8888/sendnotifications.php in a web browser.
*/
// Step 1: Download the Twilio-PHP library from twilio.com/docs/libraries,
// and move it into the folder containing this file.
require "Twilio.php";
//echo 'per limit: ', $pageMax, PHP_EOL;
$config = (require PROJECT_ROOT . 'config' . DS . 'db.php');
$from_config = $config['db'][$config['db']['adapter']];
$to_config = $config['db2'][$config['db2']['adapter']];
//连接mongodb
try {
$mongoClient = new \MongoClient($from_config['dsn']);
// $node_collection = $mongoClient->selectCollection($from_config['db'], 'MEMBER_NODE');
} catch (Exception $e) {
echo $e->getMessage();
return;
}
//连接mysql server
$to_conn = mysqli_connect($to_config['host'], $to_config['usernmae'], $to_config['password']);
if (!$to_conn) {
$mongoClient->close();
die(mysqli_error($to_conn));
}
mysqli_select_db($to_config['db'], $to_conn);
//读取数据
$queries = [];
foreach ($table_list as $table => $entity) {
$queries = array_merge($queries, create_queries($from_config['db'], $table, $start, $end, $entity, $per_limit));
}
//开启事务
$to_conn->autocommit(false);
$to_conn->begin_transaction();
$flag = $to_conn->commit();
if (!$flag) {
$to_conn->rollback();
}
try {
$db_url = "mongodb://localhost:27017";
$connect = new MongoClient($db_url);
$db_name = "amazon";
$db = $connect->selectDB($db_name);
$collection = $db->selectCollection("products");
$data = $collection->findOne(array("pid" => $pid));
if (isset($data)) {
$size = sizeof($data['price']);
// echo $size;
for ($x = 0; $x < $size; $x++) {
echo "{ x: datetimeToDate(\"" . $data['timestamp'][$x] . "\"), y: " . str_replace(",", "", $data['price'][$x]) . "}," . "\n";
}
}
// disconnect from server
$connect->close();
} catch (MongoConnectionException $e) {
die('Cannot connect to MongoDB server');
} catch (MongoException $e) {
die('Mongo Error: ' . $e->getMessage());
} catch (Exception $e) {
die('Error: ' . $e->getMessage());
}
}
?>
]
}
]
});
function deletePerson($id)
{
try {
global $mongoHost;
$connection = new MongoClient($mongoHost);
$db = $connection->Equipments;
$collection = $db->Peoples;
$collection->remove(array('_id' => new MongoId($id)));
$connection->close();
} catch (MongoConnectionException $e) {
echo $e->getMessage();
} catch (MongoException $e) {
echo $e->getMessage();
}
}
<?php
require_once 'config.php';
$agent = '*****@*****.**';
$connection = new MongoClient('mongodb://' . MDBHOST . ':' . MDBPORT, ['username' => MDBUSERNAME, 'password' => MDBPASSWORD, 'db' => MDBDB]);
//$connection = new MongoClient();
$db = $connection->selectDB(MDBDB);
$collection = $db->statements;
$query = array('statement.actor.mbox' => 'mailto:' . $agent, 'statement.verb.id' => 'http://activitystrea.ms/schema/1.0/create', 'statement.object.definition.type' => 'http://adlnet.gov/expapi/activities/course');
$lrsid = LRSID;
$query['lrs._id'] = $lrsid;
$cursor = $collection->find($query);
$connection->close();
$courses = array();
foreach ($cursor as $document) {
$courses[] = $document['statement'];
}
$uniquecourses = array();
foreach ($courses as $course) {
if (!array_key_exists($course['object']['id'], $uniquecourses)) {
$uniquecourses[$course['object']['id']] = $course;
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
/**
* Close the connection to Mongo
*
* @return boolean if the connection was successfully closed
*/
public function close()
{
if ($this->_connected) {
$this->_connected = $this->_connection->close();
$this->_db = "{$this->_db}";
}
return $this->_connected;
}
$lines = file("../data/members.txt");
$userCount = count($lines);
foreach ($lines as $line) {
$line = trim($line);
list($name, $mail) = explode(":", $line);
$nameList[$name] = 0;
}
try {
$mongo = new MongoClient('mongodb://nb403:27127/admin:admin');
$db = $mongo->youdaoSports;
$collection = $db->votes;
$doc = $collection->findOne(array("_id" => new MongoId($id)));
foreach ($doc["users"] as $user) {
$nameList[$user] = 1;
}
$mongo->close();
} catch (MongoConnectionException $e) {
die($e->getMessage());
return;
}
?>
<table border='1'>
<tr>
<th>成员名</th>
<th>支持</th>
<th>反对</th>
</tr>
<?php
foreach ($nameList as $name => $val) {
if ($val == 0) {
/**
* You should never call this function.
*
* The PHP driver will handle connections automatically, and will
* keep this performant for you.
*/
public function close()
{
if (!empty($this->_mongo)) {
$this->_mongo->close();
}
}
