Can i use php sql functions instead of $wpdb?

There are a few different reasons.

1. Separation of Concerns

Fundamentally, your logical code (i.e. your plugin or your theme) should not need to know anything about the database. At all. Really.

The $wpdb object is the global database access layer, and you should be using it for all of your database access. If you need to run a custom query (let’s say you have a custom table somewhere) then you should use $wpdb->prepare() and $wpdb->query() to prepare your queries and fetch data from the database.

2. Security

It’s very easy to forget to sanitize a query and open your site to some kind of SQL injection attack. Using WordPress’ built-in sanitation methods is one way of protecting against this. It’s not perfect (you could still write a really bad query) but it definitely helps.

3. Performance

The queries built in to the WordPress API have been poured over by several developers and tweaked to run with the smallest memory footprint and return as quickly as possible. In addition, some of these API calls are self-caching, so you can “query” for data that hasn’t changed and is already in memory. This is a huge performance benefit over making a direct SQL call.

And with every new version of WordPress, we make changes to make things faster and more nimble.

4. Flexibility and Stability

The database is not a fixed construct. The table schema can and will change. Hard-coding queries to WordPress objects in your own code is an inflexible maintenance nightmare. When a new version of WP drops, you’ll have to rewrite your queries again … opening yourself up to potential vulnerabilities (#2) again or negatively impacting your site’s performance (#3).

The Bottom Line

All of PHP is still available to you. You can make direct connections to whatever database you need and run whatever queries you want. But WordPress has already (in the majority of cases) done the heavy lifting and abstracted these calls for you.

The benefit of using $wpdb is that it’s already there, is maintained by several developers, and is well-documented. You don’t have to reinvent the wheel. And you know, if WordPress changes, it will change along with it for you.

Related Posts:

  1. How to return number of found rows from SELECT query
  2. $wpdb->delete column values IN ARRAY()?
  3. Custom query to get post names beginning with a digit
  4. WordPress get pagination on wpdb get_results
  5. Ajax $wpdb not returning table data
  6. Converting MYSQL to WordPress $WPDB
  7. Why is variable not working on custom sql query using wpdb?
  8. Show MySQL errors that occur when I excute $wpdb->insert()
  9. Can’t get wp_insert_post to work
  10. WSoD being caused by this piece of code
  11. I want to select the from values from database in WordPress? [closed]
  12. Update results, Before deleting the related category [closed]
  13. wp query foreach deleting record returning only first or last item
  14. Database query works fine outside WordPress
  15. Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
  16. $wpdb->insert() does not Insert record in a table
  17. Help with a $wpdb MySQL Query
  18. Custom array from a query only write the last row of the query
  19. $wpdb returns duplicate posts
  20. Mixing variables into an array when inserting values
  21. Use $wpdb or other PHP script method to find/replace in WP database
  22. How can I add a new row in a separate database when someone registers via WordPress?
  23. Basic wpdb update question
  24. I can’t update my data through $wpdb
  25. Output: “Array”
  26. How to use mysql LIKE with wpdb?
  27. How do I prepare strings for insertions as values into a MySQL table?
  28. How to use AJAX in WordPress in MYSQL query?
  29. form $_post action value gets truncated after it passes through two forms
  30. Why won’t this wpdb get_results query return results?
  31. WPDB secure custom form
  32. Add row to custom database Table and delete all rows older than 1 day
  33. select a single val though a table in wordpress
  34. populate select options from extra mysql table data
  35. Query the links Database
  36. MySQL Query Returns Array () In Shortcode
  37. Passing in MySQL prepare statement parameter separately throwing error
  38. Convert a column of a table containing an Array as response in HTML
  39. Database SQL query error
  40. MYSQL TIMESTAMP when adding DATE_FORMAT then the output is blank, PHP conflict?
  41. Conditional formatting on data fetched from MYSQL
  42. What is the correct way to search 3 custom fields only in WordPress?
  43. Using wpdb to connect to a different database is not working
  44. Rewrite SQL query as a prepared statement and use in foreach loop
  45. Advanced WordPress SQL Query
  46. MySQL query in WordPress with AJAX
  47. Passed variable gets undefined variable error on insert on next page
  48. MySQL queries in WordPress
  49. Using the same shortcode to show any table from the database
  50. MySQL database migration to WordPress
  51. Error resetting database index using ALTER TABLE in $wpdb->query
  52. Putting form result in my database
  53. How can I update a value of a field depending on outside source?
  54. dbDelta support for FOREIGN KEY
  55. is it possible to run some php code within a wordpress page?
  56. How to use update and delete query in wordpress
  57. How to implement WP_List_Table? WP_List_Table giving array instead of a value in listing table
  58. queries inside of a class
  59. MySQL query performed 4 times inside loop
  60. Show only one post for each author ( Page loads too slow )
  61. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  62. Modern Tribe Calendar wp-query with meta query not working at all
  63. WP database error for comments_popup_link()
  64. Insert all post IDs in new database table
  65. Is the outdated PHP mysql extension a requirement for WordPress 4.6?
  66. Get WooCommerce product details and transfer them to a custom DB table
  67. How can I export posts with featured images, without download them
  68. What is a valid parent for get_terms()?
  69. Calculating a large number of MYSQL queries as customshort codes, slow
  70. Sum the total amount of a specific product purchased per user and display in table
  71. $wpdb->wp_users returning empty value for
  72. Error using WordPress $wpdb object to get result from custom table
  73. How to retrieve the data from the sever and displaying it in a page?
  74. Make a database query using WordPress
  75. Cannot access $wpdb, comes back NULL
  76. Using wordpress function to retrieve data
  77. making php value numeric
  78. Add posts to custom table in database instead of wp_posts
  79. Please help! I have a problem with getting wordpress databas
  80. How to run complex query using PHP
  81. Creating multiple tables with Plugin
  82. Can I split a huge wp_postmeta table across different databases or servers?
  83. WordPress mysql deos not work with php7
  84. How do I create a WP endpoint that retrieves all custom post types that have a tag?
  85. Error inserting into custom table – Object of class wpdb could not be converted to string [closed]
  86. WP + MySql db / PHP
  87. The plugin generated 225 characters of unexpected output during activation
  88. append data to mysql table via submit button coded in php – not working
  89. WordPress select query issue
  90. How to do a MySql query in WordPress?
  91. Add two or multiple functions in WordPress Post or Page
  92. Send data from plugin to external database
  93. How to set max users to 17.000
  94. directorypress theme error mysql_error() [closed]
  95. Querying multiple meta_keys in WordPress SQL query
  96. Cannot Upload Custom Header Image into WordPress Dashboard
  97. How do you get a reference to $wpdb in a PHP script
  98. Predefine Magazine Style Layouts
  99. Parse error: syntax error, unexpected ‘}’ in C:\xampp\htdocs\admin\products.php on line 148 [closed]
  100. How to set variable to specific field when querying

Leave a Comment