queries inside of a class

class MyClass{
    function __construct(){
        global $wpdb;
        $this->db = $wpdb;
    }

    function query(){
       return $this->db->query( 
            $this->db->prepare("INSERT INTO {$this->db->wp_competitors} (id, ield_key, field_value) VALUES ( %d, %s, %s )",
            1, $field_key, $field_value) 
       );
    }
}

Related Posts:

  1. How to return number of found rows from SELECT query
  2. Can i use php sql functions instead of $wpdb?
  3. $wpdb->get_results(…) returns empty array despite correct query
  4. $wpdb->delete column values IN ARRAY()?
  5. wpdb::prepare was called incorrectly
  6. Custom query to get post names beginning with a digit
  7. How to display only first value of database column in WordPress
  8. Print out WordPress user ID – two sites with same code but different output
  9. WPDB: how to get the value of a field in a custom database table
  10. Can’t use get_results() in ajax query
  11. Export WordPress Table to CSV from page
  12. WordPress get pagination on wpdb get_results
  13. $wpdb->flush(); breaks the loop
  14. Call External Object in Class Function During Callback
  15. Why is variable not working on custom sql query using wpdb?
  16. Show MySQL errors that occur when I excute $wpdb->insert()
  17. Any possible way to make $wpdb->get_results() return anything else than array?
  18. database interactions using OOP
  19. how to delete 30 day old data using PHP [closed]
  20. Echo a hierarchical list of post data from custom fields
  21. WSoD being caused by this piece of code
  22. Querying wpdb using PHP
  23. Update results, Before deleting the related category [closed]
  24. How WordPress reacts to a lack of memory of the server [closed]
  25. wpdb php get_var query to get ID for URL image doesn’t work for ID over 999
  26. Database query works fine outside WordPress
  27. $wpdb->insert() does not Insert record in a table
  28. Help with a $wpdb MySQL Query
  29. Fatal error: Call to a member function query() on a non-object
  30. Error using WordPress $wpdb object to get result from custom table
  31. How to retrieve the data from the sever and displaying it in a page?
  32. $wpdb returns duplicate posts
  33. Can’t update multiple rows with $wpdb query
  34. Mixing variables into an array when inserting values
  35. Wpdb->insert() doesn’t insert new row after the last one
  36. How can I add a new row in a separate database when someone registers via WordPress?
  37. How to get specific attribute from DB
  38. I can’t update my data through $wpdb
  39. Output: “Array”
  40. How to use mysql LIKE with wpdb?
  41. PHP -> SQL Query with Summing
  42. How to insert wp_users ->user login name to wp_terms when a new user registering?
  43. Delete database record using plugin from admin panel
  44. Cannot access $wpdb, comes back NULL
  45. Wpdb get->results to out the the month from the db
  46. How to use AJAX in WordPress in MYSQL query?
  47. Change MySQL PDO connection to a WPDB connection
  48. $wpdb->get_results breaking page?
  49. form $_post action value gets truncated after it passes through two forms
  50. Why my query does not run with prepare
  51. WPDB secure custom form
  52. wpdb getting avatars and author url
  53. Add row to custom database Table and delete all rows older than 1 day
  54. Call to a member function get_row() on a non-object, Unable to use global $wbdp inside a plugin
  55. select a single val though a table in wordpress
  56. WordPress SQL JOIN query
  57. populate select options from extra mysql table data
  58. Query the links Database
  59. Fetching review value using wpdb class
  60. MySQL Query Returns Array () In Shortcode
  61. Add posts to custom table in database instead of wp_posts
  62. Isn’t Returning Value While Using SELECT COUNT(*) FROM {$wpdb->prefix}
  63. Passing in MySQL prepare statement parameter separately throwing error
  64. Convert a column of a table containing an Array as response in HTML
  65. Database SQL query error
  66. WordPress SQL Prepare
  67. Creating multiple tables with Plugin
  68. MYSQL TIMESTAMP when adding DATE_FORMAT then the output is blank, PHP conflict?
  69. Conditional formatting on data fetched from MYSQL
  70. What is the correct way to search 3 custom fields only in WordPress?
  71. How do I create a WP endpoint that retrieves all custom post types that have a tag?
  72. Modify post image in full size
  73. 403 Forbidden WordPress Database Results
  74. How to grab data from input and store it into custom table in database?
  75. problem in using wpdb->prepare and a string placeholder
  76. Advanced WordPress SQL Query
  77. MySQL query in WordPress with AJAX
  78. Accessing external database: ERR_INCOMPLETE_CHUNKED_ENCODING
  79. MySQL queries in WordPress
  80. Order by in foreach
  81. How to fetch results from database
  82. At what point during a typical request does the $wpdb object become available?
  83. Using the same shortcode to show any table from the database
  84. AJAX with Selectbox Plugins (Select2, Chosen, Selectize)
  85. Get null from POST
  86. Querying multiple meta_keys in WordPress SQL query
  87. Fetching wpdb data from a php file seems to break?
  88. How do you get a reference to $wpdb in a PHP script
  89. Insert into db with foreach problem
  90. posts_clauses drop ACF get_field function
  91. WordPress Query -> Ajax Query
  92. how to display tables via ajax
  93. inner-wrap div pushing custom table far down on page
  94. use wpdb object on other file
  95. I have an error WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version
  96. Warning: Undefined property: wpdb::$question_overview in C:\Wamp.NET\sites\proxyvragenmodule\wordpress\wp-includes\class-wpdb.php
  97. WordPress / PHP: Check if column has value and then check if value in array
  98. Putting form result in my database
  99. SQL – How to echo out inside of where statement
  100. How can I update a value of a field depending on outside source?

Leave a Comment