mysql

Performing CRUD operations on front end in wordpress

Yes. You can do. Try using ajax, or better? using wordpress rest api Ajax method: need register your function and action to do Simple example: add_action( ‘wp_ajax_my_action’, ‘my_action’ ); add_action( ‘wp_ajax_nopriv_my_action’, ‘my_action’ ); function my_action() { return json_encode(‘hello word’); } jQuery(document).ready(function() { var data = { ‘action’: ‘my_action’ }; jQuery.post(ajax_url, data, function(response) { alert(response); }); … Read more

Query to fetch custom taxonomy along with post title

If we want to display taxonomy name along with post title in backend MYSQL query you can use this query :- SELECT p.ID,taxonomy,post_title,post_status,name FROM wp_posts p, wp_term_relationships rel, wp_terms t, wp_term_taxonomy te where p.ID = rel.object_id AND t.term_id=te.term_id AND t.term_id=rel.term_taxonomy_id AND taxonomy in (‘taxonomy’) AND Post_type=”post” and name=”name of taxonomy”

Why last row deleted when refresh page

I think the reason for the error is you are not creating a form for it, so the last result being used in the foreach is assigning that $print->id to $id. If you did this foreach ( $result as $print ) { ?> <tr> <form method=”POST” action=”{page url}”> <td><?php echo $print->id; ?></td> <td><?php echo $print->names; … Read more

+ More