README.md

CMS Tables - a site management system based on Symfony and Google Tables

---

Installation

Clone cms-tables:

git clone [email protected]:artemsites/cms-tables.git

OR:

git clone ssh://[email protected]:2222/artemsites/cms-tables.git

Copy and rename

.env.example -> .env 

Set connection MySQL in .env

DATABASE_URL="mysql://username:[email protected]:3306/dbname" 

Or with mysql version:

DATABASE_URL="mysql://username:[email protected]:3306/dbname?serverVersion=5.7.21" 

Copy Google Table (Sheet) to your drive

https://docs.google.com/spreadsheets/d/19NC3QrrWEvAwljyhzKF9LqCds4gtOvP5OAZUqqd3k-w/edit?usp=sharing

Change Key and Domain in Google Table

Внимание! Если у вас на сайте ещё нет https то необходимо в ссылке заменить https на http!

And set this key to .env file

Compress code to ZIP and upload to server (for example to shared hosting)

Setting HTTPS and redirect to it and setting last PHP version at you site in hosting panel or you server!

Update composer vendors (libs)

For example at shared hosting (beget.com):

cd some-site.com
php8.3 $(which ~/.local/bin/composer) update

If you are doing local development, then you need to create access to remote mysql

Migration tables to your database

php bin/console doctrine:migrations:migrate

Or:

php8.3 bin/console doctrine:migrations:migrate

It is migrate file migrations/Version[id].php to your database!

Then create first page at google table!

And upload this content to site!

1. Select the line (web page data) that you want to send to the site. 2-3. Send the changes to the website!

After that, the cache of this page will be reset and the updated content will be displayed on the site!

In this case, the content can be written directly to the content column, so you can place a link to html or md markup there so as not to clutter the table cell!

---

Features

Fill in the content as HTML or MD

Insert shortcodes like [[youtube id="7c238trc"]] into the content (HTML or MD)

---

Configuration

Vue the type of interpolation brackets is specified in .env:

SHORTCODE_START_REGEXP
SHORTCODE_END_REGEXP

It shouldn't be {{ }} - it's twig
It shouldn't be [ ] - this is md content
Probably better [[ ]]
! It is important to specify in REGEXP format, that is, special characters should be escaped [[ - otherwise they will be incorrectly read in REGEXP and will not be used

---

Shortcodes

Double brackets are selected as in MODx: [[shortcodename]],
because there is a conflict with md parsing
(there links look like name)

[[youtube id="7c238trc"]] - YouTube video output

Parameters:
id is the ID of a YouTube video

[[code code="some code"]] - code block output

Parameters:
code - if this is a link, then we will get the content that is located on the link

[[articles]] - output of all child articles for this url in the form of links