Bootstrap Table Server Side With PHP Example

Bootstrap Table Server Side With PHP and MYSQL. Table have licensed under the The MIT License. Server side table pagination example  HTML/Javascript code -Bootstrap Table Server Side: <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta name="description" content=""> <meta name="author" content=""> <title>Bootstrap Table Server Side</title> <!-- Bootstrap core CSS

Coldfusion Interview Questions

Coldfusion interview questions mostly asked by Interviewer. Some Coldfusion interview questions for experience developer. Q1: How to find last 3 character is .com in email? Answer: <cfoutput> <cfset string = "pintukumar_2013@hotmail.com"> #right(string,len(string)-find('.',string))# </cfoutput> Q2: What is difference between listContains and listFind? Answer: ListFind(): Looks for the value AS one of the list items. ListContains(): Looks

Convert Speech Text Using IBM Watson | Bluemix | Coldfusion

Convert speech to text using ibm web service with coldfusion cfhttp. First we need to create an account on ibm and bluemix to get username and password. More info: http://www.ibm.com/smarterplanet/us/en/ibmwatson/developercloud/speech-to-text.html https://console.ng.bluemix.net/catalog/services/speech-to-text. Convert Speech Text: <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.2/jquery.min.js"></script> <form name="postFile" id="voiceToText"> Browse (.wav) File <input type="file" name="waveFile"><br> <input type="submit" value="Submit"> </form> <br> <!--- This is audio player

Convert Query Column Values Into To Column In Coldfusion

Convert Query Column Values Into To Column using coldfusion, ArrayNew, QueryNew, cffunction, queryAddColumn, ListGetAt etc. Convert Query Column Values Into To Column – CFC Code: <cffunction name="queryColumnValuesIntoColumns" returntype="query"> <cfargument name="inputQuery" type="query" required="true"> <cfargument name="includeHeaders" type="boolean" default="yes" required="false"> <cfset var outputQuery = QueryNew("")> <cfset var columnsList = inputQuery.ColumnList> <cfset var newColumn = ArrayNew(1)> <cfset var row

Google place Api – Find place and nearby places and directions

Google place Api Google Place Api Autocomplete address and Search Places and Find direction and places between current place using google map api with bootstrap tab. <!DOCTYPE html> <html> <head> <title>Place Autocomplete Address Form</title> <meta name="viewport" content="initial-scale=1.0, user-scalable=no"> <meta charset="utf-8"> <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css"> <link type="text/css" rel="stylesheet" href="https://fonts.googleapis.com/css?family=Roboto:300,400,500"> <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script> <script src="https://maps.googleapis.com/maps/api/js?v=3.exp&libraries=places"></script> <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/js/bootstrap.min.js"></script> </head> <body>

Indexes – Advantages And Disadvantages In Database

Advantages And Disadvantages Of Indexes In Database. An index allows the program to find the specific data in a table without scanning the entire table. SQL have two type of indexes: Clustered Index: A table can have only one clustered index because the clustered index dictates the physical storage order of the data. Non-Clustered Index:

Make Filterable Download In Datatable Server Side

Make Filterable Download In Datatable Server Side. DataTables is a plug-in for the jQuery Javascript library. Here is a example to export data in csv using filtered and searched records in server side. Datatable Server Side HTML Code: <table cellpadding="0" cellspacing="10" width="100%" id="demoDownloadFilteredTable" class="display datatable"> <thead> <tr> <th>FirstName</th> <th>LastName</th> </tr> </thead> </table> Datatable Server Side

Export data into csv and force to download in coldfusion

Export data into csv and force to download in coldfusion. I am tired many types of downloading in coldfusion but I found this method faster then other one. You can also force to download created CSV file by using cfheader and cfcontent. <cfquery name="getRecords" datasource="demoDB"> SELECT id, firstName, lastName, emailId FROM users WHERE created_dt BETWEEN

Oauth2 refresh access token on expired in coldfusion

OAuth2 Server. Refresh access token when an old one expired. A ColdFusion component to manage generating access tokens, refresh token and authorization codes. Get Oauth2 Access Token <Cffunction name="renewAccessToken" output="true" returnType="any" access="private"> <cfset callURL = "authURL"/> <cfset bodyJSON = '{"clientId": "xxxxxxxxxxxxxxxxx","clientApiToken": "xxxxxxxxxxxxxxxxxxxxx"}' /> <cfhttp method="post" url="#callURL#" result="result"> <cfhttpparam type="header" name="Content-Type" value="application/json"> <cfhttpparam type="body" value="#bodyJSON#" />

Bootstrap Grid Tutorial – Grid Has Predefined Classes

Bootstrap Grid Bootstrap Grid has predefined classes that allows up to 12 columns across the page to create responsive website layouts. Bootstrap 3 introduces the responsive mobile first fluid grid system that appropriately scales up to 12 columns and the columns will re-arrange automatically depending on the screen size. You can group the columns together

Bootstrap Heading – Default font-size is 14px

Bootstrap Heading Its default fonts like Helvetica Neue, Helvetica, Arial, and sans-serif and default font-size is 14px, with a line-height of 1.428. Bootstrap typography creates headings, paragraphs, lists and other inline elements. Headings <h1> To <h6> Example: Bootstrap styles Headings tags <h1> to <h6> <h1>This is heading 1 (36px)</h1> <h2>This is heading 2 (30px)</h2> <h3>This

Bootstrap Button Groups

Bootstrap Button Groups We can use bootstrap buttons as group of buttons in a div element using .btn-group class. Bootstrap has many optional classes to group buttons together. .btn-group class: <div class="btn-group"> <button type="button" class="btn btn-primary">Coldfusion</button> <button type="button" class="btn btn-primary">PHP</button> <button type="button" class="btn btn-primary">Sql Server</button> </div> Bootstrap vertical button groups using .btn-group-vertical class: <div class="btn-group-vertical">

Bootstrap Badges – .Badge Class Highlight – Unread Items

Bootstrap Badges highlight new or unread items. Badges work with .badge class within elements. The Badges corners are more rounded then labels.  Bootstrap Badges .badge class examples: <a href="#">News <span class="badge">10</span></a><br> <a href="#">Comments <span class="badge">15</span></a><br> <button type="button" class="btn btn-primary">Inbox <span class="badge">25</span></button>

Bootstrap Labels

Bootstrap labels displays additional information on the web pages such as important notes, warning messages, etc. Bootstrap .label class work with .label-default .label-primary .label-success .label-info .label-warning or .label-danger contextual classes within a span element. Example Label Classes: <span class="badge badge-default">Default Label</span> <span class="badge badge-primary">Primary Label</span> <span class="badge badge-success">Success Label</span> <span class="badge badge-info">Info Label</span> <span class="badge

Progress Bar in Bootstrap to show an action

A progress bar is used to show an action, how far in a process and not supported in Internet Explorer 9 and below or older versions of Firefox and Opera 12 does not support animations progress bar. Its provides several types of progress bars Like Colored Progress Bars, Striped Progress Bars,  etc. with .progress class

Bootstrap Pagination

Pagination is used to display a limited number of posts or results on every page. Bootstraps creates pagination to add the .pagination class to an ul element. Basic Bootstrap Pagination: <ul class="pagination"> <li class="page-item"><a class="page-link" href="#">Previous</a></li> <li class="page-item"><a class="page-link" href="#">1</a></li> <li class="page-item"><a class="page-link" href="#">2</a></li> <li class="page-item"><a class="page-link" href="#">3</a></li> <li class="page-item"><a class="page-link" href="#">Next</a></li> </ul> Active State

Coldfusion ListFindNocase

Coldfusion ListFindNocase Coldfusion ListFindNocase is used to search case-insensitive in list index. ListFindNocase return Index of the first list element that contains value. If not found, returns zero. Syntax: ListFindNoCase(list, value, delimiters, includeEmptyValues) NOTE: 1. delimiters – The default value is comma. 2. includeEmptyValues is Optional. Set to yes to include empty values. <cfset List

Coldfusion Querynew – Cfoutput Query – Cfloop Query

Coldfusion Querynew: Querynew() function creates a new query object with queryAddRow(), querySetCell() functions. Querynew Syntax: <cfset employeeQuery = QueryNew("empName, department", "VarChar, VarChar")> <cfset QueryAddRow(employeeQuery)> <cfset QuerySetCell(employeeQuery, "empName", "Pintu Kumar")> <cfset QuerySetCell(employeeQuery, "department", "IT")> <cfset QueryAddRow(employeeQuery)> <cfset QuerySetCell(employeeQuery, "empName", "Rahul Pal")> <cfset QuerySetCell(employeeQuery, "department", "IT")> <cfset QueryAddRow(employeeQuery)> <cfset QuerySetCell(employeeQuery, "empName", "Reenu Pal")> <cfset QuerySetCell(employeeQuery, "department", "HR")>