table - Read For Learn

Carrying information from button click into form [closed]

The better way to do this is using javascript/jquery. Use either javascript webstorage api or jquery ajax $.post. Webstorage api will be good for this. Here how you can do it. $(‘body’).on(‘click’, ‘.button.small’, function(){ var index = $(this).parents(‘table’).index(‘table’); var cur_workshop = $(this).parents(‘.innercontent’).find(‘h3’).eq(index).text(); localStorage.setItem(‘workshop’, cur_workshop); }); Place above script on http://yft.ac/upcoming-workshops/ this page template. Then call … Read more

get_var result empty for query of custom table in plugin admin

There’s error in your query statement. Change to this $post_id = $wpdb->get_var( “SELECT post_id FROM $customtable WHERE uniquecode=”$uniquecode” AND blog_id = ‘$user_blog_id'” );

MailPress plugin: table inline style tag removed when sending the newsletter

SOLVED, the problem wasn’t with wordpress. Just a couple of css and table formatting issues was the cause of gmail displaying wrong my table. In desktops and mobile email clients was looking just good so I was assuming the problem were beyond my html table code. But the own developer of the plugin review it … Read more

Database custom table issues – incorrect result displayed

Not sure why you’re getting a WSOD, but immediately I can see that in the following: $selectedSchoolName = $wpdb->get_results( “SELECT Name FROM tblYBSSchool WHERE SchoolID=”.$SelectedSchoolID ); // get selected location name $selectedLocationName = $wpdb->get_results( “SELECT Name FROM tblYBSLocality WHERE LocalityID=”.$SelectedLocationID ); // get route ID $getRouteID = $wpdb->get_results( “SELECT * FROM tblYBSRoute WHERE RouteID IN … Read more

Display single post inside accordion based on form submission results

Closing off as the issue is resolved. For anyone interested, the result is as follows (refer to the code detailed above for the initial DB-table connections, as the code below refers to the output only): if (isset($SelectedLocationID) && isset($SelectedSchoolID)) { ?> <div id=”resultsDiv”> <div id=”resultsHead”> <h3>Search results for routes between:</h3> <b><?php echo $selectedLocationName; ?></b> and … Read more

Search Query that Includes Custom Table

I managed to solve this by taking s_ha_dum’s suggestion to use a UNION. It is as follows: (SELECT ID, post_status, post_title, post_excerpt, post_content FROM wp_posts WHERE ((`post_title` LIKE ‘%diamond%’) OR (`post_excerpt` LIKE ‘%diamond%’) OR (`post_content` LIKE ‘%diamond%’)) AND (`post_status` = ‘publish’ )) UNION (SELECT ref, StoreID, Article, subarticle, description FROM wp_hwproducts WHERE (`article` LIKE ‘%diamond%’) … Read more

Insert double entry in DB

Simple – if you do not want duplicate information then before you insert anything check if such data is already present. Just query for it and see if there is a match. From WP perspective however, you seem to be looking at technique (database table) that you will rarely need in practice. WordPress offers wealth … Read more

Add pagination to table generated by wp_query

As already pointed out in comments gb_bypass_filter is not a valid parameter for WP_Query. If you want to suppress to effect of filters on your query, add ‘suppress_filters’ => true to your query arguments previous_posts_link() does not accept two arguments, only one. Unlike next_posts_link(), it does not have the second $max_pages parameter. So you can … Read more

Plugin does not create a custom table upon activation

To answear my question: It’s a typo. `students_email` VARCHAR 850) NOT NULL, should be: `students_email` VARCHAR (50) NOT NULL, Oh the headache. When the typo is corrected it creates a new table.

Google does not index data from custom table used for a plugin

The problem was caused by canonical meta tag (thanks @Milo), as it had the same value for all of these pages. You have to avoid using the same value for canonical meta tag for pages with dynamic content. I changed it to be unique for every page. However it took google more than one month … Read more

+ More