[mysql_fetch_field와 함께 mysql_field_len을 사용하는 방법? 예제 설명을 참조하십시오]

gitbox 2025-09-23

<span><span><span class="hljs-meta">&lt;?php</span></span><span>
</span><span><span class="hljs-comment">// 이것은 기사의 내용과 관련이 없습니다.PHP코드 예제</span></span><span>
</span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"이 기사를 읽을 수 있습니다！&lt;br&gt;"</span></span><span>;
</span><span><span class="hljs-title function_ invoke__">date_default_timezone_set</span></span><span>(</span><span><span class="hljs-string">'Asia/Shanghai'</span></span><span>);
</span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"현재 시간："</span></span><span> . </span><span><span class="hljs-title function_ invoke__">date</span></span><span>(</span><span><span class="hljs-string">'Y-m-d H:i:s'</span></span><span>) . </span><span><span class="hljs-string">"&lt;br&gt;"</span></span><span>;
</span><span><span class="hljs-meta">?&gt;</span></span><span>

&lt;hr&gt;

</span><span><span class="hljs-meta">&lt;?php</span></span><span>
<span class="hljs-comment">/*
기사 제목：【mysql_field_len성냥mysql_fetch_field함께 사용하는 방법？예제 설명을 봅시다】
*/</span>

</span><span><span class="hljs-comment">// 사용 중PHP작동하다MySQL데이터베이스시기，많은 사람들이 필드 길이를 얻을 필요성을 겪을 것입니다.。</span></span><span>
</span><span><span class="hljs-comment">// 여기서 설명하겠습니다mysql_field_len기능을 사용하는 방법mysql_fetch_field성냥사용。</span></span><span>

</span><span><span class="hljs-comment">// 1. 데이터베이스에 연결하십시오</span></span><span>
</span><span><span class="hljs-variable">$conn</span></span><span> = </span><span><span class="hljs-title function_ invoke__">mysql_connect</span></span><span>(</span><span><span class="hljs-string">'localhost'</span></span><span>, </span><span><span class="hljs-string">'root'</span></span><span>, </span><span><span class="hljs-string">'password'</span></span><span>);
</span><span><span class="hljs-keyword">if</span></span><span> (!</span><span><span class="hljs-variable">$conn</span></span><span>) {
    </span><span><span class="hljs-keyword">die</span></span><span>(</span><span><span class="hljs-string">'데이터베이스 연결에 실패했습니다: '</span></span><span> . </span><span><span class="hljs-title function_ invoke__">mysql_error</span></span><span>());
}
</span><span><span class="hljs-title function_ invoke__">mysql_select_db</span></span><span>(</span><span><span class="hljs-string">'test_db'</span></span><span>, </span><span><span class="hljs-variable">$conn</span></span><span>);

</span><span><span class="hljs-comment">// 2. 쿼리를 실행하십시오</span></span><span>
</span><span><span class="hljs-variable">$result</span></span><span> = </span><span><span class="hljs-title function_ invoke__">mysql_query</span></span><span>(</span><span><span class="hljs-string">'SELECT id, username, email FROM users'</span></span><span>);
</span><span><span class="hljs-keyword">if</span></span><span> (!</span><span><span class="hljs-variable">$result</span></span><span>) {
    </span><span><span class="hljs-keyword">die</span></span><span>(</span><span><span class="hljs-string">'쿼리가 실패했습니다: '</span></span><span> . </span><span><span class="hljs-title function_ invoke__">mysql_error</span></span><span>());
}

</span><span><span class="hljs-comment">// 3. 사용mysql_fetch_field현장 정보를 얻으십시오</span></span><span>
</span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"&lt;h3&gt;필드 정보 목록：&lt;/h3&gt;"</span></span><span>;
</span><span><span class="hljs-keyword">while</span></span><span> (</span><span><span class="hljs-variable">$field</span></span><span> = </span><span><span class="hljs-title function_ invoke__">mysql_fetch_field</span></span><span>(</span><span><span class="hljs-variable">$result</span></span><span>)) {
    </span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"필드 이름: "</span></span><span> . </span><span><span class="hljs-variable">$field</span></span><span>-&gt;name . </span><span><span class="hljs-string">"&lt;br&gt;"</span></span><span>;
    </span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"필드 유형: "</span></span><span> . </span><span><span class="hljs-variable">$field</span></span><span>-&gt;type . </span><span><span class="hljs-string">"&lt;br&gt;"</span></span><span>;
    </span><span><span class="hljs-comment">// 4. 사용mysql_field_len필드 길이를 얻으십시오</span></span><span>
    </span><span><span class="hljs-variable">$length</span></span><span> = </span><span><span class="hljs-title function_ invoke__">mysql_field_len</span></span><span>(</span><span><span class="hljs-variable">$result</span></span><span>, </span><span><span class="hljs-variable">$field</span></span><span>-&gt;orgname ? </span><span><span class="hljs-variable">$field</span></span><span>-&gt;orgname : </span><span><span class="hljs-variable">$field</span></span><span>-&gt;name);
    </span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"필드 길이: "</span></span><span> . </span><span><span class="hljs-variable">$length</span></span><span> . </span><span><span class="hljs-string">"&lt;br&gt;&lt;hr&gt;"</span></span><span>;
}

<span class="hljs-comment">/*
주목해야 할 것：
1. mysql_* 시리즈 기능은 다음과 같습니다 PHP 7 위의 버전은 더 이상 사용되지 않았습니다，建议사용 mysqli 또는 PDO。
2. mysql_field_len 필드의 최대 바이트 길이를 반환합니다，문자 수가 아닙니다，멀티 바이트 문자 세트에주의하십시오。
3. mysql_fetch_field 필드의 세부 사항을 얻을 수 있습니다，유형을 포함합니다、길이、기본값 등。
*/</span>

</span><span><span class="hljs-meta">?&gt;</span></span><span>
</span></span>

<HR>

 <span><span><span class="hljs-meta">&lt;?php</span></span><span>
</span><span><span class="hljs-comment">// 尾部无关코드 예제</span></span><span>
</span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"이 기사를 읽어 주셔서 감사합니다！&lt;br&gt;"</span></span><span>;
</span><span><span class="hljs-meta">?&gt;</span></span><span>
</span></span>

mysql_field_len