Skip to main content

Posts

OB START FUNCTION

  <?php somesetupcode(); ob_start(); ?> <html> <body> html text </body> </html> <?php //This will assign everything that has been output since call to ob_start to your variable. $myHTML = ob_get_contents() ; ob_end_flush(); ?>
Post a Comment
Read more

Password validation script

  < script >         var check = function () {             if ( document . getElementById ( 'password' ). value ==                 document . getElementById ( 'confirm_password' ). value ) {                     document . getElementById ( 'message' ). innerHTML = '' ;                 document . getElementById ( 'submit' ). disabled = false ;             } else {                     document . getElementById ( 'message' ). style . color = 'red' ;                 document . getElementById ( 'message' ). innerHTML = 'not matching' ;                 document . getElementById ( 'submit' ). disabled = true ;         ...
Post a Comment
Read more

Restoring MySQL on XAMMP

  Follow these steps and save your time and databases:- Go to your  XAMMP  installation, it’s mostly in  C drive . Now inside  mysql  folder rename the folder  data  to  data-old  (or any other name you like) Create a new folder  data  under  mysql  folder Copy the contents of  backup  folder to the new  data  folder Now copy all your  database  folders that are in  data-old  folder to the new  data  folder (skip the mysql, performance_scheme and phpmyadmin folder) And the last, copy the  ibdata1  file from  data-old  folder and replace it inside new  data  folder Restart your  MYSQL  server from  XAMPP control panel . And done!
Post a Comment
Read more

Connecting mysql using cmd

 Local your Mysql >> Bin folder & open the command prompt here. to connect MySQL remotely -- >> mysql -h hostname -u username -p hostname is your hostname, username is user database username, leave -p as it is. cmd prompt will ask you to enter password. Once connected you can fire any SQL command. Import large file ingoring errors. >> mysql -u userName -p -f -D dbName < script.sql Dump backup to local file. >> mysqldump -u [user name] –p [password] [options] [database_name] [tablename] > [dumpfilename.sql] for more, https://www.sqlshack.com/how-to-backup-and-restore-mysql-databases-using-the-mysqldump-command/
Post a Comment
Read more

terms and condition checkbox validation before submit. JS

  <button type="submit" id="submit_button" disabled>Sign Up</button>   /JavaScript function that enables or disables a submit button depending //on whether a checkbox has been ticked or not. function terms_changed(termsCheckBox){ //If the checkbox has been checked if(termsCheckBox.checked){ //Set the disabled property to FALSE and enable the button. document.getElementById("submit_button").disabled = false; } else{ //Otherwise, disable the submit button. document.getElementById("submit_button").disabled = true; } } 
Post a Comment
Read more

QR code generation code, custom image generation, custom certificate generation

 Purpose of directories and files.   Download code from here. (drive link) directory: phpqrcode (library used to generate the QR code) arial.ttf: font used while generating certificate image. format.jpg : Blank template image file which we are using for editing and generating dynamic image. placing_QR_on_another_image.php : sample code to add QR code on certificate image file. qr_code_generation.php : Used to generate custom QR code. qr_sample.jpg : used in placing_QR_on_another_image.php file.
Post a Comment
Read more

Adding image on image (Eg. QR code on certificates or Stamp on image.)

 <?php header('Content-type: image/jpeg'); $image1='format.jpg'; $image2='qr_sample.png'; list($width, $height) = getimagesize($image2); $image1 = imagecreatefromstring(file_get_contents($image1)); $image2 = imagecreatefromstring(file_get_contents($image2)); // imagecopymerge(dst_im, src_im, dst_x, dst_y, src_x, src_y, src_w, src_h, pct) imagecopymerge($image1, $image2, 280, 180, 0, 0, $width, $height, 100); // display img in browser imagepng($image1); // save image on server // imagejpeg($image1,"trial.jpg"); ?>
Post a Comment
Read more

Adding image on text using php (Certificate generation in php)

      <?php header('Content-type: image/jpeg'); //loading custom form $font=realpath('arial.ttf'); //creating pointer from sample image which is being edited $image=imagecreatefromjpeg("format.jpg"); //Adding color $color=imagecolorallocate($image, 51, 51, 102); $date=date('d F, Y'); //Adding date on image imagettftext($image, 18, 0, 880, 188, $color,$font, $date); //Adding name on image $name="Sagar kokare"; imagettftext($image, 48, 0, 120, 520, $color,$font, $name); //Saving edited image on server imagejpeg($image,"$name.jpg"); // you can show this image in browser // imagejpeg($image); imagedestroy($image); ?>
Post a Comment
Read more

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>    ...
Post a Comment
Read more

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...
Post a Comment
Read more

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;    ...
Post a Comment
Read more

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;                     ...
Post a Comment
Read more

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);
Post a Comment
Read more

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>                                                ...
Post a Comment
Read more

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"> 
Post a Comment
Read more

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']; */
Post a Comment
Read more