WordPress.DB.RestrictedFunctions.mysql_mysqli_fetch_array
mysql mysqli fetch array
The plugin uses a raw MySQL extension or class instead of WordPress database APIs.
Why It Shows Up
The scan found `mysql_*`, `mysqli_*`, PDO MySQL, or related database functions in plugin code.
Why It Matters
Bypassing `$wpdb` can ignore WordPress database configuration, escaping conventions, character sets, and compatibility layers.
How to Fix
- Replace raw MySQL calls with `$wpdb` methods or higher-level WordPress APIs.
- Use `$wpdb->prepare()` for dynamic values.
- If a third-party library requires a database connection, isolate it and document why WordPress APIs cannot be used.
References
Affected Plugins
| Rank | Plugin | Score | Errors | Warnings | Installs | Added | Updated | Top Issue |
|---|---|---|---|---|---|---|---|---|
| #1 | Brizy – Page Builder | 20 | 586 | 726 | 70k+ | Output is not escaped | ||
| #2 | Backup Migration | 21 | 981 | 1,093 | 80k+ | Non-prefixed global variable | ||
| #3 | Duplicator – Backups & Migration Plugin – Cloud Backups, Scheduled Backups, & More | 21 | 2,572 | 1,277 | 1m+ | Output is not escaped | ||
| #4 | wpDataTables – WordPress Data Table, Dynamic Tables & Table Charts Plugin | 21 | 1,812 | 1,432 | 70k+ | Output is not escaped | ||
| #5 | 1 Click Migration & Backup: Free WordPress Migration Plugin with Zero Downtime & Easy Clone | 24 | 140 | 193 | 400 | Direct Query | ||
| #6 | 404 Solution | 24 | 483 | 1,355 | 10k+ | Non-prefixed class | ||
| #7 | Backuply – Backup, Restore, Migrate and Clone | 24 | 711 | 556 | 600k+ | Non-prefixed global variable | ||
| #8 | Softaculous | 24 | 115 | 50 | 10k+ | file system operations fread | ||
| #9 | All 404 Redirect to Homepage | 25 | 140 | 301 | 200k+ | date date | ||
| #10 | SQL Executioner | 70 | 18 | 17 | 2k+ | Non-prefixed global variable | ||
| #11 | Run SQL Query | 78 | 13 | 8 | 600 | Non-prefixed global variable |
