Hello all,
I just found out that my script has a issue where it still runs even if the count is < or = to the result_c it keeps on displaying as if its processing.
my code is:
<?php
ini_set('display_errors', 'ON');
ini_set('error_reporting', E_ALL | E_STRICT );
include '/home/dev/www/lib/db_config_cr-dev.php';
include '/home/dev/www/lib/db_conn-select.php';
// Counts record in table
$query_s = "SELECT COUNT(*) FROM irs_rawdata";
$result_s = mysql_query($query_s) OR die("Sorry, unable to count the records in the table!");
$result_c = mysql_result($result_s, 0);
$record_count = $result_c;
echo "There is ". $record_count ." records in the irs_rawdata table<br /><br />";
$result_c = 810; // block when sript is done
// checks to see if sesult_c is greater then zero
// if so then it runs script
// otherwise it says there is no more records to process
for($i=0; $i <= $result_c; $i++)
{
//used to display a real number instead of 0
$record_id = $i + 1;
// selects and limits it to the first row only and retrives the EIN then return a 1 or 0
echo "We are now geting a record to process!<br />";
$query_s = "SELECT EIN FROM irs_rawdata LIMIT 0,1";
$result_s = mysql_query($query_s) OR die("Sorry, unable to to select EIN for the first record! <br /> ". mysql_error());
$record = mysql_fetch_assoc($result_s);
$count = mysql_num_rows($result_s);
if($count)
{
// changes long var to short var
$fin = $record['EIN'];
// gets record if there is one in block returns 1 or 0
echo "We are now processing record ". $record_id. " with Fed ID #". $fin ."!<br />";
$query_s = "SELECT fin FROM block WHERE fin = '$fin'";
$result_s = mysql_query($query_s) OR die("Sorry, unable to select record: " . mysql_error());
$record = mysql_fetch_assoc($result_s);
$count = mysql_num_rows($result_s);
if ($count == 0)
{
echo "There was no record found in the \"block\" table!<br />";
echo "We are now checking the \"allow\" table!<br />";
$query_s = "SELECT fin FROM allow WHERE fin = '$fin'";
$result_s = mysql_query($query_s) OR die("Sorry, unable to select record: " . mysql_error());
$record = mysql_fetch_assoc($result_s);
$count = mysql_num_rows($result_s);
if ($count == 0)
{
echo "There was no record found in the \"allow\" table!<br />";
echo "We are now checking if record ". $record_id ." matchs the required criteria!<br />";
$query_is = "INSERT INTO irs_query SELECT * FROM irs_rawdata WHERE EIN = '$fin' AND PNO LIKE '%blind%'";
$result_is = mysql_query($query_is);
$count = mysql_affected_rows();
if ($count)
{
echo "We have successfully added the record to the \"irs_query\" table, it match the criteria!<br />";
echo "We are now deleting record ". $record_id . " from \"irs_rawdata\" table!<br />";
$query_d = "DELETE FROM irs_rawdata WHERE EIN = '$fin'";
$result_d = mysql_query($query_d) OR die("Was unable delete ". $fin ." from the db table irs_rawdata! <br />" . mysql_error());
$count = mysql_affected_rows();
if($count)
{
echo "We have successfully deleted the record from the \"irs_rawdata\" table!<br /><br />";
}
}
else
{
echo "We was unable to match the record ". $record_id ." to the criteria!<br />";
echo "We are now adding record ". $record_id . " to \"block\" table!<br />";
$query_i = "INSERT INTO block (fin, who_blocked) VALUES ('$fin', 'S-123456789')";
$result_i = mysql_query($query_i) OR die("Sorry was unable to insert ".$fin." into the database table allowed! <br />" . mysql_error());
$count = mysql_affected_rows();
if($count)
{
echo "We have successfully added the record to the \"block\" table!<br />";
echo "We are now deleting record ". $record_id . " from \"irs_rawdata\" table!<br />";
$query_d = "DELETE FROM irs_rawdata WHERE EIN ='$fin'";
$result_d = mysql_query($query_d) OR die("Was unable to delete ".$fin." from the db table irs_rawdata! <br />" . mysql_error());
$count = mysql_affected_rows();
if($count)
{
echo "We have successfully deleted the record from the \"irs_rawdata\" table!<br /><br />";
}
}
}
}
else
{
$query_is = "INSERT INTO irs_query SELECT * FROM irs_rawdata WHERE EIN = '$fin'";
$result_is = mysql_query($query_is);
$count = mysql_affected_rows();
if ($count)
{
echo "We was sucessfully added / replaced the record in \"irs_query\" table!<br />";
echo "We are now deleting record ". $record_id . " from \"irs_rawdata\" table!<br />";
$count = mysql_affected_rows();
$count = 1;
if($count == 1)
{
echo "We have successfully deleted the record from the \"irs_rawdata\" table!<br /><br />";
}
}
}
}
else
{
echo "There was one record found in the \"block\" table!<br />";
echo "We are now deleting record ". $record_id . " from \"irs_rawdata\" table!<br />";
$query_d = "DELETE FROM irs_rawdata WHERE EIN = '$fin'";
$result_d = mysql_query($query_d) OR die("Was unable delete ".$fin." from the db table irs_rawdata! <br />" . mysql_error());
$count = mysql_affected_rows();
if($count)
{
echo "We have successfully deleted the record from the \"irs_rawdata\" table!<br /><br />";
}
}
}
else
{
echo "There is no records in the table!";
}
endfor;
}
echo "The computer has finished processing the records in irs_rawdata!";
include_once ('/home/dev/www/lib/db_close.php');
?>
