@droopsnoot, WHAT SHOULD I DO NOW?
I don’t really know. You say that $inserted is an exploded array, but that’s not how it appears from your code. Can you show a sample of what is in $inserted, perhaps the result of var_dump() on it?
Also, you’re missing a parameter from bind_param() that I keep mentioning, so you need to add that. And your code would be much clearer if you got rid of all the columns in the query that you are not providing values for.
1 Like
here is a sample of the data in $inserted.
string(5) “NWEZE” string(18) " Mrs. AKPURU NGOZI" string(12) “GL08_CONHESS” string(1) “5” string(6) “EBONYI” string(9) “120901.75” string(9) “105583.75” string(0) “” string(6) “OKPANI” string(17) " Mr. IDAM ROMANUS" string(12) “GL04_CONHESS” string(1) “5” string(6) “EBONYI” string(8) “40091.33” string(8) “30914.33” string(0) “” string(8) “EKEMEZIE” string(21) " Mr. UKACHUKWU FESTUS" string(12) “GL08_CONHESS” string(1) “4” string(6) “EBONYI” string(9) “117388.83” string(9) “102388.83” string(0) “” string(5) “OKORO” string(15) " Mr. YOUNG MBAM" string(12) “GL03_CONHESS” string(1) “8” string(6) “EBONYI” string(8) “39002.17” string(8) “29961.17” string(0) “” string(9) “EKWEDIGWE” string(20) " Dr. CHINEDU KENNETH" string(12) “GL05_CONMESS” string(1) “9” string(6) “EBONYI” string(9) “823128.34” string(9) “373788.44” string(0) “” string(4) “UGWU” string(18) " Ms. ORIEOMA IRENE" string(12) “GL08_CONHESS” string(1) “4” string(6) “EBONYI” string(9) “117388.83” string(9) “102388.83” string(0) “” string(5) “NJOKU” string(21) " Mr. CLINTON DAVIDSON" string(12) “GL04_CONHESS” string(1) “5” string(6) “EBONYI” string(8) “40091.33” string(8) “30914.33” string(0) “” string(4) “ELOM” string(19) " Mr. USULOR HYGINUS" string(12) “GL09_CONHESS” string(1) “4” string(6) “EBONYI” string(9) “136496.92” string(9) “119798.92” string(0) “” string(4) “IREM” string(18) " Mr. OBIAHU JULIUS" string(12) “GL05_CONHESS” string(1) “5” string(6) “EBONYI” string(8) “47683.25” string(8) “37556.25” string(0)
for. bind param:
here is it:
mysqli_stmt_bind_result($stmt) check it i have it there…
And is this as you run through the loop, so each time you run through the loop it has one of those values? Or is it an array containing all those values at the same time, and you’ve edited out the bit where var_dump() said it’s an array?
I am confused at why that data would all want to go in the same column of a database table. You are trying to insert it into a column called “surname”, yet a lot of it is clearly not a surname. It’s not all that relevant to the problem you’re having, though.
I am not referring to that. When I first made the comment about the first parameter being missing, that was while you were using OOP style code, and I was referring to bind_param() as I said. Reading that documentation page:
and
this happen on the loop.
am not trying to insert it into one column but into table that have all the colunm which the excel file have.
for the colunm of suename we have fullname and once the record run i have a query already that split the column and sent the names to the appropet column
Just to chime in… I believe you have misunderstood what Droopsnoot was saying in post #16 regarding missing the first parameter. Please see the link he posted. The first parameter would define the type of variable(s) being passed with bind_param. If I am not mistaken it looks like you have 26 “values” being passed and so you would need to define the type for each of these. Again see link. As an example I used “s” to define all inputs as a string 26 times. “ssssssssssssssssssssssssss”
So your query would look more like this.
$institution=$_SESSION['Company'];
$UserLogin=$_SESSION['UserLogin'];
$textfile_surname = $_POST['surname'];
$textfile_occupation = $_POST['occupation2'];
$textfile_occupation1 = $_POST['occupation'];
$textfile__monthlygross = $_POST['monthly_gross'];
for ($col = 0; $col <= $highestColumnIndex; $col++) {
//assigning all data to one variable
$allcolrowdata = $columnNames = $worksheet->getCellByColumnAndRow($col, $row)->getValue();
//echo $allcolrowdata.'<br>';
$allcolrowdataexplode=explode(",",$allcolrowdata);
//var_dump( $allcolrowdataexplode).'<br>';
foreach($allcolrowdataexplode as $key => $inserted){
$stmt =$connect->prepare("INSERT INTO tem_treg2 (title,surname,first_name,middle_name,gender,dob,marital_status,occupation,phone_number,company_name,registration_type,registered_by,tax_id,office_address,office_city,temp_reg,workplace_category,active,monthly_gross,nhf,nhis,nsitf,basic_salary,grade,designation,pension,gratuity) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
$stmt->bind_param("ssssssssssssssssssssssssss","work", $inserted,'','','','','',$textfile_occupation,'',$institution,'',$UserLogin,'','','','','','','','','','','','','','','');
$stmt->execute();
}
}
I will not be available for any follow up (I have work to do) but hopefully this will help.
1 Like
thanks for the correction
You may not be intending to insert it into one column, but that is what you are doing in that code - every time you run through that loop, you try to insert $inserted into the surname column.
so how can i handdle it?
It’s hard to say without knowing how the table relates to the data you get from Excel. But I suspect it’s just a case of assigning each column from Excel to a suitable variable, then use those in your query. So you’ll run the query once for every row in the spreadsheet, containing the data from the relevant columns.
Would you mind using print_r to print your array so we can see the array structure? Can you also define what each array value represents. You MAY not be wanting to use the foreach to run through columns but rather get values from the array itself. Please use this.
echo "<pre>";
print_r($allcolrowdataexplode);
echo "</pre>";
You may be able to use the array keys to get values.
//JUST AS AN EXAMPLE: You may be able to use the array keys to get values
$surname = $allcolrowdataexplode[0];
$first_name = $allcolrowdataexplode[1];
$middle_name = $allcolrowdataexplode[2];
$gender = $allcolrowdataexplode[3];
Not knowing array structure this is just a sample to work from.
NOTE: As mentioned, you wouldn’t be using the foreach statement anymore. Just defining variables on each FOR loop.
@Drummin.
here is what the array look like.
Array
(
[0] =>
)
Array
(
[0] => NWEZE
[1] => Mrs. AKPURU NGOZI
)
Array
(
[0] => GL08_CONHESS
)
Array
(
[0] => 5
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 120901.75
)
Array
(
[0] => 105583.75
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => OKPANI
[1] => Mr. IDAM ROMANUS
)
Array
(
[0] => GL04_CONHESS
)
Array
(
[0] => 5
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 40091.33
)
Array
(
[0] => 30914.33
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => EKEMEZIE
[1] => Mr. UKACHUKWU FESTUS
)
Array
(
[0] => GL08_CONHESS
)
Array
(
[0] => 4
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 117388.83
)
Array
(
[0] => 102388.83
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => OKORO
[1] => Mr. YOUNG MBAM
)
Array
(
[0] => GL03_CONHESS
)
Array
(
[0] => 8
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 39002.17
)
Array
(
[0] => 29961.17
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => EKWEDIGWE
[1] => Dr. CHINEDU KENNETH
)
Array
(
[0] => GL05_CONMESS
)
Array
(
[0] => 9
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 823128.34
)
Array
(
[0] => 373788.44
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => UGWU
[1] => Ms. ORIEOMA IRENE
)
Array
(
[0] => GL08_CONHESS
)
Array
(
[0] => 4
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 117388.83
)
Array
(
[0] => 102388.83
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => NJOKU
[1] => Mr. CLINTON DAVIDSON
)
Array
(
[0] => GL04_CONHESS
)
Array
(
[0] => 5
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 40091.33
)
Array
(
[0] => 30914.33
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => ELOM
[1] => Mr. USULOR HYGINUS
)
Array
(
[0] => GL09_CONHESS
)
Array
(
[0] => 4
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 136496.92
)
Array
(
[0] => 119798.92
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => IREM
[1] => Mr. OBIAHU JULIUS
)
Array
(
[0] => GL05_CONHESS
)
Array
(
[0] => 5
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 47683.25
)
Array
(
[0] => 37556.25
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => MOLOKWU
[1] => Mr. RAPULUCHUKWU STEPHEN
)
Array
(
[0] => GL11_CONHESS
)
Array
(
[0] => 3
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 181536.42
)
Array
(
[0] => 161654.42
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => OTI
[1] => Mr. OGBONNIA WILLIAM
)
Array
(
[0] => GL12_CONHESS
)
Array
(
[0] => 11
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 530084.78
)
Array
(
[0] => 232168.08
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => NTE
[1] => Mrs. SANDRA NGOZI
)
Array
(
[0] => GL09_CONHESS
)
Array
(
[0] => 4
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 146781.17
)
Array
(
[0] => 119798.92
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => UZIM
[1] => Ms. CHIKA PEACE
)
Array
(
[0] => GL08_CONHESS
)
Array
(
[0] => 5
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 120901.75
)
Array
(
[0] => 105583.75
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => NWIGWE
[1] => Ms. SUCCESS CHINASA
)
Array
(
[0] => GL03_CONHESS
)
Array
(
[0] => 6
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 36945
)
Array
(
[0] => 28162
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => OBASI
[1] => Mr. NWORIE SIMON
)
Array
(
[0] => GL07_CONHESS
)
Array
(
[0] => 3
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 98633.33
)
Array
(
[0] => 85425.33
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => EGWU
[1] => Mr. AGHA EDWIN
)
Array
(
[0] => GL07_CONHESS
)
Array
(
[0] => 3
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 98633.33
)
Array
(
[0] => 85425.33
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => DANTANI
[1] => Dr. DANLADI
)
Array
(
[0] => GL04_CONMESS
)
Array
(
[0] => 9
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 465446.59
)
Array
(
[0] => 289213.01
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => OSONDU
[1] => Mrs. KEN EBELE
)
Array
(
[0] => GL11_CONHESS
)
Array
(
[0] => 3
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 195569.25
)
Array
(
[0] => 161654.42
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => ORIKO
[1] => Mr. EJEM ISAAC
)
Array
(
[0] => GL03_CONHESS
)
Array
(
[0] => 8
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 39002.17
)
Array
(
[0] => 29961.17
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => UGURU
[1] => Dr. MAXIMUS SUNDAY
)
Array
(
[0] => GL03_CONMESS
)
Array
(
[0] => 5
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 329705.83
)
Array
(
[0] => 202334.83
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => POPOOLA
[1] => Dr. ADEMUNUMIDUN SUNDAY
)
Array
(
[0] => GL03_CONMESS
)
Array
(
[0] => 7
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 344833.59
)
Array
(
[0] => 210684.42
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => OKO
[1] => Mr. OGBONNIA ANTHONY
)
Array
(
[0] => GL12_CONHESS
)
Array
(
[0] => 11
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 258539.08
)
Array
(
[0] => 232168.08
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => ONWE
[1] => Mrs. ORI VERONICA
)
Array
(
[0] => GL12_CONHESS
)
Array
(
[0] => 11
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 278732.66
)
Array
(
[0] => 232168.08
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => SEBASTINE-AZI
[1] => Mrs. IJEOMA LOUISA
)
Array
(
[0] => GL08_CONHESS
)
Array
(
[0] => 4
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 117388.83
)
Array
(
[0] => 102388.83
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => NWODE-GOODLUCK
[1] => Mrs. GLORY ONYINYECHI
)
Array
(
[0] => GL08_CONHESS
)
Array
(
[0] => 4
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 117388.83
)
Array
(
[0] => 102388.83
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => NWODOM
[1] => Mrs. AGNES
)
Array
(
[0] => GL03_CONHESS
)
Array
(
[0] => 8
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 39002.17
)
Array
(
[0] => 29961.17
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => NWOGHA
[1] => Mrs. VERONICA CHINWE
)
Array
(
[0] => GL02_CONHESS
)
Array
(
[0] => 7
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 35744.92
)
Array
(
[0] => 27111.92
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => UCHE
[1] => Mrs. ONYEBUCHI STELLA
)
Array
(
[0] => GL03_CONHESS
)
Array
(
[0] => 9
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 40029.75
)
Array
(
[0] => 30860.75
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => IGWE
[1] => Mr. KINGSLEY NWAGU
)
Array
(
[0] => GL04_CONHESS
)
Array
(
[0] => 5
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 40091.33
)
Array
(
[0] => 30914.33
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => NWIZI
[1] => Ms. ANASTECIA EGONNA
)
Array
(
[0] => GL03_CONHESS
)
Array
(
[0] => 6
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 36945
)
Array
(
[0] => 28162
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => NWOBA
[1] => Mrs. CHINYERE
)
Array
(
[0] => GL06_CONHESS
)
Array
(
[0] => 5
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 71316.42
)
Array
(
[0] => 59520.42
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => NWEKE
[1] => Ms. NWEKE NGOZI
)
Array
(
[0] => GL03_CONHESS
)
Array
(
[0] => 9
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 40029.75
)
Array
(
[0] => 30860.75
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => NWOFE
[1] => Mrs. AGNES
)
Array
(
[0] => GL03_CONHESS
)
Array
(
[0] => 9
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 40029.75
)
Array
(
[0] => 30860.75
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => IMORIN
[1] => Ms. MABEL
)
Array
(
[0] => GL08_CONHESS
)
Array
(
[0] => 4
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 117388.83
)
Array
(
[0] => 102388.83
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => NKWEGU
[1] => Mrs. O. JENNIFER
)
Array
(
[0] => GL03_CONHESS
)
Array
(
[0] => 6
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 36945
)
Array
(
[0] => 28162
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => JONAS OMOKHUWELE
[1] => Mrs. PATRICIA
)
Array
(
[0] => GL07_CONHESS
)
Array
(
[0] => 10
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 119517.42
)
Array
(
[0] => 104437.42
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => EBENYI
[1] => Mrs. NNENNA THERESA
)
Array
(
[0] => GL03_CONHESS
)
Array
(
[0] => 9
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 40029.75
)
Array
(
[0] => 30860.75
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => ELIBOH
[1] => Dr. OSAZEBEMIDE MONDAY
)
Array
(
[0] => GL03_CONMESS
)
Array
(
[0] => 5
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 329705.83
)
Array
(
[0] => 202334.83
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => NWOBA
[1] => Mrs. AUGUSTINA
)
Array
(
[0] => GL03_CONHESS
)
Array
(
[0] => 9
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 40029.75
)
Array
(
[0] => 30860.75
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => UKPACHUKWU
[1] => Mrs. CHINEME
)
Array
(
[0] => GL08_CONHESS
)
Array
(
[0] => 5
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 120901.75
)
Array
(
[0] => 105583.75
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => NWIBO
[1] => Mr. NWIBO GODWIN
)
Array
(
[0] => GL11_CONHESS
)
Array
(
[0] => 3
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 231467.25
)
Array
(
[0] => 161654.42
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => CHUKWU
[1] => Mrs. ESTHER
)
Array
(
[0] => GL03_CONHESS
)
Array
(
[0] => 6
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 36945
)
Array
(
[0] => 28162
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => OKOCHA
[1] => Mrs. CHINYERE
)
Array
(
[0] => GL11_CONHESS
)
Array
(
[0] => 9
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 221501.75
)
Array
(
[0] => 182528.33
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => ABAA
[1] => Mrs. OGODO CORDELIA
)
Array
(
[0] => GL03_CONHESS
)
Array
(
[0] => 8
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 39002.17
)
Array
(
[0] => 29961.17
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => AJA
[1] => Ms. ONYEKACHI ROSELINE
)
Array
(
[0] => GL07_CONHESS
)
Array
(
[0] => 4
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 101616.33
)
Array
(
[0] => 88141.33
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => OTUONYE
[1] => Mr. CHIEMELA CHRISTIAN
)
Array
(
[0] => GL09_CONHESS
)
Array
(
[0] => 5
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 140371.08
)
Array
(
[0] => 123322.08
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => NWANGELE
[1] => Dr. ZIJL SUNDAY
)
Array
(
[0] => GL04_CONMESS
)
Array
(
[0] => 10
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 475509.34
)
Array
(
[0] => 295515.76
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => UMOREN
[1] => Mrs. JOHNSON CHRISTIANA
)
Array
(
[0] => GL08_CONHESS
)
Array
(
[0] => 4
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 117388.83
)
Array
(
[0] => 102388.83
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => OBINNA
[1] => Mrs. CHINOMSO SANDRA
)
Array
(
[0] => GL07_CONHESS
)
Array
(
[0] => 3
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 98633.33
)
Array
(
[0] => 85425.33
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => EDIGBO
[1] => Mr. OGBONNA CHRISTOPHER
)
Array
(
[0] => GL07_CONHESS
)
Array
(
[0] => 4
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 101616.33
)
Array
(
[0] => 88141.33
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => MBAM
[1] => Ms. OGOCHUKWU
)
Array
(
[0] => GL06_CONHESS
)
Array
(
[0] => 3
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 67067.92
)
Array
(
[0] => 55720.92
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => UCHENCHI
[1] => Ms. AZUKA KINDNESS
)
Array
(
[0] => GL07_CONHESS
)
Array
(
[0] => 4
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 101616.33
)
Array
(
[0] => 88141.33
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => AMAMILO
[1] => Dr. CHINENYE JESSICA IFEOMA
)
Array
(
[0] => GL03_CONMESS
)
Array
(
[0] => 4
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 322141.95
)
Array
(
[0] => 198160.03
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => OBASI
[1] => Mrs. UGOCHUKWU OMOBONIKE
)
Array
(
[0] => GL07_CONHESS
)
Array
(
[0] => 4
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 101616.33
)
Array
(
[0] => 88141.33
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => EJIEGBU
[1] => Mr. EJIEGBU OGBONNA
)
Array
(
[0] => GL09_CONHESS
)
Array
(
[0] => 4
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 168003.17
)
Array
(
[0] => 119798.92
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => UGURU
[1] => Dr. AWOKE ISREAL
)
Array
(
[0] => GL03_CONMESS
)
Array
(
[0] => 4
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 322141.95
)
Array
(
[0] => 198160.03
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => UCHE
[1] => Mr. OKO HILARY
)
Array
(
[0] => GL07_CONHESS
)
Array
(
[0] => 2
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 95650.33
)
Array
(
[0] => 82709.33
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => AJA
[1] => Dr. OGBONNA JOHN DANIEL
)
Array
(
[0] => GL03_CONMESS
)
Array
(
[0] => 4
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 322141.95
)
Array
(
[0] => 198160.03
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => OFFIM
[1] => Mr. CHUKWUKA COSMAS
)
Array
(
[0] => GL01_CONHESS
)
Array
(
[0] => 4
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 32358.25
)
Array
(
[0] => 24150.25
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => IJEZIE
[1] => Mrs. VICTORIA BUKOLA
)
Array
(
[0] => GL09_CONHESS
)
Array
(
[0] => 4
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 136496.92
)
Array
(
[0] => 119798.92
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => ENWERE
[1] => Mrs. CHIDIMMA TINA
)
Array
(
[0] => GL09_CONHESS
)
Array
(
[0] => 4
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 168003.17
)
Array
(
[0] => 119798.92
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => EZENYEKA
[1] => Mr. C. SIXTUS
)
Array
(
[0] => GL09_CONHESS
)
Array
(
[0] => 4
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 168003.17
)
Array
(
[0] => 119798.92
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => OBIWURU
[1] => Mrs. CONSOLATA CHIDINMA
)
Array
(
[0] => GL07_CONHESS
)
Array
(
[0] => 3
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 98633.33
)
Array
(
[0] => 85425.33
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => OMOREBOKHAE
[1] => Mr. AORIE FRED
)
Array
(
[0] => GL09_CONHESS
)
Array
(
[0] => 4
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 168003.17
)
Array
(
[0] => 119798.92
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => EKONG
[1] => Mr. UDUAK ETIENEOBONG
)
Array
(
[0] => GL09_CONHESS
)
Array
(
[0] => 4
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 168003.17
)
Array
(
[0] => 119798.92
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => ODII
[1] => Mr. ORJI UMAHI PRINCE
)
Array
(
[0] => GL07_CONHESS
)
Array
(
[0] => 4
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 101616.33
)
Array
(
[0] => 88141.33
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => OBIOHA
[1] => Mrs. CHIZOBA GRACE
)
Array
(
[0] => GL07_CONHESS
)
Array
(
[0] => 3
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 98633.33
)
Array
(
[0] => 85425.33
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => EDOMWONYI
[1] => Ms. OCOSSY MERCY
)
Array
(
[0] => GL07_CONHESS
)
Array
(
[0] => 4
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 101616.33
)
Array
(
[0] => 88141.33
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => EHIGHIBE
[1] => Ms. EZINNE ISABELLA
)
Array
(
[0] => GL07_CONHESS
)
Array
(
[0] => 4
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 101616.33
)
Array
(
[0] => 88141.33
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => OPEKE
[1] => Mr. CLIFFORD ONYEBUCHI
)
Array
(
[0] => GL09_CONHESS
)
Array
(
[0] => 4
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 168003.17
)
Array
(
[0] => 119798.92
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => IBIAM
[1] => Mr. NDUBUISI
)
Array
(
[0] => GL08_CONHESS
)
Array
(
[0] => 4
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 117388.83
)
Array
(
[0] => 102388.83
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => AFOKE
[1] => Mr. ORIGBO EMMANUEL
)
Array
(
[0] => GL13_CONHESS
)
Array
(
[0] => 9
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 315965.58
)
Array
(
[0] => 287529.58
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => EBEI
[1] => Ms. ESEBONU BLESSING
)
Array
(
[0] => GL08_CONHESS
)
Array
(
[0] => 5
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 110583.75
)
Array
(
[0] => 105583.75
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => UKPAI
[1] => Ms. OGONNA HENRIETTA
)
Array
(
[0] => GL08_CONHESS
)
Array
(
[0] => 5
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 120901.75
)
Array
(
[0] => 105583.75
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => NWOGHA
[1] => Mrs. OBIAGELI
)
Array
(
[0] => GL03_CONHESS
)
Array
(
[0] => 9
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 40029.75
)
Array
(
[0] => 30860.75
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => AJA
[1] => Mrs. ONWUTA CECILIA
)
Array
(
[0] => GL12_CONHESS
)
Array
(
[0] => 10
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 272866.41
)
Array
(
[0] => 227319.83
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => UZAM
[1] => Mrs. COURAGE ELIZABETH
)
Array
(
[0] => GL12_CONHESS
)
Array
(
[0] => 11
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 530084.78
)
Array
(
[0] => 232168.08
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => UKPAI
[1] => Mrs. NNENNE ROSELINE
)
Array
(
[0] => GL11_CONHESS
)
Array
(
[0] => 11
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 230147
)
Array
(
[0] => 189486.42
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => OKWUEGBU
[1] => Mrs. NWAKAEGO
)
Array
(
[0] => GL03_CONHESS
)
Array
(
[0] => 9
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 40029.75
)
Array
(
[0] => 30860.75
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => AWOKE
[1] => Mrs. VERONICA CHINYERE
)
Array
(
[0] => GL03_CONHESS
)
Array
(
[0] => 9
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 40029.75
)
Array
(
[0] => 30860.75
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => ONWE
[1] => Ms. ONANA UKAMAKA
)
Array
(
[0] => GL02_CONHESS
)
Array
(
[0] => 6
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 34888.08
)
Array
(
[0] => 26363.08
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => NKOKA
[1] => Mr. NWAFOR BENJAMIN
)
Array
(
[0] => GL03_CONHESS
)
Array
(
[0] => 6
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 36945
)
Array
(
[0] => 28162
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => UZOKE
[1] => Mr. EFURU KELECHI
)
Array
(
[0] => GL03_CONHESS
)
Array
(
[0] => 9
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 40029.75
)
Array
(
[0] => 30860.75
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => EZE
[1] => Mrs. EUNICE
)
Array
(
[0] => GL03_CONHESS
)
Array
(
[0] => 9
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 40029.75
)
Array
(
[0] => 30860.75
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => MIGHTY-CHUKWU
[1] => Mrs. CHRISTIANA IFEOMA
)
Array
(
[0] => GL11_CONHESS
)
Array
(
[0] => 9
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 221501.75
)
Array
(
[0] => 182528.33
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => UKPAI
[1] => Ms. DOLLY UDOCHUKWU
)
Array
(
[0] => GL07_CONHESS
)
Array
(
[0] => 5
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 104600.33
)
Array
(
[0] => 90857.33
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => OGEH
[1] => Mr. OGE CHUKWUMA
)
Array
(
[0] => GL03_CONHESS
)
Array
(
[0] => 9
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 40029.75
)
Array
(
[0] => 30860.75
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => ITEZE
[1] => Mr. ANDREW SUNDAY
)
Array
(
[0] => GL03_CONHESS
)
Array
(
[0] => 9
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 40029.75
)
Array
(
[0] => 30860.75
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => RAY-AKANWA
[1] => Mrs. EMILIA NNEOMA
)
Array
(
[0] => GL09_CONHESS
)
Array
(
[0] => 4
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 136496.92
)
Array
(
[0] => 119798.92
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => SUNDAY-ADEOYE
[1] => Dr. AOISEOJE ILEOGBEN
)
Array
(
[0] => GL04_CONTOPSAL
)
Array
(
[0] => 4
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 1066407.66
)
Array
(
[0] => 0
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => OJI
[1] => Mrs. IHEKA CHRISTIANA
)
Array
(
[0] => GL07_CONHESS
)
Array
(
[0] => 6
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 107583.33
)
Array
(
[0] => 93573.33
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => ORJI
[1] => Mrs. JANET EMMANUEL
)
Array
(
[0] => GL03_CONHESS
)
Array
(
[0] => 5
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 35916.42
)
Array
(
[0] => 27262.42
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => EMEKALAM
[1] => Mrs. OMOH JUSTINA
)
Array
(
[0] => GL12_CONHESS
)
Array
(
[0] => 10
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 272866.41
)
Array
(
[0] => 227319.83
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => EZE
[1] => Mrs. PERPETUA NGOZI
)
Array
(
[0] => GL07_CONHESS
)
Array
(
[0] => 4
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 101616.33
)
Array
(
[0] => 88141.33
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => YAKUBU
[1] => Dr. NYAM EMMANUEL
)
Array
(
[0] => GL05_CONMESS
)
Array
(
[0] => 8
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 1054666.02
)
Array
(
[0] => 364795
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => NKAMA
[1] => Mr. UDUMA ISAAC
)
Array
(
[0] => GL06_CONHESS
)
Array
(
[0] => 3
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 67067.92
)
Array
(
[0] => 55720.92
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => ONWE
[1] => Mr. ONWE IFEANYI
)
Array
(
[0] => GL06_CONHESS
)
Array
(
[0] => 3
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 67067.92
)
Array
(
[0] => 55720.92
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => ELOM
[1] => Mr. OROKE UCHENNA
)
Array
(
[0] => GL04_CONHESS
)
Array
(
[0] => 5
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 40091.33
)
Array
(
[0] => 30914.33
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => USULOR
[1] => Mrs. BENEDETH
)
Array
(
[0] => GL03_CONHESS
)
Array
(
[0] => 9
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 40029.75
)
Array
(
[0] => 30860.75
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => NWALI
[1] => Ms. JENIFER GRACE
)
Array
(
[0] => GL03_CONHESS
)
Array
(
[0] => 9
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 40029.75
)
Array
(
[0] => 30860.75
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => MBAMALU
[1] => Dr. OGOCHUKWU SOPHIA
)
Array
(
[0] => GL03_CONMESS
)
Array
(
[0] => 5
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 329705.83
)
Array
(
[0] => 202334.83
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => EKOH
[1] => Mrs. ONYEMACHI BRIDGET
)
Array
(
[0] => GL12_CONHESS
)
Array
(
[0] => 11
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 278732.66
)
Array
(
[0] => 232168.08
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => OBASI
[1] => Mrs. NWABUZOR ROSELINE CECILIA
)
Array
(
[0] => GL12_CONHESS
)
Array
(
[0] => 10
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 272866.41
)
Array
(
[0] => 227319.83
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => OZIBO
[1] => Mr. NWITE JOHN
)
Array
(
[0] => GL08_CONHESS
)
Array
(
[0] => 5
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 120901.75
)
Array
(
[0] => 105583.75
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => AWONGE
[1] => Mr. AMAECHI GODWIN
)
Array
(
[0] => GL05_CONHESS
)
Array
(
[0] => 5
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 47683.25
)
Array
(
[0] => 37556.25
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => OKOLO
[1] => Mrs. OSOBOMENMEN DORCAS
)
Array
(
[0] => GL08_CONHESS
)
Array
(
[0] => 4
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 117388.83
)
Array
(
[0] => 102388.83
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => SHIMWEN
[1] => Ms. LUTHER NANDI
)
Array
(
[0] => GL07_CONHESS
)
Array
(
[0] => 9
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 116533.42
)
Array
(
[0] => 101721.42
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => CHIGBO
[1] => Mr. CHIDI EMMANUEL
)
Array
(
[0] => GL08_CONHESS
)
Array
(
[0] => 4
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 117388.83
)
Array
(
[0] => 102388.83
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => ITUMA
[1] => Mrs. LINDA NKEMJIKA
)
Array
(
[0] => GL11_CONHESS
)
Array
(
[0] => 11
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 230147
)
Array
(
[0] => 189486.42
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => ELECHI
[1] => Mrs. OWHUO COLLETTE
)
Array
(
[0] => GL12_CONHESS
)
Array
(
[0] => 9
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 322785.16
)
Array
(
[0] => 222471.58
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => OGBONNAYA
[1] => Mrs. NGOZI GOODNESS
)
Array
(
[0] => GL09_CONHESS
)
Array
(
[0] => 4
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 146781.17
)
Array
(
[0] => 119798.92
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => OKENWA
[1] => Dr. SAMUEL CHIMA
)
Array
(
[0] => GL03_CONMESS
)
Array
(
[0] => 5
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 329705.83
)
Array
(
[0] => 202334.83
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => EGWU-ALLOYIS
[1] => Mrs. OBIA FLORA
)
Array
(
[0] => GL11_CONHESS
)
Array
(
[0] => 11
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 213961.42
)
Array
(
[0] => 189486.42
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => IZUCHUKWU-IDAGBA
[1] => Mrs. AGATHA CHIZOBA
)
Array
(
[0] => GL07_CONHESS
)
Array
(
[0] => 9
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 116533.42
)
Array
(
[0] => 101721.42
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => NWACHUKWU
[1] => Mrs. HANNAH NKOLIKA
)
Array
(
[0] => GL12_CONHESS
)
Array
(
[0] => 11
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 278732.66
)
Array
(
[0] => 232168.08
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => NWOKORO
[1] => Mr. DENNIS
)
Array
(
[0] => GL06_CONHESS
)
Array
(
[0] => 3
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 67067.92
)
Array
(
[0] => 55720.92
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => JOSIAH-AJA
[1] => Mrs. BLESSING
)
Array
(
[0] => GL08_CONHESS
)
Array
(
[0] => 4
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 117388.83
)
Array
(
[0] => 102388.83
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => NWEKE
[1] => Mr. NOEL MARTINS UGOCHUKWU
)
Array
(
[0] => GL09_CONHESS
)
Array
(
[0] => 5
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 172790.58
)
Array
(
[0] => 123322.08
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => EMEM
[1] => Mr. EDE LAWRENCE
)
Array
(
[0] => GL03_CONHESS
)
Array
(
[0] => 5
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 35916.42
)
Array
(
[0] => 27262.42
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => ASIEGBU
[1] => Ms. OBIMBA OLUCHI
)
Array
(
[0] => GL11_CONHESS
)
Array
(
[0] => 3
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 231467.25
)
Array
(
[0] => 161654.42
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => IDAM
[1] => Mrs. OGBONNIE JOY
)
Array
(
[0] => GL07_CONHESS
)
Array
(
[0] => 3
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 98633.33
)
Array
(
[0] => 85425.33
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => JWAT
[1] => Mr. EMMANUEL SIMON
)
Array
(
[0] => GL11_CONHESS
)
Array
(
[0] => 9
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 205854.33
)
Array
(
[0] => 182528.33
)
Array
(
[0] =>
)
Array
(
[0] =>
)
Array
(
[0] => CHUKWU
[1] => Mrs. NCHEKWUBEDI STELLA
)
Array
(
[0] => GL08_CONHESS
)
Array
(
[0] => 4
)
Array
(
[0] => EBONYI
)
Array
(
[0] => 117388.83
)
Array
(
[0] => 102388.83
)
Array
(
[0] =>
)
her is the table structure.
idtreg int(10) unsigned NO PRI auto_increment
title varchar(45) YES
surname varchar(45) NO
first_name varchar(45) NO
middle_name varchar(45) YES
gender varchar(45) YES
dob date YES
marital_status varchar(45) YES
occupation varchar(45) NO
phone_number varchar(45) YES
company_name varchar(200) YES
registration_type tinyint(1) unsigned NO 1
registered_by varchar(45) NO taxo_import
tax_id varchar(45) NO
office_address varchar(45) YES
office_city varchar(45) YES
temp_reg tinyint(1) unsigned NO 1
workplace_category varchar(45) YES
active tinyint(1) unsigned NO 0
monthly_gross decimal(50,2) NO
NHF decimal(50,2) NO 0.00
NHIS decimal(50,2) NO 0.00
NSITF decimal(50,2) NO 0.00
basic_salary decimal(50,2) NO
grade varchar(45) YES
designation varchar(45) YES
pension decimal(50,2) NO 0.00
locked tinyint(1) unsigned NO 0
gratuity decimal(50,2) NO 0.00
hash varchar(244) YES
Hmm. OK well, not as I expected. We need to be looping through rows not columns.
What we are looking for is an array that would look something like this.
Array
(
[0] => NWEZE
[1] => Mrs. AKPURU NGOZI
[2] => GL08_CONHESS
[3] => 5
[4] => EBONYI
[5] => 120901.75
[6] => 105583.75
[7] =>
[8] =>
)
… which you can then set to variables based on their numeric keys 0 ,1 ,2 etc.
I am not really setup for doing any testing but I would think you would need to loop through your rows something like this. Hopefully you will see arrays like I showed above.
$highestRowIndex = $worksheet->getHighestRow();
$highestColumnIndex = $worksheet->getHighestColumn();
for ($row = 1; $row <= $highestRowIndex; $row++) {
$rowData = $worksheet->rangeToArray('A' . $row . ':' . $highestColumnIndex . $row, null, true, false);
echo '<pre>';
print_r($rowData[0]);
echo '</pre>';
//JUST AS AN EXAMPLE: you be able to use the array keys to get values
$surname = $rowData[0][0];
$first_name = $rowData[0][1];
$middle_name = $rowData[0][2];
$gender = $rowData[0][3];
//$stmt =$connect->prepare("INSERT INTO tem_treg2 (title,surname,first_name,middle_name,gender,dob,marital_status,occupation,phone_number,company_name,registration_type,registered_by,tax_id,office_address,office_city,temp_reg,workplace_category,active,monthly_gross,nhf,nhis,nsitf,basic_salary,grade,designation,pension,gratuity) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
//$stmt->bind_param("ssssssssssssssssssssssssss","work", $inserted,'','','','','',$textfile_occupation,'',$institution,'',$UserLogin,'','','','','','','','','','','','','','','');
//$stmt->execute();
}
@Drummin. am happy bcos you are getting my point.
but what i want to achieve in this whole process is to read the xls file dynamically and mapp the column with my database table. i have already loop through the row as you just said. it read with particular file formate. but that is not what i want to archiev here.
i want to read the heading and mapp with my table regardless of the column position in the excel file
Wouldn’t the xlx column (name) be the same for each row loop?
no it Wouldn’t be of the same name
Do you get column names when print the first row?
$headings = $worksheet->rangeToArray('A1:' . $highestColumnIndex . 1,null, true, false);
yes i do
Can you give example of these headings?