PHP Classes

Noter: Create and manage notes shared between users

Recommend this page to a friend!
  Info   View files Example   View files View files (22)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStarStar 70%Total: 209 All time: 8,367 This week: 125Up
Version License PHP version Categories
noter 0.41GNU General Publi...5.4PHP 5, Content management
Description 

Author

This package can be used to create and manage notes shared between users.

It can perform several types of operations requested by logged users on notes stored on SQLite database.

Currently each user can add, update, delete and search for stored notes.

Innovation Award
PHP Programming Innovation award nominee
September 2016
Number 9


Prize: One downloadable copy of Komodo IDE
Many teams need to collaborate sharing information between members.

There are many applications on the Web that can be used for this purpose. However, they require that the teams send information over the Internet to be stored in the infrastructure of a different company.

This package implements a simple notes sharing system that can be implemented on a intranet, so no information is sent to outside the company network.

Manuel Lemos
Picture of Martin Latter
  Performance   Level  
Name: Martin Latter <contact>
Classes: 8 packages by
Country: United Kingdom
Age: ???
All time rank: 130560 in United Kingdom
Week rank: 312 Up8 in United Kingdom Up
Innovation award
Innovation award
Nominee: 5x

Example

<?php

declare(strict_types=1);

#########################################
require('classes/sqlite.class.php');
require(
'classes/sqlitefunc.class.php');
require(
'classes/helpers.class.php');
#########################################

session_start();

require(
'includes/head.php');

?>

        <h1 id="indextitle">
            <a href="index.php" id="index"><?php echo CONFIG_APP_NAME; ?></a>
            <a href="<?php echo (isset($_SESSION['sVerifiedName'])) ? 'menu.php' : 'edit.php'; ?>" id="edit">&#9998;</a>
        </h1>

<?php
Helpers
::outputSearchForm();
?>

        <div id="notecont">

<?php

$oNote
= new SQLiteFunc();


if ( ! isset(
$_POST['search_flag']))
{
    echo
$oNote->lastNotesEntered();
}
else
{
   
$aResults = $oNote->search($_POST['term'], $_POST['choice']);

    if (
$aResults[0])
    {
        echo
$aResults[1];
    }
    else
    {
        echo
'<p class="error">' . $aResults[1] . '</p>';
    }
}

?>

        </div>

<?php

require('includes/foot.php');


Details

Noter

Share notes across devices on a local network.

[1]: https://tinram.github.io/images/noter.png ![noter][1]

Purpose

  • Share notes easily across different devices and operating systems on a local network.
  • Avoid awkward device connections, network shares, or Internet transfer.

Noter's focus is simplicity &ndash; browser display and search, with a log-in to add, edit, and delete notes.

The log-in offers basic protection from unauthorised tampering via password obfuscation and session timeout.

Noter was created for an isolated network where plain text transfer and viewing is acceptable, and without determined adversaries. Noter is NOT suitable for storing sensitive data.

A single SQLite database file facilitates easy backup, transfer, and source control of data.

A Raspberry Pi, with Apache and PHP installed, could make an ideal low-powered always-on host for Noter.

Requirements

  • PHP server with version 7.2+ and sqlite3 module enabled

Setup

Clone the repository (or extract the ZIP archive) into the server's web directory e.g.

    cd /var/www/html

    sudo git clone https://github.com/Tinram/Noter.git

    sudo chown -R <username>:www-data Noter/

(Debian-based; use apache instead of www-data for Red Hat-based distros)

    sudo chown www-data Noter/log/badlog.txt

    sudo chmod 600 Noter/log/badlog.txt

SQLite file operation (requires actioning on the directory itself):

    sudo chown -R www-data Noter/db/

Check the configuration file constants: config/config.php Only the timezone, session timeouts, CONFIG_NUM_NOTES_DISPLAYED, and user credentials are of immediate interest.

Change the users and the user password hashes (CONFIG_USER1, CONFIG_USER1_PASS). The default users are martin and alison, and both passwords are P@55w0rd. (More users can be added here, and editing the relevant locations in classes/login.class.php.)

Passwords are stored as SHA-256 hashes. CONFIG_USER1_PASS etc should be replaced with a hash generated from either a website service or by running one of the following commands in a terminal and copying the output hash:

Bash

    echo -n 'PASSWORD' | sha256sum

PHP

    php -r "echo hash('sha256', 'PASSWORD');"

Python

    python -c "import hashlib;print(hashlib.sha256('PASSWORD'.encode()).hexdigest())"

    python3 -c "import hashlib;print(hashlib.sha256('PASSWORD'.encode()).hexdigest())"

Manually Create the SQLite Database

Noter includes an initial SQLite database: db/noter.sqlite3

However, where GitHub importing does not permit binary files (e.g. PHPClasses and the noter.sqlite3 file is consequently missing, the file will need to be created manually &ndash;

In a terminal:

    cd db/
    sudo sqlite3 noter.sqlite3
    .read noter_schema_data.sql
    .exit
    sudo chown www-data:www-data noter.sqlite3

Viewing and Searching

http://localhost/Noter

http://IP.add.re.ss/Noter

or better, configure an Apache vhost and access with:

Noter

Adding and Editing

http://localhost/Noter/edit

or if Apache rewrite is disabled:

http://localhost/Noter/edit.php

Upon logging-in through this page, notes can be added, updated, or deleted.

<pre>...</pre> and <code>...</code> tags can be used to highlight code snippets.

<pre>...</pre> preserves whitespace (both spaces and copy/pasted tabs).

<code>...</code> does not preserve whitespace.

Most types of link references will be automatically converted into HTML links upon note addition (but not on note updating).

Other Files

The SQLite database schema is available at db/noter\_schema.sql

The SQLite database schema and initial data is available at db/noter\_schema\_data.sql

Unsuccessful log-in attempts are recorded in log/badlog.txt

Credits

  • Angel Marin and Paul Johnston: JavaScript SHA-256 hash function.
  • Andrew Ellis: link regex.

Miscellaneous

Noter was originally created as a second language flashcard viewer (to which it can be easily reverted).

Noter was never created for coding elegance, merely to do a simple job in minimal code. It's like my car: looks ancient, runs quite well.

License

Noter is released under the GPL v.3.


  Files folder image Files  
File Role Description
Files folder imageclasses (4 files)
Files folder imageconfig (1 file)
Files folder imagecss (1 file)
Files folder imagedb (2 files)
Files folder imageincludes (2 files)
Files folder imagejs (2 files)
Files folder imagelog (1 file)
Accessible without login Plain text file .htaccess Data Auxiliary data
Accessible without login Plain text file add.php Example Example script
Accessible without login Plain text file delete.php Example Example script
Accessible without login Plain text file edit.php Example Example script
Accessible without login Plain text file index.php Example Example script
Accessible without login Plain text file LICENSE Lic. License text
Accessible without login Plain text file menu.php Aux. Auxiliary script
Accessible without login Plain text file README.md Doc. Documentation
Accessible without login Plain text file update.php Example Example script

  Files folder image Files  /  classes  
File Role Description
  Plain text file helpers.class.php Class Class source
  Plain text file login.class.php Class Class source
  Plain text file sqlite.class.php Class Class source
  Plain text file sqlitefunc.class.php Class Class source

  Files folder image Files  /  config  
File Role Description
  Accessible without login Plain text file config.php Aux. Auxiliary script

  Files folder image Files  /  css  
File Role Description
  Accessible without login Plain text file noter.css Data Auxiliary data

  Files folder image Files  /  db  
File Role Description
  Accessible without login Plain text file noter_schema.sql Data Auxiliary data
  Accessible without login Plain text file noter_schema_data.sql Data Auxiliary data

  Files folder image Files  /  includes  
File Role Description
  Accessible without login Plain text file foot.php Aux. Auxiliary script
  Accessible without login Plain text file head.php Aux. Auxiliary script

  Files folder image Files  /  js  
File Role Description
  Accessible without login Plain text file common.js Data Auxiliary data
  Accessible without login Plain text file edit.js Data Auxiliary data

  Files folder image Files  /  log  
File Role Description
  Accessible without login Plain text file badlog.txt Doc. Documentation

 Version Control Unique User Downloads Download Rankings  
 100%
Total:209
This week:0
All time:8,367
This week:125Up
 User Ratings  
 
 All time
Utility:91%StarStarStarStarStar
Consistency:75%StarStarStarStar
Documentation:83%StarStarStarStarStar
Examples:91%StarStarStarStarStar
Tests:-
Videos:-
Overall:70%StarStarStarStar
Rank:244