Skip to main content

Posts

Showing posts from April, 2021

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

Simple code: Calling API's using CURL in php.

Calling API's using CURL in php.   $message = "This is test message."; $enc_msg= rawurlencode($message); //Create API URL $fullapiurl="http://173.45.76.227/sendunicode.aspx?username=USERNAME&pass=PASSWORD&route=trans1&senderid=SENDERID&numbers=MOBILENO&message=$enc_msg"; //Calling API $ch = curl_init($fullapiurl); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); //Calling API using curl. This will actually calls the API and store the response into $result variable which you can use in further operations. $result = curl_exec($ch); echo $result ; curl_close($ch);

Adding/Subtracting no. of days to specific date using php.

Adding/Subtracting no. of days to given date using PHP.   //Capturing today's date $date = date('Y-m-d'); // logic to calculate date -7 days from $date. Update the -7 days as per your requirement.   $newDate=date_create($date)->modify('-7 days')->format('Y-m-d');  echo $newDate; /* Output: Eg. $date is 2021-03-20. Hence $newDate will be 2021-03-13 */