PHP row_to_elggrelationship Examples

Example #1

File: relationships.php Project: portokallidis/Metamorphosis-Meducator

/**
 * Return a relationship.
 *
 * @param int $id The ID of a relationship
 *
 * @return mixed
 */
function get_relationship($id)
{
    global $CONFIG;
    $id = (int) $id;
    $query = "SELECT * from {$CONFIG->dbprefix}entity_relationships where id={$id}";
    return row_to_elggrelationship(get_data_row($query));
}

Example #2

File: relationships.php Project: gzachos/elgg_ellak

/**
 * Check if a relationship exists between two entities. If so, the relationship object is returned.
 *
 * This function lets you ask "Is $guid_one a $relationship of $guid_two?"
 *
 * @param int    $guid_one     GUID of the subject entity of the relationship
 * @param string $relationship Type of the relationship
 * @param int    $guid_two     GUID of the target entity of the relationship
 *
 * @return ElggRelationship|false Depending on success
 */
function check_entity_relationship($guid_one, $relationship, $guid_two)
{
    global $CONFIG;
    $guid_one = (int) $guid_one;
    $relationship = sanitise_string($relationship);
    $guid_two = (int) $guid_two;
    $query = "SELECT * FROM {$CONFIG->dbprefix}entity_relationships\n\t\tWHERE guid_one={$guid_one}\n\t\t\tAND relationship='{$relationship}'\n\t\t\tAND guid_two={$guid_two} limit 1";
    $row = row_to_elggrelationship(get_data_row($query));
    if ($row) {
        return $row;
    }
    return false;
}

Example #3

File: RelationshipsTable.php Project: n8b/VMN

 /**
  * Check if a relationship exists between two entities. If so, the relationship object is returned.
  *
  * This function lets you ask "Is $guid_one a $relationship of $guid_two?"
  *
  * @param int    $guid_one     GUID of the subject entity of the relationship
  * @param string $relationship Type of the relationship
  * @param int    $guid_two     GUID of the target entity of the relationship
  *
  * @return \ElggRelationship|false Depending on success
  */
 function check($guid_one, $relationship, $guid_two)
 {
     $guid_one = (int) $guid_one;
     $relationship = sanitise_string($relationship);
     $guid_two = (int) $guid_two;
     $query = "SELECT * FROM {$this->CONFIG->dbprefix}entity_relationships\n\t\t\tWHERE guid_one={$guid_one}\n\t\t\t\tAND relationship='{$relationship}'\n\t\t\t\tAND guid_two={$guid_two} limit 1";
     $row = row_to_elggrelationship(_elgg_services()->db->getDataRow($query));
     if ($row) {
         return $row;
     }
     return false;
 }

Example #4

File: RelationshipsTable.php Project: cyrixhero/Elgg

 /**
  * Check if a relationship exists between two entities. If so, the relationship object is returned.
  *
  * This function lets you ask "Is $guid_one a $relationship of $guid_two?"
  *
  * @param int    $guid_one     GUID of the subject entity of the relationship
  * @param string $relationship Type of the relationship
  * @param int    $guid_two     GUID of the target entity of the relationship
  *
  * @return \ElggRelationship|false Depending on success
  */
 function check($guid_one, $relationship, $guid_two)
 {
     $guid_one = (int) $guid_one;
     $relationship = $this->db->sanitizeString($relationship);
     $guid_two = (int) $guid_two;
     $query = "\n\t\t\tSELECT * FROM {$this->db->getTablePrefix()}entity_relationships\n\t\t\tWHERE guid_one = {$guid_one}\n\t\t\t  AND relationship = '{$relationship}'\n\t\t\t  AND guid_two = {$guid_two}\n\t\t\tLIMIT 1\n\t\t";
     $row = row_to_elggrelationship($this->db->getDataRow($query));
     if ($row) {
         return $row;
     }
     return false;
 }