Database

How to add download link from database on custom page template?

/*you’re expecting a single row result so better use $wpdb->get_row ..$id I guess it’s numeric so dont’use quote*/ global $wpdb; $download = $wpdb->get_row(“SELECT realname FROM odm_data where id=”.$id); <a href=”https://wordpress.stackexchange.com/questions/308676/download.php?file=<?php echo $download->realname ?>”>Download</a>

database error WordPress move from one hosting to other

The credentials for your database are located in the wp-config.php file. Make sure those settings are correct. In particular, non-ASCII characters may be causing a problem. Or an extra space in any value (especially the password). Look at the user/pass/dbname in your host also. An extra space at the end of the password in wp-config … Read more

create a table using user meta custom data

See how the data is stored in the database in the table “wp_usermeta” Find the storage keys for “points”, “training completed” Then using the function https://codex.wordpress.org/Function_Reference/get_users $users = get_users( $args ); foreach ( $users as $user ): echo $user->ID; echo $user->display_name ; echo get_user_meta( $user->ID, ‘KEY_POINTS’, $single = true); echo get_user_meta( $user->ID, ‘KEY_TRAINING_COMPLETE’, $single = … Read more

error establishing database connection (WAMP + filezilla)

If everything is normal ( i.e., web server is working, ) you should care for only following things when creating new wordpress site. define(‘DB_NAME’, ‘db_name’); /** MySQL database username */ define(‘DB_USER’, ‘user_name’); /** MySQL database password */ define(‘DB_PASSWORD’, ‘db_password’); /** MySQL hostname */ define(‘DB_HOST’, ‘localhost’); db_name : name of the database that will hold your … Read more

WP website showing blank page after moving from subdomain to main domain

you need to see below post to move word-press site one server to other Ref :- WordPress link some simple steps follow and change site location you can update your database using following queries UPDATE wp_options SET option_value = replace(option_value, ‘https://www.oldurl’, ‘https://www.newurl’) WHERE option_name=”home” OR option_name=”siteurl”; UPDATE wp_posts SET guid = replace(guid, ‘https://www.oldurl’,’https://www.newurl’); UPDATE wp_posts … Read more

+ More