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

SOME BASIC IDEA ABOUT $wpdb OBJECT AND ITS CLASS FILE For performing database operations WordPress provides a class wpdb which is present in the file – wp-includes\wp-db.php. This class abstracts the database functions for WordPressand most WordPress functions directly or indirectly use this class.We can create an object of this class to perform database operations …

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 »

Lock MYSQL tables before exporting tables

  Ensure a consistent snapshot by executing this statement to lock the tables so that they cannot be modified during export: mysql> FLUSH TABLES hr.employees, hr.managers WITH READ LOCK; While the lock is in effect, the tables can still be used, but only for read access. Unlock the tables: mysql> UNLOCK TABLES;

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 »

ChatGPT Crash Course | 10 Practical Use Cases For Developers

  Εxamples of 10 ways to use OpenAI’s ChatGPT as a developer including general learning, getting feedback, writing tests and more ChatGPT: https://chat.openai.com Full Blog Post: https://www.traversymedia.com/blog/ch… Timestamps: 0:00 – Intro 2:14 – The Interface 3:31 – #1 – General Learning Tool 9:24 – #2 Code Feedback 10:57 – #3 Specific Solutions 12:39 – #4 …

ChatGPT Crash Course | 10 Practical Use Cases For Developers Read More »

Artificial Intelligence (AI) tools for web developers

1. https://textblaze.me/moh — Texual task automation 2. http://durable.co — AI website builder 3. http://tldv.io — AI meeting recorder 4. http://whatthediff.ai — AI code reviewer 5. http://tabnine.com — AI coding assistant 6. http://testkit.app — AI testing tool 7. http://aiseo.ai — AI writing assistant 8. http://uizard.io — AI web designing tool 1. https://textblaze.me/moh — Texual task automation …

Artificial Intelligence (AI) tools for web developers Read More »

Microsoft Inclusive Design

https://inclusive.microsoft.design/ Learn the Inclusive Design principles Get tools and activities See Inclusive Design in action Get started with web  https://www.microsoft.com/design/fluent/#/web Styles https://developer.microsoft.com/en-us/fluentui#/styles/web Controls https://developer.microsoft.com/en-us/fluentui#/controls/web Resourses https://developer.microsoft.com/en-us/fluentui#/resources

Scroll to Top

Don’t miss these tips!

Join us to get informed about our new posts and tips!

We don’t spam! Read our privacy policy for more info.