Web Development

How to change the PHP version for subfolders or subdomains

2025-03-10T03:03:00.000-07:00

How to change the PHP version for subfolders or subdomains

Setting a specific PHP version for a specific websites, subfolders or subdomains

Updated over 8 months ago

You can update the PHP version applicable to your hosting plan directly in hPanel.

If you'd like to change the PHP version for a specific domain, subdomain, or subfolder, you can do so by adding a line of code to the .htaccess file, as explained below 👇

Step 1 - Open the .htaccess file

Go to Websites → Dashboard, search for File Manager on the sidebar, and click on it:

Then, access the folder to which you would like to apply a different PHP version:

If you want to edit a domain, access its public_html folder.
For a subdomain, the corresponding folder will be inside the domain's public_html folder:

For a specific folder, go to the desired folder's path. Once in the correct location, open the .htaccess file by double-clicking on it.

If the .htaccess file doesn't exist, you can create it directly in the file manager. Make sure to include a dot (.) at the beginning of the filename:

Step 2 - Edit the .htaccess file

Add the following code to the very beginning of your .htaccess file:

<FilesMatch "\.(php4|php5|php3|php2|php|phtml)$">
SetHandler application/x-lsphp74
</FilesMatch>

Make sure to replace the application/x-lsphp74 portion of the code with the version that you would like to use. Check this table for the possible values:

PHP version	Code
7.3	application/x-lsphp73
7.4	application/x-lsphp74
8.0	application/x-lsphp80
8.1	application/x-lsphp81
8.2	application/x-lsphp82
8.3	application/x-lsphp83

It is recommended to use only PHP version 7.3 or higher. Lower versions are deprecated and can generate security risks and performance issues on your website.

NOTES

To check if the change was applied correctly, you can create a phpinfo.php file.
Using this method to change the PHP versions will not include PHP extensions and options.
Using the php -v command on SSH will show the PHP version of the hosting plan, not the domain or subdomain.

Main Source of Article is: https://support.hostinger.com/en/articles/4047803-how-to-change-the-php-version-for-subfolders-or-subdomains

How to backup and download Database using PHP

2023-08-14T21:45:00.008-07:00

<?php

    $mysqlUserName      = 'databaseusername';

    $mysqlPassword      = 'databasepassword';

    $mysqlHostName      = 'localhost';

    $DbName             = 'mydatabasename';

    Export_Database($mysqlHostName,$mysqlUserName,$mysqlPassword,$DbName,  $tables=false, $backup_name=false );

    function Export_Database($host,$user,$pass,$name,  $tables=false, $backup_name=false )

{

        $mysqli = new mysqli($host,$user,$pass,$name); 

        $mysqli->select_db($name); 

        $mysqli->query("SET NAMES 'utf8'");

        $queryTables    = $mysqli->query('SHOW TABLES'); 

        while($row = $queryTables->fetch_row()) 

{

            $target_tables[] = $row[0]; 

}

        if($tables !== false) 

{

            $target_tables = array_intersect( $target_tables, $tables); 

}

        foreach($target_tables as $table)

{

            $result         =   $mysqli->query('SELECT * FROM '.$table);  

            $fields_amount  =   $result->field_count;  

            $rows_num=$mysqli->affected_rows;     

            $res            =   $mysqli->query('SHOW CREATE TABLE '.$table); 

            $TableMLine     =   $res->fetch_row();

            $content        = (!isset($content) ?  '' : $content) . "\n\n".$TableMLine[1].";\n\n";

            for ($i = 0, $st_counter = 0; $i < $fields_amount;   $i++, $st_counter=0) 

{

                while($row = $result->fetch_row())  

                { //when started (and every after 100 command cycle):

                    if ($st_counter%100 == 0 || $st_counter == 0 )  

{

                            $content .= "\nINSERT INTO ".$table." VALUES";

}

                    $content .= "\n(";

                    for($j=0; $j<$fields_amount; $j++)  

{

                        $row[$j] = str_replace("\n","\\n", addslashes($row[$j]) ); 

                        if (isset($row[$j]))

{

                            $content .= '"'.$row[$j].'"' ; 

}

                        else 

{

                            $content .= '""';

}

                        if ($j<($fields_amount-1))

{

                                $content.= ',';

}

}

                    $content .=")";

                    //every after 100 command cycle [or at last line] ....p.s. but should be inserted 1 cycle eariler

                    if ( (($st_counter+1)%100==0 && $st_counter!=0) || $st_counter+1==$rows_num) 

{

                        $content .= ";";

}

                    else 

{

                        $content .= ",";

}

                    $st_counter=$st_counter+1;

}

            } $content .="\n\n\n";

}

        $backup_name = $name.".sql";

        header('Content-Type: application/octet-stream');   

        header("Content-Transfer-Encoding: Binary"); 

        header("Content-disposition: attachment; filename=\"".$backup_name."\"");  

        echo $content; exit;

}

?>

Source: https://codeconia.com/how-to-backup-and-download-database-using-php/

How to Batch Import Huge CSV Fast using PHP (Million Records in Seconds)

2023-08-06T06:40:00.005-07:00

I know, I know! How can you put PHP and Fast in the same line? I would say, you are stuck in the past. You should try PHP 7 and experience it yourself. There will be a lot of criticism for this article. Kindly read through.

LOAD DATA INFILE is the best option to import a huge CSV file. In this article we are going to see how we are going to read a CSV file and INSERT records via PHP script. This can be used in such a special case.

In general PHP will not have such use cases. But you never know, when you will come across such a situation, a client requirement can come any time. When you are a “freelance programmer” (not playing a consultant role), you will be thrust upon with all sorts of crazy requirements.

I have written an article about all things CSV in PHP. You should go through that to learn about handling CSV files in PHP.

I am well aware about the micro-benchmarking and its pitfalls. So, I didn’t go in that direction for this articles. That’s why I have given in the title as just seconds. It’s an approximation. This is not for people who are going to see in micro, nano seconds.

If you want to insert a million records in few seconds, using PHP script programmatically, then this will definitely help. The use case is rare and so the solution. You may have to do some tweaks here and there in this sample code to fit for your case.

<?php

function file_get_contents_chunked($link, $file, $chunk_size, $queryValuePrefix, $callback)
{
    try {
        $handle = fopen($file, "r");
        $i = 0;
        while (! feof($handle)) {
            call_user_func_array($callback, array(
                fread($handle, $chunk_size),
                &$handle,
                $i,
                &$queryValuePrefix,
                $link
            ));
            $i ++;
        }
        fclose($handle);
    } catch (Exception $e) {
        trigger_error("file_get_contents_chunked::" . $e->getMessage(), E_USER_NOTICE);
        return false;
    }

    return true;
}
$link = mysqli_connect("localhost", "root", "pass", "huge-csv");
$success = file_get_contents_chunked($link, "sample-dataset.csv", 2048, '', function ($chunk, &$handle, $iteration, &$queryValuePrefix, $link) {
    $TABLENAME = 'tbl_lead';
    $chunk = $queryValuePrefix . $chunk;

    // split the chunk of string by newline. Not using PHP's EOF
    // as it may not work for content stored on external sources
    $lineArray = preg_split("/\r\n|\n|\r/", $chunk);
    $query = 'INSERT INTO ' . $TABLENAME . '(id, name, email) VALUES ';
    $numberOfRecords = count($lineArray);
    for ($i = 0; $i < $numberOfRecords - 2; $i ++) {
        // split single CSV row to columns
        $colArray = explode(',', $lineArray[$i]);
        $query = $query . '(' . $colArray[0] . ',"' . $colArray[1] . '","' . $colArray[2] . '"),';
    }
    // last row without a comma
    $colArray = explode(',', $lineArray[$i]);
    $query = $query . '(' . $colArray[0] . ',"' . $colArray[1] . '","' . $colArray[2] . '")';
    $i = $i + 1;

    // storing the last truncated record and this will become the
    // prefix in the next run
    $queryValuePrefix = $lineArray[$i];
    mysqli_query($link, $query) or die(mysqli_error($link));

    /*
     * {$handle} is passed in case you want to seek to different parts of the file
     * {$iteration} is the section of the file that has been read so
     * ($i * 4096) is your current offset within the file.
     */
});

if (! $success) {
    // It Failed
}

Two main things to note are,

Read the file in chunks (batch).
Insert multiple records in a single insert statement.

The above is key in speeding up the overall process. Reading line by line and iterating through a loop will slowdown the process. So everything boils down to reading chunks (batches) and multi insert. Then a third point worth mentioning is use PHP native functions wherever possible.

I have used a Regex to replace newline in the CSV file. If you got a better option please suggest via comments section below.

Now let me walkthrough the code.

PHP’s fread allows to read in chunks of strings. Try experimenting with different chunk (batch) sizes. There is no particular right size. There are lots of variables, your server configuration, hardware, MySQL setup and lot more.

I have used a sample CSV file which I generated myself. I will detail the process below. You can use your own sample or real data and pass that as a parameter.

file_get_contents_chunked does the processing of CSV file and this has a callback function as the last argument. This callback takes care of parsing the record by the delimiter (comma in my example) and creating the multi-insert query and doing the actual insert.

You may have to modify the query part to suit your database table format. The overall structure of the script takes care of parsing the CSV in chunks (batches) and callbacks. Thanks to RobertPitt.

One thing worth mentioning is, instead of reading line by line I have used the chunk as it is to improve the speed. All through the Internet users have suggested fgetcsv. But I have gone ahead with chunk (batch) read of fread.

The fread when reading as chunk (batch) it will obviously have part a part of a CSV row truncated. I have stored that truncated last record in each chunk in $queryValuePrefix variable. It is retained by declaring as a reference via callback.

Sample CSV dataset

I wrote a tiny PHP script to generate the required CSV dataset. There are a lot of sources like Government census record, now popular Covid data, weather data and lot more.

At this time of Artificial Intelligence era, where Data Mining is more popular than Twinkle Twinkle Little Star, getting a sample huge CSV file is just a click away.

But still for flexibility, I wrote the PHP script myself.

<?php
$file = fopen('s-sample-dataset.csv', 'w');

for ($i = 1; $i <= 1000000; $i ++) {
    echo $i;
    $line[] = $i;
    $line[] = uniqid();
    $line[] = uniqid();
    fputcsv($file, $line);
    $line = null;
}
fclose($file);

This is a ruthless way of generating a sample data :-) At this juncture Faker is worth mentioning. It is a good PHP library for generating nice fake data. It will look very close to real.

Last, for the nerds. This script ran and imported one million (1000000) records in 9 seconds. My machine is a MacBookPro with Catalina, 2.3 GHz i5, 16 GB RAM and PHP 7.4. This is just for an idea and please do not make much out of this.

Pour in all your view points and suggestions for improvement in the below comments. Happy parsing all your CSVs, chunk it out!

Comments to “How to Batch Import Huge CSV Fast using PHP (Million Records in Seconds)”

This article is taken from below website.

Credit goes to: Nikunj Jadav

SOURCE: https://phppot.com/php/how-to-batch-import-huge-csv-fast-using-php-million-records-in-seconds/

Get a list of (date) quarters between two given dates. Return array of objects with information about each quarter

2022-12-19T10:18:00.001-08:00

<?php 

// get month name from number
function month_name($month_number){
	return date('F', mktime(0, 0, 0, $month_number, 10));
}


// get get last date of given month (of year)
function month_end_date($year, $month_number){
	return date("t", strtotime("$year-$month_number-1"));
}

// return two digit month or day, e.g. 04 - April
function zero_pad($number){
	if($number < 10)
		return "0$number";
	
	return "$number";
}

// Return quarters between tow dates. Array of objects
function get_quarters($start_date, $end_date){
	
	$quarters = array();
	
	$start_month = date( 'm', strtotime($start_date) );
	$start_year = date( 'Y', strtotime($start_date) );
	
	$end_month = date( 'm', strtotime($end_date) );
	$end_year = date( 'Y', strtotime($end_date) );
	
	$start_quarter = ceil($start_month/3);
	$end_quarter = ceil($end_month/3);

	$quarter = $start_quarter; // variable to track current quarter
	
	// Loop over years and quarters to create array
	for( $y = $start_year; $y <= $end_year; $y++ ){
		if($y == $end_year)
			$max_qtr = $end_quarter;
		else
			$max_qtr = 4;
		
		for($q=$quarter; $q<=$max_qtr; $q++){
			
			$current_quarter = new stdClass();
			
			$end_month_num = zero_pad($q * 3);
			$start_month_num = ($end_month_num - 2);

			$q_start_month = month_name($start_month_num);
			$q_end_month = month_name($end_month_num);
			
			$current_quarter->period = "Qtr $q ($q_start_month - $q_end_month) $y";
			$current_quarter->period_start = "$y-$start_month_num-01";      // yyyy-mm-dd    
			$current_quarter->period_end = "$y-$end_month_num-" . month_end_date($y, $end_month_num);
			
			$quarters[] = $current_quarter;
			unset($current_quarter);
		}

		$quarter = 1; // reset to 1 for next year
	}
	
	return $quarters;
	
}

$quarters = get_quarters('2010-04-05', '2015-05-01');
       

// Test	   
echo '<pre>';
print_r($quarters);
echo '</pre>';

Source: https://gist.github.com/steveirl/63c65561b6000de5c346

How to update product price programmatically in WooCommerce

2022-11-15T02:25:00.004-08:00

How to update product price programmatically in WooCommerce

Do you want to learn how to update the product price programmatically in WooCommerce? In this guide, we’ll show you how to change prices in WooCommerce without using any plugins or installing any extra tool.

If you use them smartly, discounts can help you improve your conversion rates and increase your sales. There are several ways to implement discounts on your e-commerce store. For example, you can apply WooCommerce coupons programmatically.

However, you can also update the product price without using coupons. For example, you could give an exclusive discount to users that are subscribed to your newsletter or who have spent more than $100 in your store.

In this guide, you’ll learn to change the price when customers add a product to the cart without using any coupons and by accessing the WooCommerce cart object directly. We’ll have a look at some examples and apply some logic when updating the price. The goal is that you understand the logic so you can customize the scripts and apply them to your store.

How to update the product price programmatically in WooCommerce

In this section, you’ll learn how to update the product price programmatically in WooCommerce. We’ll have a look at different examples to give you some ideas of what you can do in your store.

Update product price when a checkbox is selected
1. Add the checkbox input field to the products page
2. Update the price when a user adds a product to the cart
3. Recalculate the total price of the cart
Edit the product price based on user roles
Update the product price based on product taxonomy

Keep in mind that we’ll use several WooCommerce hooks so it’s a good idea to check out this guide if you’re not familiar with them.

Before we start…

Before we start, as we’ll make modifications to some core files, we recommend you install a child theme on your site. If you don’t have a child theme and you don’t know how to install it, check out our guide to create a child theme or our list of the best child theme plugins.

NOTE: To apply these scripts, copy and paste them in the functions.php file of the child theme. However, keep in mind that they’re intended for didactic purposes only so customize them before taking them to production.

1) Update product price when a checkbox is selected

In the following sample script, we’ll add a checkbox input in the cart form on the product page. This way, we can apply custom logic and dynamically update the price of any product that customers add to the cart only when the checkbox is selected.

1.1 Add the checkbox input field to the products page

Before we update the WooCommerce product price programmatically, let’s add the checkbox to the products page. To do that, simply copy and paste the following script:

add_action('woocommerce_after_add_to_cart_button', 'add_check_box_to_product_page', 30 );
function add_check_box_to_product_page(){ ?>     
       <div style="margin-top:20px">           
<label for="extra_pack"> <?php _e( 'Extra packaging', 'quadlayers' ); ?>
<input type="checkbox" name="extra_pack" value="extra_pack"> 
</label>
                    
</div>
     <?php
}

The woocommerce_after_add_to_cart_button hook allows us to print the checkbox right after the button as shown in the image above.

1.2 Update the price when the user adds a product to the cart

Another interesting option is to update the price dynamically when customers add a product to their carts. So, in this case, to update the price programmatically in WooCommerce simply paste this script right after the previous one.

add_filter( 'woocommerce_add_cart_item_data', 'add_cart_item_data', 10, 3 );
 
function add_cart_item_data( $cart_item_data, $product_id, $variation_id ) {
     // get product id & price
    $product = wc_get_product( $product_id );
    $price = $product->get_price();
    // extra pack checkbox
    if( ! empty( $_POST['extra_pack'] ) ) {
       
        $cart_item_data['new_price'] = $price + 15;
    }
return $cart_item_data;
}

woocommerce_add_cart_item_data is the WooCommerce hook that will allow us to edit the price of the current product. Additionally, the if() conditional checks whether the checkbox is selected or not, and if it is, updates the price in the following line. Now, let’s break down the code to better understand what each part does.

extra_pack is the name of the checkbox we’ve created in the previous step
$price is the current product price. We can modify it as we want with some conditions
$cart_item_data['new_price'] = $price + 15; is how we increase the price by $15 when the if() conditional is true, this is when the user selects the extra packaging checkbox. By adjusting the code, you can choose to increase or decrease the price by any amount you want.

1.3 Recalculate the total price of the cart

Since we can call the woocommerce_add_cart_item_data hook several times when loading the cart, we need to recalculate the totals and subtotals of the cart to avoid undesired results such as prices being updated multiple times or every time a user adds a product. To update the product, paste the following code after the previous two ones:

add_action( 'woocommerce_before_calculate_totals', 'before_calculate_totals', 10, 1 );
 
function before_calculate_totals( $cart_obj ) {
if ( is_admin() && ! defined( 'DOING_AJAX' ) ) {
return;
}
// Iterate through each cart item
foreach( $cart_obj->get_cart() as $key=>$value ) {
if( isset( $value['new_price'] ) ) {
$price = $value['new_price'];
$value['data']->set_price( ( $price ) );
}
}
}

This function ensures that we only update the price when a product matches our conditional logic (that the user selects the extra packaging checkbox). This way, we prevent all possible errors when calculating the total price of the cart.

Product price increases by $15

If everything went fine and the cart meets the conditions we set, our function will add an extra $15 charge to the original price when the user selects the checkbox on the product page, before clicking the Add to cart button.

To avoid cart abandonment and improve the buying experience, you should always display the new price before the customers add the products to their carts. Otherwise, they’ll only see the final price on the checkout page.

2. Edit the product price based on user roles

Similarly, we can update the WooCommerce product price programmatically based on user roles. For example, you could give subscribed or registered users an exclusive discount. To do that, copy and paste the following script:

function add_cart_item_data( $cart_item_data, $product_id, $variation_id ) {
    // get product id & price
   $product = wc_get_product( $product_id );
   $price = $product->get_price();
   if(// Is logged in && is customer role
       is_user_logged_in()==true&& wc_current_user_has_role( 'customer' )){
       
        $cart_item_data['new_price'] = $price * 0.8;
   }
return $cart_item_data;
}
add_filter( 'woocommerce_add_cart_item_data', 'add_cart_item_data', 10, 3 );

As you can see, the only difference between this script and the previous one in point 1.2 is the if() logic operator. Here, we are checking whether the user is logged in or not and if it has a customer role, which we assign to registered users who have purchased from our store before.

When a shopper meets that condition, we multiply the product price by 0.8, giving them a 20% discount. Of course, you can edit the user roles and change them for others such as Subscriber, Editor, or any other roles that you have registered on your website.

Note that to work properly, you also need to use the 'before_calculate_totals' function and its hook to recalculate the cart totals. So simply use recalculate the total price of the cart script we saw in step 1.3.

3. Update product price based on product taxonomy

Finally, in WooCommerce we can also dynamically update the product price programmatically based on product taxonomies. To do that, let’s have a look at the following script.

add_filter( 'woocommerce_add_cart_item_data', 'add_cart_item_data', 10, 3 );
 
function add_cart_item_data( $cart_item_data, $product_id, $variation_id ) {
     // get product id & price
    $product = wc_get_product( $product_id );
    $price = $product->get_price();
    $terms = get_the_terms( $product_id, 'product_cat' );
    // Category match ! apply discount
    if($terms[0]->name=='Posters'){                    
        $cart_item_data['new_price'] = $price + 20;
     }   
return $cart_item_data;
 
}

In this example, we are getting the category of the product that has been added to the cart using the get_the_terms() WordPress inbuilt function. In the next line, we apply our conditional to retrieve the category of the product using $terms[0]->name. This way, if the product belongs to the category Posters, we increase the price by $20.

This is a sample script that you can take as a base and edit it to change both the taxonomy and the amount you want to add or deduct from the price.

Finally, remember that you need to use the 'before_calculate_totals' function and its corresponding hook as we did in step 1.3.

As you can see, the know-how of using conditional and WordPress/WooCommerce functions will provide an extremely flexible way to update product prices programmatically. These are just a few examples to give you ideas of what’s possible.

However, there’s a lot more you can do so unleash your creativity and find new ways to edit the price of your products. For example, you can apply discounts on specific product IDs, based on the URL the users came from, depending on the users’ location or ID, and so on. The possibilities are endless so play around with the script and find the best solutions for your store.

FINAL NOTES

These sample scripts in points 1, 2, and 3 will not work together. You will need to refine your logic into a single one if you want to apply multiple functions at the same time
You may need to include additional validation functions for more complex conditional logic
Always apply a recalculation function – as seen in point 1.3 – when working with the WooCommerce cart object
These are sample scripts and are intended for didactic purposes only. Please adjust them before taking them into production

Source: https://quadlayers.com/update-product-price-programmatically-in-woocommerce/
Credit : SEBASTOPOLYS

Add image file upload field to WooCommerce single products

2022-10-26T04:07:00.002-07:00

You could try the following, that will store uploaded image data as custom cart item data and save it as custom order item meta data:

// Display additional product fields (+ jQuery code)

add_action( 'woocommerce_before_add_to_cart_button', 'display_additional_product_fields', 9 );
function display_additional_product_fields(){
    ?>
    <p class="form-row validate-required" id="image" >
        <label for="file_field"><?php echo __("Upload Image") . ': '; ?>
            <input type='file' name='image' accept='image/*'>
        </label>
    </p>
    <?php
}


// Add custom fields data as the cart item custom data
add_filter( 'woocommerce_add_cart_item_data', 'add_custom_fields_data_as_custom_cart_item_data', 10, 2 );
function add_custom_fields_data_as_custom_cart_item_data( $cart_item, $product_id ){
    if( isset($_FILES['image']) && ! empty($_FILES['image']) ) {
        $upload       = wp_upload_bits( $_FILES['image']['name'], null, file_get_contents( $_FILES['image']['tmp_name'] ) );
        $filetype     = wp_check_filetype( basename( $upload['file'] ), null );
        $upload_dir   = wp_upload_dir();
        $upl_base_url = is_ssl() ? str_replace('http://', 'https://', $upload_dir['baseurl']) : $upload_dir['baseurl'];
        $base_name    = basename( $upload['file'] );

        $cart_item['file_upload'] = array(
            'guid'      => $upl_base_url .'/'. _wp_relative_upload_path( $upload['file'] ), // Url
            'file_type' => $filetype['type'], // File type
            'file_name' => $base_name, // File name
            'title'     => ucfirst( preg_replace('/\.[^.]+$/', '', $base_name ) ), // Title
        );
        $cart_item['unique_key'] = md5( microtime().rand() ); // Avoid merging items
    }
    return $cart_item;
}

// Display custom cart item data in cart (optional)
add_filter( 'woocommerce_get_item_data', 'display_custom_item_data', 10, 2 );
function display_custom_item_data( $cart_item_data, $cart_item ) {
    if ( isset( $cart_item['file_upload']['title'] ) ){
        $cart_item_data[] = array(
            'name' => __( 'Image uploaded', 'woocommerce' ),
            'value' =>  str_pad($cart_item['file_upload']['title'], 16, 'X', STR_PAD_LEFT) . '…',
        );
    }
    return $cart_item_data;
}

// Save Image data as order item meta data
add_action( 'woocommerce_checkout_create_order_line_item', 'custom_field_update_order_item_meta', 20, 4 );
function custom_field_update_order_item_meta( $item, $cart_item_key, $values, $order ) {
    if ( isset( $values['file_upload'] ) ){
        $item->update_meta_data( '_img_file',  $values['file_upload'] );
    }
}

// Admin orders: Display a linked button + the link of the image file
add_action( 'woocommerce_after_order_itemmeta', 'backend_image_link_after_order_itemmeta', 10, 3 );
function backend_image_link_after_order_itemmeta( $item_id, $item, $product ) {
    // Only in backend for order line items (avoiding errors)
    if( is_admin() && $item->is_type('line_item') && $file_data = $item->get_meta( '_img_file' ) ){
        echo '<p><a href="'.$file_data['guid'].'" target="_blank" class="button">'.__("Open Image") . '</a></p>'; // Optional
        echo '<p><code>'.$file_data['guid'].'</code></p>'; // Optional
    }
}

// Admin new order email: Display a linked button + the link of the image file
add_action( 'woocommerce_email_after_order_table', 'wc_email_new_order_custom_meta_data', 10, 4);
function wc_email_new_order_custom_meta_data( $order, $sent_to_admin, $plain_text, $email ){
    // On "new order" email notifications
    if ( 'new_order' === $email->id ) {
        foreach ($order->get_items() as $item ) {
            if ( $file_data = $item->get_meta( '_img_file' ) ) {
                echo '<p>
                    <a href="'.$file_data['guid'].'" target="_blank" class="button">'.__("Download Image") . '</a><br>
                    <pre><code style="font-size:12px; background-color:#eee; padding:5px;">'.$file_data['guid'].'</code></pre>
                </p><br>';
            }
        }
    }
}

Source: https://stackoverflow.com/questions/62847710/add-image-file-upload-field-to-woocommerce-single-products

Remove jQuery Validate error class from input fields and apply on error labels only

2022-01-24T22:39:00.007-08:00

You can use the following method to remove error class apply on form elements.

$('#addNewForm').validate({

highlight: function(element) {

$(element).removeClass("error");

}

});

Disable dynamic dropdown option value onchange another dynamic dropdown

2021-09-05T05:54:00.001-07:00

I would make a function that checks every selected value, and then enables all options, searches through the .staff_lists for options in that array that are not currently selected, and disables them all.

Add that function as a listener to the wrapper (with event delegation) and run it after more <select>s are appended (to ensure the new options' values get properly disabled), and run it after <select>s are deleted (so that if that <select> had anything selected, its value is now enabled again in the other elements).

This ensures a correct re-calculation of disabled options whenever there's a change.

Note that because there are currently only 3 possible values (a, b, and c), only three selects can currently be changed - after that, every possible option (except the default) will be disabled.

var add_button = $(".add_sign");
var wrapper = $(".sign");
var max_fields = 6;
var x = 1;


add_button.click(function(e) {
  if (x < max_fields) {
    x++;
    wrapper.append('<div  class="input-group sign_user"><select class="staff_list" name="staff_id"><option value="">--Select staff--</option><option value="a">A</option><option value="b">B</option><option value="c">C</option></select><span class="input-group-btn delete_sign"><a href="#" class="btn btn-sm btn-danger">X</a></span></div>');
    recalcDisabled();
  } else {
    alert('Maximum 5 Authorised Signatory only!');
  }
});
//Delete staff_list
$(wrapper).on("click", ".delete_sign", function(e) {
  e.preventDefault();
  $(this).parent('div').remove();
  recalcDisabled();
  x--;
});
wrapper.on('change', 'select', recalcDisabled);

function recalcDisabled() {
  const selectedValues = $('.staff_list')
    .map((_, sel) => sel.value)
    .get()
    .filter(Boolean); // Filter out the empty string
  $('.staff_list option').prop('disabled', false);
  selectedValues.forEach(value => {
    $(`.staff_list[value!="${value}"] option[value="${value}"]`)
      .prop('disabled', true);
  });
}

<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
<div class="sign">
  <button class="add_sign">Add New Field &nbsp; 
    <span style="font-size:16px; font-weight:bold;">+ </span>   </button>
</div>
Credit: CertainPerformance (https://stackoverflow.com/users/9515207/certainperformance)
Source: https://stackoverflow.com/questions/51738465/disable-dynamic-dropdown-option-value-onchange-another-dynamic-dropdown

Round number up to .49 or .99

2021-08-02T04:05:00.007-07:00

You need using custom round function for this. Because rounding to 0.49 is not standard way.

    function rounder($num){
    $fln= $num-floor($num);
    if ($fln>0 and $fln<0.5) $fln=0.49;
    else $fln=0.99;

    return floor($num)+$fln;
    }
    echo rounder(5.24882);

source: https://stackoverflow.com/questions/47389399/round-number-up-to-49-or-99

PHP calculate a date based on function for working days for future

2021-06-30T12:07:00.000-07:00

If someone's interested, I'm using this function to add X business days to a date. The function takes in a timestamp and returns a timestamp. It's possible to specify the holidays via an array (if in the US, you can use usBankHolidays()).

At the moment, it's assuming Saturday and Sunday are not business days but that can be changed easily.

Code:

function addBusinessDays($date, $days, $holidays = array()) {
    $output = new DateTime();
    $output->setTimestamp($date);
    while ($days > 0) {
        $weekDay = $output->format('N');

        // Skip Saturday and Sunday
        if ($weekDay == 6 || $weekDay == 7) {
            $output = $output->add(new DateInterval('P1D'));
            continue;
        }

        // Skip holidays
        $strDate = $output->format('Y-m-d');
        foreach ($holidays as $s) {
            if ($s == $strDate) {
                $output = $output->add(new DateInterval('P1D'));
                continue 2;
            }
        }

        $days--;
        $output = $output->add(new DateInterval('P1D'));
    }
    return $output->getTimestamp();
}

function usBankHolidays($format = 'datesonly') {
    $output = array(
        array('2015-05-25', 'Memorial Day'),
        array('2015-07-03', 'Independence Day'),
        array('2015-09-07', 'Labor Day'),
        array('2015-10-12', 'Columbus Day'),
        array('2015-11-11', 'Veterans Day'),
        array('2015-11-26', 'Thanksgiving Day'),
        array('2015-12-25', 'Christmas Day'),
        array('2016-01-01', 'New Year Day'),
        array('2016-01-18', 'Martin Luther King Jr. Day'),
        array('2016-02-15', 'Presidents Day (Washingtons Birthday)'),
        array('2016-05-30', 'Memorial Day'),
        array('2016-07-04', 'Independence Day'),
        array('2016-09-05', 'Labor Day'),
        array('2016-10-10', 'Columbus Day'),
        array('2016-11-11', 'Veterans Day'),
        array('2016-11-24', 'Thanksgiving Day'),
        array('2016-12-25', 'Christmas Day'),
        array('2017-01-02', 'New Year Day'),
        array('2017-01-16', 'Martin Luther King Jr. Day'),
        array('2017-02-20', 'Presidents Day (Washingtons Birthday)'),
        array('2017-05-29', 'Memorial Day'),
        array('2017-07-04', 'Independence Day'),
        array('2017-09-04', 'Labor Day'),
        array('2017-10-09', 'Columbus Day'),
        array('2017-11-10', 'Veterans Day'),
        array('2017-11-23', 'Thanksgiving Day'),
        array('2017-12-25', 'Christmas Day'),
        array('2018-01-01', 'New Year Day'),
        array('2018-01-15', 'Martin Luther King Jr. Day'),
        array('2018-02-19', 'Presidents Day (Washingtons Birthday)'),
        array('2018-05-28', 'Memorial Day'),
        array('2018-07-04', 'Independence Day'),
        array('2018-09-03', 'Labor Day'),
        array('2018-10-08', 'Columbus Day'),
        array('2018-11-12', 'Veterans Day'),
        array('2018-11-22', 'Thanksgiving Day'),
        array('2018-12-25', 'Christmas Day'),
        array('2019-01-01', 'New Year Day'),
        array('2019-01-21', 'Martin Luther King Jr. Day'),
        array('2019-02-18', 'Presidents Day (Washingtons Birthday)'),
        array('2019-05-27', 'Memorial Day'),
        array('2019-07-04', 'Independence Day'),
        array('2019-09-02', 'Labor Day'),
        array('2019-10-14', 'Columbus Day'),
        array('2019-11-11', 'Veterans Day'),
        array('2019-11-28', 'Thanksgiving Day'),
        array('2019-12-25', 'Christmas Day'),
        array('2020-01-01', 'New Year Day'),
        array('2020-01-20', 'Martin Luther King Jr. Day'),
        array('2020-02-17', 'Presidents Day (Washingtons Birthday)'),
        array('2020-05-25', 'Memorial Day'),
        array('2020-07-03', 'Independence Day'),
        array('2020-09-07', 'Labor Day'),
        array('2020-10-12', 'Columbus Day'),
        array('2020-11-11', 'Veterans Day'),
        array('2020-11-26', 'Thanksgiving Day'),
        array('2020-12-25', 'Christmas Day '),
    );

    if ($format == 'datesonly') {
        $temp = array();
        foreach ($output as $item) {
            $temp[] = $item[0];
        }
        $output = $temp;
    }

    return $output;
}

Usage:

$deliveryDate = addBusinessDays(time(), 7, usBankHolidays());

Source: https://stackoverflow.com/questions/11130390/php-calculate-a-date-based-on-function-for-working-days/34083964

PHP: Calculating past and future dates

2021-06-12T01:56:00.002-07:00

The strtotime function in PHP is incredibly powerful but very much underutilised - mainly because some aspects can be a bit confusing and people are more confident 'doing things the hard way'. The strtotime function doesn't just convert date strings to timestamp values but also has its own 'language' to let you specify just about any date or time you want.

1. Calculating dates for past and future days

The easiest and most common calculations are based on seconds, minutes, hours and days. Months and years are also valid input but not always useful in calculations as they're not all of equal length because of the way our calendar works.

Shown below are the results of various strings passed to strtotime and converted to date strings.

For example:

echo date('l jS F (Y-m-d)', strtotime('-3 days'));

3 days ago: Wednesday 9th June (2021-06-09)
-3 days: Wednesday 9th June (2021-06-09)
-2 days: Thursday 10th June (2021-06-10)
yesterday: Friday 11th June (2021-06-11)
now: Saturday 12th June (2021-06-12)
today: Saturday 12th June (2021-06-12)
tomorrow: Sunday 13th June (2021-06-13)
+2 days: Monday 14th June (2021-06-14)
+3 days: Tuesday 15th June (2021-06-15)

As always there are often different ways to achieve the same result. In the list above you can see that '3 days ago' is equivalent to '-3 days'. Also 'yesterday' is the same as '-1 days' or '1 day ago'. The 's' on the end of 'days', 'years' or other measurements can be left off if you want.

The 'now' and 'today' input values in the list above are superfluous as if we leave off the second paramater of the date function it will default to the current time anyway.

2. Working with days of the week

Sometimes we work with days of the week and need to know the last/next occurrence of, for example, a Saturday:

-2 weeks Saturday: Saturday 29th May (2021-05-29)
last Saturday: Saturday 5th June (2021-06-05)
Saturday: Saturday 12th June (2021-06-12)
this Saturday: Saturday 12th June (2021-06-12)
first Saturday: Saturday 19th June (2021-06-19)
next Saturday: Saturday 19th June (2021-06-19)
third Saturday: Saturday 3rd July (2021-07-03)
+2 weeks Saturday: Saturday 26th June (2021-06-26)

In the list above we can see that 'Saturday', 'this Saturday' and 'first Saturday' are all equivalent. The 'this' and 'first' keywords are only used to improve readability.

Now it gets a bit complicated to explain. The following appears on the PHP website:

In PHP 5 up to 5.0.2, "now" and other relative times are wrongly computed from today's midnight. It differs from other versions where it is correctly computed from current time.

In addition, they've introduced 'second' as in 'second Saturday' and seem to have changed the meaning of 'next' to mean the same as 'first'. Finally, the return value on failure is now FALSE instead of -1. This last change is the most likely to cause problems in legacy applications.

The table below shows how the output has changed:

Older versions of PHP:	PHP 5.0.2 and higher:
last Saturday this Saturday or first Saturday next Saturday third Saturday fourth Saturday	last Saturday this Saturday or first Saturday or next Saturday second Saturday third Saturday fourth Saturday

3. Using offsets to get the right day

Another problem is when you want to find the previous or next occurence of a certain day of the week. For example, today being a Saturday we can run the following:

last Saturday: Saturday 5th June (2021-06-05)
Saturday: Saturday 12th June (2021-06-12)
this Saturday: Saturday 12th June (2021-06-12)
first Saturday: Saturday 19th June (2021-06-19)
next Saturday: Saturday 19th June (2021-06-19)
third Saturday: Saturday 3rd July (2021-07-03)

Older versions of PHP:	PHP 5.0.2 and higher:
last Saturday this Saturday or first Saturday next Saturday third Saturday fourth Saturday	last Saturday this Saturday first Saturday or next Saturday second Saturday third Saturday

You can see in the table above that, while 'next Saturday' returns the same result, the 'first', 'second', 'third', ... modifiers have all changed in meaning - thankfully to a more logical state.

You may notice also that this only occurs when you're calculating from the current day and not in the previous examples (unless today is Saturday). Whenever you do calculations based on days you should test as many possibilities as possible: Does it work today? yesterday? tomorrow? and so on.

Sometimes you want to find the last occurence of a day before today, or before yesterday or before 2 days ago. The following examples show the syntax you can use for this:

-3 days last Saturday: Wednesday 2nd June (2021-06-02)
-2 days last Saturday: Thursday 3rd June (2021-06-03)
yesterday last Saturday: Friday 4th June (2021-06-04)
tomorrow Saturday: Sunday 13th June (2021-06-13)
+2 days Saturday: Monday 14th June (2021-06-14)
+3 days Saturday: Tuesday 15th June (2021-06-15)

Now that you understand the inner workings of strtotime you should be able to drastically reduce the amount of code required to calculate past and future dates.

4. Checking if a date is in the Past or Future

The strtotime function returns an integer value so it's a simple matter to see if a date is in the past or in the future.

   if(strtotime(dateString) > time()) {
     # date is in the future
   }
   if(strtotime(dateString) < time()) {
     # date is in the past
   }
   if(strtotime(dateString) == time()) {
     # date is right now
   }

Note: time() is equivalent to date('U') and returns the current timestamp to the nearest second.

You might want to replace time() with strtotime('0:00') if you want to compare a date string to the current date rather than the current date and time.

Source: https://www.the-art-of-web.com/php/strtotime/

stripe cancel subscription using curl in php

2021-06-06T23:40:00.002-07:00

stripe cancel subscription using curl in php

In this post we will show you stripe cancel subscription using curl in php, hear for stripe cancel subscription using curl in php we will give you demo and example for implement.

stripe cancel subscriptionCanceling subscriptions

Subscriptions can be canceled through the API:

1

2

3

curl https://api.stripe.com/v1/subscriptions/sub_B49U3MADTZ8Onp \
   -u sk_test_a85RX6H48G5dfD55FDF77: \
   -X DELETE

Code for stripe cancel subscription using curl in php

function curl_del($path)
{
    // Add your key
    $headers = array('Authorization: Bearer sk_test_a85RX6H48G5dfD55FDF77');
    $ch = curl_init();
    curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);
    curl_setopt($ch, CURLOPT_URL, $path);
    curl_setopt($ch, CURLOPT_CUSTOMREQUEST, "DELETE");
    curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
    $result = curl_exec($ch);
    $httpCode = curl_getinfo($ch, CURLINFO_HTTP_CODE);  
    curl_close($ch);
    return $result;
}
 
// add your subscriptions id
$path = "https://api.stripe.com/v1/subscriptions/sub_B49U3MADTZ8Onp";
$curl_del = curl_del($path);
echo "<pre>";
print_r($curl_del);
echo "</pre>";

cSource: https://www.onlinecode.org/stripe-cancel-subscription-using-curl-php/

jQuery DataTables: ROWSPAN in table body TBODY

2021-05-29T06:12:00.006-07:00

jQuery DataTables plugin doesn’t yet support COLSPAN and ROWSPAN attributes in table body. However there is a RowsGroup plugin for jQuery DataTables that emulates appearance of using ROWSPAN attribute by grouping cells together.

Plugin requires jQuery DataTables version 1.10 or above. According to the author’s post on DataTables forum, this plugin has the following features:

supports nested multi grouping rows
supports both client-side and server-side processing
correctly handles single-column and multi-column ordering

To use the plugin, you need to include JavaScript file dataTables.rowsGroup.js and use rowsGroup option as shown below. Option rowsGroup should be an array of the column selectors in order you want the grouping to be applied.

var table = $('#example').DataTable({
   'rowsGroup': [2]
});

More details on usage can be found on plugin’s project page.

$(document).ready(function(){
   var table = $('#example').DataTable({
      'ajax': 'https://api.myjson.com/bins/qgcu',
      'rowsGroup': [2]
   });
});

In addition to the above code, the following Javascript library files are loaded for use in this example:

//ajax.googleapis.com/ajax/libs/jquery/1.11.0/jquery.min.js
https://cdn.datatables.net/v/dt/dt-1.10.12/datatables.min.js
https://cdn.rawgit.com/ashl1/datatables-rowsgroup/fbd569b8768155c7a9a62568e66a64115887d7d0/dataTables.rowsGroup.js

Credits & Source: https://www.gyrocode.com/articles/jquery-datatables-rowspan-in-table-body-tbody/

Convert MSSQL to MySQL

2021-04-22T09:54:00.000-07:00

With this website you can covert MSSQL to msyql easily.

http://www.sqlines.com/online

Convert php date to mysql format

2021-04-16T10:15:00.003-07:00

$date = mysql_real_escape_string($_POST['intake_date']);

1. If your MySQL column is DATE type:

$date = date('Y-m-d', strtotime(str_replace('-', '/', $date)));

2. If your MySQL column is DATETIME type:

$date = date('Y-m-d H:i:s', strtotime(str_replace('-', '/', $date)));

You haven't got to work strototime(), because it will not work with dash - separators, it will try to do a subtraction.

Update, the way your date is formatted you can't use strtotime(), use this code instead:

$date = '02/07/2009 00:07:00';
$date = preg_replace('#(\d{2})/(\d{2})/(\d{4})\s(.*)#', '$3-$2-$1 $4', $date);
echo $date;

Output:

2009-07-02 00:07:00

Source: https://stackoverflow.com/questions/6790930/convert-php-date-to-mysql-format/6791068

BY: https://stackoverflow.com/users/645186/shef

Autocomplete Address Search Module Using Google API and PHP

2021-04-09T11:27:00.003-07:00

Steps to implement an autocomplete address search module

The first step is to grab a google’s API Key, you can find it here.

index.php

<!DOCTYPE html>
<html lang="en">
    <head>
        <meta charset="utf-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">

        <script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script>

        <link href="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.3/css/select2.min.css" rel="stylesheet" />

        <script src="https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.3/js/select2.min.js"></script>

    </head>
    <body>

        <select id="address" style="width:500px;"></select>

        <script type="text/javascript">
            $(document).ready(function(){

                $("#submit").click(function(){
                    var val = $("#address").val();
                    alert(val);
                });

                $('select').select2({
                    placeholder: "Search for your city",
                    ajax: {
                        url: function(params){
                            return 'api.php?data='+params.term; 
                        },
                        dataType: 'json', 
                        processResults: function (data) {
                            return {
                                results: $.map(data, function (item) {
                                    return {
                                        text: item.text,
                                        id: item.text
                                    }
                                })
                            };
                        }
                    }

                });
            });
        </script>

    </body>
</html>

api.php


<?php

 $terms = $_GET['data'];

 $data = file_get_contents("https://maps.googleapis.com/maps/api/place/autocomplete/json?input=".$terms."&types=geocode&key={YOUR_API_KEY}");


 $arr = array();
 $i=0;
 foreach(json_decode($data)->predictions as $item){
 $arr[$i] = array(
 'id' => $i,
 'text' => $item->description
 );
 $i++;
 }

 echo json_encode($arr);

?>

you just have to put above index.html and api.php in the same directory, and you replace {YOUR_API_KEY} with your’s one.

Important Note

By using google place API google simply needs some policy to follow (read this policy here), Google wants their “powered by Google” logo to be shown in the drop-down.

Note:- you need a live or local server to run this module.

Source: https://www.myprogrammingtutorials.com/autocomplete-address-search-module-google-api-php.html

PHP cURL Examples

2021-04-02T07:56:00.003-07:00

cURL is software which you can use to make various requests using different protocols. PHP has the option to use cURL and in this article, we’ll show several examples.

PHP cURL Basics

curl_init();      // initializes a cURL session
curl_setopt();    // changes the cURL session behavior with options
curl_exec();      // executes the started cURL session
curl_close();     // closes the cURL session and deletes the variable made by curl_init();

PHP cURL POST Request

A POST request is usually made to send user collected data to a server.

<?php

$postRequest = array(
    'firstFieldData' => 'foo',
    'secondFieldData' => 'bar'
);

$cURLConnection = curl_init('http://hostname.tld/api');
curl_setopt($cURLConnection, CURLOPT_POSTFIELDS, $postRequest);
curl_setopt($cURLConnection, CURLOPT_RETURNTRANSFER, true);

$apiResponse = curl_exec($cURLConnection);
curl_close($cURLConnection);

// $apiResponse - available data from the API request
$jsonArrayResponse - json_decode($apiResponse);

PHP cURL GET Request

A GET request retrieves data from a server. This can be a website’s HTML, an API response or other resources.

<?php

$cURLConnection = curl_init();

curl_setopt($cURLConnection, CURLOPT_URL, 'https://hostname.tld/phone-list');
curl_setopt($cURLConnection, CURLOPT_RETURNTRANSFER, true);

$phoneList = curl_exec($cURLConnection);
curl_close($cURLConnection);

$jsonArrayResponse - json_decode($phoneList);

PHP cURL Header

You can also set custom headers in your cURL requests. For this, we’ll use the curl_setopt() function.

curl_setopt($ch, CURLOPT_HTTPHEADER, array(
    'Header-Key: Header-Value',
    'Header-Key-2: Header-Value-2'
));

Source: https://www.webhostface.com/kb/knowledgebase/php-curl-examples/

dayofweek() : Records of the weekdays

2021-03-25T00:38:00.002-07:00

dayofweek() : Records of the weekdays

To get the number of weekday ( from 1 to 7 ) we will use dayofweek function of MySQL.

DAYOFWEEK(date)

Example

SELECT DAYOFWEEK('2016-05-06')

Output is 6.
For a invalid date output will give NULL
1 = Sunday , 2 = Monday, 3 = Tuesday, 4 = Wednesday , 5 = Thursday, 6 = Friday, 7 = Saturday

This function dayofweek returns values 1 to 7 based on the weekday starting from Sunday as 1, Monday as 2 and �so on for others. So if today is Thursday then dayofweek function will return 5. So we need before three days record ( excluding today ) from today to get the records stating from Monday. So we will deduct 2 from the weekday figure. Here is the query to get the records of all weekdays of a week till today.

SELECT id,date,weekday, dayofweek(CURDATE()) as dayofweek 
FROM dt_weekday 
WHERE `date` BETWEEN DATE_SUB( CURDATE( ) ,INTERVAL (dayofweek(CURDATE())-2) DAY ) AND CURDATE( )

Above query will collect records starting from Monday and ending with today. For example if today is Tuesday then you will get two records ( of Monday and Tuesday )

Please read the tutorial on last x day's record in part 1 of this tutorial. Here we will develop a query to get records of weekdays of the present week.

For your understanding we have displayed dayofweek value against each record.

Using weekday function

By using weekday function we will get the same result but here weekday will return different number for days.

Monday = 0, Tuesday = 1  and so on��

Here is a simple query

SELECT WEEKDAY(  '2014-08-15' )

Output of above query is 4 . (15th Aug 2014 is Friday).

Here is the query using weekday function to get records of the week starting from Monday.

SELECT id, DATE, weekday, WEEKDAY( CURDATE( ) ) AS weekday 
FROM dt_weekday 
WHERE  `date` BETWEEN DATE_SUB( CURDATE( ) , INTERVAL( WEEKDAY( CURDATE( ) ) ) DAY ) AND CURDATE( )

Previous One week records

By adjusting the interval in our above query we can return the records of previous Week starting from Monday to Saturday.

SELECT id, DATE, weekday, DAYOFWEEK( CURDATE( ) ) AS dayofweek 
FROM dt_weekday 
WHERE `date` 
BETWEEN DATE_SUB( CURDATE( ) , INTERVAL (dayofweek(CURDATE())+5) 
DAY ) 
AND DATE_SUB( CURDATE( ) , INTERVAL (dayofweek(CURDATE())) 
DAY )

Previous Two week records

This query can be further adjusted to return previous two weeks record. ( Check the difference with previous query )

SELECT id, DATE, weekday, DAYOFWEEK( CURDATE( ) ) AS dayofweek
FROM dt_weekday
WHERE  `date` 
BETWEEN DATE_SUB( CURDATE( ) , INTERVAL( DAYOFWEEK( CURDATE( ) ) +12 ) 
DAY ) 
AND DATE_SUB( CURDATE( ) , INTERVAL( DAYOFWEEK( CURDATE( ) ) +7 ) 
DAY )

Dynamic SQL Dump

Here is the sql dump to create table dt_weekday. This dump is dynamically created by considering previous 15 days and next 15 days starting from today. You will have one record for each day.

You should always take a fresh dump file from here for your testing, if you are not executing on same day.

One column weekday is kept to store name of the weekday ( sun, mon, tue � ) for your understanding.

CREATE TABLE IF NOT EXISTS `dt_weekday` (

  `id` varchar(3) NOT NULL,

  `date` date NOT NULL,

  `weekday` varchar(3) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8;



INSERT INTO `dt_weekday` VALUES ('-15', '2021-04-09','Fri' ); 
INSERT INTO `dt_weekday` VALUES ('-14', '2021-04-08','Thu' ); 
INSERT INTO `dt_weekday` VALUES ('-13', '2021-04-07','Wed' ); 
INSERT INTO `dt_weekday` VALUES ('-12', '2021-04-06','Tue' ); 
INSERT INTO `dt_weekday` VALUES ('-11', '2021-04-05','Mon' ); 
INSERT INTO `dt_weekday` VALUES ('-10', '2021-04-04','Sun' ); 
INSERT INTO `dt_weekday` VALUES ('-9', '2021-04-03','Sat' ); 
INSERT INTO `dt_weekday` VALUES ('-8', '2021-04-02','Fri' ); 
INSERT INTO `dt_weekday` VALUES ('-7', '2021-04-01','Thu' ); 
INSERT INTO `dt_weekday` VALUES ('-6', '2021-03-31','Wed' ); 
INSERT INTO `dt_weekday` VALUES ('-5', '2021-03-30','Tue' ); 
INSERT INTO `dt_weekday` VALUES ('-4', '2021-03-29','Mon' ); 
INSERT INTO `dt_weekday` VALUES ('-3', '2021-03-28','Sun' ); 
INSERT INTO `dt_weekday` VALUES ('-2', '2021-03-27','Sat' ); 
INSERT INTO `dt_weekday` VALUES ('-1', '2021-03-26','Fri' ); 
INSERT INTO `dt_weekday` VALUES ('0', '2021-03-25','Thu' ); 
INSERT INTO `dt_weekday` VALUES ('1', '2021-03-24','Wed' ); 
INSERT INTO `dt_weekday` VALUES ('2', '2021-03-23','Tue' ); 
INSERT INTO `dt_weekday` VALUES ('3', '2021-03-22','Mon' ); 
INSERT INTO `dt_weekday` VALUES ('4', '2021-03-21','Sun' ); 
INSERT INTO `dt_weekday` VALUES ('5', '2021-03-20','Sat' ); 
INSERT INTO `dt_weekday` VALUES ('6', '2021-03-19','Fri' ); 
INSERT INTO `dt_weekday` VALUES ('7', '2021-03-18','Thu' ); 
INSERT INTO `dt_weekday` VALUES ('8', '2021-03-17','Wed' ); 
INSERT INTO `dt_weekday` VALUES ('9', '2021-03-16','Tue' ); 
INSERT INTO `dt_weekday` VALUES ('10', '2021-03-15','Mon' ); 
INSERT INTO `dt_weekday` VALUES ('11', '2021-03-14','Sun' ); 
INSERT INTO `dt_weekday` VALUES ('12', '2021-03-13','Sat' ); 
INSERT INTO `dt_weekday` VALUES ('13', '2021-03-12','Fri' ); 
INSERT INTO `dt_weekday` VALUES ('14', '2021-03-11','Thu' ); 
INSERT INTO `dt_weekday` VALUES ('15', '2021-03-10','Wed' ); 
INSERT INTO `dt_weekday` VALUES ('16', '2021-03-09','Tue' );

Source & Credit: https://www.plus2net.com/sql_tutorial/date-dayofweek.php

Getting the recent week, one month or year records from MySQL table

2021-03-25T00:35:00.002-07:00

DATE_SUB() Getting the recent one month or year records from MySQL table

Syntax of DATE_SUB()

DATE_SUB(date, INTERVAL, expression, UNIT)

Example

SELECT DATE_SUB(  '2016-12-25', INTERVAL 3 DAY )

Output is 2016-12-22

We have subtracted three days form the given date by using DATE_SUB() function. In place of DAY we can use Month, year, hour, minute, second etc , here is the list.

unit Value	Expected expr Format	Example
DAY	DAYS	DATE_SUB( '2016-11-29', INTERVAL 10 DAY )
MONTH	MONTHS	DATE_SUB( '2015-11-20', INTERVAL 5 MONTH )
WEEK	WEEKS	DATE_SUB( '2016-08-20', INTERVAL 5 WEEK )
QUARTER	QUARTERS	DATE_SUB( '2016-08-20', INTERVAL 2 QUARTER )
YEAR	YEARS	DATE_SUB( '2016-02-23', INTERVAL 2 YEAR )
YEAR_MONTH	'YEARS-MONTHS'	DATE_SUB( '2016-02-23', INTERVAL '2-5' YEAR_MONTH )

To use the above Examples add SELECT at left and run the query.

SELECT DATE_SUB( '2016-02-23', INTERVAL 2 YEAR ); // 2014-02-23 
SELECT DATE_SUB( CURDATE(), INTERVAL 2 YEAR ); // 2018-02-23

The second query depends on the todays date, so your result will be different.
Some time we have to collect last 7 or 15 days or X days (or month, year or week) data from MySQL table.

For example let us find out who are the new members joined in our forum in last week. One shop may be interested in knowing new products added in last one month. What are the books arrived in last one year. Here irrespective of the date values we want the records of last X days from today, or we can say that the records between today and last X days ( month , year or week) are required.

We will use the MySQL function CURDATE() to get the today's date.

To get the difference in today date and previous day or month we have to use the MySQL function DATE_SUB

DATE_SUB is a MySQL function which takes date expression, the interval and the constant to return the date value for further calculation.

Here are some sample queries on how to get the records as per requirements . �

Last 10 days records

select * from dt_table where  `date` >= DATE_SUB(CURDATE(), INTERVAL 10 DAY)

The above query will return last 10 days records. Note that this query will return all future dates also. To exclude future dates we have to modify the above command a little by using between query to get records. Here is the modified one.

SELECT * FROM dt_table WHERE `date` BETWEEN DATE_SUB( CURDATE( ) ,INTERVAL 10 DAY ) AND CURDATE( )

Present Month Records

Starting from 1st day of the current month till now.

SELECT * FROM `dt_table` WHERE  date between  DATE_FORMAT(CURDATE() ,'%Y-%m-01') AND CURDATE()

Present Year Records

Starting from 1st Jan of the current Year till now.

SELECT * FROM `dt_table` WHERE  date between  DATE_FORMAT(CURDATE() ,'%Y-01-01') AND CURDATE()

Last one month records

Let us try to get records added in last one month

SELECT * FROM dt_table where  `date` >= DATE_SUB(CURDATE(), INTERVAL 1 MONTH)

Here also future records will be returned so we can take care of that by using BETWEEN commands if required.

SELECT * FROM dt_table WHERE date BETWEEN DATE_SUB(CURDATE(), INTERVAL 1 MONTH)  AND CURDATE();

Using Year

select * from dt_table WHERE `date` >= DATE_SUB(CURDATE(), INTERVAL 1 YEAR)

Using year with BETWEEN

SELECT * FROM dt_table WHERE date BETWEEN DATE_SUB(CURDATE(), INTERVAL 1 YEAR)  AND CURDATE();

Records of previous month of any year

SELECT * FROM  dt_table WHERE MONTH( DATE ) = MONTH( DATE_SUB(CURDATE(),INTERVAL 1 MONTH ))

Records of previous month of same year

SELECT * FROM  dt_table WHERE MONTH( DATE ) = MONTH( DATE_SUB(CURDATE(),INTERVAL 1 MONTH )) 
AND 
YEAR( DATE ) = YEAR( DATE_SUB(CURDATE( ),INTERVAL 1 MONTH ))

Note the difference between Last one month record and Previous month record

Records of two date ranges

We can collect records between a particular date ranges by using between command and DATE_SUB. Here are some queries to generate records between two date ranges.

SELECT * FROM dt_table WHERE `date` BETWEEN DATE_SUB( CURDATE( ) ,INTERVAL 3 MONTH ) AND DATE_SUB( CURDATE( ) ,INTERVAL 0 MONTH )

This query will return records between last three months. This query again we will modify to get the records between three moths and six months.

SELECT * FROM dt_table WHERE `date` BETWEEN DATE_SUB( CURDATE( ) ,INTERVAL 6 MONTH ) AND DATE_SUB( CURDATE( ) ,INTERVAL 3 MONTH )

Now let us change this to get records between 6 month and 12 month.

SELECT * FROM dt_table WHERE `date` BETWEEN DATE_SUB( CURDATE( ) ,INTERVAL 12  MONTH ) AND DATE_SUB( CURDATE( ) ,INTERVAL 6 MONTH )

With this you can understand how the records between a month range or a year range can be collected from a table. Note that the months ranges are calculated starting from current day. So if we are collecting records of last three months and we are in 15th day of 9th month then records of 15th day of 6th month we will get but the records of 14th day of 6th month will be returning on next query that is between 3 months and 6 months.

Records of present week

SELECT * FROM `dt_table` WHERE WEEKOFYEAR(date)=WEEKOFYEAR(CURDATE())

Records of previous week

SELECT * FROM `dt_table` WHERE WEEKOFYEAR(date)=WEEKOFYEAR(CURDATE())-1

Records of next week

SELECT * FROM `dt_table` WHERE WEEKOFYEAR(date)=WEEKOFYEAR(CURDATE())+1

Records of present week all working days ( Mon - Fri )

SELECT * FROM `dt_table` WHERE WEEKOFYEAR(date)=WEEKOFYEAR(CURDATE()) 
AND 
WEEKDAY(date)  BETWEEN 1 AND 5

Records of present week all working days till today

SELECT * FROM `dt_table` 
WHERE WEEKOFYEAR( DATE ) = WEEKOFYEAR( CURDATE( ) )
AND WEEKDAY( DATE ) BETWEEN 1 AND WEEKDAY(CURDATE())

Using Date and time Queries

Now let us calculate with Time

unit Value	Expected expr Format
Example
MICROSECOND	MICROSECONDS
DATE_SUB( '2016-02-23 20:55:58', INTERVAL 225 MICROSECOND )
SECOND	SECONDS
DATE_SUB( '2016-02-23 20:55:58', INTERVAL 2 SECOND )
MINUTE	MINUTES
DATE_SUB( '2016-02-23 20:55:58', INTERVAL 2 MINUTE )
HOUR	HOURS
DATE_SUB( '2016-02-23 20:55:58', INTERVAL 5 HOUR )
SECOND_MICROSECOND	'SECONDS. MICROSECONDS'
DATE_SUB( '2016-02-23 20:55:58', INTERVAL '1.543' SECOND_MICROSECOND )
MINUTE_MICROSECOND	'MINUTES: SECONDS. MICROSECONDS'
DATE_SUB ( '2016-02-23 20:55:58', INTERVAL '5:2.743' MINUTE_MICROSECOND )
MINUTE_SECOND	'MINUTES: SECONDS'
DATE_SUB( '2016-02-23 20:55:58', INTERVAL '5:2' MINUTE_SECOND )
HOUR_MICROSECOND	'HOURS:MINUTES: SECONDS. MICROSECONDS'
DATE_SUB( '2016-02-23 20:55:58', INTERVAL '5:2:1.249' HOUR_MICROSECOND)
HOUR_SECOND	'HOURS:MINUTES: SECONDS'
DATE_SUB( '2016-02-23 20:55:58', INTERVAL '5:2:1' HOUR_SECOND )
HOUR_MINUTE	'HOURS:MINUTES'
DATE_SUB( '2016-02-23 20:55:52', INTERVAL '5:2' HOUR_MINUTE )
DAY_MICROSECOND	'DAYS HOURS: MINUTES: SECONDS. MICROSECONDS'
DATE_SUB( '2016-02-23 20:55:52', INTERVAL '2 5:2:24.879' DAY_MICROSECOND
DAY_SECOND	'DAYS HOURS: MINUTES:SECONDS'
DATE_SUB( '2016-02-23 20:55:52', INTERVAL '2 5:2:24' DAY_SECOND)
DAY_MINUTE	'DAYS HOURS: MINUTES'
DATE_SUB( '2016-02-23 20:55:52', INTERVAL '2 5:2' DAY_MINUTE)
DAY_HOUR	'DAYS HOURS'
DATE_SUB( '2016-02-23 20:55:52', INTERVAL '2 5' DAY_HOUR)

Our sample table dt_table_tm stores login date with time in a field along with one more column showing event_id.

All records of Last 5 Hours

SELECT * FROM `dt_table_tm` WHERE tm>=DATE_SUB(NOW(), INTERVAL 5 HOUR)

All records of Last 48 Hours

SELECT * FROM `dt_table_tm` WHERE tm>=DATE_SUB(NOW(), INTERVAL 48 HOUR)

All records of 15 hours 12 minutes

SELECT * FROM `dt_table_tm` WHERE tm>=DATE_SUB(NOW() , INTERVAL '15:12' HOUR_MINUTE)

In place of NOW() we can use specific date and time ( timestamp ) Note : While using date use the format YYYY-mm-dd ( YEAR - Month - date) and while using time use HH:MM:SS ( Hour : Minutes : Seconds )

SELECT * FROM  `dt_table_tm` WHERE tm >= DATE_SUB( '2018-08-10 11:50:00', INTERVAL '2:18:33' HOUR_SECOND )

All logins between 9 and 10 hours ( from 9 and 10 both inclusive till it is not 11 )

SELECT * FROM `dt_table_tm` WHERE HOUR(tm) between 9 and 10

All logins betwee 9 and 10 for a perticular month and year

SELECT * FROM `dt_table_tm` WHERE HOUR(tm) between 9 and 10 and MONTH(tm)=08 and year(tm)=2018

By Using date_format()

SELECT * FROM `dt_table_tm` WHERE HOUR(tm) between 9 and 10 and date_format(tm,'%Y-%m')='2018-08'

All logins between 11 and 18 hours on a prticular day

SELECT * FROM `dt_table_tm` WHERE HOUR(tm) between 11 and 18 and date(tm)='2018-08-09'

All logins between two input times in hour : minutes : seconds on a perticular day

SELECT * FROM `dt_table_tm` WHERE date(tm)='2018-08-09' AND  TIME(tm) BETWEEN TIME('9:00:00') AND TIME('10:15:00')

Counting logins at different hours in all days ( using GROUP BY )

SELECT hour(tm) , count(event_id)   FROM `dt_table_tm` group by HOUR(tm)

First Login ( tm ) of all days. We will use GROUP BY and MIN()

SELECT DATE(tm), MIN(tm),DATE_FORMAT(MIN(tm),'%H : %i :%s') time 
FROM `dt_table_tm` GROUP BY  DATE(tm)

First Login of all days after a particular hour. ( HOUR(tm) >16 )

SELECT DATE(tm), MIN(tm),DATE_FORMAT(MIN(tm),'%H : %i :%s') time
 FROM `dt_table_tm`  WHERE HOUR(tm) > 16 GROUP BY  DATE(tm)

First login of all days after a particular HOUR Minutes and seconds.

SELECT DATE(tm), MIN(tm),DATE_FORMAT(MIN(tm),'%H : %i :%s') time 
 FROM `dt_table_tm`  WHERE TIME(tm) > '16:01:00'  GROUP BY  DATE(tm)

Credit & Source: https://www.plus2net.com/sql_tutorial/date-lastweek.php

HTML2Canvas does not render full div, only what is visible on screen?

2021-03-21T06:38:00.006-07:00

`html2canvas(htmlSource, {scrollY: -window.scrollY}).then(function(canvas) {var img = canvas.toDataURL();window.open(img);});`

Credit: https://stackoverflow.com/questions/36213275/html2canvas-does-not-render-full-div-only-what-is-visible-on-screen/59841384#59841384

How to Quickly Insert Date and Timestamp in Excel

2021-02-21T09:54:00.004-08:00

A timestamp is something you use when you want to track activities.

For example, you may want to track activities such as when was a particular expense incurred, what time did the sale invoice was created, when was the data entry done in a cell, when was the report last updated, etc.

This Tutorial Covers:

Let’s get started.

Keyboard Shortcut to Insert Date and Timestamp in Excel

If you have to insert the date and timestamp in a few cells in Excel, doing it manually could be faster and more efficient.

Here is the keyboard shortcut to quickly enter the current Date in Excel:

Control + : (hold the control key and press the colon key).

Here is how to use it:

Select the cell where you want to insert the timestamp.
Use the keyboard shortcut Control + :
- This would instantly insert the current date in the cell.

A couple of important things to know:

This shortcut would only insert the current date and not the time.
It comes in handy when you want to selectively enter the current date.
It picks the current date from your system’s clock.
Once you have the date in the cell, you can apply any date format to it. Simply go to the ‘Number Format’ drop-down in the ribbon and select the date format you want.

Note that this is not dynamic, which means that it will not refresh and change the next time you open the workbook. Once inserted, it remains as a static value in the cell.

While this shortcut does not insert the timestamp, you can use the following shortcut to do this:

Control + Shift + :

This would instantly insert the current time in the cell.

So if you want to have both date and timestamp, you can use two different cells, one for date and one for the timestamp.

Using TODAY and NOW Functions to Insert Date and Timestamps in Excel

In the above method using shortcuts, the date and timestamp inserted are static values and don’t update with the change in date and time.

If you want to update the current date and time every time a change is done in the workbook, you need to use Excel functions.

This could be the case when you have a report and you want the printed copy to reflect the last update time.

Insert Current Date Using TODAY Function

To insert the current date, simply enter =TODAY() in the cell where you want it.

Since all the dates and times are stored as numbers in Excel, make sure that the cell is formatted to display the result of the TODAY function in the date format.

To do this:

Right-click on the cell and select ‘Format cells’.
In the Format Cells dialog box, select Date category in the Number tab.
Select the required date format (or you can simply go with the default one).
Click OK.

Note that this formula is volatile and would recalculate every time there is a change in the workbook.

Insert Date and Timestamp Using NOW Function

If you want the date and timestamp together in a cell, you can use the NOW function.

Again, since all the dates and times are stored as numbers in Excel, it is important to make sure that the cell is formatted to have the result of the NOW function displayed in the format that shows the date as well as time.

To do this:

Right-click on the cell and select ‘Format cells’.
In the Format Cells dialog box, select ‘Custom’ category in the Number tab.
In the Type field, enter dd-mm-yyyy hh:mm:ss
Click OK.

This would ensure that the result shows the date as well as the time.

Note that this formula is volatile and would recalculate every time there is a change in the workbook.

Circular References Trick to Automatically Insert Date and Timestamp in Excel

One of my readers Jim Meyer reached out to me with the below query.

“Is there a way we can automatically Insert Date and Time Stamp in Excel when a data entry is made, such that it does not change every time there is a change or the workbook is saved and opened?”

This can be done using the keyboard shortcuts (as shown above in the tutorial). However, it is not automatic. With shortcuts, you’ll have to manually insert the date and timestamp in Excel.

To automatically insert the timestamp, there is a smart technique using circular references (thanks to Chandoo for this wonderful technique).

Let’s first understand what a circular reference means in Excel.

Suppose you have a value 1 in cell A1 and 2 in cell A2.

Now if you use the formula =A1+A2+A3 in cell A3, it will lead to a circular reference error. You may also see a prompt as shown below:

This happens as you are using the cell reference A3 in the calculation that is happening in A3.

Now, when a circular reference error happens, there is a non-ending loop that starts and would have led to a stalled Excel program. But the smart folks in the Excel development team made sure that when a circular reference is found, it is not calculated and the non-ending loop disaster is averted.

However, there is a mechanism where we can force Excel to at least try for a given number of times before giving up.

Now let’s see how we can use this to automatically get a date and timestamp in Excel (as shown below).

Note that as soon as I enter something in cells in column A, a timestamp appears in the adjacent cell in column B. However, if I change a value anywhere else, nothing happens.

Here are the steps to get this done:

Go to File –> Options.
In the Excel Options dialog box, select Formulas.
In the Calculated options, check the Enable iterative calculation option.
Go to cell B2 and enter the following formula:
```
=IF(A2<>"",IF(B2<>"",B2,NOW()),"")
```

That’s it!

Now when you enter anything in column A, a timestamp would automatically appear in column B in the cell adjacent to it.

With the above formula, once the timestamp is inserted, it doesn’t update when you change the contents of the adjacent cell.

If you want the timestamp to update every time the adjacent cell in Column A is updated, use the below formula (use Control + Shift + Enter instead of the Enter key):

=IF(A2<>"",IF(AND(B2<>"",CELL("address")=ADDRESS(ROW(A2),COLUMN(A2))),NOW(),IF(CELL("address")<>ADDRESS(ROW(A2),COLUMN(A2)),B2,NOW())),"")

This formula uses the CELL function to get the reference of the last edited cell, and if it’s the same as the one to the left of it, it updates the timestamp.

Note: When you enable iterative calculations in the workbook once, it will be active until you turn it off. To turn it off, you need to go to Excel Options and uncheck the ‘Enable iterative calculation’ option.

Using VBA to Automatically Insert Timestamp in Excel

If VBA is your weapon of choice, you’ll find it to be a handy way to insert a timestamp in Excel.

VBA gives you a lot of flexibility in assigning conditions in which you want the timestamp to appear.

Below is a code that will insert a timestamp in column B whenever there is any entry/change in the cells in Column A.

'Code by Sumit Bansal from https://trumpexcel.com
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo Handler
If Target.Column = 1 And Target.Value <> "" Then
Application.EnableEvents = False
Target.Offset(0, 1) = Format(Now(), "dd-mm-yyyy hh:mm:ss")
Application.EnableEvents = True
End If
Handler:
End Sub

This code uses the IF Then construct to check whether the cell that is being edited is in column A. If this is the case, then it inserts the timestamp in the adjacent cell in column B.

Note that this code would overwrite any existing contents of the cells in column B. If you want. You can modify the code to add a message box to show a prompt in case there is any existing content.

Where to Put this Code?

This code needs to be entered as the worksheet change event so that it gets triggered whenever there is a change.

To do this:

Right-click on the worksheet tab and select View Code (or use the keyboard shortcut Alt + F11 and then double click on the sheet name in the project explorer).
Copy-paste this code into the code window for the sheet.
Close the VB Editor.

Make sure you save the file with .XLS or .XLSM extension as it contains a macro.

Creating a Custom Function to Insert Timestamp

Creating a custom function is a really smart way of inserting a timestamp in Excel.

It combines the power of VBA with functions, and you can use it like any other worksheet function.

Here is the code that will create a custom “Timestamp” function in Excel:

'Code by Sumit Bansal from http://trumpexcel.com
Function Timestamp(Reference As Range)
If Reference.Value <> "" Then
Timestamp = Format(Now, "dd-mm-yyy hh:mm:ss")
Else
Timestamp = ""
End If
End Function

Where to Put this Code?

This code needs to be placed in a module in the VB Editor. Once you do that, the Timestamp function becomes available in the worksheet (just like any other regular function).

Here are the steps to place this code in a module:

Press ALT + F11 from your keyboard. It will open the VB Editor.
In the Project Explorer in VB Editor, right-click on any of the objects and go to Insert –> Module. This will insert a new module.
Copy-paste the above code in the module code window.
Close the VB Editor or press ALT + F11 again to go back to the worksheet.

Now you can use the function in the worksheet. It will evaluate the cell to its left and insert the timestamp accordingly.

It also updates the timestamp whenever the entry is updated.

Make sure you save the file with .XLS or .XLSM extension as it contains VB code.

Hope you’ve found this tutorial useful.

Source & Credits: https://trumpexcel.com/date-timestamp-excel/

PHPSpreadSheet Beginner Tutorial

2021-02-10T02:42:00.003-08:00

What is PHPSpreadSheet Library

PHPSpreadSheet library is purely writter in PHP and it main purpose of communicate your PHP application with Excel spreadsheet. Here communicate means data send and received or import or export from excel spreadsheet to PHP application and from PHP application to Excel file. It not only support excel file for reading and writing of data, but also read and write html file data and CSV file data. PHPSpreadSheet library is a import version of PHPExcel library. PHPExcel library is not maintained for many years and very less has used this library. Most of the user has been migrated to this PHPSpreadSheet library or any other alternate library.

If you want to use this PHPSpreadSheet Library, you have to PHP 7.1 version or latest PHP version. For this library you have to install composer in your computer.

How to install PHPSpreadSheet Library

If you are looking for install PHPSpreadsheet library, then you have to go command prompt and go to directory in which you want to download this library and write following command.


composer require phpoffice/phpspreadsheet

This command will download PHPSpreadSheet library by using composer. We will discuss following topic of PHPSpreadsheet library in this post.

1. Load Excel File Data in Browser

This is first topic, which we have discuss in this post is that How to view Excel Spreadsheet data in Browser by using PHPSpreadSheet library. Here we will make PHP script with PHPSpreadsheet library for load Excel sheet content directly in browser without store in our computer. Because this library has capability to view excel data in browser. Below you can find source code of directly view Excel data in browser.

index.php


<!DOCTYPE html>
<html>
   <head>
     <title>Load Excel Sheet in Browser using PHPSpreadsheet</title>
     <meta name="viewport" content="width=device-width, initial-scale=1.0">
     <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" />
   </head>
   <body>
     <div class="container">
      <br />
      <h3 align="center">Load Excel Sheet in Browser using PHPSpreadsheet</h3>
      <br />
      <div class="table-responsive">
       <span id="message"></span>
          <form method="post" id="load_excel_form" enctype="multipart/form-data">
            <table class="table">
              <tr>
                <td width="25%" align="right">Select Excel File</td>
                <td width="50%"><input type="file" name="select_excel" /></td>
                <td width="25%"><input type="submit" name="load" class="btn btn-primary" /></td>
              </tr>
            </table>
          </form>
       <br />
          <div id="excel_area"></div>
      </div>
     </div>
     <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.0/jquery.min.js"></script>
  </body>
</html>
<script>
$(document).ready(function(){
  $('#load_excel_form').on('submit', function(event){
    event.preventDefault();
    $.ajax({
      url:"upload.php",
      method:"POST",
      data:new FormData(this),
      contentType:false,
      cache:false,
      processData:false,
      success:function(data)
      {
        $('#excel_area').html(data);
        $('table').css('width','100%');
      }
    })
  });
});
</script>

upload.php


<?php

//upload.php

include 'vendor/autoload.php';

use PhpOffice\PhpSpreadsheet\IOFactory;
use PhpOffice\PhpSpreadsheet\Spreadsheet;

if($_FILES["select_excel"]["name"] != '')
{
 $allowed_extension = array('xls', 'xlsx');
 $file_array = explode(".", $_FILES['select_excel']['name']);
 $file_extension = end($file_array);
 if(in_array($file_extension, $allowed_extension))
 {
  $reader = IOFactory::createReader('Xlsx');
  $spreadsheet = $reader->load($_FILES['select_excel']['tmp_name']);
  $writer = IOFactory::createWriter($spreadsheet, 'Html');
  $message = $writer->save('php://output');
 }
 else
 {
  $message = '<div class="alert alert-danger">Only .xls or .xlsx file allowed</div>';
 }
}
else
{
 $message = '<div class="alert alert-danger">Please Select File</div>';
}

echo $message;

?>

2. Convert HTML Table Data to Excel Sheet Data

There are lots of tutorial available on Internet regarding make excel sheet from HTML table data, but that tutorial use javascript for convert html table data to excel data. But it has not make original excel spreadsheet but it has only open html data in excel file format. So, when we have open that type of excel then it has display corrupted or invalid file format message has been appear in window. This is because that file is not correctly excel file but only open html file in excel file. For make original excel file you have to use PHPSpreadsheet library or PHPExcel library. By using both library you can make excel sheet.

Here we have use PHPSpreadsheet library for create excel file from HTML table data. Here we have use simple jquery code with PHP script and PHPSpreadsheet library for export html table data to excel. First it will store html table data in temporary html file, then after by using PHPSpreadsheet IOFactory class method, it will read HTML file by using createReader() method of IOFactory class. Next it will make excel file from that temporary html file by using createWriter() method of PHPSpreadSheet IOFactory class. Once HTML table data has been exported to Excel file then excel sheet will be downloaded in computer and temporary excel file and temporary html file will be removed from working folder.

html-to-excel.php


<?php

//html-to-excel.php

$connect = new PDO("mysql:host=localhost;dbname=testing", "root", "");

$query = "SELECT * FROM sample_datas";

$statement = $connect->prepare($query);

$statement->execute();

$result = $statement->fetchAll();

?>

<!DOCTYPE html>
<html>
   <head>
     <title>Convert HTML Table to Excel using PHPSpreadsheet</title>
     <meta name="viewport" content="width=device-width, initial-scale=1.0">
     <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" />
   </head>
   <body>
     <div class="container">
      <br />
      <h3 align="center">Convert HTML Table to Excel using PHPSpreadsheet</h3>
      <br />
      <div class="table-responsive">
       <form method="POST" id="convert_form" action="export.php">
            <table class="table table-striped table-bordered" id="table_content">
              <tr>
                <th>First Name</th>
                <th>Last Name</th>
                <th>Created At</th>
                <th>Updated At</th>
              </tr>
              <?php
              foreach($result as $row)
              {
                echo '
                <tr>
                  <td>'.$row["first_name"].'</td>
                  <td>'.$row["last_name"].'</td>
                  <td>'.$row["created_at"].'</td>
                  <td>'.$row["updated_at"].'</td>
                </tr>
                ';
              }
              ?>
            </table>
            <input type="hidden" name="file_content" id="file_content" />
            <button type="button" name="convert" id="convert" class="btn btn-primary">Convert</button>
          </form>
          <br />
          <br />
      </div>
     </div>
     <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.0/jquery.min.js"></script>
  </body>
</html>

<script>
$(document).ready(function(){
 $('#convert').click(function(){
    var table_content = '<table>';
    table_content += $('#table_content').html();
    table_content += '</table>';
    $('#file_content').val(table_content);
    $('#convert_form').submit();
  });
});
</script>

export.php


<?php

//export.php

include 'vendor/autoload.php';
use PhpOffice\PhpSpreadsheet\IOFactory;

if(isset($_POST["file_content"]))
{
 $temporary_html_file = './tmp_html/' . time() . '.html';

 file_put_contents($temporary_html_file, $_POST["file_content"]);

 $reader = IOFactory::createReader('Html');

 $spreadsheet = $reader->load($temporary_html_file);

 $writer = IOFactory::createWriter($spreadsheet, 'Xlsx');

 $filename = time() . '.xlsx';

 $writer->save($filename);

 header('Content-Type: application/x-www-form-urlencoded');

 header('Content-Transfer-Encoding: Binary');

 header("Content-disposition: attachment; filename=\"".$filename."\"");

 readfile($filename);

 unlink($temporary_html_file);

 unlink($filename);

 exit;
}

?>

3. Import Data From Xls, Xlsx or CSV file to Mysql

PHPSpreadSheet library is able to read data from Excel file or CSV file. So, here we have use PHPSpreadSheet library has been use for Import data from Excel sheet or CSV file and Insert into Mysql table using PHP script. If we have developed any web based application, then data import is the basic feature for any PHP application. So, for this feature here we have use PHPSpreadsheet library for read data from Excel or CSV file, this is because by using this library, we can easily import data from Excel or CSV file and Insert into Mysql table using PHP script.

php_spreadsheet_import.php


<!DOCTYPE html>
<html>
   <head>
     <title>Import Data From Excel or CSV File to Mysql using PHPSpreadsheet</title>
     <meta name="viewport" content="width=device-width, initial-scale=1.0">
     <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" />
   </head>
   <body>
     <div class="container">
      <br />
      <h3 align="center">Import Data From Excel or CSV File to Mysql using PHPSpreadsheet</h3>
      <br />
        <div class="panel panel-default">
          <div class="panel-heading">Import Data From Excel or CSV File to Mysql using PHPSpreadsheet</div>
          <div class="panel-body">
          <div class="table-responsive">
           <span id="message"></span>
              <form method="post" id="import_excel_form" enctype="multipart/form-data">
                <table class="table">
                  <tr>
                    <td width="25%" align="right">Select Excel File</td>
                    <td width="50%"><input type="file" name="import_excel" /></td>
                    <td width="25%"><input type="submit" name="import" id="import" class="btn btn-primary" value="Import" /></td>
                  </tr>
                </table>
              </form>
           <br />
              
          </div>
          </div>
        </div>
     </div>
     <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.0/jquery.min.js"></script>
  </body>
</html>
<script>
$(document).ready(function(){
  $('#import_excel_form').on('submit', function(event){
    event.preventDefault();
    $.ajax({
      url:"import.php",
      method:"POST",
      data:new FormData(this),
      contentType:false,
      cache:false,
      processData:false,
      beforeSend:function(){
        $('#import').attr('disabled', 'disabled');
        $('#import').val('Importing...');
      },
      success:function(data)
      {
        $('#message').html(data);
        $('#import_excel_form')[0].reset();
        $('#import').attr('disabled', false);
        $('#import').val('Import');
      }
    })
  });
});
</script>

import.php


<?php

//import.php

include 'vendor/autoload.php';

$connect = new PDO("mysql:host=localhost;dbname=testing", "root", "");

if($_FILES["import_excel"]["name"] != '')
{
 $allowed_extension = array('xls', 'csv', 'xlsx');
 $file_array = explode(".", $_FILES["import_excel"]["name"]);
 $file_extension = end($file_array);

 if(in_array($file_extension, $allowed_extension))
 {
  $file_name = time() . '.' . $file_extension;
  move_uploaded_file($_FILES['import_excel']['tmp_name'], $file_name);
  $file_type = \PhpOffice\PhpSpreadsheet\IOFactory::identify($file_name);
  $reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader($file_type);

  $spreadsheet = $reader->load($file_name);

  unlink($file_name);

  $data = $spreadsheet->getActiveSheet()->toArray();

  foreach($data as $row)
  {
   $insert_data = array(
    ':first_name'  => $row[0],
    ':last_name'  => $row[1],
    ':created_at'  => $row[2],
    ':updated_at'  => $row[3]
   );

   $query = "
   INSERT INTO sample_datas 
   (first_name, last_name, created_at, updated_at) 
   VALUES (:first_name, :last_name, :created_at, :updated_at)
   ";

   $statement = $connect->prepare($query);
   $statement->execute($insert_data);
  }
  $message = '<div class="alert alert-success">Data Imported Successfully</div>';

 }
 else
 {
  $message = '<div class="alert alert-danger">Only .xls .csv or .xlsx file allowed</div>';
 }
}
else
{
 $message = '<div class="alert alert-danger">Please Select File</div>';
}

echo $message;

?>

4. Export Mysql Table Data to .xlsx, .xls or .csv File

PHPSpreadSheet library can write data in Excel or CSV file. So suppose you have build any web based application by using PHP script. Then you have to use PHPSpreadSheet library for export data from Mysql database to any spreadsheet file format like .xlsx, .xls or .csv file. Export data from web application is one of the feature of you system. If your system is able to give data to user in Excel or csv file, so it will increase your application usabilty and user can use that data for other purpose. So, below you can find source code for How to Export Mysql data to Excel or Csv file format by using PhpSpreadsheet library.

php_spreadsheet_export.php


<?php

//php_spreadsheet_export.php

include 'vendor/autoload.php';

use PhpOffice\PhpSpreadsheet\Spreadsheet;


$connect = new PDO("mysql:host=localhost;dbname=testing", "root", "");


$query = "SELECT * FROM sample_datas ORDER BY id DESC";

$statement = $connect->prepare($query);

$statement->execute();

$result = $statement->fetchAll();

if(isset($_POST["export"]))
{
  $file = new Spreadsheet();

  $active_sheet = $file->getActiveSheet();

  $active_sheet->setCellValue('A1', 'First Name');
  $active_sheet->setCellValue('B1', 'Last Name');
  $active_sheet->setCellValue('C1', 'Created At');
  $active_sheet->setCellValue('D1', 'Updated At');

  $count = 2;

  foreach($result as $row)
  {
    $active_sheet->setCellValue('A' . $count, $row["first_name"]);
    $active_sheet->setCellValue('B' . $count, $row["last_name"]);
    $active_sheet->setCellValue('C' . $count, $row["created_at"]);
    $active_sheet->setCellValue('D' . $count, $row["updated_at"]);

    $count = $count + 1;
  }

  $writer = \PhpOffice\PhpSpreadsheet\IOFactory::createWriter($file, $_POST["file_type"]);

  $file_name = time() . '.' . strtolower($_POST["file_type"]);

  $writer->save($file_name);

  header('Content-Type: application/x-www-form-urlencoded');

  header('Content-Transfer-Encoding: Binary');

  header("Content-disposition: attachment; filename=\"".$file_name."\"");

  readfile($file_name);

  unlink($file_name);

  exit;

}

?>
<!DOCTYPE html>
<html>
   <head>
     <title>Export Data From Mysql to Excel using PHPSpreadsheet</title>
     <meta name="viewport" content="width=device-width, initial-scale=1.0">
     <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" />
   </head>
   <body>
     <div class="container">
      <br />
      <h3 align="center">Export Data From Mysql to Excel using PHPSpreadsheet</h3>
      <br />
        <div class="panel panel-default">
          <div class="panel-heading">
            <form method="post">
              <div class="row">
                <div class="col-md-6">User Data</div>
                <div class="col-md-4">
                  <select name="file_type" class="form-control input-sm">
                    <option value="Xlsx">Xlsx</option>
                    <option value="Xls">Xls</option>
                    <option value="Csv">Csv</option>
                  </select>
                </div>
                <div class="col-md-2">
                  <input type="submit" name="export" class="btn btn-primary btn-sm" value="Export" />
                </div>
              </div>
            </form>
          </div>
          <div class="panel-body">
          <div class="table-responsive">
           <table class="table table-striped table-bordered">
                <tr>
                  <th>First Name</th>
                  <th>Last Name</th>
                  <th>Created At</th>
                  <th>Updated At</th>
                </tr>
                <?php

                foreach($result as $row)
                {
                  echo '
                  <tr>
                    <td>'.$row["first_name"].'</td>
                    <td>'.$row["last_name"].'</td>
                    <td>'.$row["created_at"].'</td>
                    <td>'.$row["updated_at"].'</td>
                  </tr>
                  ';
                }
                ?>

              </table>
          </div>
          </div>
        </div>
     </div>
      <br />
      <br />
     <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.0/jquery.min.js"></script>
  </body>
</html>

Sourece: https://www.webslesson.info/2020/03/phpspreadsheet-beginner-tutorial.html

Loading data remotely in Select2 with AJAX

2021-02-06T07:40:00.004-08:00

Select2 is a jQuery plugin that extends the functionality of a simple HTML drop-down element by allowing to search the list, adding the image with options, navigate to the option with arrow keys, etc.

It comes with the AJAX supports where you can call it in the same way as $.ajax in the jQuery.

The plugin provides the currently inputted value in the search box which can be used as data in the AJAX request.

1. Table structure

I am using users table.

CREATE TABLE `users` (
  `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  `username` varchar(80) NOT NULL,
  `name` varchar(80) NOT NULL,
  `password` varchar(80) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

2. Configuration

Create a config.php for database configuration.

Completed Code

<?php

$host = "localhost"; /* Host name */
$user = "root"; /* User */
$password = ""; /* Password */
$dbname = "tutorial"; /* Database name */

$con = mysqli_connect($host, $user, $password,$dbname);
// Check connection
if (!$con) {
  die("Connection failed: " . mysqli_connect_error());
}

3. Download and Include

Download the library from here.
Include select2.min.css and select2.min.js files with the jQuery library in the <head> section. You can also use the CDN.

<meta charset="UTF-8">
<link href='https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.3/css/select2.min.css' rel='stylesheet' type='text/css'>

<!-- Script -->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<script src='https://cdnjs.cloudflare.com/ajax/libs/select2/4.0.3/js/select2.min.js'></script>

4. HTML

Create a drop-down element.

Completed Code

<select id='selUser' style='width: 200px;'>
 <option value='0'>- Search user -</option>
</select>

5. PHP

Create a getData.php file.

Select all records with the limit of 5 when $_POST['searchTerm'] is not set otherwise select record according to the search term.

Create an array that initializes with user id and name. Return the array in JSON format.

NOTE – While creating associative array for initialize the Array make sure that their you have defined id and text keys otherwise the HTML element will not be initialized.

Completed Code

<?php
include 'config.php';

if(!isset($_POST['searchTerm'])){ 
  $fetchData = mysqli_query($con,"select * from users order by name limit 5");
}else{ 
  $search = $_POST['searchTerm'];   
  $fetchData = mysqli_query($con,"select * from users where name like '%".$search."%' limit 5");
} 

$data = array();
while ($row = mysqli_fetch_array($fetchData)) {    
  $data[] = array("id"=>$row['id'], "text"=>$row['name']);
}
echo json_encode($data);

6. jQuery

Call select2() method on the <select id='selUser'> to initialize the plugin. To load records remotely specify ajax option where set its url, type, dataType, delay, data, and processResults.

Get the entered values using params.term in data. The successful callback handle by processResults function where initialize results with the response.

Completed Code

$(document).ready(function(){

 $("#selUser").select2({
  ajax: { 
   url: "getData.php",
   type: "post",
   dataType: 'json',
   delay: 250,
   data: function (params) {
    return {
      searchTerm: params.term // search term
    };
   },
   processResults: function (response) {
     return {
        results: response
     };
   },
   cache: true
  }
 });
});

Credits: https://makitweb.com/loading-data-remotely-in-select2-with-ajax/

Best Way to redirect http to https in CodeIgniter

2020-12-20T00:16:00.002-08:00

Follow the below steps to enable http to https on your codeIgnitor 3.x using.

STEP 1. Config changes :- Go to “application/config/config.php” and enable or set hooks to true.

$config['enable_hooks'] = TRUE;

STEP 2: Create a new file named hooks.php in “application/config/hooks.php” if not exists and if its already exists just add below code in hooks.php

$hook['post_controller_constructor'][] = array(

'function' => 'redirect_ssl',

'filename' => 'ssl.php',

'filepath' => 'hooks'

);

STEP 3: Now create a new directory with named “hooks” under application directory and then create new file named “ssl.php” in “application/hooks/ssl.php” and add below code to “ssl.php”

function redirect_ssl() {

$CI =& get_instance();

$class = $CI->router->fetch_class();

$exclude = array('client'); // add all your controllers name to exclude ssl.

if(!in_array($class,$exclude)) {

// redirecting to ssl.

$CI->config->config['base_url'] = str_replace('http://', 'https://', $CI->config->config['base_url']);

if ($_SERVER['SERVER_PORT'] != 443) redirect($CI->uri->uri_string());

}

else {

// redirecting with no ssl.

$CI->config->config['base_url'] = str_replace('https://', 'http://', $CI->config->config['base_url']);

if ($_SERVER['SERVER_PORT'] == 443) redirect($CI->uri->uri_string());

}

Credits: https://stackoverflow.com/users/2261069/preetham-hegde

JavaScript : HTML Form validation - checking for password

2020-12-17T06:25:00.002-08:00

Password validation

Sometimes a password validation in a form is essential. You can create a password in different ways, it's structure may be simple, reasonable or strong. Here we validate various type of password structure through JavaScript codes and regular expression.

Check a password between 7 to 16 characters which contain only characters, numeric digits and underscore and first character must be a letter.
Check a password between 6 to 20 characters which contain at least one numeric digit, one uppercase and one lowercase letter.
Check a password between 7 to 15 characters which contain at least one numeric digit and a special character.
Check a password between 8 to 15 characters which contain at least one lowercase letter, one uppercase letter, one numeric digit, and one special character.

Following code blocks contain actual codes for the said validations. We have kept the CSS code part common for all the validations.

CSS Code:

li {list-style-type: none;
font-size: 16pt;
}
.mail {
margin: auto;
padding-top: 10px;
padding-bottom: 10px;
width: 400px;
background : #D8F1F8;
border: 1px soild silver;
}
.mail h2 {
margin-left: 38px;
}
input {
font-size: 20pt;
}
input:focus, textarea:focus{
background-color: lightyellow;
}
input submit {
font-size: 12pt;
}
.rq {
color: #FF0000;
font-size: 10pt;
}

To check a password between 7 to 16 characters which contain only characters, numeric digits, underscore and first character must be a letter

To validate the said format we use the regular expression ^[A-Za-z]\w{7,15}$, where \w matches any word character (alphanumeric) including the underscore (equivalent to [A-Za-z0-9_]). Next the match() method of string object is used to match the said regular expression against the input value. Here is the complete web document.

HTML Code:

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
title>JavaScript form validation - Password Checking - 1</title>
<link rel='stylesheet' href='form-style.css' type='text/css' />
</head>
<body onload='document.form1.text1.focus()'>
<div class="mail">
<h2>Input Password and Submit [7 to 15 characters which contain only characters, numeric digits, underscore and first character must be a letter]</h2
<form name="form1" action="#">
<ul>
<li><input type='text' name='text1'/></li>
<li class="rq">*Enter numbers only.</li>
<li>&nbsp;</li>
<li class="submit"><input type="submit" name="submit" value="Submit" onclick="CheckPassword(document.form1.text1)"/></li>
<li>&nbsp;</li>
</ul>
</form>
</div>
<script src="check-password-1.js"></script>
</body>
</html>

JavaScript Code:

function CheckPassword(inputtxt) 
{ 
var passw=  /^[A-Za-z]\w{7,14}$/;
if(inputtxt.value.match(passw)) 
{ 
alert('Correct, try another...')
return true;
}
else
{ 
alert('Wrong...!')
return false;
}
}

View the example in the browser

To check a password between 6 to 20 characters which contain at least one numeric digit, one uppercase and one lowercase letter

To validate the said format we use the regular expression ^(?=.*\d)(?=.*[a-z])(?=.*[A-Z]).{4,8}$. Next the match() method of string object is used to match the said regular expression against the input value. Here is the complete web document.

HTML Code:

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>JavaScript form validation - Password Checking - 2</title>
<link rel='stylesheet' href='form-style.css' type='text/css' />
</head>
<body onload='document.form1.text1.focus()'>
<div class="mail">
<h2>Input Password and Submit [6 to 20 characters which contain at least one numeric digit, one uppercase and one lowercase letter]</h2>
<form name="form1" action="#">
<ul>
<li><input type='text' name='text1'/></li>
<li class="rq">*Enter numbers only.</li>
<li>&nbsp;</li>
<li class="submit"><input type="submit" name="submit" value="Submit" onclick="CheckPassword(document.form1.text1)"/></li>
<li>&nbsp;</li>
</ul>
</form>
</div>
<script src="check-password-2.js"></script>
</body>
</html>

JavaScript Code:

function CheckPassword(inputtxt) 
{ 
var passw = /^(?=.*\d)(?=.*[a-z])(?=.*[A-Z]).{6,20}$/;
if(inputtxt.value.match(passw)) 
{ 
alert('Correct, try another...')
return true;
}
else
{ 
alert('Wrong...!')
return false;
}
}

View the example in the browser

To check a password between 7 to 15 characters which contain at least one numeric digit and a special character

To validate the said format we use the regular expression ^^(?=.*[0-9])(?=.*[!@#$%^&*])[a-zA-Z0-9!@#$%^&*]{7,15}$. Next the match() method of string object is used to match the said regular expression against the input value. Here is the complete web document.

HTML Code:

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>JavaScript form validation - Password Checking - 3</title>
<link rel='stylesheet' href='form-style.css' type='text/css' />
</head>
<body onload='document.form1.text1.focus()'>
<div class="mail">
<h2>Input Password and Submit [7 to 15 characters which contain at least one numeric digit and a special character]</h2>
<form name="form1" action="#">
<ul>
<li><input type='text' name='text1'/></li>
<li class="rq">*Enter numbers only.</li>
<li>&nbsp;</li>
<li><input type="submit" name="submit" value="Submit" onclick="allnumericplusminus(document.form1.text1)" /></li>
<li>&nbsp;</li>
</ul>
</form>
</div>
<script src="check-password-3.js"></script>
</body>
</html>

JavaScript Code

function CheckPassword(inputtxt) 
{ 
var paswd=  /^(?=.*[0-9])(?=.*[!@#$%^&*])[a-zA-Z0-9!@#$%^&*]{7,15}$/;
if(inputtxt.value.match(paswd)) 
{ 
alert('Correct, try another...')
return true;
}
else
{ 
alert('Wrong...!')
return false;
}
}

View the example in the browser

To check a password between 8 to 15 characters which contain at least one lowercase letter, one uppercase letter, one numeric digit, and one special character

To validate the said format we use the regular expression ^(?=.*\d)(?=.*[a-z])(?=.*[A-Z])(?=.*[^a-zA-Z0-9])(?!.*\s).{8,15}$. Next the match() method of string object is used to match the said regular expression against the input value. Here is the complete web document.

HTML Code:

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>JavaScript form validation - Password Checking - 4</title>
<link rel='stylesheet' href='form-style.css' type='text/css' />
</head>
<body onload='document.form1.text1.focus()'>
<div class="mail">
<h2>Input Password and Submit [8 to 15 characters which contain at least one lowercase letter, one uppercase letter, one numeric digit, and one special character]</h2>
<form name="form1" action="#">
<ul>
<li><input type='text' name='text1'/></li>
<li class="rq">*Enter numbers only.</li>
<li>&nbsp;</li>
<li><input type="submit" name="submit" value="Submit" onclick="allnumericplusminus(document.form1.text1)" /></li>
<li>&nbsp;</li>
</ul>
</form>
</div>
<script src="check-password-4.js"></script>
</body>
</html>

JavaScript Code:

function CheckPassword(inputtxt) 
{ 
var decimal=  /^(?=.*\d)(?=.*[a-z])(?=.*[A-Z])(?=.*[^a-zA-Z0-9])(?!.*\s).{8,15}$/;
if(inputtxt.value.match(decimal)) 
{ 
alert('Correct, try another...')
return true;
}
else
{ 
alert('Wrong...!')
return false;
}
}

View the example in the browser

Web Development

How to change the PHP version for subfolders or subdomains

Step 1 - Open the .htaccess file

Step 2 - Edit the .htaccess file

How to backup and download Database using PHP

How to Batch Import Huge CSV Fast using PHP (Million Records in Seconds)

Sample CSV dataset

Comments to “How to Batch Import Huge CSV Fast using PHP (Million Records in Seconds)”

Get a list of (date) quarters between two given dates. Return array of objects with information about each quarter

How to update product price programmatically in WooCommerce

How to update product price programmatically in WooCommerce

How to update the product price programmatically in WooCommerce

Before we start…

1) Update product price when a checkbox is selected

1.1 Add the checkbox input field to the products page

1.2 Update the price when the user adds a product to the cart

1.3 Recalculate the total price of the cart

2. Edit the product price based on user roles

3. Update product price based on product taxonomy

FINAL NOTES

Source: https://quadlayers.com/update-product-price-programmatically-in-woocommerce/Credit : SEBASTOPOLYS

Add image file upload field to WooCommerce single products

Remove jQuery Validate error class from input fields and apply on error labels only

Disable dynamic dropdown option value onchange another dynamic dropdown

Round number up to .49 or .99

PHP calculate a date based on function for working days for future

PHP: Calculating past and future dates

1. Calculating dates for past and future days

2. Working with days of the week

3. Using offsets to get the right day

4. Checking if a date is in the Past or Future

stripe cancel subscription using curl in php

stripe cancel subscription using curl in php

stripe cancel subscriptionCanceling subscriptions

Code for stripe cancel subscription using curl in php

jQuery DataTables: ROWSPAN in table body TBODY

Convert MSSQL to MySQL

Convert php date to mysql format

Autocomplete Address Search Module Using Google API and PHP

Steps to implement an autocomplete address search module

Important Note

Source: https://www.myprogrammingtutorials.com/autocomplete-address-search-module-google-api-php.html

PHP cURL Examples

PHP cURL Basics

PHP cURL POST Request

PHP cURL GET Request

PHP cURL Header

dayofweek() : Records of the weekdays

dayofweek() : Records of the weekdays

Using weekday function

Previous One week records

Previous Two week records

Dynamic SQL Dump

Source & Credit: https://www.plus2net.com/sql_tutorial/date-dayofweek.php

Getting the recent week, one month or year records from MySQL table

DATE_SUB() Getting the recent one month or year records from MySQL table

Last 10 days records

Present Month Records

Present Year Records

Last one month records

Records of previous month of any year

Records of previous month of same year

Records of two date ranges

Records of present week

Records of previous week

Records of next week

Records of present week all working days ( Mon - Fri )

Records of present week all working days till today

Using Date and time Queries

HTML2Canvas does not render full div, only what is visible on screen?

html2canvas(htmlSource, {scrollY: -window.scrollY}).then(function(canvas) { var img = canvas.toDataURL(); window.open(img);});

Credit: https://stackoverflow.com/questions/36213275/html2canvas-does-not-render-full-div-only-what-is-visible-on-screen/59841384#59841384

How to Quickly Insert Date and Timestamp in Excel

Keyboard Shortcut to Insert Date and Timestamp in Excel

Using TODAY and NOW Functions to Insert Date and Timestamps in Excel

Insert Current Date Using TODAY Function

Insert Date and Timestamp Using NOW Function

Circular References Trick to Automatically Insert Date and Timestamp in Excel

Using VBA to Automatically Insert Timestamp in Excel

Creating a Custom Function to Insert Timestamp

Source: https://quadlayers.com/update-product-price-programmatically-in-woocommerce/
Credit : SEBASTOPOLYS

`html2canvas(htmlSource, {scrollY: -window.scrollY}).then(function(canvas) {var img = canvas.toDataURL();window.open(img);});`