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:
Continue readingI 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 just fine but the script would just die for the error similar to the one below.
Continue readingFollowing some of the most commonly used linux command which I have to use most of the times while managing hosted sites on my and client’ server. It is just few of them which I usually forget and just wanted to make a list here for my own personal reference.
Continue readingI have a date field in my mysql database table. I want to replace year 2017 in this field to 2019 Following command would do this.
UPDATE races SET `date` =REPLACE( `date` , ‘2018’, ‘2019’ ) WHERE INSTR( `date` , ‘2018’ ) >0
Just saving it for reference here.
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 partner.
For this position, I had been using Google Hindi Phonetic Typing Tool for last few years. It is sad that Google has stopped providing this Google Input Tool anymore and has replaced it with its online tool I had to look for an alternate.
Continue reading
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_htmlContinue reading
Looking for a free Windows 7 product key? I tried to find one and I did find one. So if your voyage to find a Windows 7 product key free only hasn’t shored anywhere yet, it might now. Read on. Continue reading
If you are looking for Hindi Phonetic Typing Tool support, check this post instead.
This is a web tool to convert content written using Hindi fonts such as Kruti Dev 10, Krishna etc. In first text field given here you paste content copied from your file and push Convert into Unicode Hindi button. The converted text would show in second box. You can use this tool effectively to convert Hindi to Unicode (web) content online or offline.
Continue readingIt is possible to add multiple Google Recaptcha on single page. Here is an example of adding Google Recaptcha in two different forms and adding custom validation to them. This example illustrates using how response ids are created when rendering of form and later using them to create custom validation on the time of submission of this form. Example uses jQuery to handle form submission events and the action of adding fields dynamically to forms where you don’t have an access to the building or rendering of the form. Continue reading
Sometimes you want to know the location of a function defined in your php application. For example you are debugging a large online web application or website. To continue debug you want to enter into a function to debug. You don’t have an easy way to download all the files to your location system to do a text search. Also you don’t have access to file system search capabilities on the server. How to get into the function? Continue reading