Skip to main content

Posts

simple email template with inline css

<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>    ...

PHP : Looping through database rows.

    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...

File upload in php

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;    ...

Input file validation with alert using javascript.

 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;                     ...

PHP INI & ON PAGE ERROR REPORTING

  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);

Simple check-all button for checkboxes using javascript-html.

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>                                                ...

Character set in MySQL.

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"> 

Simple method to connect database using PHP.

    $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']; */

Setting default timezone in php.

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

Cron file setup on cPanel. (goDaddy)

       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.                  

Reference code for AJAX and Sweetalert

  <?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 -->   ...