Example Machine Learning with MySQL via PHP with Apache2
- Apache2
- php7.1-mysql
- php7.1
- PHP-ML (0.6+)
If you did want to run this yourself without tinkering, you should install PHP-ML using composer as in their guide and set up MySQL to look for files in /var/lib/mysql-files/, have apache2 look for html in /var/www/html/ and also store a dbconfig.php
<?php
$host = 'localhost';
$dbname = 'Youtube';
$username = 'root';
$password = 'yourpassword';
?>in you home/bin/. Then when ready run
./UpdateSQLDataBase.sh && ./deploydeploy will attempt to open localhost in firefox so change that if you want.
Note there's a
// because ML...
<?php ini_set('memory_limit','4096M'); ?>in YoutubeSQL.php since the data is so large, even with just using the first 1000 rows!
- Using Youtube trending data from Kaggle
- Forming a MySQL database with a bash generated script
- Doing some basic MLP classification from tokenised descriptions and some other simple attributes to detemine the category and some other things
- Using PHP-ML to do the machine learning because why not learn some more PHP
