<pre style="color:#f8f8f2;font-family:Menlo;font-size:16pt;background-color:#272822;"><span style="background-color:#3c3c57;">common.js파일의 get</span></pre><pre style="color:#f8f8f2;font-family:Menlo;font-size:16pt;background-color:#272822;"><span style="background-color:#3c3c57;"><br></span></pre><pre style="color:#f8f8f2;font-family:Menlo;font-size:16pt;background-color:#272822;"><span style="background-color:#3c3c57;">router</span>.<span style="color:#979748;">get</span>(<span style="color:#e6db74;">'/all_schedule'</span><span style="color:#cc7832;">, </span><span style="color:#f92672;">function </span>(<span style="color:#fd971f;font-style:italic;">req</span><span style="color:#cc7832;">, </span><span style="color:#fd971f;font-style:italic;">res</span><span style="color:#cc7832;">, </span><span style="color:#fd971f;font-style:italic;">next</span>) {<br><span style="color:#f92672;">var </span><span style="color:#64a2a2;">query </span><span style="color:#f92672;">= </span><span style="color:#e6db74;">'select * from schedule'</span><span style="color:#cc7832;">;<br></span><span style="color:#cc7832;"> </span>console.<span style="color:#979748;">log</span>(<span style="color:#e6db74;">"들어옵니까"</span>)<span style="color:#cc7832;">;<br></span><span style="color:#cc7832;"> </span><span style="font-style:italic;">mysql</span>.query(<span style="color:#64a2a2;">query</span><span style="color:#cc7832;">, </span><span style="color:#f92672;">function </span>(<span style="color:#fd971f;font-style:italic;">err</span><span style="color:#cc7832;">, </span><span style="color:#fd971f;font-style:italic;">rows</span><span style="color:#cc7832;">, </span><span style="color:#fd971f;font-style:italic;">fields</span>) {<br><span style="color:#f92672;">if </span>(<span style="color:#fd971f;font-style:italic;">err</span>) {<br> console.<span style="color:#979748;">log</span>(<span style="color:#e6db74;">"에러군요"</span>)<span style="color:#cc7832;">;<br></span><span style="color:#cc7832;"> </span><span style="color:#fd971f;font-style:italic;">res</span>.<span style="color:#979748;">send</span>({ err<span style="color:#f92672;">: </span><span style="color:#e6db74;">'dberror'</span><span style="color:#cc7832;">, </span>id<span style="color:#f92672;">: </span>id })<span style="color:#cc7832;">;<br></span><span style="color:#cc7832;"> </span><span style="color:#f92672;">return</span><span style="color:#cc7832;">;<br></span><span style="color:#cc7832;"> </span>}<br><br><span style="color:#f92672;">var </span><span style="color:#64a2a2;">kv_list </span><span style="color:#f92672;">= </span>[]<span style="color:#cc7832;">;<br></span><span style="color:#cc7832;"><br></span><span style="color:#cc7832;"> </span><span style="color:#f92672;">for </span>(k <span style="color:#f92672;">in </span><span style="color:#fd971f;font-style:italic;">rows</span>) {<br> console.<span style="color:#979748;">log</span>(<span style="color:#e6db74;">"만드눈중"</span>)<span style="color:#cc7832;">;<br></span><span style="color:#cc7832;"> </span><span style="color:#64a2a2;">kv_list</span>.<span style="color:#979748;">push</span>({<br> key <span style="color:#f92672;">: </span><span style="color:#fd971f;font-style:italic;">rows</span>[k].id<br> })<span style="color:#cc7832;">;<br></span><span style="color:#cc7832;"> </span>}<br> console.<span style="color:#979748;">log</span>(<span style="color:#e6db74;">"전송합니다"</span>)<span style="color:#cc7832;">;<br></span><span style="color:#cc7832;"> </span><span style="color:#fd971f;font-style:italic;">res</span>.<span style="color:#979748;">send</span>({ all_schedule<span style="color:#f92672;">: </span><span style="color:#64a2a2;">kv_list </span>})<span style="color:#cc7832;">;<br></span><span style="color:#cc7832;"> </span>})<span style="color:#cc7832;">;<br></span><span style="color:#cc7832;"><br></span>})<span style="color:#cc7832;">;</span></pre><pre style="color:#f8f8f2;font-family:Menlo;font-size:16pt;background-color:#272822;"><span style="color:#cc7832;"><br></span></pre><pre style="font-family:Menlo;font-size:16pt;background-color:#272822;"></pre><pre style="font-family:Menlo;font-size:16pt;background-color:#272822;"></pre><pre style="background-color:#272822;"></pre><pre style="color:#f8f8f2;font-family:Menlo;font-size:16pt;"><<span style="color:#e3e3ff;font-weight:bold;">script </span><span style="color:#a6e22e;">type=</span><span style="color:#e6db74;font-weight:bold;">"text/javascript"</span>><br> $.<span style="color:#979748;">ajax</span>({<br> type<span style="color:#f92672;">: </span><span style="color:#e6db74;">"GET"</span><span style="color:#cc7832;">,<br></span><span style="color:#cc7832;"> </span>url<span style="color:#f92672;">: </span><span style="color:#e6db74;">"/common/all_schedule"</span><span style="color:#cc7832;">,<br></span><span style="color:#cc7832;"> </span><span style="color:#979748;">success</span><span style="color:#f92672;">: function </span>(<span style="color:#fd971f;font-style:italic;">data</span>) {<br><span style="color:#f92672;">if </span>(<span style="color:#fd971f;font-style:italic;">data</span>.err) {<br><span style="color:#979748;">alert</span>(<span style="color:#fd971f;font-style:italic;">data</span>.err)<span style="color:#cc7832;">;<br></span><span style="color:#cc7832;"> </span>console.<span style="color:#979748;">log</span>(<span style="color:#e6db74;">"실패패"</span>)<span style="color:#cc7832;">;<br></span><span style="color:#cc7832;"> </span><span style="color:#f92672;">return false</span><span style="color:#cc7832;">;<br></span><span style="color:#cc7832;"> </span>}<br> console.<span style="color:#979748;">log</span>(<span style="color:#e6db74;">"성공공"</span>)<span style="color:#cc7832;">;<br></span><span style="color:#cc7832;"> </span><span style="color:#a6e22e;">drawMemoListFunction</span>(<span style="color:#fd971f;font-style:italic;">data</span>)<span style="color:#cc7832;">;<br></span><span style="color:#cc7832;"> </span>}<br> }<br> )<span style="color:#cc7832;">;<br></span><span style="color:#cc7832;"><br></span><span style="color:#cc7832;"><br></span><span style="color:#cc7832;"> </span><span style="color:#f92672;">function </span><span style="color:#a6e22e;">drawMemoListFunction</span>(<span style="color:#fd971f;font-style:italic;">data</span>)<br> {<br> console.<span style="color:#979748;">log</span>(<span style="color:#e6db74;">"ㅇㅇㅇㅇ"</span>)<span style="color:#cc7832;">;<br></span><span style="color:#cc7832;"> </span><span style="color:#f92672;">for</span>(<span style="color:#f92672;">var </span><span style="color:#64a2a2;">i</span><span style="color:#f92672;">=</span><span style="color:#ae81ff;">0</span><span style="color:#cc7832;">; </span><span style="color:#64a2a2;">i</span><span style="color:#f92672;"><</span><span style="color:#fd971f;font-style:italic;">data</span>.<span style="color:#979748;">length</span><span style="color:#cc7832;">; </span><span style="color:#64a2a2;">i</span><span style="color:#f92672;">++</span>)<br> {<br><span style="color:#979748;">alert</span>(<span style="color:#e6db74;">"i"</span>)<span style="color:#cc7832;">;<br></span><span style="color:#cc7832;"> </span>}<br> }<br><br><br></<span style="color:#e3e3ff;font-weight:bold;">script</span>></pre><pre style="color:#f8f8f2;font-family:Menlo;font-size:16pt;"><br></pre><pre style="color:#f8f8f2;font-family:Menlo;font-size:16pt;"><br></pre><pre style="color:#f8f8f2;font-family:Menlo;font-size:16pt;">이렇게 해서 만드는데 분명히 ajax에서 요청을 하는것 같긴 한데</pre><pre style="color:#f8f8f2;font-family:Menlo;font-size:16pt;">success로 들어오지 않네요 ..ㅠㅠ 로그도 안찍히구..</pre><pre style="color:#f8f8f2;font-family:Menlo;font-size:16pt;">로그보면 정확하게</pre><pre></pre><pre></pre><pre></pre><pre></pre><pre></pre>
댓글 분란 또는 분쟁 때문에 전체 댓글이 블라인드 처리되었습니다.