Go to file
cExplorer 9823e43614 change order 2023-01-14 10:15:07 +01:00
assets change order 2023-01-14 10:15:07 +01:00
.gitignore fix file name 2019-03-11 09:37:56 +01:00
README.md add inserting datetime 2021-06-26 10:26:52 +02:00
htaccess.template added auth to word_admin.html 2019-03-26 11:31:07 +01:00
index.html add rezize canvas 2022-10-10 21:03:54 +02:00
index_simple.html add bootstrap form stuff, change to submit with enter 2022-03-23 20:14:31 +01:00
word_admin.html add exec show functions after deleting 2023-01-14 10:06:58 +01:00

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