WordPress.DB.RestrictedFunctions.mysql_mysqli_connect
mysql mysqli connect
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 | WPPizza – A Restaurant Plugin | 18 | 4,689 | 2,703 | 1k+ | Text Domain Mismatch | ||
| #2 | GoUrl Bitcoin Payment Gateway & Paid Downloads & Membership | 20 | 1,832 | 720 | 700 | Non Singular String Literal Domain | ||
| #3 | Backup Migration | 21 | 981 | 1,093 | 80k+ | Non-prefixed global variable | ||
| #4 | WP phpMyAdmin | 21 | 4,528 | 6,435 | 50k+ | Missing Arg Domain | ||
| #5 | wpDataTables – WordPress Data Table, Dynamic Tables & Table Charts Plugin | 21 | 1,812 | 1,432 | 70k+ | Output is not escaped | ||
| #6 | Data Tables Generator by Supsystic | 22 | 164 | 198 | 10k+ | Exception output is not escaped | ||
| #7 | Smart Popup by Supsystic | 22 | 3,120 | 492 | 10k+ | Non Singular String Literal Domain | ||
| #8 | File Manager | 22 | 740 | 520 | 1m+ | Unsafe printing function | ||
| #9 | WPBot – AI ChatBot for Live Support, Lead Generation, AI Services | 23 | 514 | 1,220 | 5k+ | Non-prefixed global variable | ||
| #10 | Redirection | 23 | 523 | 457 | 100k+ | Non-prefixed global variable | ||
| #11 | Clone | 23 | 244 | 262 | 40k+ | Output is not escaped | ||
| #12 | WP-CRM System – Manage Clients and Projects | 23 | 297 | 1,094 | 800 | Non-prefixed global variable | ||
| #13 | 1 Click Migration & Backup: Free WordPress Migration Plugin with Zero Downtime & Easy Clone | 24 | 140 | 193 | 400 | Direct Query | ||
| #14 | A2 Optimized WP – Turbocharge and secure your WordPress site | 24 | 271 | 231 | 60k+ | Missing Arg Domain | ||
| #15 | Backuply – Backup, Restore, Migrate and Clone | 24 | 709 | 555 | 600k+ | Non-prefixed global variable | ||
| #16 | Screen Reader Accessibility – WCAG, Text-to-Speech & AI Accessibility Fixes | 24 | 235 | 330 | 600 | Non-prefixed global variable | ||
| #17 | Softaculous | 24 | 115 | 50 | 10k+ | file system operations fread | ||
| #18 | WEB-Translation – eTranslation Multilingual | 25 | 217 | 1,057 | 400 | Non-prefixed function | ||
| #19 | TranslatePress – Translate Multilingual sites with AI Translation | 25 | 583 | 1,673 | 400k+ | Non-prefixed hook name | ||
| #20 | Social Media Share Buttons & Social Sharing Icons | 25 | 2,433 | 1,383 | 100k+ | Unsafe printing function | ||
| #21 | Social Share Icons & Social Share Buttons | 25 | 2,365 | 1,357 | 10k+ | Output is not escaped | ||
| #22 | RSS Redirect & Feedburner Alternative | 26 | 277 | 272 | 1k+ | Output is not escaped | ||
| #23 | EZ SQL Reports Shortcode Widget and DB Backup | 27 | 165 | 158 | 500 | Output is not escaped | ||
| #24 | Void Contact Form 7 Widget For Elementor Page Builder | 28 | 279 | 66 | 10k+ | Text Domain Mismatch | ||
| #25 | Duplicate Post | 28 | 448 | 255 | 300k+ | Unsafe printing function | ||
| #26 | Pop-up | 31 | 103 | 91 | 10k+ | Output is not escaped | ||
| #27 | Ultimate Posts Widget | 31 | 309 | 86 | 10k+ | Output is not escaped | ||
| #28 | Enhanced Text Widget | 34 | 101 | 58 | 30k+ | Output is not escaped | ||
| #29 | SSL Mixed Content Fix | 34 | 53 | 65 | 8k+ | Output is not escaped | ||
| #30 | WPPerformanceTester | 35 | 94 | 44 | 1k+ | Output is not escaped | ||
| #31 | Graphina – Charts and Graphs For Elementor | 39 | 1,910 | 113 | 10k+ | Text Domain Mismatch | ||
| #32 | SQL Executioner | 70 | 18 | 17 | 2k+ | Non-prefixed global variable | ||
| #33 | Run SQL Query | 78 | 13 | 8 | 600 | Non-prefixed global variable | ||
| #34 | WP PHP Version Display | 90 | 6 | 4 | 3k+ | trademarked term | ||
| #35 | Display PHP Version | 96 | 6 | 2 | 30k+ | Missing direct file access protection |
