Hello fellas, If you've faced a situation like where you have data in different databases located in different servers then in case of SQL server there's a solution to that problem- linked server. Linked server can be set up through SQL server to SQL server or other servers as well.

To open a port in the Windows firewall for TCP access On the Start menu, click Run, type WF.msc, and then click OK. In the Windows Firewall with Advanced Security, in the left pane, right-click Inbound Rules, and then click New Rule in the action pane. In the Rule Type


Today i will discus about `How to generate PDF in Codeigniter using mPDF` Step 1. Download mPDF-Codeigniter from here. Step 2. After Downloading extract it. Here is the codeigniter framework with mPDF integrated. You can copy mPDF to your existing project. Copy Pdf.php library from library to your existing project

Well, there are several ways you can create WordPress REST API but before that you need to understand what REST API is and how it works. The following ways are listed down below : WP REST API V2 SMIO Wordpress API Complete Solution You can look through these and decide which

Arrays can take any class. A common class to place into an array is a custom class for your model. For example , you might have a class to keep track of cookies //Using arrays in a model class class Cookie{ var name = "" var price = 0.00 var rating

  This piece of code is to retrieve data from database. Integrated security set to false for sql server authentication. After passing the dataset to view and display as table I wrote my view like this.

To import excel to sql server database I did as following: 1. Add Reference Add Microsoft Excel 15.0 Object Library to the reference. Too refer it in controller I added it as following: 2. Create model I have created a student model. Highlighted part is to auto generate id. 3. Upload

  Create a stored procedure in database After expanding the database follow this: Programmability>Stored Procedures>Right click on it and select New Stored Procedure Here write codes to create a procedure. I created a simple procedure like following: My procedure's name is GetProducts which will take a parameter named pricerange of


    Intel or AMD Computers by any of the desktop virtualization software  VirtualBox? Then this post will be helpful to increase screen resolution size of  Virtual Machine to get full screen. Adjusting screen size including wide screen on VMware is easy since VMware tools ( Not official, with VGA driver)

Create a new laravel 5.3 preject Select htdocs then(Ctrl+Shift) Same time press then click right button on the mouse then show message box, then select (Open command window here) click then past ( composer create-project --prefer-dist laravel/laravel blog ), then created a project that project name is blog in the