Create Rest API with JSON output form MySQL Database Tables Data in PHP

Developed Simple Rest API data in array convert into JSON fetch from MySQL Database Tables. Below is code for creating JSON Array API data fetch from MySQL database. I use this simple API to get all records entered in a database table. I developed this on localhost requires database configuration changes in the top 4 […]

Libmergepdf PHP Code for merge or concatenate multiple pdf files into single pdf

PHP composer library / SDK for merging or Concatenate multiples PDf(.pdf) files.   Install libmerge pdf sdk by Packagist composer. Open your folder with CMD for installation of the composer package and run below command. Installation composer require iio/libmergepdf Library for merging multiple PDFs   Add bulk .pdf files using PHP array. <?php require […]

Get Country Name and IP Address in Form Hidden Field by PHP Geoplugin API

Using GeoPlugin PHP API to Get Country Name and Country IP address.   Some time in HTML contact or WordPress contact form 7 we need to Country and Country IP address where the user fills the form. It’s required for tracking which country user used the form and find out where a lead comes from […]

SSH Command for Exclude subfolders when create zip on parent folder

SSH Command for excluded specific subdirectories when zipping a directory. I need to backup my website but I need to exclude a couple of subdirectories content all files and folders. Then I used the below command in Putty SSH. zip -r public_html -x blog/* -x portfolio/*   with the above Putty SSH command, I […]

SSH Linux Command for Putty Client – All MySQL Line commands for maintain MySQL database

How to manage MySQL user account, update records, insert records, login into SSH MySQL, and another SSH command for help to learn MySQL in SSH. List of all commands used in SSH for creating a new database, insert the record into the selected database, Alter the table column, login database by SSH client (Putty). Below […]

React Tutorial : Basic Form of React Code

Basic Form of React. import React, { useState } from ‘react’; // JS // const input = document.getElementById(‘myText’); // const inputValue = input.value // React // value, onChange const ControlledInputs = () => { const handleSubmit = (e) => { e.preventDefault(); console.log(‘Hello World…’); } return <> <article> <form className=”form”> <div className=”form-control”> <label htmlFor=”firstName”> Name : […]

React: Create Simple Counter Use Function, Inline CSS and Call function in React

React: Create Simple Counter Use Function, Inline CSS and Call function in React   import React, { useState } from ‘react’; const UseStateCounter = () => { const [value, setValue] = useState(0); const reset = () => { setValue(0); } return <> <section style={{ margin : ‘4rem 0’}}> <h2>Regular Counter</h2> <h1>{value}</h1> <button className=”btn” onClick={() => […]

Responsive with SASS Mixin use breakpoint on if condition

Responsive with SASS Mixin use breakpoint on if the condition SCSS Code _mixins.scss code @mixin response($breakpoint) { @if($breakpoint == xl){ @media(max-width: 1200px){ @content; } } @if($breakpoint == lg){ @media(max-width: 1000px){ @content; } } @if($breakpoint == md){ @media(max-width: 768px){ @content; } } } Use mixin in other SCSS files .first-nav{ grid-column: 7 / 10; grid-row: 1 […]

@each Loop with Index SASS Code

SCSS Code $socialMediaColors : 1 #3b5998, 2 #b31217, 3 #dc4e41, 4 #55acee, 5 #517fa4, 6 #0077b5; @each $color in $socialMediaColors { .social-icons-item:nth-child(#{nth($color, 1)}) .social-icons-link{ color: nth($color, 2); border: .1rem solid nth($color, 2); } } HTML Code <ul class=”social-icons”> <li class=”social-icons-item”> <a href=”#” class=”social-icons-link”> <i class=”fab fa-facebook”></i> </a> </li> <li class=”social-icons-item”> <a href=”#” class=”social-icons-link”> <i class=”fab […]

How to Check domain, URL or link does not has http or https and end with slash

Check a link start with HTTP or HTTPS How to check a link not start with http:// or https:// below code helps to add and find link does has it or not. if(pageUrl.indexOf(“http://”) == 0 || pageUrl.indexOf(“https://”) == 0 ){ pageUrl = pageUrl; }else{ pageUrl = “http://” + pageUrl; } add a slash and check […]