SmartUni MySQL Migration Notes 1. Import database_schema_mysql.sql in phpMyAdmin first. 2. Update db.php if your MySQL username/password/database name is different. Default for XAMPP is usually: username: root password: empty database: socmed 3. This version uses mysqli and includes temporary sqlsrv_* compatibility functions in db.php. This keeps the project working while moving from SQL Server to MySQL. 4. SQL Server syntax updated: GETDATE() -> NOW() ISNULL() -> COALESCE() SELECT TOP n -> LIMIT n SQL Server IF OBJECT_ID table creation -> MySQL CREATE TABLE IF NOT EXISTS