PHP Code Snipes

<table style='display:none!important;'>         <tr>             <td>                 <div style='overflow:hidden;display:none;font-size:1px;color:#ffffff;line-height:1px;font-family:Arial;maxheight:0px;max-width:0px;opacity:0;'>                     Welcome to MDB!                 </div>             </td>         </tr>     </table>     <table border='0' width='100%' cellpadding='0' cellspacing='0' bgcolor='ffffff'>         <tr>    ...

    if (isset($_GET['getState'])) {     $sql = "SELECT id,state_name FROM loc_state WHERE inactive='0' AND country_id ='".$_GET['getState']."';";     $stateDdList = $conn->query($sql);     if ($stateDdList->num_rows > 0) {         echo "<select name='state' onChange='getDistrict(this.value)' required='' class='form-control custom-select' >";         echo "<option value=''>Choose state</option>";         while($state=$stateDdList->fetch_assoc()) {             echo "<option value='".$state['id']."'>".$state['state_name']."</option>";         }         echo "</select>";     } else {             echo "<select name='state' required='' cl...

Simple way to upload file using php.     //HTML code <input type="file" required="" name="avatarUrl"/>   //On action page code where form is being submitted. if($_FILES['avatarUrl']['name']!='') {                        $fileTmpPath = $_FILES['avatarUrl']['tmp_name'];           $fileName = $_FILES['avatarUrl']['name'];           $fileSize = $_FILES['avatarUrl']['size'];           $fileType = $_FILES['avatarUrl']['type'];           $fileNameCmps = explode(".", $fileName);           $fileExtension = strtolower(end($fileNameCmps));              $dateMin = date('Ymdhms');           $rand = $dateMin;    ...

 Following code validates the file extension as soon as file is selected. If the extension/s are not as per requirement this will reset the input box with alert. //Javascript code -- add following code into html head.     <script>        var _validFileExtensions = [".jpg", ".jpeg", ".bmp", ".gif", ".png"];            function ValidateSingleInput(oInput) {             if (oInput.type == "file") {                 var sFileName = oInput.value;                  if (sFileName.length > 0) {                     var blnValid = false;                     ...

  Enable-Disable on-page error reporting for debugging purpose.   //Turn off error reporting error_reporting(0); //Report runtime errors error_reporting(E_ERROR | E_WARNING | E_PARSE); //Report all errors error_reporting(E_ALL); //Same as error_reporting(E_ALL); ini_set("error_reporting", E_ALL); //Report all errors except E_NOTICE error_reporting(E_ALL & ~E_NOTICE); // Removing memory limit ini_set("memory_limit",-1); //Removing max execution time for php ini_set('max_execution_time', 0);

Implementing Select all button using java-script in simpler way. <table class="table table-bordered table-striped">     <thead>         <tr>             <th>Username</th>             <th>Select All <input type="checkbox" id="select-all" ></th>         </tr>     </thead>     <tbody>         <tr>             <td>User1</td>                                                ...

Sometimes this happens regional language stored in DB properly, but when rendered on UI it shows the question mark or special character even after the HTML character set is added. Solution for this is add the MySQL character set. mysql_query (" set character_set_results='utf8' "); // Add this before executing the sql query. OR in your connection file so it will be used through-out your application. For full reference, click here .  //Adding HTML character set for reference purpose. (Read more at, W3Schools ) < meta http-equiv ="Content-Type" content ="text/html;charset=UTF-8" > <meta charset="utf-8"> 

    $servername = "localhost"; $username = "root"; $password = ""; $dbname = "jjmtmain"; // Create connection $conn = mysqli_connect($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) {     die("Connection failed: " . $conn->connect_error); } else {     echo "Connected to database."; }  /* In further operations you can use the $conn object for the database connection.              For eg. $q = mysqli_query($conn, "select * from user where email='$userid'"); $r = mysqli_fetch_array($q); echo $name = $r['name']; */

Most of the time in shared hosting, default server time seems to be different than local timezone. You can change the default timezone using following snippet. date_default_timezone_set("Asia/Kolkata"); $dateTime = date("Y-m-d H:i:s", time()); //For full reference, visit. https://www.php.net/manual/en/timezones.php

       Step 1: Adding common setting. Choose settings as per your requirement.    Step 2: Adding the command. (Main step.)   (Screenshot showing command to run the twice a day)   This actually worked for me. php -f/home/ yourCpanelUsername /public_html/CRON_FILE_PATH.php THIS DIDN'T WORKED FOR "ME". (You can give it a try) /home/yourCpanelUsername/public_html/ CRON_FILE_PATH.php /usr/local/bin/php -q /home/yourCpanelUsername/public_html/ CRON_FILE_PATH.php   DO NOT TRY THIS /usr/bin/php -q /home/yourCpanelUsername/public_html/ CRON_FILE_PATH.php     *Note:   1. yourCpanelUsername is cPanel username used while actual login. (Working for goDaddy cPanel) . 2. Please make sure cron file has executable permission set.                  

  <?php include('php-includes/check-login.php'); require('php-includes/connect.php'); ?> <!DOCTYPE html> <html lang="en"> <head>     <meta charset="utf-8">     <meta http-equiv="X-UA-Compatible" content="IE=edge">     <meta name="viewport" content="width=device-width, initial-scale=1">     <meta name="description" content="">     <meta name="author" content="">     <title>Mlml Website  - Home</title>     <!-- Bootstrap Core CSS -->     <link href="vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet">     <link href='../dist/css/style.min.css' rel='stylesheet' />     <!-- MetisMenu CSS -->     <link href="vendor/metisMenu/metisMenu.min.css" rel="stylesheet">     <!-- Custom CSS -->   ...