Sunday, December 8, 2019

How to Install cPanel and WHM in CentOS 7

# hostnamectl set-hostname cpanel.tecmint.lan

#yum groupinstall base -y

# curl -o latest -L https://securedownloads.cpanel.net/latest

# sh latest

How to install Multiple Android Studio Versions

It's possible to have multiple versions of Android Studio installed simultaneously.You can install the new version without replacing your existing stable install.

Android Studio stores its settings in version specific folders; the exact locations depend on the operating system (and the versions of the IDE), but for example, if you have both Android Studio 1.5.1 and Android Studio 2.0 Preview 1 installed, these will consult settings in different directory.

Therefore, once you've installed the two versions, you can use them, even side by side, and they should not interfere with each other. (Note however that newer versions of the may change some of the configuration data in your projects (such as code style settings in .idea).
The first thing you’ll want to do with GitLab is create a new project. This is accomplished by clicking the “+” icon on the toolbar. You’ll be asked for the project’s name, which namespace it should belong to, and what its visibility level should be. Most of what you specify here isn’t permanent, and can be re-adjusted later through the settings interface. Click “Create Project”, and you’re done. <a href="https://git-scm.com/book/be/v2/Git-on-the-Server-GitLab" target="_blank">More..</a>

<code>cd existing_folder
git init
git remote add origin https://gitlab.com/amisalabir/crudproject.git
git add .
git commit -m "Initial commit"
git push -u origin master</code>

How to import large sql file using windows command line.

c:\xampp\mysql\bin>mysql -u root -p -h localhost 
Enter password: 
show databases;
Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 28 Server version: 10.1.21-MariaDB mariadb.org binary distribution Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> use database; source c:/xampp/mysql/bin/file_name.sql

How to concatenate self column in mysql

By using the following sql command we can edit a column with the value of same column: UPDATE tblclients SET phonenumber = concat('880',RIGHT(phonenumber,10)); 

Pass value from parent to child window in php

parent.php <?php $userid=37; echo "<form><input name=\"$userid\" align=\"center\" class=\"button btn btn-primary\" type=\"button\" onclick=\"window.open('popup.php?id='+$userid,'windowfrm','menubar=yes,toolbar=yes,scrollbars=yes,resizable=yes,width=783,height=auto')\" value=\"Printable Version\"></div>\n</form>\n\n"; ?> popup.php <?php $userid = $_GET['id']; echo $userid; ?>

Upload file to server using Power Shell Command

 scp file_name.zip username@server_ip/server_address:/directory_path