Execute query on sqlite database in html script base using javascript

Asked May 10 '19 at 14:29

Active May 11 '19 at 17:43

Viewed 718 times

I'm new in web developing. I want to query an SQLite database from HTML script balise. for more details, I share my code.

function test() {
  var fullname;
  var fname = "bishoy";
  const sqlite3 = require('sqlite3').verbose();
  let db = new sqlite3.Database('./Basket.db');
  let sql = 'SELECT * FROM [Source: players]';
  db.each(sql, [fname], (err, row) => {
    if (err) {
      throw err;
    }
    fullname = ('${row.Name}');
    alert(fullname);;
  });
  db.close();
}

<!DOCTYPE html>
<html>

<head>

</head>

<body>
  <button type="button" onclick="test()" style="font-family:cambria; 
    
    ">Execute</button>
</body>

</html>

the problem that I encounter when I execute it on my Chrome browser: storage.html:8 Uncaught ReferenceError: require is not defined at test (storage.html:8) at HTMLButtonElement.onclick (storage.html:22) , please someone can help me to fix the problem.

edited May 11 '19 at 17:43

Nazim Kerimbekov

4,712
8
34
58

asked May 10 '19 at 14:29

Dihia LANASRI

"please someone can help me to fix the problem." What exactly is your problem? – JDunken May 10 '19 at 14:32
I updated the post above. thaks – Dihia LANASRI May 10 '19 at 14:35
3

Possible duplicate of [Client on node: Uncaught ReferenceError: require is not defined](https://stackoverflow.com/questions/19059580/client-on-node-uncaught-referenceerror-require-is-not-defined) – evolutionxbox May 10 '19 at 14:43

Execute query on sqlite database in html script base using javascript

0 Answers0