title: Node.js mysql display table on html site
body: <p>I'm new to node.js and try to display a simple table on a html site. This table should be filled with the data from a mysql select (eg: select * from testtable).</p>
  
  <p>But I really don't get it how to do it. For someone with PHP background how can I display some sql content in a HTML in nodejs? I know the git mysql nodejs wiki but it didn't help at all since this is only about getting the data and not displaying it on a webpage.</p>
  
  <p>What is the best practice to do something like that in nodeJS? Is there an easy understandable way, or should I stay with PHP? I really like the idea about node.js but the start is like climbing a slippery cliff.</p>
  
  <p>I also buyed a book about it, but the book never gets deep into express (because this would be too much information..). So I know about express, pug, serve-static and I was able to serve a simple html. But that's it, no CRUD or REST and I payed 50€ for nothing.</p>
  
  <p>EDIT:
  Do I need to use an API or is maybe using Angular.js the correct way for this?</p>
  
  <p>EDIT2:</p>
  
  <pre><code>C:\Users\user\node_test\CRUD2&gt;node app.js
  module.js:327
  throw err;
  ^
  
  Error: Cannot find module './routes'
  
  at Function.Module._resolveFilename (module.js:325:15)
  
  at Function.Module._load (module.js:276:25)
  
  at Module.require (module.js:353:17)
  
  at require (internal/module.js:12:17)
  
  at Object.&lt;anonymous&gt; (C:\Users\user\node_test\CRUD2\app.js:2:14)
  at Module._compile (module.js:409:26)
  
  at Object.Module._extensions..js (module.js:416:10)
  
  at Module.load (module.js:343:32)
  
  at Function.Module._load (module.js:300:12)
  
  at Function.Module.runMain (module.js:441:10)
  </code></pre>
  
  <p>EDIT3:</p>
  
  <pre><code>C:\Users\user\node_test\CRUD2&gt;node app.js
  Express server listening on port 4300
  C:\Users\user\node_test\CRUD2\routes\testtable.js:4
  var query = connection.query('SELECT * FROM testtable',function(err,rows){
                      ^
  
  TypeError: Cannot read property 'query' of undefined
  at C:\Users\user\node_test\CRUD2\routes\testtable.js:4:29
  at C:\Users\user\node_test\CRUD2\node_modules\express-myconnection\lib\express-myconnection.js:87:41
  at Pool.&lt;anonymous&gt; (C:\Users\user\node_test\CRUD2\node_modules\mysql\lib\Pool.js:47:16)
  at Handshake.Sequence.end (C:\Users\user\node_test\CRUD2\node_modules\mysql\lib\protocol\sequences\Sequence.js:78:24)
  at Handshake.ErrorPacket (C:\Users\user\node_test\CRUD2\node_modules\mysql\lib\protocol\sequences\Handshake.js:101:8)
  at Protocol._parsePacket (C:\Users\user\node_test\CRUD2\node_modules\mysql\lib\protocol\Protocol.js:205:24)
  at Parser.write (C:\Users\user\node_test\CRUD2\node_modules\mysql\lib\protocol\Parser.js:62:12)
  at Protocol.write (C:\Users\user\node_test\CRUD2\node_modules\mysql\lib\protocol\Protocol.js:37:16)
  at Socket.&lt;anonymous&gt; (C:\Users\user\node_test\CRUD2\node_modules\mysql\lib\Connection.js:73:28)
  at emitOne (events.js:77:13)
  </code></pre>