Dan
New Coder
Hi There, I'm quite new into the game and ask for forgiveness if my question doesnt quite make sense.
I'm basically trying to query an SQL DB from a html page based on what item in a link was selected, I don't want to load a new page but essentially update the current page, the code below is what I have so far.
I'm using node with express and EJS
ps, any help would be greatly appreciated.
kind regards - Daniel
I'm basically trying to query an SQL DB from a html page based on what item in a link was selected, I don't want to load a new page but essentially update the current page, the code below is what I have so far.
I'm using node with express and EJS
ps, any help would be greatly appreciated.
kind regards - Daniel
HTML:
<!doctype html>
<html>
<head>
<title>Devices</title>
</head>
<body>
<h1> Devices</h1>
<nav>
<ul>
<li><a href="/">Home</a></li>
<li><a href="about">About</a></li>
</ul>
</nav>
<form>
<select id="deviceList" onchange="loadData()">
<%devices.forEach((device)=>{%>
<option id="<%=device.deviceID%>"><%=device.deviceName%></option>
<%})%>
</select>
</form>
<P name="" id="devName"></P>
<p id="devType"></p>
<img>;
<script>
function loadData(){
var x = document.getElementById("deviceList");
var i = x.selectedIndex;
console.log(x.options[i].id);
// document.getElementById("devName").innerHTML = x.options[i].innerHTML;
// console.log();
}
</script>
</body>
</html>
