Hello All,
My script after a week now is done, I have been at it for hours on end every day and I can say it works it works :-) now I know there can be improvements in the code and maybe a function or two could be used, but I don't know much and this is what I was able to do to get my script to work. I used a lots of if() statements in it
I am hoping someone can help me write this code better so it can do the job and not kill the server as it does if I set the var (result_c) to more then 813 now I know this will be better with better code and changes made to the server also maybe.
Any how the filter does exactly that filters data from a table called irs_rawdata it checks to see if its in two different tables if its not in either one then it checks to see if it matches some rules if it does it adds it if it finds a match in allow table then it adds it also to the irs_query table, any how the code kind of tell you whats going on by my echo
Any advice on this script would be grateful.
Sincerely,
Christopher
PS: Would it be hard to convert this to a mysql stored process? if not could you recommend a good reading site (www).
<?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 = 850; // 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 />";
$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();
$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 ". $i . " 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!";
}
}
echo "The computer has finished processing the records in irs_rawdata!";
include_once ('/home/dev/www/lib/db_close.php');
?>
