Spilit comma seprated string using SQL Server 2012

Create a function that will separate the comma-separated string and extract each word in using SQL Server 2012.

declare @str varchar(50),@l int,@i int,@p int,@slen int

select @str='o,222,333,kl,4444,555,88pol'

select @l=LEN(@str)

set @i=1

set @p=0

set @slen=1

Post data over with API using PHP

This post will help you to understand. How can you call an API created from ASP.NET MVC and calling from PHP?  API was created for the notification purpose for school.API Database is SQL server and server-side language is C#. You will see in this post how can you consume a post API created from other language and consume by PHP

Data Model

Field	Description
ID	Row ID (Auto Increment)
NotesText	Text of notification
NotesType	Attachment Type (Text,Link,File)
Path	Location of Attachemntq
ClassID	Class Name
NewGIF
CreateDate	Created Date

API Code (C#)

Horizontal Image Slider

Head Section

<link rel="stylesheet" href="lightslider.css" />

   

    <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>

    <script src="lightslider.js"></script>

CSS

<style>

        ul {

            list-style: none outside none;

            padding-left: 0;

            margin: 0;

        }

        .demo .item {

            margin-bottom: 60px;

        }