Saturday, July 7, 2012

mysql_fetch_lengths() function


mysql_fetch_lengths() function ကေတာ႔ row ထဲ႔မွာရွိတဲ႔ field တစ္ခုစီရဲ႕စာေၾကာင္းရဲ႕အရွည္ကို return ျပန္ေပးမွာျဖစ္ပါတယ္၊
row ေတြကိုေတာ႔ mysql_fetch_array(),mysql_fetch_assoc,mysql_fetch_object() ဒါမွမဟုတ္ mysql_fetch_row() သံုးျပီးထုတ္ယူနိုင္ပါတယ္၊
ဒီ function ကေတာ႔ မွန္ခဲ႔ရင္ numeric array ကို return ျပန္ေပးျပီး မဟုတ္ဘူးဆိုရင္ေတာ႔ false ျဖစ္သြားမွျဖစ္ပါတယ္

Syntax
mysql_fetch_lengths(data)

data ဆိုတာ parameter ပါ
သူရဲ႕ ေဖာ္ျပခ်က္ကေတာ႔ မရွိမျဖစ္ထည္႔ေပးရမွာပါ၊ဘယ္ data ကိုသံုးမယ္ဆိုတာေရႊးေပးရပါမယ္။ data ကိုေတာ႔ mysql_query() function ကေန result ရမွာပါ

ဥပမာ
<?php
$con=mysql_connect("localhost","root","");
if(!$con)
    {
    die("Could not connect : " . mysql_error());
    }
$db=mysql_select_db("mydb",$con);
$sql="SELECT * FROM person WHERE name='cyberoot'";
$result=mysql_query($sql,$con);
print_r(mysql_fetch_row($result));
print_r(mysql_fetch_lengths($results));
mysql_close($con);
?>

The Output is
Array ( [0] => 1 [1] => cyberoot [2] => @ygn )
Array ( [0] => 1 [1] => 8           [2] => 4 )

အဆင္ေျပမယ္လို႔ထင္ပါတယ္ဗ်ာ

No comments:

Post a Comment

Thanks for your comments
Welcome from cyberoot