MS SQL Connect and Get Data

Webix JS
1

Hi.
I’m new to webix and i’m trying to build a web app to present to my employer.
I want to see if it’s worth buying.
I working in Eclipse.
I have set the UI and just need to link data to the datatable.
I created data.php and need to point it to MSSQL.
I then need to fetch the data and make it show in the datattable.
Please help.

2

Hi, could you please clarify your problem? You can share the code snippet here and provide some details on what’s going wrong.

And make sure you have studied docs and samples well.

3

Hi.
I’m trying to get data from MSSQL Server to display in datatable.
I created data.php as per my understanding.

Index.jsp

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
        <link rel="stylesheet" href="../codebase/webix.css" type="text/css" charset="utf-8">
        <script src="../codebase/webix.js" type="text/javascript" charset="utf-8"></script>
</head>


<body>
	<div id="testb" style="width:400px; height:5; margin:10px;"></div>	
	<script type="text/javascript">

      webix.ui({
          rows:[
              	{ view:"toolbar", id:"mybar", elements:[
				{ view:"label", label:"My Rewards", width:"auto"}
 ]
			},
              {template: ""},
              {cols:[
                  {template: ""},
                  {
                      
                      view:"form",
                      elements:[
                          {view:"text",placeholder:"User Name"},
                          {view:"text",placeholder:"Password",type:"password"},
                          {view:"button",label:"Login", type:"form"},
                          {view:"button", label:"Password"},
                      ]
                  },
                  { }
                  
              ]},
              {
            	  view: "datatable", 
            	  id:"datav",
            	    url: "../codebase/data.php"
            	
              }
              
          ]   
      });
        </script>
</body>
</html>

data.php

<?php
		require_once("../connector/data_connector.php"); //!connector
		$dbtype = "mssql";
		$conn = mssql_connect('MZAAIMANWRK\\SQLEXPRESS', "Uname","pword");
		$data = new JSONDataConnector($conn, $dbtype);
//testing with this table
		$data->render_table("RewardUsers","ID","USERNAME, PASSWORD, ROLE");

		}
?>
4

And what is the problem? Are there errors in the log, what does the server respond?

Also, you can skip using data connectors (just an optional helper) and get your server-side data in any suitable way, which is even preferable. Webix is totally client-side.

Check the server script for this sample in the downloaded package.

5

Hi Mybe i’m just being silly. But i dont get any errors. the page opens with the UI. Just no data.
What i need to do is as follwos.
Connect to Microsoft SQL Server
Get data from a table to display in a datatable.
At the end i need an application that can communicate with Microsoft SQL Server