Handlebars+mysql °üÇØ¼­ [0]

¡ã ¸Ç¹Ø ¡å
ÀÎõÈ÷Åä¹Ì
¾Æ¹ÙŸ/ÂÊÁö/±Û°Ë»ö

2020-06-27 00:38:48
1 0 0 238

¨Û Ãßõ  ¨á ´ÜÃàURL
¡è º¹»ç ÈÄ ºÙ¿©³ÖÀ¸¼¼¿ä.
 ±â±â¸¦ °¨ÁöÇÏ¿© ÃÖÀû URL ·Î º¸³»ÁÝ´Ï´Ù.
ÀÎõÈ÷Åä¹Ì
https://humoruniv.com/program7542 URL º¹»ç

ȯ°æÀº ÀÌ·¸½À´Ï´Ù


node.js
express-handlebars
mysql
sequelize
sequelize-cli

index.js

router.get£¨"/map1", function £¨req, res, next£© {
const loca = req.query.location;
models.motels.findAll£¨£©.then£¨£¨result£© => {
res.render£¨"map1", {
motel: result,
}£©;
}£©;
}£©;

map1.hbs

var positions = [
{
title: 'īī¿À',
latlng: new kakao.maps.LatLng£¨33.450705, 126.570677£©
},
{
title: '»ýÅ¿¬¸ø',
latlng: new kakao.maps.LatLng£¨33.450936, 126.569477£©
},
{
title: 'ÅÔ¹ç',
latlng: new kakao.maps.LatLng£¨33.450879, 126.569940£©
},
{
title: '±Ù¸°°ø¿ø',
latlng: new kakao.maps.LatLng£¨33.451393, 126.570738£©
}
];

À̰É

var positions = [
{ title: {{ m_name }}, //db¾ÈÀÇ m_nameÀ̶ó´Â Ä÷³
latlng: new kakao.maps.LatLng£¨{{ m_lati }}, {{ m_long }}£©} //db¾ÈÀÇ m_lati m_long Ä÷³
];

¹è¿­ ´ë½Å¿¡ DB¿¡¼­ Á¶È¸ÇÑ µ¥ÀÌÅ͸¦ »ç¿ëÇϰí½ÍÀºµ¥ ¹æ¹ýÀ» ¸ð¸£°Ú½À´Ï´Ù... ¾î¶»°Ô ÇØ¾ßÇÒ±î¿ä?

* ÄÁÅÙÃ÷ Ãâó : ÀÛ¼ºÀÚ º»ÀÎ
Áú¹®¿¡ ´äº¯Çϱâ

¨Û °Ô ½Ã ¹°    Ãß Ãµ ÇÏ ±â
  ·Î±×ÀÎ ¾øÀÌ Ãßõ°¡´ÉÇÕ´Ï´Ù.
ÃßõµÇ¾ú½À´Ï´Ù.
¨Û Ãßõ   ¨ä ¹Ý´ë   ¨Þ ´ä±Û   ¢Ç ¸ñ·Ï
¡ç µÚ·Î   ¡è ¸ÇÀ§   ¡é ¸Ç¹Ø   ¨· ½Å°í   ¢½ ½ºÅ©·¦
´ä±Û ÀÛ¼ºÇϱâ (·Î±×ÀÎ ÇÊ¿ä)
·Î±×ÀÎ   ¸ÞÀÎ   »çÀÌÆ®¸Ê   PCÈ­¸é