task

|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||

Problem : PHP-FPM pool is consuming a substantial amount of memory, the reason server get's crashed.

Solution :  We have adjusted the standard configuration for better handling of PHP-FPM processes

sudo nano /opt/bitnami/php/etc/php-fpm.d/www.conf

pm = static

pm.max_children = 25   # Reduce if memory is high

|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||

 

In this video, I'll guide you through the process of creating your MySQL and phpMyAdmin containers. Later on, I'll show you how to access the MySQL database using phpMyAdmin.

$ docker create volume mariadb-volume

$ docker run -p 3307:3306 -v mariadb-volume:/var/lib/mysql --name Practiceflow_Mariadb10_3 -e MYSQL_ROOT_PASSWORD=34278wtfea4rDXe57RDEu4643wedFRdc -d mariadb:10.3

$ docker run --name my-phpmyadmin -d -p 8080:80 -e PMA_ARBITRARY=1 phpmyadmin/phpmyadmin

mysql -u root -p --host=127.0.0.1 --port=3307
http://container-ip:8080

Note : If you encounter connection issues with phpMyAdmin, try specifying the MySQL container's IP address in the server section of phpMyAdmin.

|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||

 

 

|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||

How to Calculate Percentage of your Marks:

1) Eng 50
2) Mat 56
3) Sci 88
4) Eco 66
5) Eng 76
6) Pol 52
_______________

Total= 388
_______________

388/600*100= 64%


How to Calculate Percentage of Any Amount :  20000 x 2% / 100 = 400

 

 

|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||

 

FYI: IonCube Loader should be installed On Every PHP Project.

IonCube Loader is a PHP extension that is used to decode encrypted PHP files at runtime. It is commonly used by developers to protect their PHP code from unauthorized access and to prevent it from being reverse-engineered. 

|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||

Connect EC2 Instance Via “Session Manager”

a) Create EC2 Role and Assigne "AmazonSSMManagedInstanceCore" Policy
b) Assigne that role to desried ec2 instance.
c) Check and connect after 2 min

|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||

1) Html Row and Table Generate  https://www.htmlcodegenerator-tools.com/

2) Create Html table code via excel file just save the file in .html and open it on notepad

$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$

For your Information :

Wildcard certificate can secure unlimited subdomains of the 1st level subdomain by default.
Ex 1st level subdomain: dev.domain.com, demo.domain.com

and if you also want to secure 2nd level subdomain with the same Wildcard certificate, So can't do it in namecheap.
you need to purchase another another wildcard certificate, those will secure 2nd level subdomain.
Ex 2nd level subdomain: delhi.dev.domain.com, mumbai.demo.domain.com  

 

$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$

How To Add Code Box In Blog

@Below Is the Code

<form><textarea cols="100" onclick="select()" readonly="" rows="10">

Here-Write-Or-Paste-Your-Code-And-Text

</textarea></form>

 

$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ 

Install Let's Encrypt SSL On WHM/Cpanel

1) install snapd and certbot -----> from certbot website
2) stop httpd service
3) sudo certbot certonly --standalone
4) you will get certificate files in -----> /etc/letsencrypt/live/
5) upload following files in cpanel

a) cert.pem
b) privkey.pem
c) chain.pem(Bundle)

 

$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$

 

###If you are getting Error during making database connection on adminser or phpmyadmin ###

So, kindly add below command on mysql configuration file then restart database.

Error : The server requested authentication method unknown to the client

vim /etc/mysql/mysql.conf.d/mysqld.cnf

default_authentication_plugin= mysql_native_password

$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$

### new changes not reflecting in s3 bucket ###

The main advantage of using CloudFront is to get your files from a source (S3 in your case) and store it on edge servers to respond to GET requests faster. CloudFront will not go back to S3 source for each http request.

For immediate reflection of your changes, you have to invalidate objects in the Cloudfront
- Distribution list -> settings -> Invalidations -> Create Invalidation.

Write /* for all object
This will clear the cache objects and load the latest ones from S3.

$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$

#Issue

I am getting en error in Apache since long time. And the issue is that after some time,
reverse proxy rules removed from Apache virtual host automatically.

#Cpanel_Reply

The most common reason that a configuration setting would get removed from WHM/Cpanel when rebuilding the httpd.conf file is because the modification was done directly to the configuration file. When cPanel rebuilds the apache conf, it does so using template files and any configuration not in those templates are not included.

#Solution_cPanel Apache Reverse Proxy

Step 1. Download The Proxy Script

wget https://raw.githubusercontent.com/varunsridharan/cpanel-apache-proxy/main/proxy.sh

Step 2. Run To Create A New Proxy

sh proxy.sh "cpanelAccountName" "blog.example.com" "http://192.168.1.41:32000"

Step 3. Rebuild & Restart HTTP /scripts/rebuildhttpdconf && service httpd restart
 
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$

https://awspolicygen.s3.amazonaws.com/policygen.html


$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$

====================================================================================== DNS changes usually take 24 to 48 hours to fully start working. This period is called propagation, which is the projected length of time it takes for root name servers and cache records across the entire web to be updated with your website's DNS information. A RECORDS An A record points a hostname to an IP address. To point just example.com to an IP address. ====================================================================================== MX RECORDS are used to deliver email associated with your domain name, such as info@yourdomain.com, to the appropriate mail server, for instance, mail.yourdomain.com. Name.com Email customers If you have purchased Name.com email and created email addresses, an MX record has been automatically generated for your domain name and you do not need to do anything more to route email associated with your domain name to our mail server. On the preceding web page, you should see an MX record with yourdomain.com listed as the Record Host and mx3.name.com denoted as the Record Answer. Third-party email service customers If you are using a third-party mail server, create an MX record on this page in which you leave the Record Host name field blank and enter the name of your third-party mail server into the Record Answer field. Customers who provide their own email service If you are using your own mail server, you must do the following. First, create a Host record with the name of your mail server (most often mail.yourdomain.com or smtp.yourdomain.com) in the host name field and the Internet Protocol (IP) address of your mail server in the IP address field. Second, make an MX record in which you leave the Record Host name field blank and enter the name of your mail server (again, mail.yourdomain.com or smtp.yourdomain.com) in the Record Answer server field. ====================================================================================== CNAME RECORDS A CNAME or Canonical Name record points a host name with no other records to another valid hostname. The Canonical Name you use shouldn’t have any other DNS records associated with it. Please note that CNAME records should be used rarely—an ANAME record or A record (for common aliases and host names) should be used instead where possible. A bare CNAME (ie: no “www”) will break MX records and prevent email from working. We recommend placing the CNAME on the “www” subdomain. If you do not understand what CNAME records are used for, we strongly suggest that you do not tinker with them. Misuse of CNAME records can cause problems with the resolution of your domain name and potentially bring down your site. ====================================================================================== What is diffrence between A Record and CNAME ? An A Record maps a hostname to one or more IP addresses, while the CNAME record maps a hostname to another hostname. ====================================================================================== TXT RECORDS TXT or text records can be used to enter arbitrary text strings into a DNS entry. ====================================================================================== SRV RECORDS An SRV record can be used to encode the location and port of services on a domain name. When encoding, the priority field is used to encode the priority. More info about SRV records is available at wikipedia.com ====================================================================================== IPV6 (AAAA) RECORDS An IPV6 (AAAA) record can point a host name to an IPV6 IP address. To point just helmtickets.com to an IP address, leave the "Record Host" field blank. To point helmtickets.com to an IP address enter www into the "Record Host" field. To point all sub domains for helmtickets.com (that do not already have a host record) to an IP address enter * into the "Record Host" field. You can add multiple host records for a domain name. ====================================================================================== NS RECORDS An NS record allows you to delegate authority for a hostname to another nameserver. You’ll need to know the hostname of the nameserver you wish to delegate authority to. NS Records can ONLY be created on subdomains. ====================================================================================== ANAME RECORDS An ANAME record is a Name.com-specific feature that automatically finds and updates A and AAAA records from the target. Unlike CNAME records, ANAMEs can be placed next to other records (one per hostname). ANAME records are commonly known as ALIAS records or CNAME flattening. ======================================================================================

$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
CI/CD Key Components

Build

The build phase is usually the one that starts the whole pipeline. Whenever the developer pushes the code to a repository, the build phase of CI/CD will be triggered. As mentioned in the previous section, the outcome of the build phase will depend on the languages and technologies used. Nevertheless, the successful completion of the build phase should result in a new software release being created.

Test

The Test phase can happen a few times in the whole process. You can execute a different set of tests at the beginning and at the end of the pipeline. After the initial build phase, it's common to run unit tests on the newly created software release. This step will determine if written code does what it's supposed to do. Later in the process, you can run the test phase again to execute integration or any other tests. In fact, you can run the test phase after every other phase in the process.

Remember that one of the key points of CI/CD is to spot issues as soon as possible. Therefore, instead of running one test phase at the end of the pipeline with all possible tests, it's better to split them logically into smaller test phases. For example, there is no need to run integration tests if unit tests are failing.

Deploy

The deploy phase can also happen multiple times in one pipeline. First, in a development environment, staging and production shouldn't happen at the same time, right? It's common to run basic tests first, then deploy to a staging environment, then run more tests and only then deploy to production.



$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$

Docker is a tool that helps in developing, building, deploying and executing software in isolation. It does so by creating containers that completely wrap a software. Containers are software that wrap up all the parts of a code and all its dependencies into a single deployable unit that can be used on different systems and servers. ====================== Docker Environment ====================== 1) Docker Engine 2) Docker Registry 3) Docker Objects 4) Docker Compose 5) Docker Swarm ==================== 1) Docker Engine ==================== Docker engine is as the name suggests, its technology that allows for the creation and management of all the Docker Processes. It has three major parts to it. 1) Docker CLI 2) Docker API 3) Docker Daemon ==================== 2) Docker Registry ==================== Docker registries as storage locations for Docker Images. These images can be versioned in the registry as well. ==================== 3) Docker Objects ==================== 1) Docker Images : are sets of instructions that are used to create containers and execute code inside it. 2) Docker Containers 3) Docker Volumes : are basically persistent storage locations for the containers. They can be easily & safely attached and removed from different container. And they are also portable from system to another 4) Docker Swarm Nodes Services 5) Docker Networks : is basically a connection between one or more containers.One of the more powerful things about the Docker containers is that they can be easily connected to one other and even other software, this makes it very easy to isolate and manage the containers ==================== 4) Docker Compose ==================== For Now let’s just understand that Docker Compose is just a Service within Docker that let’s us launch multiple containers at the same time. ==================== 5) Docker Swarm ==================== Docker Swarm is a service within Docker that allows us to manage multiple containers.

$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$

How To Run React Code In Docker Container

npx create-react-app react-docker
cd react-docker
vim server.js

==========================================================
const express = require("express");
const path = require("path");

const app = express();

app.use(express.static(path.join(__dirname, "./build")));
app.get("/*", (req, res) => res.sendFile(path.join(__dirname, "./build/index.html")));

const PORT = process.env.PORT || 4040;

app.listen(PORT, () => console.log(`Server started on port ${PORT}`));
==========================================================

vim Dockerfile
==========================================================
FROM node
WORKDIR /app
COPY . /app
RUN npm install
RUN npm install pm2 -g
RUN npm run build
EXPOSE 4040
CMD ["pm2-runtime", "server.js"]
==========================================================

docker build .
docker run image-id -itd -p 4040:4040



$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
IMUNIFY360 IS A COMPREHENSIVE SECURITY SUITE FOR LINUX WEB SERVERS.
Antivirus, Firewall, WAF, PHP Security Layer, Patch Management,Domain Reputation with easy UI and advanced automation.

uses For cPanel, Plesk, Direct Admin and stand-alone installation


$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$

how-to-backup-and-restore-iptables-on-centos-7-rhel-7

Step 1 : To take iptables backup
iptables-save > iptables.bak


Step 2 : To restore iptables
iptables-restore < iptables.bak


$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
Command line instructions

Git global setup
git config --global user.name "Administrator"
git config --global user.email "admin@example.com"


=======================
Create a new repository
=======================

git clone git@100.100.7.4:root/flexsin-sys-inventory.git
cd flexsin-sys-inventory
touch README.md
git add README.md
git commit -m "add README"
git push -u origin master

=======================
Existing folder
=======================

cd existing_folder
git init
git remote add origin git@100.100.7.4:root/flexsin-sys-inventory.git
git add .
git commit -m "Initial commit"
git push -u origin master

=======================
Existing Git repository
=======================

cd existing_repo
git remote rename origin old-origin
git remote add origin git@100.100.7.4:root/flexsin-sys-inventory.git
git push -u origin --all
git push -u origin --tags



$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$

All Domain Name Server

https://www.godaddy.com
NS49.DOMAINCONTROL.COM
NS50.DOMAINCONTROL.COM

Hostinger NameServer
ns1.dns-parking.com
ns2.dns-parking.com

AWS NameServer
ns-1036.awsdns-01.org
ns-1863.awsdns-40.co.uk
ns-575.awsdns-07.net
ns-297.awsdns-37.com

Name.com NameServer
ns1dhl.name.com
ns2fgv.name.com
ns3cjl.name.com
ns4dfh.name.com

BlueHost.com NameServer
NS1.BLUEHOST.COM
NS2.BLUEHOST.COM

INMOTIONHOSTING.COM NameServer
NS.INMOTIONHOSTING.COM
NS2.INMOTIONHOSTING.COM

ionos.com NameServer
Name Server: ns1124.ui-dns.org
Name Server: ns1081.ui-dns.com
Name Server: ns1095.ui-dns.de
Name Server: ns1118.ui-dns.biz
---------------------------------------------------------------------------------------------------------------------------------------------

Go To google and write "limetorrents proxy"
Open any link
then write "whatever Subject"
then download torent file
install qbittorrent software

---------------------------------------------------------------------------------------------------------------------------------------------

DNS Propagation time can vary depending on the geographical location.
Normally, the domain DNS takes 0-8 hours and is known to take up to 48 hours maximum to completely propagat

---------------------------------------------------------------------------------------------------------------------------------------------

 

 

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

PHP SMTP CHECKER CODE

git clone git@github.com:subhashsautiyal/smtp-checker.git

---------------------------------------------------------------------------------------------------------------------------------------------

Issue :- Usally We Run Project On Running Terminal, So If Terminal Closed Project also will closed.
Solution :- In Development Evenviroment Only We Create DJango Service To Run And Stop Project Without Intreptuing Terminal.

$ cd /etc/systemd/system
$ sudo vim project_name.service

[Unit]
Description=ProjectName
Requires=postgresql.service
After=network.target postgresql.service

[Service]
Type=simple
SyslogIdentifier=projectname
PermissionsStartOnly=true
User=ubuntu
Group=ubuntu
ExecStart=/var/www/html/env/bin/python3 /var/www/html/myproject/manage.py runserver 4045
StandardOutput=journal+console

[Install]
WantedBy=multi-user.target

$ sudo service project_name start
$ sudo service project_name status
$ sudo service project_name stop

-----------------------------------------------------------------------------------------------------------------------------------------

Run DJango Project On Production Without Intreptuing Terminal With Apache.

Install wsgi module in project.
$ pip install mod-wsgi

Configure HTTP AND HTTPS Virtualhost

<IfModule mod_ssl.c> <VirtualHost *:443> ServerAdmin webmaster@localhost ServerName www.tech2towards.com DocumentRoot /home/ubuntu/Project/tech2towards_Website Options -Indexes #Configuring_WSGI-(WebServer Gateway Interface) RewriteEngine on RewriteCond %{HTTP:UPGRADE} ^WebSocket$ [NC,OR] RewriteCond %{HTTP:CONNECTION} ^Upgrade$ [NC] RewriteRule .* ws://127.0.0.1:8080%{REQUEST_URI} [P,QSA,L] WSGIDaemonProcess tech2towards_Website python-path=/home/ubuntu/Project/tech2towards_Website python-home=/home/ubuntu/Project/venv WSGIProcessGroup tech2towards_Website WSGIPassAuthorization On WSGIScriptAlias / /home/ubuntu/Project/tech2towards_Website/tech2towards_Website/wsgi.py #Run_Static_URL Alias /blog /home/ubuntu/Project/tech2towards_Website/tech2towards_Website/blog Alias /login /home/ubuntu/Project/tech2towards_Website/tech2towards_login <Directory /home/ubuntu/Project/tech2towards_Website/tech2towards_login> Require all granted Options Indexes FollowSymLinks MultiViews AllowOverride All Order Allow,Deny Allow from all </Directory> <Directory /home/ubuntu/Project/tech2towards_Website/tech2towards_Website/blog> Require all granted </Directory> <Directory /home/ubuntu/Project/tech2towards_Website/tech2towards_Website/> <Files wsgi.py> Require all granted </Files> </Directory> SSLEngine on SSLProtocol all -SSLv2 SSLCipherSuite ALL:!ADH:!EXPORT:!SSLv2:RC4+RSA:+HIGH:+MEDIUM #Configure-SSL-Certification SSLCertificateFile /etc/ssl/tech2towards.org_ssl_certificate.cer SSLCertificateKeyFile /etc/ssl/_.tech2towards.org_private_key.key SSLCertificateChainFile /etc/ssl/_.tech2towards.org_ssl_certificate_INTERMEDIATE.cer <FilesMatch "\.(cgi|shtml|phtml|php)$"> SSLOptions +StdEnvVars </FilesMatch> <Directory /usr/lib/cgi-bin> SSLOptions +StdEnvVars </Directory> ErrorLog ${APACHE_LOG_DIR}/error.log CustomLog ${APACHE_LOG_DIR}/access.log combined </VirtualHost> </IfModule>

---------------------------------------------------------------------------------------------------------------------------------------------

Make Mysql Database Connection File

Pre-requties: Apache, PHP & Mysql ######### Add Following Content ######### $ mkdir /var/www/html/inc $ vim /var/www/html/inc/dbinfo.inc <?php define('DB_SERVER', 'DB_Endpoint_HOST'); define('DB_USERNAME', 'USER_NAME'); define('DB_PASSWORD', 'USER_PASSWORD'); define('DB_DATABASE', 'DATABASE_NAME'); ?> ######### Add the following contents to the sample.php file: ######### $ mkdir /var/www/html/mysqlcon $ vim /var/www/html/mysqlcon/sample.php <?php include "../inc/dbinfo.inc"; ?> <html> <body> <h1>Sample page</h1> <?php /* Connect to MySQL and select the database. */ $connection = mysqli_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD); if (mysqli_connect_errno()) echo "Failed to connect to MySQL: " . mysqli_connect_error(); $database = mysqli_select_db($connection, DB_DATABASE); /* Ensure that the EMPLOYEES table exists. */ VerifyEmployeesTable($connection, DB_DATABASE); /* If input fields are populated, add a row to the EMPLOYEES table. */ $employee_name = htmlentities($_POST['NAME']); $employee_address = htmlentities($_POST['ADDRESS']); if (strlen($employee_name) || strlen($employee_address)) { AddEmployee($connection, $employee_name, $employee_address); } ?> <!-- Input form --> <form action="<?PHP echo $_SERVER['SCRIPT_NAME'] ?>" method="POST"> <table border="0"> <tr> <td>NAME</td> <td>ADDRESS</td> </tr> <tr> <td> <input type="text" name="NAME" maxlength="45" size="30" /> </td> <td> <input type="text" name="ADDRESS" maxlength="90" size="60" /> </td> <td> <input type="submit" value="Add Data" /> </td> </tr> </table> </form> <!-- Display table data. --> <table border="1" cellpadding="2" cellspacing="2"> <tr> <td>ID</td> <td>NAME</td> <td>ADDRESS</td> </tr> <?php $result = mysqli_query($connection, "SELECT * FROM EMPLOYEES"); while($query_data = mysqli_fetch_row($result)) { echo "<tr>"; echo "<td>",$query_data[0], "</td>", "<td>",$query_data[1], "</td>", "<td>",$query_data[2], "</td>"; echo "</tr>"; } ?> </table> <!-- Clean up. --> <?php mysqli_free_result($result); mysqli_close($connection); ?> </body> </html> <?php /* Add an employee to the table. */ function AddEmployee($connection, $name, $address) { $n = mysqli_real_escape_string($connection, $name); $a = mysqli_real_escape_string($connection, $address); $query = "INSERT INTO EMPLOYEES (NAME, ADDRESS) VALUES ('$n', '$a');"; if(!mysqli_query($connection, $query)) echo("<p>Error adding employee data.</p>"); } /* Check whether the table exists and, if not, create it. */ function VerifyEmployeesTable($connection, $dbName) { if(!TableExists("EMPLOYEES", $connection, $dbName)) { $query = "CREATE TABLE EMPLOYEES ( ID int(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY, NAME VARCHAR(45), ADDRESS VARCHAR(90) )"; if(!mysqli_query($connection, $query)) echo("<p>Error creating table.</p>"); } } /* Check for the existence of a table. */ function TableExists($tableName, $connection, $dbName) { $t = mysqli_real_escape_string($connection, $tableName); $d = mysqli_real_escape_string($connection, $dbName); $checktable = mysqli_query($connection, "SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_NAME = '$t' AND TABLE_SCHEMA = '$d'"); if(mysqli_num_rows($checktable) > 0) return true; return false; } ?>

 

Verify web server connecting to your DB instance at browser http://127.0.0.1/mysqlcon/sample.php

---------------------------------------------------------------------------------------------------------------------------------------------

Stdin add in Cpanel for ci-cd

$ vim .bashrc

[ -z "$PS1" ] && return

---------------------------------------------------------------------------------------------------------------------------------------------

How To Get FaceBook Account Name From Contact Number Or Email Address.

-> Run below Url on browser and paste Contact Number Or Email Address.

https://www.facebook.com/login/identify

--------------------------------------------------------------------------------------------------------------------------------------

To get the all activity of user since many year to till now by using https://myactivity.google.com

or even can get location and chrome history

---------------------------------------------------------------------------------------------------------------------------------------------

https://www.smtper.net/

 

---------------------------------------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------------------------------------------

---------------------------------------------------------------------------------------------------------------------------------------------