<div class="colorscripter-code" style="color:#f0f0f0;overflow:auto;font-family:Consolas, 'Liberation Mono', Menlo, Courier, monospace;"> <table class="colorscripter-code-table" style="margin:0px;padding:0px;border:none;background-color:#272727;" cellspacing="0" cellpadding="0"><tbody><tr><td style="padding:6px;border-right-width:2px;border-right-style:solid;border-right-color:#4f4f4f;"> <div style="margin:0px;padding:0px;text-align:right;color:#aaaaaa;line-height:130%;"> <div style="line-height:130%;">1</div> <div style="line-height:130%;">2</div> <div style="line-height:130%;">3</div> <div style="line-height:130%;">4</div> <div style="line-height:130%;">5</div> <div style="line-height:130%;">6</div> <div style="line-height:130%;">7</div> <div style="line-height:130%;">8</div> <div style="line-height:130%;">9</div> <div style="line-height:130%;">10</div> <div style="line-height:130%;">11</div> <div style="line-height:130%;">12</div> <div style="line-height:130%;">13</div> <div style="line-height:130%;">14</div> <div style="line-height:130%;">15</div> <div style="line-height:130%;">16</div> <div style="line-height:130%;">17</div> <div style="line-height:130%;">18</div> <div style="line-height:130%;">19</div> <div style="line-height:130%;">20</div> <div style="line-height:130%;">21</div> <div style="line-height:130%;">22</div> <div style="line-height:130%;">23</div> <div style="line-height:130%;">24</div> <div style="line-height:130%;">25</div> <div style="line-height:130%;">26</div> <div style="line-height:130%;">27</div> <div style="line-height:130%;">28</div> <div style="line-height:130%;">29</div> <div style="line-height:130%;">30</div> <div style="line-height:130%;">31</div> <div style="line-height:130%;">32</div> <div style="line-height:130%;">33</div> <div style="line-height:130%;">34</div> <div style="line-height:130%;">35</div> <div style="line-height:130%;">36</div> <div style="line-height:130%;">37</div> <div style="line-height:130%;">38</div> <div style="line-height:130%;">39</div> <div style="line-height:130%;">40</div> <div style="line-height:130%;">41</div> <div style="line-height:130%;">42</div> <div style="line-height:130%;">43</div> <div style="line-height:130%;">44</div> <div style="line-height:130%;">45</div> <div style="line-height:130%;">46</div> <div style="line-height:130%;">47</div> <div style="line-height:130%;">48</div> <div style="line-height:130%;">49</div> <div style="line-height:130%;">50</div> <div style="line-height:130%;">51</div> <div style="line-height:130%;">52</div> <div style="line-height:130%;">53</div> <div style="line-height:130%;">54</div> <div style="line-height:130%;">55</div> <div style="line-height:130%;">56</div> <div style="line-height:130%;">57</div> <div style="line-height:130%;">58</div> <div style="line-height:130%;">59</div> <div style="line-height:130%;">60</div> <div style="line-height:130%;">61</div> <div style="line-height:130%;">62</div> <div style="line-height:130%;">63</div> <div style="line-height:130%;">64</div> <div style="line-height:130%;">65</div> <div style="line-height:130%;">66</div></div></td> <td style="padding:6px 0px;"> <div style="margin:0px;padding:0px;color:#f0f0f0;line-height:130%;"> <div style="padding:0px 6px;white-space:pre;line-height:130%;"> <span style="color:#999999;">//*********************************************************************//</span></div> <div style="padding:0px 6px;white-space:pre;line-height:130%;"><span style="color:#999999;">//common.js파일</span></div> <div style="padding:0px 6px;white-space:pre;line-height:130%;"><span style="color:#999999;">//GET 부분..</span></div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">router.get(<span style="color:#ffd500;">'/all_schedule'</span>, <span style="color:#ff3399;">function</span>(req, res, next) {</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">    <span style="color:#ff3399;">var</span> query <span style="color:#0086b3;"></span><span style="color:#ff3399;">=</span> <span style="color:#ffd500;">'select * from schedule'</span>;</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">    <span style="color:#4be6fa;">console</span>.log(<span style="color:#ffd500;">"들어옵니까"</span>);</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">    mysql.query(query, <span style="color:#ff3399;">function</span>(err, rows, fields) {</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">        <span style="color:#ff3399;">if</span> (err) {</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">            <span style="color:#4be6fa;">console</span>.log(<span style="color:#ffd500;">"에러군요"</span>);</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">            res.send({</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">                err: <span style="color:#ffd500;">'dberror'</span>,</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">                id: id</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">            });</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">            <span style="color:#ff3399;">return</span>;</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">        }</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;"> </div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">        <span style="color:#ff3399;">var</span> kv_list <span style="color:#0086b3;"></span><span style="color:#ff3399;">=</span> [];</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;"> </div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">        <span style="color:#ff3399;">for</span> (k <span style="color:#ff3399;">in</span> rows) {</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">            <span style="color:#4be6fa;">console</span>.log(<span style="color:#ffd500;">"만드눈중"</span>);</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">            kv_list.push({</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">                key: rows[k].id</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">            });</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">        }</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">        <span style="color:#4be6fa;">console</span>.log(<span style="color:#ffd500;">"전송합니다"</span>);</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">        res.send({</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">            all_schedule: kv_list</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">        });</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">    });</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;"> </div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">});</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;"> </div> <div style="padding:0px 6px;white-space:pre;line-height:130%;"><span style="color:#999999;">//*********************************************************************//</span></div> <div style="padding:0px 6px;white-space:pre;line-height:130%;"> </div> <div style="padding:0px 6px;white-space:pre;line-height:130%;"> </div> <div style="padding:0px 6px;white-space:pre;line-height:130%;"><span style="color:#999999;">//*********************************************************************//</span></div> <div style="padding:0px 6px;white-space:pre;line-height:130%;"> </div> <div style="padding:0px 6px;white-space:pre;line-height:130%;"> </div> <div style="padding:0px 6px;white-space:pre;line-height:130%;"><span style="color:#999999;">// 여기는 ejs파일에서 위의 common.js의 all_schedule를 읽어오는 부분</span></div> <div style="padding:0px 6px;white-space:pre;line-height:130%;"> </div> <div style="padding:0px 6px;white-space:pre;line-height:130%;"><span style="color:#0086b3;"></span><span style="color:#ff3399;"><</span>script type <span style="color:#0086b3;"></span><span style="color:#ff3399;">=</span> <span style="color:#ffd500;">"text/javascript"</span> <span style="color:#0086b3;"></span><span style="color:#ff3399;">></span></div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">    $.ajax({</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">        type: <span style="color:#ffd500;">"GET"</span>,</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">        url: <span style="color:#ffd500;">"/common/all_schedule"</span>,</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">        success: <span style="color:#ff3399;">function</span>(data) {</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">            <span style="color:#ff3399;">if</span> (data.err) {</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">                <span style="color:#4be6fa;">alert</span>(data.err);</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">                <span style="color:#4be6fa;">console</span>.log(<span style="color:#ffd500;">"실패패"</span>);</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">                <span style="color:#ff3399;">return</span> <span style="color:#c10aff;">false</span>;</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">            }</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">            <span style="color:#4be6fa;">console</span>.log(<span style="color:#ffd500;">"성공공"</span>);</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">            drawMemoListFunction(data);</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">        }</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">    });</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;"> </div> <div style="padding:0px 6px;white-space:pre;line-height:130%;"> </div> <div style="padding:0px 6px;white-space:pre;line-height:130%;"><span style="color:#ff3399;">function</span> drawMemoListFunction(data) {</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">    <span style="color:#4be6fa;">console</span>.log(<span style="color:#ffd500;">"ㅇㅇㅇㅇ"</span>);</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">    <span style="color:#ff3399;">for</span> (<span style="color:#ff3399;">var</span> i <span style="color:#0086b3;"></span><span style="color:#ff3399;">=</span> <span style="color:#c10aff;">0</span>; i <span style="color:#0086b3;"></span><span style="color:#ff3399;"><</span> data.<span style="color:#4be6fa;">length</span>; i<span style="color:#0086b3;"></span><span style="color:#ff3399;">+</span><span style="color:#0086b3;"></span><span style="color:#ff3399;">+</span>) {</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">        <span style="color:#4be6fa;">alert</span>(<span style="color:#ffd500;">"i"</span>);</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">    }</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;">}</div> <div style="padding:0px 6px;white-space:pre;line-height:130%;"> </div> <div style="padding:0px 6px;white-space:pre;line-height:130%;"> </div> <div style="padding:0px 6px;white-space:pre;line-height:130%;"><span style="color:#0086b3;"></span><span style="color:#ff3399;"><</span><span style="color:#0086b3;"></span><span style="color:#ff3399;">/</span>script<span style="color:#0086b3;"></span><span style="color:#ff3399;">></span></div> <div style="padding:0px 6px;white-space:pre;line-height:130%;"> </div></div> <div style="text-align:right;margin-top:-13px;margin-right:5px;font-size:9px;font-style:italic;"><a target="_blank" href="http://colorscripter.com/info#e" target="_blank" style="color:#4f4f4f;text-decoration:none;">Colored by Color Scripter</a></div></td> <td style="vertical-align:bottom;padding:0px 2px 4px 0px;"><a target="_blank" href="http://colorscripter.com/info#e" target="_blank" style="text-decoration:none;color:#FFFFFF;"><span style="font-size:9px;padding:1px;background-color:#4f4f4f;">cs</span></a></td></tr></tbody></table><br></div> <div class="colorscripter-code" style="overflow:auto;font-family:Consolas, 'Liberation Mono', Menlo, Courier, monospace;">로그에는</div> <div class="colorscripter-code" style="overflow:auto;font-family:Consolas, 'Liberation Mono', Menlo, Courier, monospace;"><br></div> <div class="colorscripter-code" style="overflow:auto;font-family:Consolas, 'Liberation Mono', Menlo, Courier, monospace;"> <div class="colorscripter-code" style="overflow:auto;">들어옵니까</div> <div class="colorscripter-code" style="overflow:auto;">만드눈중</div> <div class="colorscripter-code" style="overflow:auto;">만드눈중</div> <div class="colorscripter-code" style="overflow:auto;">전송합니다</div> <div class="colorscripter-code" style="overflow:auto;">GET /common/all_schedule 304 4.882 ms - -</div> <div class="colorscripter-code" style="overflow:auto;"><br></div> <div class="colorscripter-code" style="overflow:auto;">이렇게 나오는데 정작 success에는 데이터가 안들어있네요 ㅠㅠㅠㅠ</div> <div class="colorscripter-code" style="overflow:auto;">원인이 뭘까요?</div> <div class="colorscripter-code" style="overflow:auto;"><br></div> <div class="colorscripter-code" style="overflow:auto;">자바스크립트는 첨이라 너무 생소하네요 ㅠㅠ</div></div>