cExplorer bf0e8b10da add bootstrap form stuff, change to submit with enter		7 months ago
assets	mitigate possible sql injection	7 months ago
.gitignore	fix file name	4 years ago
README.md	add inserting datetime	1 year ago
htaccess.template	added auth to word_admin.html	4 years ago
index.html	polish canvas screen size	7 months ago
index_simple.html	add bootstrap form stuff, change to submit with enter	7 months ago
word_admin.html	add missing doctype	7 months ago

README.md

wordcloud

Install

Clone the repo git clone https://gitlab.com/tigexplorer/wordcloud.git
Prevent accessing git files from the web, activate and edit the htaccess file
```
mv htaccess.template .htaccess
nano .htaccess
```
Set admin access (creating .htusers_wordcloud with user/ password, replace my-web-path with yours path, replace myAdminUser with yours) htpasswd -c my-web-path/.htusers_wordcloud myAdminUser

Create database

mysql -u MYUSER -p
create database `wordcloud`;
grant CREATE,ALTER,SELECT,INSERT,UPDATE,DELETE,INDEX,DROP on `wordcloud`.* to 'MyWordcloudUSER'@'localhost' identified by 'MyPassword';
SHOW databases;
SELECT User FROM mysql.user;

Create tables

USE wordcloud;
CREATE TABLE IF NOT EXISTS words (
    word_id INT AUTO_INCREMENT,
    word VARCHAR(255) NOT NULL,
    word_date_time DATETIME,
    PRIMARY KEY (word_id)
)  ENGINE=INNODB;

SHOW TABLES;

Set db access

cp assets/php/db_conf_pdo.inc.php.template assets/php/db_conf_pdo.inc.php
nano assets/php/db_conf_pdo.inc.php