The Art of Cinematic Composition
The Art of Cinematic Composition Read More »
Only Noobs Build Beautiful Websites
5 pilars: Humans are patterns recognition machines Use multiples of number 4 for sizes
Only Noobs Build Beautiful Websites Read More »
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:
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 »
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;
Lock MYSQL tables before exporting tables Read More »