database - Read For Learn

How to retrieve the data from the sever and displaying it in a page?

So in this case, the problem is that your line right before the echo call is incomplete: $number_rows= $wpdb->get_var( “SELECT COUNT(*) FROM $wpdb->daviddgl_wp1.SaveContactForm7_7” ); $x=1; while ($x<$number_rows) { $results = $wpdb->get_results(“SELECT ticket, name,email FROM $wpdb->daviddgl_wp1.SaveContactForm7_7 WHERE id = $x”); print_r($results); $x++; } (You’re missing the closing bracket and semi-column) Note also that your echo will … Read more

WordPress Block developer from exporting Database via PHP

First of all, as Mark suggested in the comment: never use developers you don’t trust. Once you give a developer FTP | Git | SSH etc. access to your site, he or she can do anything you can from the admin panel & even more. There is no way to stop them that will not … Read more

WP User Query with Custom Fields and Search Results

Not sure if you ever found the answer, but just in case, I just did 🙂 There’s a hook I (finally!) found that lets you do this and works in a similar way to posts_where. The hook is pre_user_query. Here’s an example on the Codex: https://developer.wordpress.org/reference/hooks/pre_user_query/#user-contributed-notes With the above, your function could now look like … Read more

Is it possible to use WP_Query to only pull posts with attachments?

From the research I was doing, and from hearing from Kero in the comments, it would appear that querying for posts with attachments via WP_Query isn’t possible in a concise manner. With that in mind, I changed my podcasting plugin to no longer pull posts with attachments (since that could ultimately be unreliable anyway), and … Read more

Does WordPress store the username as a primary key in the database?

WP is not likely going to add this feature… From https://core.trac.wordpress.org/ticket/14644, the main reason given by Nacin is: This is a caching issue. Additionally, it also breaks URLs and such, which is why I don’t think administrators should be able to do it either. Seems simple enough to relegate to a plugin, or a straight … Read more

Blob file download problem

There are some security issues. Please sanitize your input because someone can download from Your database something different than archive, or simply drop Your database. $fid = sanitize_text_field( $_GET[‘fid’] );

creating new field on mysql

You can find any additional information in the usermeta table as meta_key meta_value pairs. Wordpress doesn’t create additional database columns for custom fields. That’s one of the great concepts that make WordPress so smart and flexible.

How to keep variable `$post` to using in another file

$post isn’t set in an admin-ajax.php request because you’re not querying for any post or inside a loop. In your script that sends the ajax request you’ll need to send the post ID and retrieve a post object in the callback: function ajax_cart_send_mail(){ $post = get_post( $_POST[‘post_id’] ); $id = $post->ID; $name = $post->post_title; } … Read more

Changing between Local Host DB to Production DB and in reverse

The short answer is — no, there is no simple way. WP is designed to work within a boundries of a single database as installed and with core exclusively manipulating that data. There are no concepts of database being manipulated partially and externally. The most common and reliable workflow is that you copy database from … Read more

How to delete database without using any plugin?

If the database server is available publicly you should be able to use a MySQL client to interact with it. Sequel Pro is a good one for mac, check this list if you need something for windows or linux. If the database is only available locally on your web server, you might be able to … Read more

+ More