<code><span><span><?php</span><span>$link</span> = mysqli_connect(<span>"localhost"</span>,<span>"root"</span>,<span>"root"</span>) <span>or</span><span>die</span>(<span>"Connect error"</span>); <span>if</span>(<span>$link</span>){ <span>echo</span><span>"Connect success<br>"</span>; mysqli_select_db(<span>$link</span>, <span>"world"</span>); <span>$sql</span> = <span>"select * from city"</span>; <span>$result</span> = mysqli_query(<span>$link</span>, <span>$sql</span>); <span>$rows</span> = mysqli_num_rows(<span>$result</span>); <span>$cols</span> = mysqli_num_fields(<span>$result</span>); <span>echo</span><span>"rows are "</span>.<span>$rows</span>.<span>", cols are "</span>.<span>$cols</span>.<span>"<br>"</span>; <span>echo</span><span>"<table border='1' align='center' width='80%'>"</span>; <span>echo</span><span>"<caption>City info</caption>"</span>; <span>echo</span><span>"<th>ID</th><th>Name</th><th>CountryCode</th><th>District</th><th>Population</th>"</span>; <span>while</span> (<span>$row</span>=mysqli_fetch_row(<span>$result</span>)){ <span>echo</span><span>"<tr align='center'>"</span>; <span>foreach</span> (<span>$row</span><span>as</span><span>$data</span>){ <span>echo</span><span>"<td>"</span>.<span>$data</span>.<span>"</td>"</span>; } <span>echo</span><span>"</tr>"</span>; } <span>echo</span><span>"</table>"</span>; }<span>else</span> { <span>echo</span><span>"Connect error"</span>; } <span>?></span></span></code>').addClass('pre-numbering').hide(); $(this).addClass('has-numbering').parent().append($numbering); for (i = 1; i ').text(i)); }; $numbering.fadeIn(1700); }); });
위 내용은 데이터베이스에 연결하여 데이터를 읽고 인쇄하는 내용을 포함하여 PHP를 소개하는 내용이 PHP 튜토리얼에 관심이 있는 친구들에게 도움이 되기를 바랍니다.