php - Associative Array with Variable Values -

-

i have been looking on place need i'm not getting anywhere. not sure if because thing want isn't allowed or don't' know how word find solution.

i creating excel export has lot of worksheets there lot of repetitive code made foreach loop. problem array have has variables inside , need code put specific variables spots need it. 

 $y1953 =& $workbook->add_worksheet('1953');  $y1958 =& $workbook->add_worksheet('1958');  $y1963 =& $workbook->add_worksheet('1963');  $y1978 =& $workbook->add_worksheet('1978');  $y1988 =& $workbook->add_worksheet('1988');  $y2003 =& $workbook->add_worksheet('2003');         $yearlist = array($y1953 => '1953', $y1958 => '1958', $y1963 => '1963', $y1978 => '1978', $y1988 => '1988', $y2003 => '2003');     foreach ($yearlist $year => $yearnum){    $line = 1; # start on line 2     # write each line        foreach ($bll->rows $row) {         $numberlist = array (''=>'1', '2'=>'2', '3' => '3', '4' => '4');        foreach ($numberlist $name => $num){       if ($row['gyear'.$name] === $yearnum){             $col = 0;                    $year->write_string($line, $col, ''); $col += 1;             $year->write_string($line, $col, $row['name_last'.$name]);$col += 1;             $year->write_string($line, $col, $row['name_first'.$name]); $col += 1;             $year->write_string($line, $col, $row['name_last']); $col +=1;              if($row['session'. $num .'1'] === '1')             {             $year->write_number($line, $col, $row['session'. $num .'1'] );               }$col += 1;             if($row['session'. $num .'2'] === '1')             {             $year->write_number($line, $col, $row['session'. $num .'2'] );              }$col += 1;              if($row['session'. $num .'3'] === '1')             {             $year->write_number($line, $col, $row['session'. $num .'3'] );              }$col += 1;              if($row['session'. $num .'4'] === '1')             {             $year->write_number($line, $col, $row['session'. $num .'4'] );              }$col += 1;              if($row['session'. $num .'5'] === '1')             {             $year->write_number($line, $col,$row['session'. $num .'5'] );              }$col += 1;              if($row['session'. $num .'6'] === '1')             {             $year->write_number($line, $col, $row['session'. $num .'6'] );             }$col += 1;               $year->write_number($line, $col, '1'); $col +=1;             $year->write_string($line, $col, $row['notes']); $col += 1;                  $line += 1;        }       }   }

$yearlist array having trouble with. need first value "$y1953" $year in foreach loop. right now, nothing shows in excel sheet. there way have code put variable in spot need it? or variables values?

i differently person making excel export wants specific way.

thanks

arrays , objects can not used keys. doing result in warning: illegal offset type.

http://php.net/manual/en/language.types.array.php

try switching keys , values around in array declaration.

$yearlist = array('1953' => $y1953, '1958' => $y1958......etc.

than change foreach 

foreach ($yearlist $yearnum => $year)

Comments

Post a Comment

Popular posts from this blog

c++ - Creating new partition disk winapi -

-
i'am trying create new partition , mount volume new, thought createfile let me this, code : lpctstr lpfilename=l"\\\\.\\device\\harddisk0\\partition3"; handle handl=createfile( lpfilename, generic_read | generic_write, file_share_read | file_share_write, null, create_always, file_attribute_normal, null ); if (handl==invalid_handle_value) { qdebug()<<"handl invalid"<<" error"<<getlasterror();} bool success = definedosdevice(ddd_raw_target_path,l"i:",l"\\device\\harddisk0\\partition3"); if(!success) qdebug()<<" definedosdevice failed "<<getlasterror(); bflag = getvolumenameforvolumemountpoint( l"i:\\", // input volume mount point or directory /** u in dir
Read more

Android Prevent Bluetooth Pairing Dialog -

-
i'm developing internal application uses bluetooth printing. want bluetooth pairing occur without user input. have managed working trapping android.bluetooth.device.action.pairing_request broadcast. in broadcast receiver call setpin method, , pairing works ok, bluetoothpairingdialog displayed second or two, disappears - see link below. https://github.com/android/platform_packages_apps_settings/blob/master/src/com/android/settings/bluetooth/bluetoothpairingdialog.java since broadcast non-ordered, can't call abortbroadcast() , , wondering if there other way prevent pairing dialog appearing. can hook window manager in way? i haven't been able come way without modifying sdk. if you're oem, it's easy (i'm on 4.3): in packages/apps/settings/androidmanifest.xml, comment intent filter pairing dialog: <activity android:name=".bluetooth.bluetoothpairingdialog" android:label="@string/bluetooth_pairing_request"
Read more

VBA function to include CDATA -

-
i have following function include cdata: function cdatasection() dim objdom domdocument dim objkmlrootelement ikmldomelement dim objkmlelement ikmldomelement dim cdata ikmldomcdatasection set objdom = new domdocument set objkmlrootelement = objdom.createelement("balloonstyle") objdom.appendchild objkmlrootelement set objkmlelement = objdom.createelement("text") objkmlrootelement.appendchild objkmlelement set cdata = objdom.createcdatasection("text") cdata.data = "<![cdata[<b>latitude = $[latitude]</b>?]]>;" end function when run above, getting error "user defined data type not found" function. yes ripster says find library reference. vba window tools>references for list of relevant references see... http://msdn.microsoft.com/en-us/library/windows/desktop/ms763701%28v=vs.85%29.aspx however, if have hard time tracking down reference, replace dim sta
Read more