⚙️ Setup romaniNL-pro

connect_error){echo '
❌ Eroare conexiune MySQL: '.$db->connect_error.'

Verifică că XAMPP rulează și MySQL este pornit.

';exit;} $db->query("CREATE DATABASE IF NOT EXISTS romaninl_pro CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci"); $db->select_db('romaninl_pro'); $db->set_charset('utf8mb4'); $sql=file_get_contents(__DIR__.'/install.sql'); $stmts=array_filter(array_map('trim',preg_split('/;\s*\n/',$sql))); $ok=0;$errs=[]; foreach($stmts as $s){ $s=trim($s); if(!$s||str_starts_with($s,'--')) continue; if($db->query($s)){$ok++;} else{ if(strpos($db->error,'Duplicate')===false&&strpos($db->error,'already exists')===false) $errs[]=$db->error.' → '.substr($s,0,60); } } // Reset parole $hash=password_hash('Test1234',PASSWORD_BCRYPT,['cost'=>10]); $db->query("UPDATE users SET password='$hash'"); $db->query("UPDATE users SET role='admin' WHERE email='admin@romaninl-pro.nl'"); echo '
'; echo '✅ '.$ok.' comenzi SQL executate'; foreach(array_slice($errs,0,5) as $e) echo '⚠️ '.$e.''; echo '✅ Parole resetate la: Test1234'; $cats=$db->query("SELECT COUNT(*) n FROM categories")->fetch_assoc()['n']; $subs=$db->query("SELECT COUNT(*) n FROM subcategories")->fetch_assoc()['n']; $jobs=$db->query("SELECT COUNT(*) n FROM jobs")->fetch_assoc()['n']; $users=$db->query("SELECT COUNT(*) n FROM users")->fetch_assoc()['n']; echo '
'; echo ""; echo ""; echo ""; echo ""; echo '
TabelÎnregistrări
👥 Utilizatori$users
📋 Categorii$cats
📂 Subcategorii$subs
💼 Anunțuri$jobs
'; echo '
'; echo '

🔑 Conturi de test

'; echo ''; echo ''; echo ''; echo ''; echo '
EmailParolăRol
admin@romaninl-pro.nlTest1234Admin
andrei@test.comTest1234Angajator
maria@test.comTest1234Utilizator
'; ?>
🌐 Deschide site-ul 🔐 Admin Panel 🧪 Testează API