Posts

Showing posts from October, 2015

Benefits Of Stored Procedures

There are many benefits of using a stored procedures like increased execution speed, fast access data, consistency etc. 1. Execution Speed Increased execution speed is the most useful advantage of Stored Procedures. Stored Procedures are optimized the first time they are compiled. Stored procedures are cached on the server. 2. Security One of the most useful advantage of using Stored Procedures is security. We can give execute rights to store procedure so it can perform the right task. It creates a more secure enviroment. 3. Fast Data Access SQL Stored Procedures are optimized for best execution path to the required data. 4. Consistency Utilizing Stored Procedures enforces consistency, since users do not have to create and use their T-SQL statements. 5. Modular Programming One of the most usefull advantage of Stored Procedures that Stored Procedures are located at one location means that there are no confusion and Stored Procedures is the sharing of application...
Post a Comment
Read more

Get Defined Attribute Value Using Jquery

Get user defined attribute value using jquery like name, id and other attributes < input type = " text " value = " XYZ " name = " Name " id = " Name "   myAttribute = " This is Name Of Employee " /> < script type = " text/javascript " > $ ( document ) . ready ( function ( e ) { console . log ( $ ( "#Name" ) . attr ( 'myAttribute' ) ) ; } ) ; </ script >
Post a Comment
Read more

Bootstrap Table Server Side With Coldfusion

Bootstrap Table Server Side With Coldfusion Component. Bootstrap Table is licensed under the The MIT License. <!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>Meessage Broadcast Admin</title>         <!-- Bootstrap core CSS -->         <link href="../public/css/bootstrap.min.css" rel="stylesheet">         <link href="../public/...
Post a Comment
Read more

Autocomplete Textbox Jquery with Database PHP

Autocomplete Textbox Jquery with Database php using Jquery, mysql, json_encode, htmlentities, stripslashes, strip_tags, trim, mysqli_connect, mysqli_query, autocomplete, array_push < html > < head > < script src = "jquery.min.js" > < / script > < ! -- Latest compiled and minified CSS -- > < link rel = "stylesheet" href = "bootstrap.min.css" > < ! -- Optional theme -- > < link rel = "stylesheet" href = "bootstrap-theme.min.css" > < ! -- Latest compiled and minified JavaScript -- > < script src = "bootstrap.min.js" > < / script > < link rel = "stylesheet" href = " jquery-ui.css"> < script src = " jquery-ui.js"></script> < / head > < body > < div cl - ass = "container" > < div cl - ass = "row" > < div c...
Post a Comment
Read more

Autocomplete Textbox Jquery with Database Coldfusion

Autocomplete Textbox Jquery with Database Coldfusion using cfcomponent, coldfusion, StructNew ,cffunction, ArrayAppend, mysql, cfqueryparam, Jquery, Jquery Autocomplete < link rel = " stylesheet " href = " jquery-ui.css " /> < script src = " jquery-1.9.1.js " > </ script > < script src = " jquery-ui.js " > </ script > < cfform name = " actoComp " > < table border = " 0 " cellpadding = " 0 " cellspacing = " 10 " > < tr > < td > Account No < br > < cfinput type = " text " name = " accountNo " id = " accountNo " > </ td > < td >   < input type = " submit " name = " Submit " value = " SUBMIT " >   </ td > </ tr > </ table > </ cfform > <...
Post a Comment
Read more

Create text on image in center using coldfusion imageDrawText

Using imageSetDrawingColor, imageDrawText, imageNew, writeToBrowser, coldfusion, structNew, Create text image in image center. <cfset text = "P"> <cfset imageWidth = 100 /> <cfset imageHeight = 100 /> <cfset txtWidth = 30 /> <cfset txtHeight = txtWidth /> <cfset textImg = imageNew("",imageWidth,imageHeight,"rgb","red")> <cfset x=max(textImg.width,textImg.height)> <cfset newheight=textImg.height*txtHeight/x> <cfset newwidth=textImg.width*txtWidth/x> <cfset newx = (textImg.width/2 - newwidth/2)> <cfset newy = (textImg.height/2 + newheight/2)> <cfset texAttr = StructNew()> <cfset texAttr.font="Arial"> <cfset texAttr.size = txtWidth> <cfset texAttr.style = "bolditalic">   ............ ............ ............   More details Visit - https://www.elearn99.com/programming/create-text-image-center-imagedrawtext/253/  
Post a Comment
Read more

Create CSV File Using PHP MySqli

Create comma seprated file using fwrite php function using with mysql query. It is very easy way to create csv file. <?php $con = new mysqli ( "127.0.0.1" , "root" , "cx(ymc@!" , "demodb" ) ; if ( $con - > connect_error ) { die ( "Connection failed: " . $con - > connect_error ) ; } $sql = "SELECT phoneNo_int,fName_vch,lName_vch FROM users" ; $result = $con - > query ( $sql ) ; $bufferDATA = "" ; $exportPath = $_SERVER [ "DOCUMENT_ROOT" ] . "/demo/uploads" ; $inpFileName = "users.csv" ; $bufferDATA = "Contact No,First Name,Last Name" . CHR ( 13 ) ; /*If file already found delete it from directory*/ try { if ( file_exists ( $exportPath . "/" . $inpFileName ) ) { unlink ( $exportPath . "/" . $inpFileName ) ; } } catch ( Exception $e ) { echo $e - > getMessage ( ) ; } .............
Post a Comment
Read more

Select Multiple Files in The Browser And Upload All

Implement an HTML5 input field that select multiple files to upload using with coldfusion uploadall file action. < form name = " imageForm " action = " new.cfm " method = " post "   enctype = " multipart/form-data " > < input type = " file " name = " image " multiple = " multiple "   accept = " image/jpeg, image/gif, image/png, application/zip " />   < br /> < input type = " submit " name = " submit " value = " Submit " /> </ form > More Details Visit-> https://www.elearn99.com/programming/upload-multiple-files-coldfusion/260/
Post a Comment
Read more