The Code Manager integrates very well with WP Data Access and lets WP Data Access users write their own code and use it in their own projects and publications.
- Write your own CSS
- Add interactivity with JavaScript
- Use PHP to add server logic
Resources #
Share reusable code #
Want to share your code? Please get in touch!
Hello,
I want to keep records of the files downloaded from my site. For this, I want to create a new table with wp data access. There will be (user_id, media_id, datetime, user ip) fields in this table.
When the user wants to download a file, I will first check this table and if user has downloaded it, I will not allow again. Otherwise I want to add a row to this table after the download.
function isdownloaded (user_id, media_id)
function addnew (user_id, media_id, user_id)
How can I write these functions in wp code manager?
Hi Ali,
Good question! 🙂
You can write a PHP shortcode and access your table from your shortcode. If your table is stored in your WordPress database, you can use $wpdp to access the database. If your table is stored in another (remote) database, you can use WP Data Access class WPDADB like this:
$wpdadb = \WPDataAccess\Connection\WPDADB::get_db_connection( $database);
Where $database is the database where your table is stored. You can use $wpdadb just like you would use $wpdb. Class WPDADB is a sub class of WordPress class wpdb.
Hope this helps,
Peter