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;

        }

ASP.NET MVC 3 and the @helper syntax within Razor

When you make a website then sometimes you need to make a reusable HTML component, for example, you want to show testimonial on the various page. For doing this you need to copy-paste testimonial HTML on pages where it is required. The problem arises when any modification is done on Testimonial, You will have to update testimonial manually on every page which is time taking and prone to error.