Retrieve Table Data from MySQL

Takura_T_ — Thu, 21 May 2015 21:06:13 GMT

Hi Guys

I'm new to Intel XDK, I spent the whole day trying to access data from MySQL, just couldn't do it. Is there anyone who can help me with the steps to retrieving MySQL data?

It depends on the programming

Abel_G_ — Fri, 22 May 2015 00:20:16 GMT

It depends on the programming language of your server, The Intel XDK library does not have direct interaction with the server, for example if you are using PHP in your server:

// file.php in your server

<?php
$conn = mysql_connect('localhost', 'user', 'password') or die('Could not connect: ' . mysql_error());
mysql_select_db('bd', $conn);
$sql = mysql_query("SELECT * from users");
echo json_encode($sql);
?>

and then in the XDK app:

intel.xdk.device.getRemoteData("http://yourserver.com/file.phpl", "GET","","success_handler","error_handler");

function success_handler (data) {  alert("success: " + data); }
function error_handler(data) {  alert("error: " + data); }

check this link: https://software.intel.com/es-es/node/493009

topic Retrieve Table Data from MySQL in Software Archive

Retrieve Table Data from MySQL

It depends on the programming