Create .ICS file using PHP code

Recently worked on creating a .ics file in PHP after a very long time, code so thought to share with everybody.

Please find below the complete code and modify it as per your need. 

Once the .ics file is generated, you can open it in Outlook and Save it.

<?php

class ICS {

    var $data;

    var $name;

    function ICS($start,$end,$name,$description,$location) {

        $this->name = $name;

        $this->data = "BEGIN:VCALENDAR\nVERSION:2.0\nMETHOD:PUBLISH\nBEGIN:VEVENT

        \nDTSTART:".date("Ymd\THis\Z",strtotime($start)).

        "\nDTEND:".date("Ymd\THis\Z",strtotime($end))."\nLOCATION:".$location."

        \nTRANSP: OPAQUE\nSEQUENCE:0\nUID:\nDTSTAMP:"

        .date("Ymd\THis\Z")."\nSUMMARY:".$name."\nDESCRIPTION:".

        $description."\nPRIORITY:1\nCLASS:PUBLIC\nBEGIN:VALARM\nTRIGGER:-PT10080M

        \nACTION:DISPLAY\nDESCRIPTION:Reminder\nEND:VALARM\nEND:VEVENT\nEND:VCALENDAR

        \n";

    }

    function save() {

        file_put_contents($this->name.".ics",$this->data);

    }

    function show() {

        header("Content-type:text/calendar");

        header('Content-Disposition: attachment;

        filename="'.$this->name.'.ics"');

        Header('Content-Length: '.strlen($this->data));

        Header('Connection: close');

        echo $this->data;

    }

}

$event = new ICS("2024-02-06 09:00","2024-02-06 21:00",

"Test Event", "This is an event made by Test User","Test Location");

$event->save();

$event->show();

Replace, Substring and Words Count in MySQL

Some useful string functions in MySQL.

If you want to replace a string in a given string.

SELECT name, REPLACE(name, 'Demo', 'Test') AS `replaced_string` FROM `table_names`;

If you want to get the first word in a given string.

SELECT name, SUBSTRING_INDEX(name, ' ', 1) AS first_word FROM `table_names`;

If you want to get the count of words in a string.

SELECT name, (LENGTH(name) - LENGTH(REPLACE(name, ' ', '')) + 1) AS word_count  FROM `table_names`;

Kafka

KAFKA is an open source developed by LinkedIn for data pipelining, data streaming, data processing, and data transferring with maximum throughput. It's managed by Apache.

We use Kafka on the AWS environment under Python and PHP technologies to manage a high volume of data to load in a fraction of a second.

Kafka helps in real-time data streaming, connecting to any sources like AWS S3, can be auto-scale and optimize data streams. Many big giants using Kafka.

Laravel Trottle AddHeaders Error

We sometimes face this error when new install Laravel and run composer udpate

 Type error: Argument 1 passed to Illuminate\\Routing\\Middleware\\ThrottleRequests::addHeaders()

must be an instance of Symfony\\Component\\HttpFoundation\\Response, null given

Solution:

For me, the issue is resolved by correcting database credentials in the .env file. Hope the same will work for

you as well.

Test Web Apps on all browsers online

Test Web Apps on different browsers online

Browserstack is the best solution to test website UI/UX on different browsers simulators at single place online.

Click here for more info:

https://www.browserstack.com/

I used this https://www.browserstack.com/ for my apps to test UI/UX and performance of my apps. We can get following browsers at one place:

1. Google Chrome - All Versions
2. IE - All Versions 
3. Safari - All Versions
4. Android - All Versions
5. IOS - All devices, All Versions
6. Opera browsers

Microsoft Graph API PHP

Microsoft Graph API PHP Tutorials

I am sharing some basic sample PHP code for Microsoft Graph API. May this will  helpful for someone.

For full reference, go to GIT URL:

https://github.com/microsoftgraph/msgraph-sdk-php

PHP Framework Laravel Sample Code GIT URL:

https://github.com/microsoftgraph/php-connect-sample

To start, you should have Outlook/Hotmail or any Microsoft Account.

First required to register App on Azure Active Directory. You can create App on Azure even if you have School or Organization account.

Graph API will generate Microsoft Authentication URL, where user will redirect and after successful login he will redirect back callback URL. Callback URL need to define in Azure App.

User can get Calendar events based on dates provided. User can create events on their Calendar.

Sharing Create Calendar Event using Microsoft Graph API.

<?php

// POST /me/events

$events_response = $graph->createRequest('POST', '/me/events')

    ->attachBody($newEvent)

    ->setReturnType(Model\Event::class)

    ->execute();

Get Calendar Events using Microsoft Graph API

<?php

$userEventsArr = $graph->createRequest('GET', $getEventsUrl)

// Add the user's timezone to the Prefer header

    ->addHeaders(array(

        'Prefer' => 'outlook.timezone="' . $userTimezone . '"',

    ))

    ->setReturnType(Model\Event::class)

    ->execute();

Calculate Number of Days PHP

Calculate Number of Working Days Between Two Days in PHP

I am sharing my PHP code to get difference between two dates.

$workingDays = 0;
$startTimestamp = strtotime('2021-06-03');
$endTimestamp = strtotime('2022-07-09');
for ($i = $startTimestamp; $i <= $endTimestamp; $i = $i + (60 * 60 * 24)) {
    if (date("N", $i) <= 5) $workingDays = $workingDays + 1;
}
echo "no. of days: " . $workingDays;

Save code in nofdays.php.

Run program in terminal. Output will be:

$ php nofdays.php

no. of days: 287

Digital E-sign Tool

Digital E-sign Tool

I have developed Digital E-Signature Tool to digital sign any PDF file. It's a developed in HTML5, JQuery technology and JSPDF library. JS Signature Pad library is also used. PHP script is also added to save the file on server. May be its helpful for someone.

User can drag signature at any place on the PDF document. User can upload signature as well.

    

Full code can be found at below Bitbucket URL:

sourabhgupta3838 / ws-esign — Bitbucket

First we load any PDF.  Then user click Add signature button. User can upload signature file as well. Once user draw or upload his signature, it will show in drag area on right side. User can drag that signature anywhere on the PDF file. Once user click Acceptance checkbox, as most of the sites ask for acceptance of policy or any agreement. Submit button becomes available. User can save signature file, email that or upload on server, developer has to write that script as per his requirements.

PDF file generation from HTML file in Python

PDF Generation from HTML File in Python

I am sharing my script to generate PDF file from HTML file in Python using PDFKit module.

Install Python PDF-Kit

$ pip install pdfkit

Some Simple Examples:

import pdfkit

pdfkit.from_url('http://testpage.com', 'out.pdf')
pdfkit.from_file('test.html', 'out.pdf')
pdfkit.from_string('Hello!', 'out.pdf')

My Sample Script to generate PDF from HTML page.

 import os
import sys
from flask import Flask,request
import pdfkit
from flask import make_response
import logging.config
app = Flask(__name__)
from decouple import config
# Logger and handlers
LOGGING = {
    'version': 1,
    'disable_existing_loggers': False,
    'formatters': {
        'console': {
            'format': '%(levelname)-1s: %(asctime)s [%(name)-12s.%(funcName)s.%(lineno)s] %(message)s',
        },
        'file': {
            'format': '%(levelname)-1s: %(asctime)s [%(name)-12s.%(funcName)s.%(lineno)s] %(message)s',
        },
    },
    'handlers': {
        'console': {
            'level': "DEBUG",
            'class': 'logging.StreamHandler',
            'formatter': 'console',
            'stream': sys.stdout
        },
        'file': {
            'level': "DEBUG",
            'class': 'logging.handlers.RotatingFileHandler',
            'formatter': 'file',
            'filename': 'htmltopdf.log',
        },
    },
    'loggers': {
        '': {
            'handlers': ['file'],
            'level': "DEBUG",
            'propagate': True
        },
    }
}
logging.config.dictConfig(LOGGING)
LOGGER = logging.getLogger(__name__)

@app.route("/")
# Function for html to pdf convertor
def function_html_to_pdf_convertor():
    try:
        logging.debug("calling func")
        html_file = request.args.get('f', default="", type=str)
        if html_file:
            html_file = '{}{}'.format(html_file,'.html')
            filepath = os.path.join(app.static_folder, html_file)
            filename = os.path.splitext(os.path.basename(filepath))[0]
            css = "static/style.css"
            options = {
                'page-size': 'Letter',
                'encoding': "UTF-8",
                'zoom': 1.80,
                'footer-center': 'Page [page]/[topage]',
                'footer-font-size': 8
            }
            if os.path.isfile(filepath):
                #pdf = pdfkit.from_file(filepath, css=css)
                pdf = pdfkit.from_file(filepath, False,options=options, css=css)
                response = make_response(pdf)
                response.headers.set('Content-Disposition', 'attachment', filename=filename + '.pdf')
                response.headers.set('Content-Type', 'application/pdf')
                return response
            else:
                logging.debug("File not found")
                return {
                    "status": 404,
                    "message": 'File not found'
        }
        logging.debug("'Please provide file'")
        return{
            "status": 400,
            "message": 'Please provide file'
        }
    except Exception as e:
        logging.debug("Bad request {}".format(e))
        return {
            "status": 400,
            "error": '{}'.format(e)
        }
# main function
if __name__ == "__main__":
    app.run()

AWS Cognito SSO Integration with Python

AWS Cognito SSO Integration with Python

AWS SSO Cognito OAuth2.0 implementation as per below URL:

https://aws.amazon.com/blogs/mobile/understanding-amazon-cognito-user-pool-oauth-2-0-grants/

First we need to create code, get Client ID and Client Secret. Run below URL:

https://AUTH_DOMAIN/login?client_id=XXXXXXXXXX&response_type=code&scope=email+openid&redirect_uri=http://localhost/test/sso_check

Above URL will return to redirect url with code in query string.

Note: Code is valid for one time transaction only.

Get Access Token using the Code as per below description:

Make below request:

this will return below response:

{

    "id_token": "eyJraWQiOiJJNGs2UXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX",

    "access_token": "eyJraWQiOiJENllqdXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX",

    "refresh_token": "eyJjdHkiOiJKV1QiLCJlbmXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX",

    "expires_in": 3600,

    "token_type": "Bearer"

}

From above response we need to use id_token to get user information:

• id_token – A valid user pool ID token. Note that an ID token is only provided if the openid scope was requested.

Below is the Python code Github URL to get user information by validating JWT token returned in id_token key.

https://github.com/awslabs/aws-support-tools/tree/master/Cognito/decode-verify-jwt

https://github.com/awslabs/aws-support-tools/blob/master/Cognito/decode-verify-jwt/decode-verify-jwt.py

Below is the response from above Python code:

Python Flask REST API Tutorial

Python Flask REST API Tutorial

I am sharing my Python code to create simple REST API. I have used Python's lightweight framework Flask is used to create simple REST API. Flask Restful is an extension of Flask. This code may helpful for some beginner Python developer. 

from flask import Flask

from flask_restful import Resource, Api

app = Flask(__name__)

api = Api(app)

class HelloWorld(Resource):

    def get(self):

        return {'hello': 'world'}

api.add_resource(HelloWorld, '/')

if __name__ == '__main__':

    app.run(debug=True)

Print CSV Content in Python Tutorial

As CSV is most common file to import and export data on web applications. So we may need to use this feature in almost our most of the apps. So I am sharing my small Python code to print CSV data into an array. May this code is helpful for someone.

We need CSV module of Python for this code to run. We used CSV module `reader` function to read CSV content in Python.

import csv

results = []

with open('test.csv', newline='') as csvfile:

    reader = csv.reader(csvfile, delimiter=' ', quotechar='|')

    for row in reader:

        results.append(row)

print("CSV data: ", results)

More details on CSV module of Python, please follow below URL:

https://docs.python.org/3/library/csv.html

Python Basics 

 Python is an easy to learn, powerful programming language. It has efficient high-level data structures and a simple but effective approach to object-oriented programming.

Python is an interpreted language, which can save you considerable time during program development because no compilation and linking is necessary.

Python is extensible: with C/C++/Java code, and easily embeddable in applications.

Some Python modules are also useful as scripts.

Python source files are treated as encoded in UTF-8.

Start the interpreter and wait for the primary prompt, >>>.

The interpreter acts as a simple calculator. The operators +, -, * and / work just like in most other languages.

Python can also manipulate strings.  They can be enclosed in single quotes (‘) or double quotes (“). 

Simple print command in Python.

print("Hello world")

Math Commands acts like a calculator.

>>> 2 + 2

4

>>> 17 / 3  # classic division returns a float

5.666666666666667

>>> 5 * 3 + 2  # result * divisor + remainder

17

>>> width = 20

>>> height = 5 * 9

>>> width * height

900

If Statement in Python: Below example is asking to input integer value. isdigit() function is checking if provided value in of type int.

Try Except statements are used for catching any exception. It protects any exception if we don't enter any

input.

try:

    x = int(input("Please enter number: "))

    if x.isdigit():

        if x <= 0:

            x = 0

            print('Printing 0 value')

        elif x < 10:

            print('Printing ' + str(x))

        else:

            print('Value is very big')

except:

    print("Please enter valid input")

For Loop Below example printing hexa code of colors by their name in Python.

Install colour package of Python

pip install colour

Ref: https://pypi.org/project/colour/

Converts and manipulates common color representation (RGB, HSL, web, …)

from colour import Color

colors = ['red', 'green', 'white', 'blue']

for c in colors:

    n = Color(c)

    print(c, n.hex)

Fibonacci Series in Python as follows:

# Fibonacci series:

# the sum of two elements defines the next

a, b = 0, 1

while a < 10:

    print(a)

    a, b = b, a+b

For loop in Python:

a = 0 b = [] for a in range(0, 10): b.append(4 + ((a - 1) * 3)) s = ',' . join(str(c) for c in b) print(s) // print array elements in string

Function in Python:

def parrot(a, b, c):

print(a,b,c)

d = {"a": "this", "b": " is my ", "c": "test"}

parrot(**d)

AWS X-ray Send Traces Lumen

AWS X-ray Test Script in PHP Framework Lumen

I have tested sending traces to AWS X-Ray through API Gateway through Lumen.

I have used below PHP package:

https://packagist.org/packages/pkerrigan/xray

<?php

namespace App\Http\Controllers\API;

use App\Http\Controllers\Controller;

use Illuminate\Http\Request;

use App\Support\Response;

use Pkerrigan\Xray\Trace;

use Pkerrigan\Xray\Submission\DaemonSegmentSubmitter;

use Pkerrigan\Xray\Segment;

class TestController extends Controller

{

    /**

     * construct

     */

    public function __construct(Response $response) {

        $this->response = $response;

    }

    /**

     * test xray

     */

    public function xray() {    

      try {  

        if(env('ENABLE_XRAY')) {

              //echo "----Tracing Start 14 ----";

              Trace::getInstance()

                ->setTraceHeader($_SERVER['HTTP_X_AMZN_TRACE_ID'] ?? null)

                ->setName('api-1')

                ->setUrl("[API-1-URL]")

                ->setMethod('GET')

                ->begin();

              Trace::getInstance()

                ->setTraceHeader($_SERVER['HTTP_X_AMZN_TRACE_ID'] ?? null)

                ->setName('api-2')

                ->setUrl("[API-2-URL]")

                ->setMethod('GET')

                ->begin();

                

              Trace::getInstance()

                ->setTraceHeader($_SERVER['HTTP_X_AMZN_TRACE_ID'] ?? null)

                ->setName('api-3')

                ->setUrl("[API-3-URL]")

                ->setMethod('GET')

                ->begin();    

                  

              Trace::getInstance()

              ->getCurrentSegment()

              ->end()

              ->setResponseCode(http_response_code())

              ->submit(new DaemonSegmentSubmitter());

              return $this->response->success(array('xray-res' => 'success'));

          } else {

            return $this->response->success(array('xray-res' => 'no-set'));

          }

        } catch(Exception $e) {

          return $this->response->success(array('xray-res' => $e->getMessage()));

        }

    }

}