Heres my code in a php bracket. Wouldn't all fit in one post 🙂 or maybe I'm just dumb. . .
. . .
for ($z = 0; $z <= $number; $z++)
{
$X = time();
for ($y = 0; $y <= 95; $y++)
set_time_limit(30);
//didn't work
$WO[$z][$y] = filter_var($WO[$z][$y], FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_LOW);
//didn't work
$WO[$z][$y] = mysql_real_escape_string($WO[$z][$y]);
//didn't work
$WO[$z][$y] = addcslashes($WO[$z][$y], '\'');
$WO[$z][$y] = addcslashes($WO[$z][$y], '\"');
//didn't work
$WO[$z][$y] = trim($WO[$z][$y],"\x22\x27");
//didn't work
if (get_magic_quotes_gpc())
$WO[$z][$y] = stripslashes($WO[$z][$y]);
else if (!get_magic_quotes_gpc())
$WO[$z][$y] = addslashes($WO[$z][$y]);
$X2 = time();
$X3 = $X3 + ($X2 - $X1);
}
echo "Finished filtering array. . .<br /><br /><br />";
echo "Time taken: " . date('i:s', $X3) . "<br /><br /><br />";
for ($x = 0; $x <= $number; $x++)
{
$t1 = time();
mysql_query("INSERT INTO WorkOrder (WorkOrderNumber,
CustomerOrderNumber,
ReleaseContractNumber,
AssignedVendor,
AssignedVendorSite,
AssignedEmployee,
VendorPrimaryAssign,
AssignedName,
Priority,
Status,
OrderType,
OrderTypeAlt,
OrderCategory,
PhoneFix,
PhoneFixAssn,
RequestedBy,
RequestedFrom,
ConfirmedDate,
ConfirmedBy,
DateEntered,
DateDispatchIsAllowed,
DateDispatched,
DateFaxed,
DateWorkIsAllowed,
DateNextArrival,
DateNextArrivalSite,
DateTargetDispatch,
DateTargetResponse,
DateTargetResponseSite,
DateTargetClose,
DateEstimatedComplete,
DateComplete,
DateClosed,
Timezone,
Arrival,
Departure,
OvertimeAllowed,
TravelAllowed,
ApprovalCode,
ApprovedBy,
Dispatcher,
ProblemDescription,
ProblemFound,
CompletionDescription,
GradeHD,
GradeCust,
BidAmount,
BidNotExceed,
BidAuthCode,
ActualCost,
BilledAmount,
LaborHours,
DatePosted,
PeriodPosted,
Reference,
Reference2,
ParentWorkOrder,
ParentRelationship,
PMaintCycleSeq,
CallLogNumber,
CallerSeq,
LocationPhone,
LocationDetails,
EnteredBy,
CompletedBy,
RecallCounter,
TripCounter,
InternalDivision,
InternalCostCenter,
InternalZone,
BatchNumber,
UnbatchedEmp,
EmailAddress,
EmailStatus,
AutoUpdateStatus,
TechName,
TechMinutes,
TechHoldMinutes,
TechRequired,
TechReasonNotReq,
TechComplete,
TechNotes_LD,
DateModified,
DateEnteredSite,
DateTargetCloseSite,
DateCompleteSite,
ArrivalSite,
DepartureSite,
SpclHndCode,
FSRTechName,
DateDispatchedSite,
DateFaxedSite,
SiteContactName,
SiteContactPhone,
Source,
Escalation)
VALUES ('" . $WO[$x][0] . "',
'" . $WO[$x][1] . "',
'$WO[$x][2]',
'$WO[$x][3]',
'$WO[$x][4]',
'$WO[$x][5]',
'$WO[$x][6]',
'" . $WO[$x][7] . "',
'" . $WO[$x][8] . "',
'" . $WO[$x][9] . "',
'" . $WO[$x][10] . "',
'" . $WO[$x][11] . "',
'" . $WO[$x][12] . "',
'$WO[$x][13]',
'$WO[$x][14]',
'" . $WO[$x][15] . "',
'" . $WO[$x][16] . "',
'$WO[$x][17]',
'" . $WO[$x][18] . "',
'$WO[$x][19]',
'$WO[$x][20]',
'$WO[$x][21]',
'$WO[$x][22]',
'$WO[$x][23]',
'$WO[$x][24]',
'$WO[$x][25]',
'$WO[$x][26]',
'$WO[$x][27]',
'$WO[$x][28]',
'$WO[$x][29]',
'$WO[$x][30]',
'$WO[$x][31]',
'$WO[$x][32]',
'" . $WO[$x][33] . "',
'$WO[$x][34]',
'$WO[$x][35]',
'$WO[$x][36]',
'" . $WO[$x][37] . "',
'$WO[$x][38]',
'$WO[$x][39]',
'$WO[$x][40]',
'" . $WO[$x][41] . "',
'" . $WO[$x][42] . "',
'" . $WO[$x][43] . "',
'$WO[$x][44]',
'$WO[$x][45]',
'$WO[$x][46]',
'$WO[$x][47]',
'" . $WO[$x][48] . "',
'$WO[$x][49]',
'$WO[$x][50]',
'$WO[$x][51]',
'$WO[$x][52]',
'$WO[$x][53]',
'" . $WO[$x][54] . "',
'" . $WO[$x][55] . "',
'" . $WO[$x][56] . "',
'" . $WO[$x][57] . "',
'$WO[$x][58]',
'$WO[$x][59]',
'$WO[$x][60]',
'" . $WO[$x][61] . "',
'" . $WO[$x][62] . "',
'" . $WO[$x][63] . "',
'" . $WO[$x][64] . "',
'$WO[$x][65]',
'$WO[$x][66]',
'$WO[$x][67]',
'$WO[$x][68]',
'" . $WO[$x][69] . "',
'" . $WO[$x][70] . "',
'$WO[$x][71]',
'" . $WO[$x][72] . "',
'" . $WO[$x][73] . "',
'$WO[$x][74]',
'" . $WO[$x][75] . "',
'$WO[$x][76]',
'$WO[$x][77]',
'$WO[$x][78]',
'" . $WO[$x][79] . "',
'$WO[$x][80]',
'$WO[$x][81]',
'$WO[$x][82]',
'$WO[$x][83]',
'$WO[$x][84]',
'$WO[$x][85]',
'$WO[$x][86]',
'$WO[$x][87]',
'" . $WO[$x][88] . "',
'" . $WO[$x][89] . "',
'$WO[$x][90]',
'$WO[$x][91]',
'" . $WO[$x][92] . "',
'" . $WO[$x][93] . "',
'" . $WO[$x][94] . "',
'" . $WO[$x][95] . "')") OR die(mysql_error());
$t2 = time();
$t3 = $t3 + ($t2 - $t1);
}
echo "Database populated. . .<br /><br /><br />";
echo "Time taken: " . date('i:s', $t3);
. . .