Awesome
MINI 2
What is MINI 2 ?
An extremely simple PHP barebone / skeleton application built on top of the wonderful Slim router / micro framework [1] [2] [docs].
MINI is by intention as simple as possible, while still being able to create powerful applications. I've built MINI in my free-time, unpaid, voluntarily, just for my personal commercial and private use and uploaded it on GitHub as it might be useful for others too. Nothing more. Don't hate, don't complain, don't vandalize, don't bash (this needs to be said these days as people treat tiny free open-source private scripts like they paid masses of money for them). If you don't like it, don't use it. If you see issues, please create a ticket. In case you want to contribute, please create a feature-branch, never commit into master. Thanks :)
Mini currently uses Slim 2.6.0.
There's also MINI 1, an earlier version of MINI2, but with totally different code! Since August 2016 there's also MINI 3, an improved version of MINI 1. While MINI2 uses Slim under the hood, MINI 1 and 3 are 100% native PHP.
Features
- built on Slim
- RESTful routes
- extremely simple: the entire application is just 2 .php files (plus external dependencies plus view templates)
- uses Twig as template engine, others are possible (via Slim packages)
- uses pure PDO instead of ORM (it's easier to handle)
- basic CRUD functions: create, read, update/edit and delete content
- basic search
- basic AJAX demo
- (optional) shows emulated PDO SQL statement for easy debugging
- (optional) compiles SCSS to CSS on the fly
- (optional) minifies CSS on the fly
- (optional) minifies JS on the fly
- (optional) dev/test/production switch
By default MINI allows user access to /public folder. The rest of the application (including .git files, swap files, etc) is not accessible.
Requirements
- PHP 5.3+
- MySQL
- mod_rewrite activated, document root routed to /public (tutorial below)
Maybe useful: Simple tutorials on setting up a LAMP stack on Ubuntu 14.04 LTS and 12.04 LTS.
License
MIT, so feel free to use the project for everything you like.
Screenshot
Support the project
Support the project by renting a server at DigitalOcean or just tipping a coffee at BuyMeACoffee.com. Thanks! :)
<a href="https://www.buymeacoffee.com/panique" target="_blank"><img src="https://cdn.buymeacoffee.com/buttons/v2/default-yellow.png" alt="Buy Me A Coffee" style="height: 60px !important;width: 217px !important;" ></a>
Installation (in Vagrant, 100% automatic)
If you are using Vagrant for your development, then you can install MINI with one click (or one command on the command line). MINI comes with a demo Vagrant-file (defines your Vagrant box) and a demo bootstrap.sh which automatically installs Apache, PHP, MySQL, PHPMyAdmin, git and Composer, sets a chosen password in MySQL and PHPMyadmin and even inside the application code, downloads the Composer-dependencies, activates mod_rewrite and edits the Apache settings, downloads the code from GitHub and runs the demo SQL statements (for demo data). This is 100% automatic, you'll end up after +/- 5 minutes with a fully running installation of MINI2 inside an Ubuntu 14.04 LTS Vagrant box.
To do so, put Vagrantfile
and bootstrap.sh
from Mini/_vagrant
inside a folder (and nothing else).
Do vagrant box add ubuntu/trusty64
to add Ubuntu 14.04 LTS ("Trusty Thar") 64bit to Vagrant (unless you already have
it), then do vagrant up
to run the box. When installation is finished you can directly use the fully installed demo
app on 192.168.33.77
. As this just a quick demo environment the MySQL root password and the PHPMyAdmin root password
are set to 12345678
, the project is installed in /var/www/html/myproject
.
Auto-Installation on Ubuntu 14.04 LTS (in 10 seconds)
You can install MINI2 including Apache, MySQL, PHP and PHPMyAdmin, mod_rewrite, Composer, all necessary settings and even the passwords inside the configs file by simply downloading one file and executing it, the entire installation will run 100% automatically. See the bootstrap.sh file for more infos (and the default passwords). Keep in mind that this is quick dev setup, not a perfect choice for production for sure. This should work perfectly in every naked Ubuntu 14.04 LTS.
Download the installer script
wget https://raw.githubusercontent.com/panique/mini2/master/Mini/_vagrant/bootstrap.sh
Make it executable [is this necessary ?]
chmod +x bootstrap.sh
Run it! Boooooom. Give it some minutes to perform all the tasks. And yes, you can thank me later :)
sudo ./bootstrap.sh
Installation (manual)
1. Activate mod_rewrite and ...
Tutorials for Ubuntu 14.04 LTS and Ubuntu 12.04 LTS.
2. ... route all requests to /public folder of the script
Change the VirtualHost file from DocumentRoot /var/www/html
to DocumentRoot /var/www/html/public
and from
<Directory "/var/www/html">
to <Directory "/var/www/html/public">
. Don't forget to restart. By the way this is also
mentioned in the official Slim documentation, but
hidden quite much.
3. Edit the development database configs
Inside public/index.php
edit the database credentials and fill in your values.
4. Execute the SQL statements
In _install
folder (for example with PHPMyAdmin) to create the demo database.
5. Get dependencies via Composer
Do a composer install
in the project's root folder to fetch the dependencies (and to create the autoloader).
Basic usage
See index.php in /public. The code below will basically show /view/subpage.twig when user moves to yourproject.com/subpage !
$app->get('/subpage', function () use ($app) {
$app->render('subpage.twig');
});
Same like above here, but this time the $model is passed to the route (use ($app, $model)
), so it's possible to
perform model actions (database requests, data manipulation, etc). Action getAllSongs() is called, the result $songs
(obviously an array of songs) passed to the view (view/songs.twig) via 'songs' => $songs
.
$app->get('/songs', function () use ($app, $model) {
$songs = $model->getAllSongs();
$app->render('songs.twig', array(
'songs' => $songs
));
});
Inside the view the data is easily rendered like this (the template engine Twig is used here). Twig makes the view
extremely simple and secure. Instead of doing this <?php echo htmlspecialchars($song->id, ENT_QUOTES, 'UTF-8'); ?>
inside your HTML-Twig-template you can simply do {{ song.id }}
which automatically escapes and echos $song["id"]
,
$song->id
etc. Fantastic! See the full Twig documentation here.
{% for song in songs %}
<tr>
<td>{{ song.id }}</td>
<td>{{ song.artist }}</td>
</tr>
{% endfor %}
The content of the model (currently in Mini\model\model.php
) is extremely simple, it's just some methods getting data.
When the model is initialized the database connection is created automatically (just one time for sure). A typical
model method:
public function getAllSongs()
{
$sql = "SELECT id, artist, track, link FROM song";
$query = $this->db->prepare($sql);
$query->execute();
return $query->fetchAll();
}
Configuration
Index.php holds the configs for a development environment. Self-explaining.
$app->configureMode('development', function () use ($app) {
$app->config(array(
'debug' => true,
'database' => array(
'db_host' => 'localhost',
'db_port' => '',
'db_name' => 'mini',
'db_user' => 'root',
'db_pass' => '12345678'
)
));
});
Environment switch (development / test / production)
To implement a production config simply copy the whole config block above and replace development with production. Add an environment variable to your Apache config. More here and here.
Before/after hooks
Slim can perform things at certain points in the lifetime of an application instance, for example before everything is started. MINI uses this to perform SASS-to-CSS compiling and CSS / JS minification via external tools (loaded via Composer btw). This is inside the above development environment configuration to make sure these actions are not made in production for sure.
$app->hook('slim.before', function () use ($app) {
// SASS-to-CSS compiler @see https://github.com/panique/laravel-sass
SassCompiler::run("scss/", "css/");
// CSS minifier @see https://github.com/matthiasmullie/minify
$minifier = new MatthiasMullie\Minify\CSS('css/style.css');
$minifier->minify('css/style.css');
// JS minifier @see https://github.com/matthiasmullie/minify
$minifier = new MatthiasMullie\Minify\JS('js/application.js');
$minifier->minify('js/application.js');
});
Why $_POST['x'] instead of Slim's post/get handler ?
Because it's simpler and more native. Feel free to use the Slim handlers if this fits more your workflow.
Why is the deletion of a song not made with a DELETE request ?
Because (against popular opinion) HTML4/5 does not support other HTTP methods than GET/POST (but the browsers themselves do). The most easy workaround is doing this with GET/POST. Please write a ticket if I'm totally wrong here.
Glitches
/songs/
is not the same as/songs
!- Writing the initialization in the short syntax like
$app = new \Slim\Slim(array('view' => ...));
has some issues and might eventually break your application. Using the syntax like in index.php works fine. @see http://help.slimframework.com/discussions/questions/954-twig-getenvironment-function-no-longer-available-using-slim-views
Useful: Organize view templates in sub-folders
It's possible to organize the view templates for sure, simply do $app->render('folder1/folder2/index.twig');
.
Useful: Multiple router files
When all the routes in index.php are too much for you: Create a folder routers
, put your route(r)s into files like
xxx.router.php
and load them like this:
$routers = glob('../routers/*.router.php');
foreach ($routers as $router) {
require $router;
}
Useful: get URL inside view (1)
Twig can get the URL, use this in the app
$twig->parserExtensions = array(
new \Slim\Views\TwigExtension(),
);
and then use {{ baseUrl() }}
in the view template.
Useful: get URL inside view (2)
Or manually add the baseUrl
:
$app->hook('slim.before', function () use ($app) {
$app->view()->appendData(array('baseUrl' => '/base/url/here'));
});
and use it in the view template via {{ baseUrl }}
.
More here.
Scripts used
SASS Compiler https://github.com/panique/php-sass
CSS / JS Minifier http://www.mullie.eu/dont-build-your-own-minifier/
Interesting
http://de.slideshare.net/jeremykendall/keeping-it-small-getting-to-know-the-slim-php-microframework
Injecting stuff into $app: http://www.slimframework.com/news/version-230
Slim apps https://github.com/ccoenraets/wine-cellar-php https://github.com/xsanisty/SlimStarter
https://github.com/indieisaconcept/slim-bower-server/blob/master/app/config.php
Route URL Rewriting / Installation http://docs.slimframework.com/#Route-URL-Rewriting
Change log
- [panique] upgrade from Slim 2.5 to 2.6
- [panique] upgrade from Slim 2.4.3 to 2.5.0
- [sim2github] renamed model path to uppercase to fit PSR-4