<html>
<head>
<title>DisciplinasMatriculadas</title>
<script type="text/javascript" src="index.js"></script>
</head>
<BODY style="font-family: sans-serif">
<fieldset>
<legend>Matricula de aluno em disciplina</legend>
<form action="/myform" method="GET">
ID Aluno: <input type="text" name="aluno" id="aluno">
<br/>
ID Disciplina: <input type="text" name="disc" id="disc">
<br/>
</form>
<input type="button" value="Add" onclick="addDisciplina();alert('Done.');">
</fieldset>
</body>
</html>
Hi, I'm trying to make this onclick function work (newbie here), but I can't figure out what is the problem. Could you guys help me, please?
PS: The index.js works fine if I run it by CMD.
Thanks!
PS2: I've edited like you guys said, but still didn't work. Here's the js:
addDisciplina = function() {
var mysql = require('mysql');
var express = require('express');
var app = express();
app.get('/myform', function(req, res){
var aluno = req.query.aluno;
var disc = req.query.disc;
});
var connection = mysql.createConnection({
host: "localhost",
user: "root",
password: "161616",
database: "matricula"
});
var post = {idDisciplinasMatriculada: aluno*3+disc*2, idDisciplina: disc, idAluno: aluno};
connection.query('INSERT INTO DisciplinasMatriculadas SET ?', post, function(err, result) {});
}