Re: PHP Errors - someone please take a look
| From: | Christopher J. Crane | Date: | Sun, 11 Aug 2002 02:44:41 +0000 |
| Subject: | Re: PHP Errors - someone please take a look | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-111998@lists.php.net to get a copy of this message | ||
I did and got the same error.
"Joni JäRvinen" <joni.jarvinen@kolumbus.fi> wrote in message
news:20020810213339.71176.qmail@pb1.pair.com...
> Hi.
>
> This isn't the most helpful comment but it seems your working on a
> windows-platform.
> Have you tried to use your script in a *nix platform?
>
> -- Joni
> --
> // Joni Järvinen
> // joni.jarvinen@kolumbus.fi
> // http://www.reactorbox.org/~wandu
>
> "Christopher J. Crane" <ccrane@inxdesign.com> wrote in message
> news:20020810133924.55650.qmail@pb1.pair.com...
> > I get the following errors when I run my script. It works fine with only
> 20
> > records, but at 100 I get errors.
> >
> > "PHP has encountered an Access Violation at 00DA088E Warning: Unknown
list
> > entry type in request shutdown (2) in
> > c:\www\htdocs\demos\ct.org\directory.php on line 0"
> >
> > or
> >
> > "PHP has encountered an Access Violation at 00DA088E "
> >
> > Basically, I have a CSV file with about 3500 records (lines). I have a
> while
> > statement that goes through the file line by line. I am using fgetcsv().
> > While on a line I also open another file and search for a matching field
> > (CustomerID) and if it matches print the information on that line unless
a
> > field in that file is set to "1".
> >
> > This was initially tried using a query since this data is in a database.
> > That did not work. I exported the data into csv files. It worked in
> testing
> > limiting the amount of records to be displayed to less than 30. I just
> tried
> > it with limit set to 100 and that's when I got the problem.
> >
> > Here is the code;
> > <?PHP
> > /* INFORMATION:
> > __ __
> > __/_/________________________________________\_\__
> > __|_ _|__
> > (___O) (O___)
> > (_____O) Christopher J. Crane (O_____)
> > (_____O) Web Designer (O_____)
> > (__O) I N X D E S I G N (O__)
> > | http://inxdesign.com |
> > | ccrane@inxdesign.com |
> > | |
> > |__________________________________________________|
> > This script was created to help prepare the directory information, for
the
> > Connecticut Technical Council for the Year 2002.
> >
> > My Material - Please do not copy or modify it with checking with me
first.
> > (ccrane@inxdesign.com)
> > Please leave the INFORMATION banner in place.
> > */
> >
> >
> > file://==Global Definitions
> > file://====================
> > define('SCRIPT_NAME', 'Connecticut Technology Council Directory
> > Maker');
> > define('SCRIPT_VERSION', 'v1.0');
> > define('SCRIPT_CREATOR', '<a
> href="mailto:ccrane@inxdesign.com">Christopher
> > J. Crane</a>');
> > define('CREATE_DATE', '08/06/02');
> > define('REVISED_DATE', '08/06/02');
> >
> >
> > $TestingMode = "On"; file://On or Off
> > $ShowCount = "10";
> >
> > $row = 0;
> > print "<a name\"Top\"></a><b>Company Directory
> > 2002</b><br>";
> > print "T e s t i n g M o d e - ";
> > if($TestingMode == "On") { print "On<br>Only Showing The First
$ShowCount
> > Records.\n"; }
> > else { print "Off\n"; }
> > print "<a href=\"#end\">End</a>";
> > print "<hr align=\"left\" width=\"400\" hieght=1
> > noborder>\n";
> >
> >
> > file://==C o m p a n y D a t a O u t p u t
> > file://=======================================
> > $Data1 = fopen("Final.csv","r");
> > while ($Line1 = fgetcsv($Data1, 1000, ",")) {
> > $CompanyID = $Line1[0]; $CompanyName = $Line1[1]; $MemberTypeID =
> > $Line1[2];
> > $RevenueID = $Line1[3]; $Ownership = $Line1[4]; $NoPubRevenue =
> > $Line1[5];
> > $YearEstablished = $Line1[6]; $Exchange = $Line1[7]; $TotalEmployees
=
> > $Line1[8];
> > $ConnEmployees = $Line1[9]; $Ticker = $Line1[10]; $Email =
$Line1[11];
> > $Website = $Line1[12]; $IndustryID = $Line1[13]; $AddressTypeID =
> > $Line1[14];
> > $AddressLine1 = $Line1[15]; $AddressLine2 = $Line1[16]; $City =
> > $Line1[17];
> > $State = $Line1[18]; $Zip = $Line1[19]; $CountyName = $Line1[20];
> > $Profile = $Line1[21];
> >
> > if($row != 0) {
> > print " <font
> > size=4><b>$CompanyName</b></font><br>\n";
> > if($AddressLine1 != "") { print "$AddressLine1<br>\n"; }
> > if($AddressLine2 != "") { print "$AddressLine2<br>\n"; }
> > print "$City, $State $Zip<br>\n";
> >
> >
> > file://==P h o n e D a t a O u t p u t
> > file://===================================
> > $Data2 = fopen("PhoneTable.csv","r");
> > while ($Line2 = fgetcsv ($Data2, 1000, ",")) {
> > $CompanyID2 = $Line2[0]; $PhoneType = $Line2[1]; $AreaCode =
$Line2[2];
> > $Prefix = $Line2[3]; $Suffix = $Line2[4];
> >
> > if($CompanyID2 == $CompanyID) {
> > if($PhoneType == "Office") {
> > print "<b>Phone:
> > </b>($AreaCode)$Prefix-$Suffix "; }
> > }
> > }
> > fclose($Data2);
> >
> >
> > file://==F a x D a t a O u t p u t
> > file://===================================
> > $Data3 = fopen("PhoneTable.csv","r");
> > while ($Line3 = fgetcsv ($Data3, 1000, ",")) {
> > $CompanyID3 = $Line3[0]; $PhoneType = $Line3[1]; $AreaCode =
$Line3[2];
> > $Prefix = $Line3[3]; $Suffix = $Line3[4];
> >
> > if($CompanyID3 == $CompanyID) {
> > if($PhoneType == "FAX") {
> > print "<b>Fax:
> > </b>($AreaCode)$Prefix-$Suffix "; }
> > }
> > }
> > fclose($Data3);
> > print "<br>";
> >
> >
> > file://==W e b s i t e / E m a i l D a t a O u t p u t
> > file://==================================================
> > if(($Website != "") || ($Email != "none@none.com")) {
> > if($Website != "") { print "<b>Website:
> > </b>$Website<br>\n"; }
> > if($Email != "none@none.com") { print "<b>E-Mail:
> > </b>$Email<br>\n"; }
> > }
> >
> >
> > file://==O w n e r s h i p D a t a O u t p u t
> > file://===========================================
> > print "<b>Ownership: </b>";
> > if($Ownership == "1") { print "Private "; }
> > if($Ownership == "2") {
> > print "Public ";
> > if(!($Exchange == "OTHER" or $Exchange == "")) { print
> > "($Exchange:
> > $Ticker) "; }
> > }
> > if($YearEstablished != "0") { print "<b>Est.
> > </b>$YearEstablished"; }
> > print "<br>";
> >
> >
> > file://==E m p l o y e e D a t a O u t p u t
> > file://=========================================
> > print "<b>CT Emp: </b>";
> > if(($ConnEmployees >= 1) && ($ConnEmployees <= 9)) { print
> > "1-9 "; }
> > elseif(($ConnEmployees >= 10) && ($ConnEmployees <= 50)) { print
> > "10-50 "; }
> > elseif(($ConnEmployees >= 51) && ($ConnEmployees <= 100)) { print
> > "51-100 "; }
> > elseif(($ConnEmployees >= 101) && ($ConnEmployees <= 250)) { print
> > "101-250 "; }
> > elseif(($ConnEmployees >= 251) && ($ConnEmployees <= 500)) { print
> > "251-500 "; }
> > elseif($ConnEmployees >= 501) { print
> > "500+ "; }
> >
> > if(($TotalEmployees >= 1) && ($TotalEmployees <= 50)) { print
> > "<b>Tot
> Emp:
> > </b>1-50"; }
> > elseif(($TotalEmployees >= 51) && ($TotalEmployees <= 100)) { print
> "<b>Tot
> > Emp: </b>51-100"; }
> > elseif(($TotalEmployees >= 101) && ($TotalEmployees <= 500)) { print
> > "<b>Tot Emp: </b>101-500"; }
> > elseif($TotalEmployees >= 501) { print
> > "500+ "; }
> > print "<br>";
> >
> >
> > file://==R e v e n u e D a t a O u t p u t
> > file://=======================================
> > if($NoPubRevenue == 0) {
> > print "<b>Annual Revenue: </b>";
> > if($RevenueID == 1) { print "under 1 Million"; }
> > elseif($RevenueID == 2) { print "under 1 Million"; }
> > elseif($RevenueID == 3) { print "1-10 Million"; }
> > elseif($RevenueID == 4) { print "10-50 Million"; }
> > elseif($RevenueID == 5) { print "50-100 Million"; }
> > elseif($RevenueID == 6) { print "100-500 Million"; }
> > elseif($RevenueID == 7) { print "500 Million - 1 Billion"; }
> > elseif($RevenueID == 8) { print "1+ Billion"; }
> > else { print "NotAvailable"; }
> > print "<br>\n";
> > }
> >
> >
> > file://==I n d u s t r y D a t a O u t p u t
> > file://=======================================
> > print "<b>Industry: </b>";
> > if($IndustryID == 1) { print "Aircraft and Parts"; }
> > elseif($IndustryID == 1) { print "Aircraft and Parts"; }
> > elseif($IndustryID == 3) { print "Electronics and Components"; }
> > elseif($IndustryID == 4) { print "Electrical Equipment"; }
> > elseif($IndustryID == 5) { print "Other"; }
> > elseif($IndustryID == 6) { print "Measuring & Control Devices"; }
> > elseif($IndustryID == 7) { print "Medical Instruments"; }
> > elseif($IndustryID == 11) { print "Photonics/Optics/Imaging"; }
> > elseif($IndustryID == 12) { print "Advanced Materials and Chemicals"; }
> > elseif($IndustryID == 13) { print "Industrial Machinery and
> Appliances"; }
> > elseif($IndustryID == 14) { print "Application Integration &
> Middleware"; }
> > elseif($IndustryID == 15) { print "Application Software Development"; }
> > elseif($IndustryID == 16) { print "Application Service Provider"; }
> > elseif($IndustryID == 17) { print "Collaborative Commerce/Market
> Places"; }
> > elseif($IndustryID == 18) { print "IT Hosting/Infrastructure Mgmt"; }
> > elseif($IndustryID == 19) { print "Computer Office & Equipment"; }
> > elseif($IndustryID == 20) { print "Programming, Custom Dev.,
Professional
> > Services"; }
> > elseif($IndustryID == 22) { print "Multi-media, Online Marketing"; }
> > elseif($IndustryID == 23) { print "Customer Relationship Management"; }
> > elseif($IndustryID == 25) { print "Hardware and Devices"; }
> > elseif($IndustryID == 26) { print "Information Storage, Retrieval,
> > Security"; }
> > elseif($IndustryID == 28) { print "Prepackaged Software"; }
> > elseif($IndustryID == 29) { print "Retail and Information Services"; }
> > elseif($IndustryID == 30) { print "IT Consulting and Systems Design"; }
> > elseif($IndustryID == 31) { print "Safety Products"; }
> > elseif($IndustryID == 32) { print "Web Site Design"; }
> > elseif($IndustryID == 33) { print "Biotechnology"; }
> > elseif($IndustryID == 34) { print "Drugs/Pharmaceutical"; }
> > elseif($IndustryID == 35) { print "Research and Testing"; }
> > elseif($IndustryID == 36) { print "Cable, Communications Equip, Phone
> > Systems"; }
> > elseif($IndustryID == 37) { print "HR, Search, Training"; }
> > elseif($IndustryID == 38) { print "Internet Service Provider"; }
> > elseif($IndustryID == 39) { print "Wireless and Mobile"; }
> > elseif($IndustryID == 40) { print "Communications Services"; }
> > elseif($IndustryID == 41) { print "Business/Strategy Consulting"; }
> > elseif($IndustryID == 42) { print "Legal"; }
> > elseif($IndustryID == 43) { print "PR/Marketing"; }
> > elseif($IndustryID == 44) { print "Finance and Accounting"; }
> > elseif($IndustryID == 45) { print "Financial Services"; }
> > elseif($IndustryID == 46) { print "NFP, Association, State Agency"; }
> > elseif($IndustryID == 47) { print "Engineering Services"; }
> > elseif($IndustryID == 48) { print "Academic"; }
> > elseif($IndustryID == 49) { print "Energy"; }
> > print "<br>\n";
> >
> >
> > file://==C o n t a c t D a t a O u t p u t
> > file://=======================================
> > print "<b>Management:</b><br>\n";
> > $Data4 = fopen("CompleteContact.csv","r");
> > while ($Line4 = fgetcsv ($Data4, 1000, ",")) {
> > $CompanyID4 = $Line4[0]; $FirstName = $Line4[1]; $LastName =
$Line4[2];
> > $DisplayTitle = $Line4[3]; $NoPubcontact = $Line4[4];
> >
> > if($CompanyID4 == $CompanyID) {
> > if($NoPubcontact == "0") { print "$FirstName $LastName,
> > <i>$DisplayTitle</i><br>\n"; }
> > }
> > }
> > fclose($Data4);
> >
> >
> > file://==P r o f i l e D a t a O u t p u t
> > file://=======================================
> > if($row != 0) {
> > if($Profile != "") { print
> > "<b>Profile:</b><br>$Profile<br>\n"; }
> > }
> >
> >
> > file://==End of Loop!
> > file://=======================================
> > }
> >
> >
> > $row++;
> > print "<br>\n";
> > if($TestingMode == "On") { if($row == $ShowCount) { break; } }
> >
> > }
> > fclose($Data1);
> >
> > print "<pre>
> > ===============
> > ---- Done! ----
> > ===============
> > </pre>
> > <b>Script Name:</b> " . SCRIPT_NAME . " " .
> > SCRIPT_VERSION .
"<br>\n
> > <b>Script Created By:</b> " . SCRIPT_CREATOR . "<br>\n
> > <b>Created On:</b> " . CREATE_DATE . "<br>\n
> > <b>Revised On:</b> " . REVISED_DATE . "\n";
> >
> > print "<pre>
> > __ __
> > __/_/________________________________________\_\__
> > __|_ _|__
> > (___O) (O___)
> > (_____O) Christopher J. Crane (O_____)
> > (_____O) Web Designer (O_____)
> > (__O) I N X D E S I G N (O__)
> > | http://inxdesign.com |
> > | ccrane@inxdesign.com |
> > | |
> > |__________________________________________________|
> > </pre><a name=\"End\"></a><a
> > href=\"#Top\">Top</a>\n\n";
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
>