Sanjay's Blog

 In a HTML table compare every column data of every row. if any column data has changed value with respect to previous row then highlight that data.  We can achieve this using JavaScript. Here's a basic example of how you could implement this functionality: This code compares each cell of each row with the corresponding cell of the previous row. If the content of a cell is different from the content of the corresponding cell in the previous row, it adds a changed class to highlight the change. You can customise the appearance of the changed cells by modifying the CSS class .changed.

 WordPress migration is the bare necessity of running an active website. All WordPress customers need to deal with the aggravations with migrating their site beginning with one web host onto the next web host. It is known by the web society that WordPress migration is a overwhelming undertaking. This is clear with the by and large wide number of instructional exercises and articles concerning it. Even more importantly, the expenses incurred in this system are a wide sum. In the 21st century, we would look for our prerequisites to be fulfilled intuitively for a comprehensive customer endeavour. For the particular strategies to stay reasonable to this day and age, it is fundamental for the required virtual processes to be quick, i.e. they ought to be simple for the customer. WordPress has profitable strength of 14 years on the web. Even so, after this time, migration must be done manually. This is genuinely tiresome. You will be responsible for content creation an

 To convert a numeric value to Indian currency format (words), you can use a custom function. Here's an example of how you can achieve this: This function convertToIndianCurrencyWords() converts a numeric value into its Indian currency format representation in words. Adjust the code as needed for different ranges or specific formatting requirements. The example provided here is a basic implementation for Indian currency representation.

 Converting varchar data to date format in MySQL involves several steps. Here's a method to achieve this: Assuming your varchar date column is named date_column and your table is named your_table, you can follow these steps: Add a New Date Column: First, add a new date column to your table. ALTER TABLE your_table ADD new_date_column DATE; Update New Date Column: Update the newly added date column using the STR_TO_DATE function to convert the varchar dates to date format. UPDATE your_table SET new_date_column = STR_TO_DATE(date_column, 'your_date_format'); Replace 'your_date_format' with the format of the varchar dates in your column. For example, if your dates are in the format 'YYYY-MM-DD', use '%Y-%m-%d'.  Drop Old Date Column: If you're confident that the new date column contains the correct data, you can drop the old varchar date column. ALTER TABLE your_table DROP COLUMN date_column; Rename New Date Column: Finally, rename the new date colum

 To reverse the date from the format "yyyy-mm-dd" to "mm-dd-yyyy" in PHP, you can use the following script: <?php $date = "2023-07-04" ; // Reversing the date format $reversedDate = date ( "m-d-Y" , strtotime ( $date )); echo "Original date: " . $date . "<br>" ; echo "Reversed date: " . $reversedDate ; ?> In this script, the variable $date holds the original date in the "yyyy-mm-dd" format. The date() function is then used to convert and format the date. By passing the $date variable to strtotime(), it is converted to a Unix timestamp, which can be easily manipulated. The date() function then reformats the timestamp to the desired "mm-dd-yyyy" format. Finally, the original and reversed dates are printed on the screen.

To fetch data from a MySQL database and export it to Excel, you can use PHP along with a library like PHPExcel or PHPSpreadsheet (which is the successor of PHPExcel). Here, I'll provide an example using PHPExcel. Please note that PHPExcel is now deprecated, and PHPSpreadsheet is recommended for new projects. If you're starting a new project, consider using PHPSpreadsheet. However, if you need to work with PHPExcel for any reason, you can still find it on GitHub ( https://github.com/PHPOffice/PHPExcel ). 1. Install PHPSpreadsheet: You can install PHPSpreadsheet using Composer: composer require phpoffice/phpspreadsheet 2. Create a PHP Script (export_excel.php): <?php require 'vendor/autoload.php' ; use PhpOffice\PhpSpreadsheet\Spreadsheet; use PhpOffice\PhpSpreadsheet\Writer\Xlsx; // Database connection details $servername = "localhost" ; $username = "your_username" ; $password = "your_password" ; $dbname = "your_data

In PHP, you can generate a random number between 1 and 9 using the rand() or mt_rand() functions. Here are examples of both: Using rand() Function: $randomNumber = rand(1, 9); echo "Random number between 1 and 9: " . $randomNumber; Using mt_rand() Function: $randomNumber = mt_rand(1, 9); echo "Random number between 1 and 9: " . $randomNumber; Both functions will generate a random integer between the specified range, inclusive of both 1 and 9. Here’s how you might use this in a simple PHP script: <?php // Generate a random number between 1 and 9 using rand() $randomNumberRand = rand( 1 , 9 ); echo "Random number using rand(): " . $randomNumberRand . "<br>" ; // Generate a random number between 1 and 9 using mt_rand() $randomNumberMtRand = mt_rand( 1 , 9 ); echo "Random number using mt_rand(): " . $randomNumberMtRand ; ?> Why Use mt_rand()?  While both rand() and mt_rand() are suitable for generating random

To fetch data from a MySQL database and export it to CSV using PHP, you can follow these steps: <?php // Database connection details $servername = "localhost" ; $username = "your_username" ; $password = "your_password" ; $dbname = "your_database_name" ; // Create connection $conn = new mysqli( $servername , $username , $password , $dbname ); // Check connection if ( $conn -> connect_error ) { die ( "Connection failed: " . $conn -> connect_error ); } // Fetch data from your table $sql = "SELECT * FROM your_table" ; $result = $conn -> query ( $sql ); // Check if any rows are returned if ( $result -> num_rows > 0 ) { // Define CSV filename $filename = "exported_data.csv" ; // Set headers for CSV download header( 'Content-Type: text/csv' ); header( 'Content-Disposition: attachment; filename="' . $filename . '"

Here is a PHP script that allows users to upload image and PDF files with a maximum size of 5 MB. The uploaded files will be renamed using the current timestamp: <?php if ( $_SERVER [ "REQUEST_METHOD" ] == "POST" && isset ( $_FILES [ "file" ])) { $allowedExtensions = array ( "jpg" , "jpeg" , "png" , "pdf" ); $maxFileSize = 5 * 1024 * 1024 ; // 5 MB in bytes $targetDirectory = "uploads/" ; $timestamp = time (); $targetFileName = $timestamp . "_" . basename ( $_FILES [ "file" ][ "name" ]); $targetPath = $targetDirectory . $targetFileName ; $fileExtension = strtolower( pathinfo ( $targetFileName , PATHINFO_EXTENSION)); if ( in_array ( $fileExtension , $allowedExtensions ) && $_FILES [ "file" ][ "size" ] <= $maxFileSize ) { if ( move_uploaded_file ( $_FILES [