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…
Hindi Phonetic Typing Tool for MS Word
Since I need to type in Hindi (Devnagari script) frequently and since I am not any good at typing in traditional Hindi keyboard I have to depend upon some Hindi Phonetic Typing Tool as my only long term savior and…
.htaccess pcfg_openfile: Linux- unable to check htaccess file, ensure it is readable and that public_html is executable
I am on ENTOS 7.6 xen. In order to fix some permissions error n files I ran the following while staying on the parent folder to public_html chown -R mysiteaccount:mysiteaccount public_html
