/** * Create an instance by the hash value. This function is in support * of the synchronization functionality. It takes a hash value and * it will return an instance of the object for that hash value * if the hash exists. If the hash does not exist, null will be * returned, indicating that the object should be created using the * normal constructor. */ public static function findByHash($hash = '') { if (!isset($hash) || $hash === '') { return null; } $hashValue = db_sql_encode($hash); $query = "SELECT * FROM blogTripUser " . "WHERE hash={$hashValue} " . "ORDER BY updated DESC " . "LIMIT 1"; $result = mysql_query($query); if (!$result) { // Error executing the query print $query . "<br/>"; print " --> error: " . mysql_error() . "<br/>\n"; return null; } if (mysql_num_rows($result) <= 0) { // Object does not exist return null; } // Create an instance with a special ID '-' to bypass the // checks on empty ID. The ID value will be overwritten by the // value coming back from the database anyway. $object = new TripUser('-', '-'); if ($object->loadFromResult($result)) { return $object; } return null; }