저같은경우에는 <div><br></div> <div><br></div> <div>db_conn.php 파일에</div> <div><br></div> <div><pre style="background-color:#272822;color:#f8f8f2;font-family:'굴림체';font-size:9pt;"><span style="color:#f92672;">function </span><span style="color:#a6e22e;">getDB</span>()<br>{<br><span style="color:#9876aa;">$dbhost </span><span style="color:#f92672;">= </span><span style="color:#9876aa;font-style:italic;">DB_SERVER</span><span style="color:#cc7832;">;<br></span><span style="color:#cc7832;"> </span><span style="color:#9876aa;">$dbuser </span><span style="color:#f92672;">= </span><span style="color:#9876aa;font-style:italic;">DB_USERNAME</span><span style="color:#cc7832;">;<br></span><span style="color:#cc7832;"> </span><span style="color:#9876aa;">$dbpass </span><span style="color:#f92672;">= </span><span style="color:#9876aa;font-style:italic;">DB_PASSWORD</span><span style="color:#cc7832;">;<br></span><span style="color:#cc7832;"> </span><span style="color:#9876aa;">$dbname </span><span style="color:#f92672;">= </span><span style="color:#9876aa;font-style:italic;">DB_DATABASE</span><span style="color:#cc7832;">;<br></span><span style="color:#cc7832;"> </span><span style="color:#f92672;">try </span>{<br><span style="color:#9876aa;">$dbConnection </span><span style="color:#f92672;">= new </span>PDO(<span style="color:#e6db74;">"mysql:host=</span><span style="color:#9876aa;">$dbhost</span><span style="color:#e6db74;">;dbname=</span><span style="color:#9876aa;">$dbname</span><span style="color:#e6db74;">;charset=utf8"</span><span style="color:#cc7832;">, </span><span style="color:#9876aa;">$dbuser</span><span style="color:#cc7832;">, </span><span style="color:#9876aa;">$dbpass</span>)<span style="color:#cc7832;">;<br></span><span style="color:#cc7832;"> </span><span style="color:#9876aa;">$dbConnection</span><span style="color:#f92672;">-></span><span style="color:#a6e22e;">setAttribute</span>(PDO<span style="color:#f92672;">::</span><span style="color:#9876aa;font-style:italic;">ATTR_ERRMODE</span><span style="color:#cc7832;">, </span>PDO<span style="color:#f92672;">::</span><span style="color:#9876aa;font-style:italic;">ERRMODE_EXCEPTION</span>)<span style="color:#cc7832;">;<br></span><span style="color:#cc7832;"> </span><span style="color:#f92672;">return </span><span style="color:#9876aa;">$dbConnection</span><span style="color:#cc7832;">;<br></span><span style="color:#cc7832;"> </span>} <span style="color:#f92672;">catch </span>(PDOException <span style="color:#9876aa;">$e</span>) {<br><span style="color:#f92672;">echo </span><span style="color:#e6db74;">'Connection failed: ' </span><span style="color:#f92672;">. </span><span style="color:#9876aa;">$e</span><span style="color:#f92672;">-></span><span style="color:#a6e22e;">getMessage</span>()<span style="color:#cc7832;">;<br></span><span style="color:#cc7832;"> </span>}<br>}</pre><pre style="font-size:9pt;">이렇게 만들어놓고</pre><pre style="font-size:9pt;"><br></pre><pre style="font-size:9pt;">뭐이런식으로 class하나 선언해주고</pre><pre style="font-size:9pt;">forum.class.php</pre><pre style="font-size:9pt;"></pre><pre style="background-color:#272822;color:#f8f8f2;font-family:'굴림체';font-size:9pt;"><span style="color:#f92672;"><?php<br></span><span style="color:#f92672;"><br></span><span style="color:#f92672;">class </span>forumList<br>{<br><span style="color:#f92672;">public function </span><span style="color:#a6e22e;">getKindList</span>(<span style="color:#fd971f;font-style:italic;">$kind</span><span style="color:#cc7832;">, </span><span style="color:#fd971f;font-style:italic;">$forum_id</span>)<br> {<br><span style="color:#9876aa;">$db </span><span style="color:#f92672;">= </span><span style="color:#a6e22e;">getDB</span>()<span style="color:#cc7832;">;<br></span><span style="color:#cc7832;"> </span><span style="color:#9876aa;">$query </span><span style="color:#f92672;">= </span><span style="color:#9876aa;">$db</span><span style="color:#f92672;">-></span><span style="color:#a6e22e;">prepare</span>(<span style="color:#e6db74;">'select </span><span style="color:#ffc66d;">*</span><span style="color:#e6db74;"> from 03_'</span><span style="color:#f92672;">.</span><span style="color:#fd971f;font-style:italic;">$kind</span><span style="color:#f92672;">.</span><span style="color:#e6db74;">'</span><span style="color:#fd971f;font-style:italic;">_</span><span style="color:#e6db74;">forum where kindid=' </span><span style="color:#f92672;">. </span><span style="color:#fd971f;font-style:italic;">$forum_id</span>)<span style="color:#cc7832;">;<br></span><span style="color:#cc7832;"> </span><span style="color:#9876aa;">$this</span><span style="color:#f92672;">-></span><span style="color:#a6e22e;">errorCheck</span>(<span style="color:#9876aa;">$query</span>)<span style="color:#cc7832;">;<br></span><span style="color:#cc7832;"> </span><span style="color:#9876aa;">$query</span><span style="color:#f92672;">-></span><span style="color:#a6e22e;">execute</span>()<span style="color:#cc7832;">;<br></span><span style="color:#cc7832;"> </span><span style="color:#9876aa;">$query</span><span style="color:#f92672;">-></span><span style="color:#a6e22e;">setFetchMode</span>(PDO<span style="color:#f92672;">::</span><span style="color:#9876aa;font-style:italic;">FETCH_ASSOC</span>)<span style="color:#cc7832;">;<br></span><span style="color:#cc7832;"> </span><span style="color:#9876aa;">$db </span><span style="color:#f92672;">= null</span><span style="color:#cc7832;">;<br></span><span style="color:#cc7832;"> </span><span style="color:#f92672;">return </span><span style="color:#9876aa;">$query</span><span style="color:#cc7832;">;<br></span><span style="color:#cc7832;"> </span>}<br>}</pre><pre style="font-family:'굴림체';font-size:9pt;"><span style="background-color:#000000;"><br></span></pre><pre style="font-family:'굴림체';font-size:9pt;">db접속이 필요한 곳에</pre><pre style="font-family:'굴림체';font-size:9pt;"></pre><pre style="background-color:#272822;color:#f8f8f2;font-family:'굴림체';font-size:9pt;"><span style="color:#f92672;">include</span>(<span style="color:#e6db74;">"db_conn.php"</span>)<span style="color:#cc7832;">;<br></span><span style="color:#f92672;">include</span>(<span style="color:#e6db74;">"forum.class.php"</span>)<span style="color:#cc7832;">;</span><span style="color:#cc7832;"><br></span><span style="color:#9876aa;">$forumList </span><span style="color:#f92672;">= new </span>forumList()<span style="color:#cc7832;">;</span></pre><pre style="font-family:'굴림체';font-size:9pt;">이렇게 선언해준뒤</pre><pre style="font-family:'굴림체';font-size:9pt;"><br></pre><pre style="font-family:'굴림체';font-size:9pt;">필요할때마다</pre><pre style="font-family:'굴림체';font-size:9pt;">$query = $forumList->getKindList($Kind, $forum_id);</pre><pre style="font-family:'굴림체';font-size:9pt;">해서 쓰고</pre><pre style="font-family:'굴림체';font-size:9pt;">$query = null;이렇게 닫아주고있는데요</pre><pre style="font-family:'굴림체';font-size:9pt;"><br></pre><pre style="font-family:'굴림체';font-size:9pt;">나름 짱돌굴려서 PDO쓰는방식을 제나름대로 써봤는데.....</pre><pre style="font-family:'굴림체';font-size:9pt;">이렇게 쓰는게 맞을까요?</pre><pre style="font-family:'굴림체';font-size:9pt;">여기서 수정하거나 더좋은방법이 있다면 가르침을 주십시요!</pre></div>
댓글 분란 또는 분쟁 때문에 전체 댓글이 블라인드 처리되었습니다.