ID: 34184
Updated by: [EMAIL PROTECTED]
Reported By: michel at i-real dot nl
Status: Feedback
Bug Type: dBase related
Operating System: Linux FC3
PHP Version: 4.4.0
New Comment:
And shouldn't you be using dbase_get_record_with_names() to be able to
get your expected result? (associative array)
Previous Comments:
------------------------------------------------------------------------
[2005-08-18 12:51:32] [EMAIL PROTECTED]
What fields (and what formats are they in) are there in that dbase
file?
------------------------------------------------------------------------
[2005-08-18 11:54:22] michel at i-real dot nl
Description:
------------
When I try to open a .dbf file, the rows that are returned are filled
with 0, and somtimes some a row with random crap.
The .dbf file has 255 colums an 10.000 rows . I've tried to open a much
smaller file, that's made by the same program, ands that's working out
fine.
The .dbf file is 25mb, so if you e-mail me I can give you the URL of
it, so that you can use it to test.
Reproduce code:
---------------
<?
$db = dbase_open ("TREND.dbf", "r");
if ($db) {
// count the number of rows
$record_numbers = dbase_numrecords($db);
echo $record_numbers."<br><br><pre>";
$record_numbers = 250;
for ($i=0; $i<$record_numbers;$i++) {
$row = dbase_get_record ($db, $i);
var_dump($row);
}
}
// close it
dbase_close($db);
?>
Expected result:
----------------
array(255) {
["SECTIME"]=>
string(9) "808491480"
["A"]=>
string(9) "100.00000"
["B"]=>
string(2) "32"
["C"]=>
string(9) "650.91577"
["D"]=>
string(7) "0.41026"
["E"]=>
string(9) "164.36630"
["F"]=>
string(7) "0.00000"
["G"]=>
string(2) "36"
["H"]=>
string(7) "3.18681"
["I"]=>
string(2) "34"
["J"]=>
string(7) "3.20879"
["K"]=>
string(2) "38"
["L"]=>
string(2) "31"
["M"]=>
string(2) "45"
["N"]=>
string(2) "30"
["O"]=>
string(2) "35"
["P"]=>
string(2) "30"
["Q"]=>
string(8) "69.27961"
["R"]=>
string(7) "1.30000"
["S"]=>
string(7) "1.30000"
["T"]=>
string(9) "112.13675"
["U"]=>
string(7) "0.43956"
["V"]=>
string(7) "0.53724"
["W"]=>
string(8) "99.48718"
["X"]=>
string(8) "70.13431"
["Y"]=>
string(7) "1.30000"
["Z"]=>
string(7) "0.00000"
["AA"]=>
string(9) "116.72771"
["AB"]=>
string(7) "0.19536"
["AC"]=>
string(8) "99.09646"
["AD"]=>
string(7) "0.48840"
["AE"]=>
string(3) "378"
["AF"]=>
string(4) "4898"
["AG"]=>
string(2) "17"
["AH"]=>
string(1) "0"
["AI"]=>
string(7) "1.77045"
["AJ"]=>
string(7) "1.40415"
["AK"]=>
string(7) "0.01099"
["AL"]=>
string(7) "1.22100"
["AM"]=>
string(7) "2.33089"
["AN"]=>
string(8) "19.77534"
["AO"]=>
string(7) "0.00000"
["AP"]=>
string(7) "2.33573"
["AQ"]=>
string(7) "0.00000"
["AR"]=>
string(8) "20.86447"
["AS"]=>
string(7) "1.34115"
["AT"]=>
string(7) "1.73578"
["AU"]=>
string(7) "1.20000"
["AV"]=>
string(7) "1.68498"
["AW"]=>
string(4) "4852"
["AX"]=>
string(4) "3539"
["AY"]=>
string(7) "0.00000"
["AZ"]=>
string(7) "0.00000"
["BA"]=>
string(7) "2.85470"
["BB"]=>
string(7) "3.49060"
["BC"]=>
string(2) "56"
["BD"]=>
string(2) "28"
["BE"]=>
string(2) "41"
["BF"]=>
string(2) "51"
["BG"]=>
string(2) "20"
["BH"]=>
string(7) "0.00000"
["BI"]=>
string(7) "0.00000"
["BJ"]=>
string(7) "0.00000"
["BK"]=>
string(7) "0.00000"
["BL"]=>
string(7) "0.00000"
["BM"]=>
string(7) "1.31575"
["BN"]=>
string(7) "0.67009"
["BO"]=>
string(7) "1.20000"
["BP"]=>
string(7) "2.44933"
["BQ"]=>
string(4) "1139"
["BR"]=>
string(4) "3972"
["BS"]=>
string(8) "20.55189"
["BT"]=>
string(7) "0.00000"
["BU"]=>
string(7) "2.83028"
["BV"]=>
string(7) "3.08718"
["BW"]=>
string(2) "10"
["BX"]=>
string(2) "94"
["BYY"]=>
string(7) "0.00000"
["BZ"]=>
string(2) "20"
["CA"]=>
string(7) "0.00000"
["CB"]=>
string(7) "1.56777"
["CC"]=>
string(7) "1.21123"
["CD"]=>
string(7) "1.40000"
["CE"]=>
string(7) "3.56532"
["CF"]=>
string(4) "2086"
["CG"]=>
string(4) "4000"
["CH"]=>
string(8) "21.51892"
["CI"]=>
string(7) "0.00000"
["CJ"]=>
string(7) "2.85226"
["CK"]=>
string(7) "3.42906"
["CL"]=>
string(2) "16"
["CM"]=>
string(2) "64"
["CN"]=>
string(2) "20"
["CO"]=>
string(8) "63.21856"
["CP"]=>
string(8) "63.60928"
["CQ"]=>
string(8) "65.44566"
["CR"]=>
string(8) "49.23077"
["CS"]=>
string(8) "49.44567"
["CT"]=>
string(8) "48.76191"
["CU"]=>
string(8) "56.49817"
["CV"]=>
string(8) "55.63858"
["CW"]=>
string(8) "59.83883"
["CX"]=>
string(7) "0.00000"
["CY"]=>
string(7) "2.72527"
["CZ"]=>
string(2) "43"
["DA"]=>
string(7) "1.48474"
["DB"]=>
string(2) "42"
["DC"]=>
string(7) "1.71673"
["DD"]=>
string(2) "43"
["DE"]=>
string(7) "2.13919"
["DF"]=>
string(2) "72"
["DG"]=>
string(7) "2.05372"
["DH"]=>
string(7) "0.00000"
["DI"]=>
string(7) "0.00000"
["DJ"]=>
string(3) "242"
["DK"]=>
string(7) "1.69280"
["DL"]=>
string(8) "14.03541"
["DM"]=>
string(7) "0.02051"
["DN"]=>
string(10) "3250.03662"
["DO"]=>
string(10) "1958.24170"
["DP"]=>
string(7) "3.28596"
["DQ"]=>
string(8) "17.01197"
["DR"]=>
string(8) "20.67399"
["DS"]=>
string(7) "0.00611"
["DT"]=>
string(8) "21.39682"
["DU"]=>
string(7) "0.00000"
["DV"]=>
string(9) "-10.98901"
["DW"]=>
string(7) "0.00000"
["DX"]=>
string(7) "0.00000"
["DY"]=>
string(8) "18.36874"
["DZ"]=>
string(2) "46"
["EA"]=>
string(1) "1"
["EB"]=>
string(2) "70"
["EC"]=>
string(2) "67"
["ED"]=>
string(2) "67"
["EE"]=>
string(3) "997"
["EF"]=>
string(3) "102"
["EG"]=>
string(3) "113"
["EH"]=>
string(3) "150"
["EI"]=>
string(3) "583"
["EJ"]=>
string(3) "579"
["EK"]=>
string(3) "585"
["EL"]=>
string(7) "1.60928"
["EM"]=>
string(7) "2.46886"
["EN"]=>
string(8) "13.28449"
["EO"]=>
string(7) "2.51722"
["EP"]=>
string(2) "52"
["EQ"]=>
string(8) "13.49451"
["ER"]=>
string(2) "16"
["ES"]=>
string(7) "2.20366"
["ET"]=>
string(2) "38"
["EU"]=>
string(7) "0.16606"
["EV"]=>
string(2) "14"
["EW"]=>
string(1) "0"
["EX"]=>
string(2) "42"
["EY"]=>
string(2) "85"
["EZ"]=>
string(1) "0"
["FA"]=>
string(4) "1989"
["FB"]=>
string(2) "43"
["FC"]=>
string(1) "2"
["FD"]=>
string(1) "2"
["FE"]=>
string(7) "0.00000"
["FF"]=>
string(7) "0.06886"
["FG"]=>
string(7) "0.03419"
["FH"]=>
string(7) "0.07326"
["FI"]=>
string(7) "0.37607"
["FJ"]=>
string(1) "0"
["FK"]=>
string(7) "0.00000"
["FL"]=>
string(7) "0.07912"
["FM"]=>
string(7) "0.00000"
["FN"]=>
string(7) "0.00000"
["FO"]=>
string(7) "0.44444"
["FP"]=>
string(7) "7.24176"
["FQ"]=>
string(7) "0.00000"
["FR"]=>
string(7) "2.41465"
["FS"]=>
string(7) "7.08791"
["FT"]=>
string(2) "13"
["FU"]=>
string(2) "18"
["FV"]=>
string(2) "16"
["FW"]=>
string(7) "0.00000"
["FX"]=>
string(7) "0.06447"
["FY"]=>
string(7) "0.34188"
["FZ"]=>
string(7) "0.60659"
["GA"]=>
string(7) "0.30525"
["GB"]=>
string(7) "0.26129"
["GC"]=>
string(7) "0.39048"
["GD"]=>
string(7) "0.50476"
["GE"]=>
string(7) "0.51648"
["GF"]=>
string(7) "1.85836"
["GG"]=>
string(7) "1.93407"
["GH"]=>
string(8) "-0.53602"
["GI"]=>
string(7) "0.16850"
["GJ"]=>
string(7) "2.38828"
["GK"]=>
string(2) "21"
["GL"]=>
string(1) "0"
["GM"]=>
string(8) "39.32845"
["GN"]=>
string(8) "38.68132"
["GO"]=>
string(8) "19.43834"
["GP"]=>
string(8) "55.57998"
["GQ"]=>
string(8) "62.51526"
["GR"]=>
string(8) "56.14164"
["GS"]=>
string(8) "23.32112"
["GT"]=>
string(7) "0.00000"
["GU"]=>
string(8) "54.09035"
["GV"]=>
string(7) "1.09646"
["GW"]=>
string(7) "8.48596"
["GX"]=>
string(7) "8.35165"
["GY"]=>
string(7) "0.38462"
["HA"]=>
string(2) "71"
["HB"]=>
string(1) "0"
["HC"]=>
string(1) "1"
["HD"]=>
string(2) "28"
["HE"]=>
string(3) "160"
["HF"]=>
string(1) "0"
["HG"]=>
string(1) "0"
["HH"]=>
string(1) "0"
["HI"]=>
string(1) "1"
["HJ"]=>
string(1) "0"
["HK"]=>
string(1) "3"
["HL"]=>
string(1) "0"
["HM"]=>
string(9) "100.00000"
["HN"]=>
string(1) "0"
["HO"]=>
string(1) "0"
["HP"]=>
string(1) "0"
["HQ"]=>
string(7) "0.22711"
["HR"]=>
string(7) "0.50549"
["HS"]=>
string(7) "0.00000"
["HT"]=>
string(7) "7.07448"
["HU"]=>
string(7) "6.84005"
["HV"]=>
string(7) "6.71306"
["HW"]=>
string(7) "6.37118"
["HX"]=>
string(8) "50.00000"
["HY"]=>
string(9) "-47.02076"
["HZ"]=>
string(8) "-7.16727"
["IA"]=>
string(7) "0.20513"
["IB"]=>
string(8) "35.92674"
["IC"]=>
string(7) "0.23199"
["ID"]=>
string(7) "0.48840"
["IE"]=>
string(7) "0.44689"
["IFF"]=>
string(7) "0.16117"
["IG"]=>
string(7) "0.00977"
["IH"]=>
string(7) "0.12698"
["II"]=>
string(8) "35.54335"
["IJ"]=>
string(8) "34.66423"
["IK"]=>
string(1) "0"
["IL"]=>
string(8) "40.00000"
["IM"]=>
string(7) "0.35165"
["INN"]=>
string(7) "0.00000"
["IO"]=>
string(7) "2.49377"
["IP"]=>
string(7) "1.57753"
["IQ"]=>
string(7) "0.09377"
["IR"]=>
string(7) "0.00000"
["ISS"]=>
string(7) "0.00000"
["IT"]=>
string(7) "0.03907"
["IU"]=>
string(4) "4877"
}
Actual result:
--------------
array(84) {
[0]=>
int(808491480)
[1]=>
int(0)
[2]=>
int(0)
[3]=>
int(0)
[4]=>
int(0)
[5]=>
int(0)
[6]=>
int(0)
[7]=>
int(0)
[8]=>
int(0)
[9]=>
int(0)
[10]=>
int(727)
[11]=>
int(513)
[12]=>
int(674)
[13]=>
int(0)
[14]=>
int(0)
[15]=>
int(0)
[16]=>
int(0)
[17]=>
int(0)
[18]=>
int(0)
[19]=>
int(0)
[20]=>
int(0)
[21]=>
int(0)
[22]=>
int(0)
[23]=>
int(0)
[24]=>
int(0)
[25]=>
int(0)
[26]=>
int(0)
[27]=>
int(0)
[28]=>
int(0)
[29]=>
int(0)
[30]=>
int(0)
[31]=>
int(0)
[32]=>
int(0)
[33]=>
int(0)
[34]=>
int(0)
[35]=>
int(0)
[36]=>
int(0)
[37]=>
int(0)
[38]=>
int(0)
[39]=>
int(0)
[40]=>
int(0)
[41]=>
int(0)
[42]=>
int(0)
[43]=>
int(0)
[44]=>
int(0)
[45]=>
int(0)
[46]=>
int(0)
[47]=>
int(0)
[48]=>
int(0)
[49]=>
int(0)
[50]=>
int(0)
[51]=>
int(0)
[52]=>
int(0)
[53]=>
int(0)
[54]=>
int(0)
[55]=>
int(0)
[56]=>
int(0)
[57]=>
int(0)
[58]=>
int(0)
[59]=>
int(0)
[60]=>
int(0)
[61]=>
int(0)
[62]=>
int(0)
[63]=>
int(0)
[64]=>
int(1)
[65]=>
int(0)
[66]=>
int(0)
[67]=>
int(0)
[68]=>
int(0)
[69]=>
int(0)
[70]=>
int(0)
[71]=>
int(0)
[72]=>
int(3907)
[73]=>
int(0)
[74]=>
int(0)
[75]=>
int(0)
[76]=>
int(0)
[77]=>
int(0)
[78]=>
int(0)
[79]=>
int(0)
[80]=>
int(0)
[81]=>
int(0)
[82]=>
int(0)
["deleted"]=>
int(0)
}
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=34184&edit=1
