How to use the escape function from mysql

admin.js

GitHub: Brightmuk/hotel-manage

63
64
65
66
67
68
69
70
71
72
});

data = "SELECT * " +
    "FROM users " +
    "WHERE username = " + mysql.escape(req.body.name) +
    "AND password = " + mysql.escape(req.body.pass);


connectDB.query(data, (err, result) => {
    if (err) throw err;

0

0

1

+ 71 other calls in file

user.js

GitHub: lequangdoanh/hcms

39
40
41
42
43
44
45
46
47
48
   database: "hotel"
});

data = "SELECT * " +
   "FROM  user " +
   "WHERE email = " + mysql.escape(req.body.mail) +
   " AND password = " + mysql.escape(req.body.pass);


connectDB.query(data, (err, result) => {

0

0

1

+ 35 other calls in file

admin.js

GitHub: lequangdoanh/hcms

42
43
44
45
46
47
48
49
50
51
});

data = "SELECT * " +
    "FROM admin " +
    "WHERE name = " + mysql.escape(req.body.name) +
    "AND pass = " + mysql.escape(req.body.pass);

data1 = "SELECT * " +
    "FROM  bookingstatus " +
    "WHERE status = 0 ";

0

0

1

+ 87 other calls in file

index.cjs.js

GitHub: Xu22Web/mysql-mongo

1808
1809
1810
1811
1812
1813
1814
1815
1816
1817
}
// number、string、boolean 类型
if (typeOf.isNumber(value) ||
    typeOf.isString(value) ||
    typeOf.isBooloon(value)) {
    return mysql.escape(value);
}
// null 类型
if (typeOf.isNull(value)) {
    return 'null';

0

0

1

+ 2 other calls in file

mysql.js

GitHub: jlassiwissal/Api-ETL

37
38
39
40
41
42
43
44
45
46
this.resume = function() {
    connection.resume();
};

this.escape = function(val, stringifyObjects, timeZone) {
    return Mysql.escape(val, stringifyObjects, timeZone || connection.config.timezone);
};

this.escapeId = function(val, forbidQualified) {
    return Mysql.escapeId(val, forbidQualified);

0

0

0