I have two tables, posts and categories. In posts table there is a field categoryId. I want that only those posts are shown category of which is in enabled state, i.e. for which categories.enabled = true.
How to specify a port other than 3000 to run a create-react-app based app?
This post will show you how to specify a port other than 3000 for an app based on create-react-app. This solution is valid if your app is based on create-react-app.
MYSQL – Useful commands you must know – Part-1
To know the current MYSQL version: SELECT version(); To format and formulate a float value: FORMAT(SUM(amount) * 0.6, 2) The above line sums up entire amount value, cut it down to 60% of total value and returns value precised up…
Setting up folder permissions for WordPress on Amazon EC2 (Amazon Linux)
Are you facing file uploading errors or not able to install plugins or upload files through ftp to your EC2 installation of WordPress? Possibly folder permissions?? Read on.
How to create simple counter app using Redux with React
Redux is a great tool to manage states. To share state among various components in React is always a challenge. Hence it is very useful and helpful to manage state amongh various components using Redux with React.
Passing data from child to parent component in ReactJS
Here is parent Passing data from child to parent component will look like Parent
MySQL ‘show tables’: How to list tables in a MySQL database?
This is very commonly asked question: How do I show or list all the tables in a MySQL (or MariaDB) database using mysql command line tool? In brief, to show the tables in a MySQL database, run the command:
file_get_contents(): SSL operation failed with code 1 certificate verify failed
I got this error when I moved a site to new server. It was a simple file_get_contents() call to read an image file. If i copy pasted the url of the same file to open in browser it would open…
Useful Linux commands – Linux Commands Cheatsheet
Following are some of the most commonly used Linux/Unix commands which I have to use at times while managing hosted sites on my and client’ server. Making a list for my own personal reference and ease. Someone may also find…
How to Replace a Text String in a MySQL Table Field Value
In this simple tutorial you will learn to replace a text string in a MySQL table field value. I have a races table in which I store race event information. In the date field I store event date. Since these…
