SQL Query to Update Portion of a String Uncategorized by Rajesh Kumar Sahanee - September 27, 2019September 27, 20190 Hello Friends, Today I am going to share sql query to update portion of a string in mysql. The following is the SQL syntax to update portion of a string. [crayon-694246fcc42ae993200422/] Create Table Query The below create table query will create a table with name user_transactions. [crayon-694246fcc42bb784859885/] Insert Query The below query will add some data to
Configure FTP Server(vsftpd) for Multiple User with Different Home Directory Tricks by Rajesh Kumar Sahanee - August 3, 2019April 14, 20200 Hello Friends, Today we are going to configure FTP Server(vsftpd) for multiptle user with different home directory. In previous post we have already learned how to configure FTP Server(vsftpd) on Google Cloud Compute Engine. If you not already read that post and not configured ftp server then click here to
How to Setup FTP Server (vsftpd) on Google Cloud Compute Engine Tricks by Rajesh Kumar Sahanee - August 1, 2019April 14, 20200 Hello Friends, Today we are going learn how to Setup FTP Server (vsftpd) on Google Cloud Compute Engine. Actually one of my client was asking for google cloud based ftp server but this thing was totally new for me and for that reason I had to do research on this
WebView Based Android App with ProgressBar and SwipeRefreshLayout Android by Rajesh Kumar Sahanee - July 22, 2019July 22, 20190 Hello Friends, Today we are going to see another example of WebView based App, but this time it will be WebView Based Android App with ProgressBar and SwipeRefreshLayout. Here ProgressBar helps us to see progress of page loading while SwipeRefreshLayout is used to refresh the same page with just a
ListView inside Navigation Drawer in Android Android by Rajesh Kumar Sahanee - July 18, 2019July 18, 20190 Hello Friends, Today I am going to share a code to place ListView inside Navigation Drawer in Android. A list view is an adapter view that does not know the details, such as type and contents, of the views it contains. Instead list view requests views on demand from a
Open Navigation Drawer Programmatically in Android Android by Rajesh Kumar Sahanee - July 11, 2019April 5, 20200 Hello Friends, Today I am going to share a code to Open Navigation Drawer Programmatically in Android. And to do so you just need DrawerLayout's reference and then you can call openDrawer(int) function on it to open drawer. You can also close Drawer programmatically using closeDrawer(int) function but you don't
Calculate Balances from Debit and Credit Column in MySQL Uncategorized by Rajesh Kumar Sahanee - June 30, 2019June 30, 20190 Hello Friends, Today I am going to share that how to calculate balances from debit and credit column in MySQL. If you have to show individual transactions and also want to keep a running balance column at the same time then this article will surely help you. Actually this query
Login with Google in Android Android by Rajesh Kumar Sahanee - June 9, 2019July 11, 20190 Hello Friends, Today I am going to share a code to login with Google in Android. Today Almost all mobile and web apps allow us to login with google. Login with google feature in any app is very convenient feature, because of this feature we don't have to create and
Next Increment Id in MySQL using PHP Php by Rajesh Kumar Sahanee - June 6, 20190 Hello Friends, Today I am going to share that how to get next increment id in mysql using php. Actually MySQL has AUTO_INCREMENT keyword to perform auto increment on a column value. AUTO_INCREMENT by default starts from 1 and It is incremented by 1 for each new record. To get
Url Rewriting like WordPress Php by Rajesh Kumar Sahanee - June 2, 2019June 2, 20190 Hello Friends, Today I am going to share a code for Url rewriting like WordPress do. I have taken help to develop this code from WordPress codex link mentioned below:- https://core.trac.wordpress.org/browser/tags/5.2/src/wp-includes/class-wp-post-type.php#L532 https://core.trac.wordpress.org/browser/tags/5.2/src/wp-includes/class-wp-matchesmapregex.php Actually, these days I am developing CMS in which I was required to do Url rewriting code. So to do Url
