Resources

In MySQL the default value of a column should be null or empty? What are the pros and cons?

In MySQL, when defining a  column, you have the option to set a default value. Whether you should set it to NULL or an empty value (0 in the case of INTEGER) depends on your specific use case and requirements. Here are the pros and cons of each approach: Setting the default value to NULL:

In MySQL the default value of a column should be null or empty? What are the pros and cons? Read More »

Understand & Use $wpdb Global Object WordPress

The $wpdb object is defined in the wp-includes/wp-db.php file. This file contains the class wpdb that extends the wpdb class from the db.php file. Understanding the $wpdb object and its class file is crucial for effective WordPress database operations. As you continue your WordPress journey, mastering this alongside the PHP language will empower you to

Understand & Use $wpdb Global Object WordPress Read More »

WordPress and PHP tips

Debug echo ‘<pre>’; print_r($points_sum); echo ‘</pre>’; var_dump($wpdb->last_query); Three ways to pull data from the database. https://wordpress.stackexchange.com/questions/14239/wpdb-get-row-only-returns-a-single-row 1.$wpdb->get_var:use this to get a single value from the database table. Like if you want to count the total number of comments. You can do it in following way: <?php $comment_count = $wpdb->get_var($wpdb->prepare(“SELECT COUNT(*) FROM $wpdb->comments;”)); echo ‘<p>Total comments:

WordPress and PHP tips Read More »

How To Make Any Page Layout Using The WordPress Block Builder Gutenberg

Table Of Contents 00:00:00 Build Pages With Gutenberg 00:01:00 The 3C’s Of All Page Building 00:03:07 How The 3C’s Work In Page Builders 00:05:26 Your Big Stumbling Block 00:06:43 Block Builder Interface 00:07:08 Setting Up Your Page Settings 00:08:07 Adding The 3C’s To Block Builder 00:08:39 Setup Kadence Blocks Defaults 00:11:28 Optional Block Navigator 00:12:28

How To Make Any Page Layout Using The WordPress Block Builder Gutenberg Read More »

Shopping Cart
Scroll to Top