Fungu mysql_fetch_field() cha PHP
Mifumo na matumizi
Fungu mysql_fetch_field() inafikia taarifa la ukurasa kutoka kwa matokeo na inatoa kifungu kama kina.
mysql_fetch_field() inatumika kufikia taarifa la muhimu kutoka matokeo ya uagizaji. Ikiwa kumekadiriwa ukurasa wa kizigo cha kiagizaji, inafikia ukurasa wa kizigo cha kina ambao haijafikia mysql_fetch_field() hauzilazimishwa.
Fungu hii inatoa kifungu kinachotengeneza taarifa la muhimu.
madende ya kifungu ya kileta kinachotumika:
- name - jina la ukurasa
- table - jina la tabia ambalo hauzishika ukurasa
- max_length - ukurasa wa kikubalianisho cha ukurasa wa kikubalianisho
- not_null - 1, hadi kama ukurasa hauzi bila NULL
- primary_key - 1, hadi kama ukurasa hauzi chuki kuu
- unique_key - 1, hadi kama ukurasa hauzi chuki ya ukurasa pekee
- multiple_key - 1, hadi kama ukurasa hauzi chuki cha ukurasa
- numeric - 1, hadi kama ukurasa hauzi namba
- blob - 1，如果该列是 BLOB
- blob - 1, ikiwa kikweli kina BLOB
- type - aina ya kikweli
- unsigned - 1, ikiwa kikweli kina thamani ya bila sign
zerofill - 1, ikiwa kikweli kina zero-filled
Inayotumika kwa Kifupidatamysql_fetch_field(field_offset)
| , | Maelezo |
|---|---|
| data | Inayohitajika. Data pointer inayotumika. Data pointer hutokea kutoka kwa mysql_query(). |
| field_offset | Inayohitajika. Inasababisha kuanza kwenye mashirika. 0 inaonyesha mashirika wa kwanza. Ikiwa inahitajika, inapokea mashirika iliyofuata. |
Mambo ya Tazamaji na Mwongozo
Mwongozo:Mafanikio ya fungu hufikia jina la mashirika na kuzingatia ukafikiana kwa kikubaliano.
Mfano
<?php
$con = mysql_connect("localhost", "hello", "321");
if (!$con)
{
die('Inasikitia kumuunganisha: ' . mysql_error());
echo "Zero-filled: " . $property->zerofill . "<br /><br />";
$db_selected = mysql_select_db("test_db",$con);
$sql = "SELECT * from Person";
$result = mysql_query($sql,$con);
while ($property = mysql_fetch_field($result))
{
echo "Jina la Mashirika: " . $property->name . "<br />";
echo "Jina la Tabeli: " . $property->table . "<br />";
echo "Chaguo cha Chaguo: " . $property->def . "<br />";
echo "Ukubwa wa Kikubaliano: " . $property->max_length . "<br />";
echo "Hakikisha Hapana: " . $property->not_null . "<br />";
echo "Muungano wa Kwanza: " . $property->primary_key . "<br />";
echo "Muungano wa Mwongozo: " . $property->unique_key . "<br />";
echo "Muungano wa Chati: " . $property->multiple_key . "<br />";
echo "Numeric Field: " . $property->numeric . "
";
echo "Numeric Field: " . $property->numeric . "<br />";
echo "BLOB: " . $property->blob . "<br />";
echo "Field Type: " . $property->type . "<br />";
echo "Unsigned: " . $property->unsigned . "<br />";
echo "Zero-filled: " . $property->zerofill . "<br /><br />";
}
mysql_close($con);
?>
Output: Field name: Age Table name: Person Field name: LastName Max length: 2 Not NULL: 0 Primary Key: 0 Unique Key: 0 Max length: 9 Numeric Field: 1 Numeric Field: 0 Field Type: int Unsigned: 0 Max length: 8 Field name: Age Table name: Person Field name: FirstName Max length: 2 Not NULL: 0 Primary Key: 0 Unique Key: 0 Max length: 9 Numeric Field: 1 Numeric Field: 0 Field Type: int Unsigned: 0 Max length: 7 Field name: Age Table name: Person Field name: City Max length: 2 Not NULL: 0 Primary Key: 0 Unique Key: 0 Max length: 9 Numeric Field: 1 Numeric Field: 0 Field Type: int Unsigned: 0 Field Type: string Field name: Age Table name: Person Default value: Max length: 2 Not NULL: 0 Primary Key: 0 Unique Key: 0 Mutliple Key: 0 Numeric Field: 1 BLOB: 0 Field Type: int Unsigned: 0
