Writing To multiple databases within a php script

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
mattbranch12
Forum Newbie
Posts: 18
Joined: Thu Jul 09, 2009 3:14 pm
Location: Hagerstown, MD

Writing To multiple databases within a php script

Post by mattbranch12 »

What I am trying to do is write a script that will sync two databases on two different servers. One being the local machine another being remote. The script is able to determine fine if the row needs to be add or updated my issues is actually writing to the databases. For what ever reason It will not write to a database.

Code: Select all

<?php

$handle_db1 = mysql_connect("localhost:XXXX","user","somepass");
$handle_db2 = mysql_connect("somesite.com:XXXX","user","somepass",true);

// give each handle it's own database to work with, permanently.
mysql_select_db("ddsl",$handle_db1);
mysql_select_db("dds",$handle_db2);

//Create timestamp
$ts=date("Y-m-d : H:i:s", time()); 

//Get sync table data from local machine
$query = "select * from sync"; $which = $handle_db1;
$sql=mysql_query($query,$which);
while($sync=mysql_fetch_array($sql))
{
$lab_quality_localts=$sync['lab_quality_localts'];
$dairy_master_localts=$sync['dairy_master_localts'];
$dairy_insp_localts=$sync['dairy_insp_localts'];
$lab_quality_serverts=$sync['lab_quality_serverts'];
$dairy_master_serverts=$sync['dairy_master_serverts'];
$dairy_insp_serverts=$sync['dairy_insp_serverts'];
}

//Dairy_Master Upload
$query="select * from dairy_master where serverts>'".$dairy_master_serverts."' or serverts='0000-00-00 00:00:00'"; $which=$handle_db1;
$sql=mysql_query($query,$which);
$adddm=0;
$updatedm=0;
while($row=mysql_fetch_array($sql))
{
	$query1="select * from dairy_master where serverts<='".$dairy_master_serverts."' and id='".$row['id']."' and farm_id='".$row['farm_id']."'";  $which1=$handle_db2;
	$row1=mysql_query($query1,$which1);
	
	if(mysql_fetch_row($row1)==0)
	{
		
		$adddm++;
		$query2="insert into dairy_master values (".$row['edit_date'].", ".$row['farm_id'].", ".$row['farm_name'].", ".$row['address_1 '].", ".$row['address_2'].", ".$row['city'].", ".$row['state'].", ".$row['zip'].", ".$row['plus4'].", ".$row['township'].", ".$row['county'].", ".$row['primary_contact'].", ".$row['phone_direct'].", ".$row['premise_number'].", ".$row['rBST_free'].", ".$row['rBST_expire'].", ".$row['cow_number'].", ".$row['milking_number'].", ".$row['brucellosis_type'].", ".$row['tuberculosis_type'].", ".$row['watertest_current'].", ".$row['watertest_cur_result'].", ".$row['watertest_previous'].", ".$row['water_source'].", ".$row['field_rep'].", ".$row['field_rep_name'].", ".$row['sanitarian'].", ".$row['hauler'].", ".$row['del_site'].", ".$row['handler'].", ".$row['test_card'].", ".$row['vote_privilege'].", ".$row['meeting_notice'].", ".$row['phone_pin'].", ".$row['phone_pass'].", ".$row['daily_prod'].", ".$row['btu'].", ".$row['active'].", ".$row['grazing'].", ".$row['timestamp'].", ".$row['primary_contact_title'].", ".$row['primary_contact_email'].", ".$row['localts'].")";
		$which1=$handle_db2;
		mysql_query($query2, $which1);
	}
	else
	{		
		$query2="update dairy_master set edit_date='".$row['edit_date']."', farm_id='".$row['farm_id']."', farm_name='".$row['farm_name']."', address_1='".$row['address_1']."', address_2='".$row['address_2']."', city='".$row['city']."', state='".$row['state']."', zip='".$row['zip']."', plus4='".$row['plus4']."', township='".$row['township']."', county='".$row['county']."', primary_contact='".$row['primary_contact']."', phone_direct='".$row['phone_direct']."', premise_number='".$row['premise_number']."', rBST_free='".$row['rBST_free']."', rBST_expire='".$row['rBST_expire']."', cow_number='".$row['cow_number']."', milking_number='".$row['milking_number']."', brucellosis_type='".$row['brucellosis_type']."', tuberculosis_type='".$row['tuberculosis_type']."', watertest_current='".$row['watertest_current']."', watertest_cur_result='".$row['watertest_cur_result']."', watertest_previous='".$row['watertest_previous']."', water_source='".$row['water_source']."', field_rep='".$row['field_rep']."', field_rep_name='".$row['field_rep_name']."', sanitarian='".$row['sanitarian']."', hauler='".$row['hauler']."', del_site='".$row['del_site']."', handler='".$row['handler']."', test_card='".$row['test_card']."', vote_privilege='".$row['vote_privilege']."', meeting_notice='".$row['meeting_notice']."', phone_pin='".$row['phone_pin']."', phone_pass='".$row['phone_pass']."', daily_prod='".$row['daily_prod']."', btu='".$row['btu']."', active='".$row['active']."', grazing='".$row['grazing']."', timestamp='".$row['timestamp']."', primary_contact_title='".$row['primary_contact_title']."', primary_contact_email='".$row['primary_contact_email']."', localts='".$row['localts']."', where id='".$row['id']."' and farm_id='".$row['farm_id']."'";
		$which1=$handle_db2;
		mysql_query($query2, $which1);
		$updatedm++;
		
	}
	mysql_free_result(mysql_query($query1,$which1));
}

//Dairy Insp Upload

$query="select * from dairy_insp where serverts>'".$dairy_insp_serverts."' or serverts='0000-00-00 00:00:00'"; $which=$handle_db1;
$sql=mysql_query($query,$which);
$adddi=0;
$updatedi=0;
while($row=mysql_fetch_array($sql))
{
	$query1="select * from dairy_insp where serverts<='".$dairy_insp_serverts."' and id='".$row['id']."' and farm_id='".$row['farm_id']."'";  $which1=$handle_db2;
	$row1=mysql_query($query1,$which1);
	$test=$row['id'];
	if(mysql_fetch_row($row1)==0)
	{
		$query2="insert into dairy_insp values ( ".$row['id'].", ".$row['premise_number'].", ".$row['farm_id'].", ".$row['address_1'].", ".$row['address_2'].", ".$row['city'].", ".$row['state'].", ".$row['zip'].", ".$row['plus4'].", ".$row['township'].", ".$row['county'].", ".$row['phone'].", ".$row['cow_number'].", ".$row['milking_number'].", ".$row['date'].", ".$row['time'].", ".$row['production'].", ".$row['milk_now'].", ".$row['brucellosis_type'].", ".$row['brucellosis_date'].", ".$row['insp_type'].", ".$row['tuberculosis_type'].", ".$row['tuberculosis_date'].", ".$row['buyer'].", ".$row['buyer_btu'].", ".$row['watertest_previous'].", ".$row['watertest_current'].", ".$row['watertest_cur_result'].", ".$row['water_source'].", ".$row['agent'].", ".$row['field_rep'].", ".$row['field_rep_name'].", ".$row['reinspect_days'].", ".$row['q1a'].", ".$row['q1b'].", ".$row['q1c'].", ".$row['q2a'].", ".$row['q2b'].", ".$row['q2c'].", ".$row['q2d'].", ".$row['q2e'].", ".$row['q3a'].", ".$row['q3b'].", ".$row['q3c'].", ".$row['q4a'].", ".$row['q4b'].", ".$row['q4c'].", ".$row['q4d'].", ".$row['q5floors_a'].", ".$row['q5floors_b'].", ".$row['q5floors_c'].", ".$row['q5walls_a'].", ".$row['q5walls_b'].", ".$row['q5lights_a'].", ".$row['q5lights_b'].", ".$row['q5lights_c'].", ".$row['q5lights_d'].", ".$row['q5misc_b'].", ".$row['q5misc_c'].", ".$row['q5misc_d'].", ".$row['q5misc_e'].", ".$row['q5misc_f'].", ".$row['q5clean_a'].", ".$row['q5clean_b'].", ".$row['q5clean_c'].", ".$row['q6a'].", ".$row['q6b'].", ".$row['q7a'].", ".$row['q7b'].", ".$row['q7c'].", ".$row['q7d'].", ".$row['q8a'].", ".$row['q8b'].", ".$row['q8c'].", ".$row['q9a'].", ".$row['q9b'].", ".$row['q9c'].", ".$row['q9d'].", ".$row['q9e'].", ".$row['p10a'].", ".$row['p11a'].", ".$row['p12a'].", ".$row['p12b'].", ".$row['p12c'].", ".$row['q13a'].", ".$row['q13b'].", ".$row['q13c'].", ".$row['q13d'].", ".$row['q13e'].", ".$row['q14a'].", ".$row['q14b'].", ".$row['q14c'].", ".$row['q14d'].", ".$row['q14e'].", ".$row['q14f'].", ".$row['q14g'].", ".$row['q15a'].", ".$row['q15b'].", ".$row['q15c'].", ".$row['q15d'].", ".$row['q15e'].", ".$row['q16a'].", ".$row['q16b'].", ".$row['q17a'].", ".$row['q17b'].", ".$row['q18a'].", ".$row['q18b'].", ".$row['q19a'].", ".$row['q19b'].", ".$row['q19c'].", ".$row['q19d'].", ".$row['q19e'].", ".$row['q19f'].", ".$row['q19g'].", ".$row['q19h'].", ".$row['blog_1'].", ".$row['blog_2'].", ".$row['blog_3'].", ".$row['blog_4'].", ".$row['blog_5'].", ".$row['blog_6'].", ".$row['blog_7'].", ".$row['blog_8'].", ".$row['blog_9'].", ".$row['blog_10'].", ".$row['highlight_blog_1'].", ".$row['highlight_blog_2'].", ".$row['highlight_blog_3'].", ".$row['highlight_blog_4'].", ".$row['highlight_blog_5'].", ".$row['highlight_blog_6'].", ".$row['highlight_blog_7'].", ".$row['highlight_blog_8'].", ".$row['highlight_blog_9'].", ".$row['highlight_blog_10'].", ".$row['insp_result'].", ".$row['temp_milk_tank'].", ".$row['temp_hot_water'].", ".$row['hauler'].", ".$row['last_scc'].", ".$row['last_antibiotic'].", ".$row['insp_status'].", ".$row['scoring'].", ".$row['grade'].", ".$row['results'].", ".$row['timestamp'].", ".$row['active'].", ".$row['localts'].", ".$row['serverts'].",)";
		$which1=$handle_db2;
		mysql_query($query2,$which1);
		$adddi++;
	}
	else
	{
				$query2="update dairy_insp set id='".$row['id']."', premise_number='".$row['premise_number']."', farm_id='".$row['farm_id']."', address_1='".$row['address_1']."', address_2='".$row['address_2']."', city='".$row['city']."', state='".$row['state']."', zip='".$row['zip']."', plus4='".$row['plus4']."', township='".$row['township']."', county='".$row['county']."', phone='".$row['phone']."', cow_number='".$row['cow_number']."', milking_number='".$row['milking_number']."', date='".$row['date']."', time='".$row['time']."', production='".$row['production']."', milk_now='".$row['milk_now']."', brucellosis_type='".$row['brucellosis_type']."', brucellosi_date='".$row['brucellosis_date']."', insp_type='".$row['insp_type']."', tuberculosis_type='".$row['tuberculosis_type']."', tuberculosis_date='".$row['tuberculosis_date']."', buyer='".$row['buyer']."', buyer_btu='".$row['buyer_btu']."', watertest_previous='".$row['watertest_previous']."', watertest_current='".$row['watertest_current']."', watertest_cur_result='".$row['watertest_cur_result']."', water_source='".$row['water_source']."', agent='".$row['agent']."', field_rep='".$row['field_rep']."', field_rep_name='".$row['field_rep_name']."', reinspect_days='".$row['reinspect_days']."', q1a='".$row['q1a']."', q1b='".$row['q1b']."', q1c='".$row['q1c']."', q2a='".$row['q2a']."', q2b='".$row['q2b']."', q2c='".$row['q2c']."', q2d='".$row['q2d']."', q2e='".$row['q2e']."', q3a='".$row['q3a']."', q3b='".$row['q3b']."', q3c='".$row['q3c']."', q4a='".$row['q4a']."', q4b='".$row['q4b']."', q4c='".$row['q4c']."', q4d='".$row['q4d']."', q5floors_a='".$row['q5floors_a']."', q5floors_b='".$row['q5floors_b']."', q5floors_c='".$row['q5floors_c']."', q5walls_a='".$row['q5walls_a']."', q5walls_b='".$row['q5walls_b']."', q5lights_a='".$row['q5lights_a']."', q5lights_b='".$row['q5lights_b']."', q5lights_c='".$row['q5lights_c']."', q5lights_d='".$row['q5lights_d']."', q5misc_b='".$row['q5misc_b']."', q5misc_c='".$row['q5misc_c']."', q5misc_d='".$row['q5misc_d']."', q5misc_e='".$row['q5misc_e']."', q5misc_f='".$row['q5misc_f']."', q5clean_a='".$row['q5clean_a']."', q5clean_b='".$row['q5clean_b']."', q5clean_c='".$row['q5clean_c']."', q6a='".$row['q6a']."', q6b='".$row['q6b']."', q7a='".$row['q7a']."', q7b='".$row['q7b']."', q7c='".$row['q7c']."', q7d='".$row['q7d']."', q8a='".$row['q8a']."', q8b='".$row['q8b']."', q8c='".$row['q8c']."', q9a='".$row['q9a']."', q9b='".$row['q9b']."', q9c='".$row['q9c']."', q9d='".$row['q9d']."', p9e='".$row['q9e']."', p10a='".$row['p10a']."', p11a='".$row['p11a']."', p12a='".$row['p12a']."', p12b='".$row['p12b']."', p12c='".$row['p12c']."', q13a='".$row['q13a']."', q13b='".$row['q13b']."', q13c='".$row['q13c']."', q13d='".$row['q13d']."', q13e='".$row['q13e']."', q14a='".$row['q14a']."', q14b='".$row['q14b']."', q14c='".$row['q14c']."', q14d='".$row['q14d']."', q14e='".$row['q14e']."', q14f='".$row['q14f']."', q14g='".$row['q14g']."', q15a='".$row['q15a']."', q15b='".$row['q15b']."', q15c='".$row['q15c']."', q15d='".$row['q15d']."', q15e='".$row['q15e']."', q16a='".$row['q16a']."', q16b='".$row['q16b']."', q17a='".$row['q17a']."', q17b='".$row['q17b']."', q18a='".$row['q18a']."', q18b='".$row['q18b']."', q19a='".$row['q19a']."', q19b='".$row['q19b']."', q19c='".$row['q19c']."', q19d='".$row['q19d']."', q19e='".$row['q19e']."', q19f='".$row['q19f']."', q19g='".$row['q19g']."', q19h='".$row['q19h']."', blog_1='".$row['blog_1']."', blog_2='".$row['blog_2']."', blog_3='".$row['blog_3']."', blog_4='".$row['blog_4']."', blog_5='".$row['blog_5']."', blog_6='".$row['blog_6']."', blog_7='".$row['blog_7']."', blog_8='".$row['blog_8']."', blog_9='".$row['blog_9']."', blog_10='".$row['blog_10']."', highlight_blog_1='".$row['highlight_blog_1']."', highlight_blog_2='".$row['highlight_blog_2']."', highlight_blog_3='".$row['highlight_blog_3']."', highlight_blog_4='".$row['highlight_blog_4']."', highlight_blog_5='".$row['highlight_blog_5']."', highlight_blog_6='".$row['highlight_blog_6']."', highlight_blog_7='".$row['highlight_blog_7']."', highlight_blog_8='".$row['highlight_blog_8']."', highlight_blog_9='".$row['highlight_blog_9']."', highlight_blog_10='".$row['highlight_blog_10']."', insp_result='".$row['insp_result']."', temp_milk_tank='".$row['temp_milk_tank']."', temp_hot_water='".$row['temp_hot_water']."', hauler='".$row['hauler']."', last_scc='".$row['last_scc']."', last_antibiotic='".$row['last_antibiotic']."', insp_status='".$row['insp_status']."', scoring='".$row['scoring']."', grade='".$row['grade']."', results='".$row['results']."', timestamp='".$row['timestamp']."', active='".$row['active']."', localts='".$row['localts']."', serverts='".$row['serverts']."' where id='".$row['id']."' and farm_id='".$row['farm_id']."'";
		$which1=$handle_db2;
		mysql_query();
		$updatedm++;
	}
	mysql_free_result(mysql_query($query1,$which1));
}

//Dairy Master Download
$query="select * from dairy_master where serverts>'".$dairy_master_serverts."' or serverts='0000-00-00 00:00:00'"; $which=$handle_db2;
$sql=mysql_query($query,$which);
$adddmd=0;
$updatedmd=0;
while($row=mysql_fetch_array($sql))
{
	$query1="select * from dairy_master where serverts<='".$dairy_master_serverts."' and id='".$row['id']."' and farm_id='".$row['farm_id']."'";  $which1=$handle_db1;
	$row1=mysql_query($query1,$which1);
	if(mysql_fetch_row($row1)==0)
	{
		$query2="insert into dairy_master values (".$row['edit_date'].", ".$row['farm_id'].", ".$row['farm_name'].", ".$row['address_1 '].", ".$row['address_2'].", ".$row['city'].", ".$row['state'].", ".$row['zip'].", ".$row['plus4'].", ".$row['township'].", ".$row['county'].", ".$row['primary_contact'].", ".$row['phone_direct'].", ".$row['premise_number'].", ".$row['rBST_free'].", ".$row['rBST_expire'].", ".$row['cow_number'].", ".$row['milking_number'].", ".$row['brucellosis_type'].", ".$row['tuberculosis_type'].", ".$row['watertest_current'].", ".$row['watertest_cur_result'].", ".$row['watertest_previous'].", ".$row['water_source'].", ".$row['field_rep'].", ".$row['field_rep_name'].", ".$row['sanitarian'].", ".$row['hauler'].", ".$row['del_site'].", ".$row['handler'].", ".$row['test_card'].", ".$row['vote_privilege'].", ".$row['meeting_notice'].", ".$row['phone_pin'].", ".$row['phone_pass'].", ".$row['daily_prod'].", ".$row['btu'].", ".$row['active'].", ".$row['grazing'].", ".$row['timestamp'].", ".$row['primary_contact_title'].", ".$row['primary_contact_email'].", ".$row['localts'].")";
		$which1=$handle_db1;
		mysql_query($query2,$which1);
	}
	else
	{
		$query2="update dairy_master set edit_date='".$row['edit_date']."', farm_id='".$row['farm_id']."', farm_name='".$row['farm_name']."', address_1='".$row['address_1']."', address_2='".$row['address_2']."', city='".$row['city']."', state='".$row['state']."', zip='".$row['zip']."', plus4='".$row['plus4']."', township='".$row['township']."', county='".$row['county']."', primary_contact='".$row['primary_contact']."', phone_direct='".$row['phone_direct']."', premisenumber='".$row['premise_number']."', rBST_free='".$row['rBST_free']."', rBST_expire='".$row['rBST_expire']."', cow_number='".$row['cow_number']."', milking_number='".$row['milking_number']."', brucellosis_type='".$row['brucellosis_type']."', tuberculosis_type='".$row['tuberculosis_type']."', watertest_current='".$row['watertest_current']."', watertest_cur_result='".$row['watertest_cur_result']."', watertest_previous='".$row['watertest_previous']."', water_source='".$row['water_source']."', field_rep='".$row['field_rep']."', field_rep_name='".$row['field_rep_name']."', sanitarian='".$row['sanitarian']."', hauler='".$row['hauler']."', del_site='".$row['del_site']."', handler='".$row['handler']."', test_card='".$row['test_card']."', vote_privilege='".$row['vote_privilege']."', meeting_notice='".$row['meeting_notice']."', phone_pin='".$row['phone_pin']."', phone_pass='".$row['phone_pass']."', daily_prod='".$row['daily_prod']."', btu='".$row['btu']."', active='".$row['active']."', grazing='".$row['grazing']."', timestamp='".$row['timestamp']."', primary_contact_title='".$row['primary_contact_title']."', primary_contact_email='".$row['primary_contact_email']."', localts='".$row['localts']."', where id='".$row['id']."' and farm_id='".$row['farm_id']."'";
		$which1=$handle_db1;
		mysql_query($query2, $which1);
		$updatedmd++;
	}
	mysql_free_result(mysql_query($query1,$which1));
}

//Dairy Insp Download

$query="select * from dairy_insp where serverts>'".$dairy_insp_serverts."' or serverts='0000-00-00 00:00:00'"; $which=$handle_db2;
$sql=mysql_query($query,$which);
$adddid=0;
$updatedid=0;
while($row=mysql_fetch_array($sql))
{
	$query1="select * from dairy_insp where serverts<='".$dairy_insp_serverts."' and id='".$row['id']."' and farm_id='".$row['farm_id']."'";  $which1=$handle_db1;
	$row1=mysql_query($query1,$which1);
	if(mysql_fetch_row($row1)==0)
	{
				$query2="insert into dairy_insp values ( ".$row['id'].", ".$row['premise_numb'].", ".$row['farm_id'].", ".$row['address_1'].", ".$row['address_2'].", ".$row['city'].", ".$row['state'].", ".$row['zip'].", ".$row['plus4'].", ".$row['township'].", ".$row['county'].", ".$row['phone'].", ".$row['cow_number'].", ".$row['milking_number'].", ".$row['date'].", ".$row['time'].", ".$row['production'].", ".$row['milk_now'].", ".$row['brucellosis_type'].", ".$row['brucellosis_date'].", ".$row['insp_type'].", ".$row['tuberculosis_type'].", ".$row['tuberculosis_date'].", ".$row['buyer'].", ".$row['buyer_btu'].", ".$row['watertest_previous'].", ".$row['watertest_current'].", ".$row['watertest_cur_result'].", ".$row['water_source agent'].", ".$row['field_rep'].", ".$row['field_rep_name'].", ".$row['reinspect_days'].", ".$row['q1a'].", ".$row['q1b'].", ".$row['q1c'].", ".$row['q2a'].", ".$row['q2b'].", ".$row['q2c'].", ".$row['q2d'].", ".$row['q2e'].", ".$row['q3a'].", ".$row['q3b'].", ".$row['q3c'].", ".$row['q4a'].", ".$row['q4b'].", ".$row['q4c'].", ".$row['q4d'].", ".$row['q5floors_a'].", ".$row['q5floors_b'].", ".$row['q5floors_c'].", ".$row['q5walls_a'].", ".$row['q5walls_b'].", ".$row['q5lights_a'].", ".$row['q5lights_b'].", ".$row['q5lights_c'].", ".$row['q5lights_d'].", ".$row['q5misc_b'].", ".$row['q5misc_c'].", ".$row['q5misc_d'].", ".$row['q5misc_e'].", ".$row['q5misc_f'].", ".$row['q5clean_a'].", ".$row['q5clean_b'].", ".$row['q5clean_c'].", ".$row['q6a'].", ".$row['q6b'].", ".$row['q7a'].", ".$row['q7b'].", ".$row['q7c'].", ".$row['q7d'].", ".$row['q8a'].", ".$row['q8b'].", ".$row['q8c'].", ".$row['q9a'].", ".$row['q9b'].", ".$row['q9c'].", ".$row['q9d'].", ".$row['q9e'].", ".$row['p10a'].", ".$row['p11a'].", ".$row['p12a'].", ".$row['p12b'].", ".$row['p12c'].", ".$row['q13a'].", ".$row['q13b'].", ".$row['q13c'].", ".$row['q13d'].", ".$row['q13e'].", ".$row['q14a'].", ".$row['q14b'].", ".$row['q14c'].", ".$row['q14d'].", ".$row['q14e'].", ".$row['q14f'].", ".$row['q14g'].", ".$row['q15a'].", ".$row['q15b'].", ".$row['q15c'].", ".$row['q15d'].", ".$row['q15e'].", ".$row['q16a'].", ".$row['q16b'].", ".$row['q17a'].", ".$row['q17b'].", ".$row['q18a'].", ".$row['q18b'].", ".$row['q19a'].", ".$row['q19b'].", ".$row['q19c'].", ".$row['q19d'].", ".$row['q19e'].", ".$row['q19f'].", ".$row['q19g'].", ".$row['q19h'].", ".$row['blog_1'].", ".$row['blog_2'].", ".$row['blog_3'].", ".$row['blog_4'].", ".$row['blog_5'].", ".$row['blog_6'].", ".$row['blog_7'].", ".$row['blog_8'].", ".$row['blog_9'].", ".$row['blog_10'].", ".$row['highlight_blog_1'].", ".$row['highlight_blog_2'].", ".$row['highlight_blog_3'].", ".$row['highlight_blog_4'].", ".$row['highlight_blog_5'].", ".$row['highlight_blog_6'].", ".$row['highlight_blog_7'].", ".$row['highlight_blog_8'].", ".$row['highlight_blog_9'].", ".$row['highlight_blog_10'].", ".$row['insp_result'].", ".$row['temp_milk_tank'].", ".$row['temp_hot_water'].", ".$row['hauler'].", ".$row['last_scc'].", ".$row['last_antibiotic'].", ".$row['insp_status'].", ".$row['scoring'].", ".$row['grade'].", ".$row['results'].", ".$row['timestamp'].", ".$row['active'].", ".$row['localts'].", ".$row['serverts'].")";
		$which1=$handle_db1;
		mysql_query($query2,$which1);
	}
	else
	{
		$query2="update dairy_insp set id='".$row['id']."', premise_number='".$row['premise_number']."', farm_id='".$row['farm_id']."', address_1='".$row['address_1']."', address_2='".$row['address_2']."', city='".$row['city']."', state='".$row['state']."', zip='".$row['zip']."', plus4='".$row['plus4']."', township='".$row['township']."', county='".$row['county']."', phone='".$row['phone']."', cow_number='".$row['cow_number']."', milking_number='".$row['milking_number']."', date='".$row['date']."', time='".$row['time']."', production='".$row['production']."', milk_now='".$row['milk_now']."', brucellosis_type='".$row['brucellosis_type']."', brucellosi_date='".$row['brucellosis_date']."', insp_type='".$row['insp_type']."', tuberculosis_type='".$row['tuberculosis_type']."', tuberculosis_date='".$row['tuberculosis_date']."', buyer='".$row['buyer']."', buyer_btu='".$row['buyer_btu']."', watertest_previous='".$row['watertest_previous']."', watertest_current='".$row['watertest_current']."', watertest_cur_result='".$row['watertest_cur_result']."', water_source='".$row['water_source']."', agent='".$row['agent']."', field_rep='".$row['field_rep']."', field_rep_name='".$row['field_rep_name']."', reinspect_days='".$row['reinspect_days']."', q1a='".$row['q1a']."', q1b='".$row['q1b']."', q1c='".$row['q1c']."', q2a='".$row['q2a']."', q2b='".$row['q2b']."', q2c='".$row['q2c']."', q2d='".$row['q2d']."', q2e='".$row['q2e']."', q3a='".$row['q3a']."', q3b='".$row['q3b']."', q3c='".$row['q3c']."', q4a='".$row['q4a']."', q4b='".$row['q4b']."', q4c='".$row['q4c']."', q4d='".$row['q4d']."', q5floors_a='".$row['q5floors_a']."', q5floors_b='".$row['q5floors_b']."', q5floors_c='".$row['q5floors_c']."', q5walls_a='".$row['q5walls_a']."', q5walls_b='".$row['q5walls_b']."', q5lights_a='".$row['q5lights_a']."', q5lights_b='".$row['q5lights_b']."', q5lights_c='".$row['q5lights_c']."', q5lights_d='".$row['q5lights_d']."', q5misc_b='".$row['q5misc_b']."', q5misc_c='".$row['q5misc_c']."', q5misc_d='".$row['q5misc_d']."', q5misc_e='".$row['q5misc_e']."', q5misc_f='".$row['q5misc_f']."', q5clean_a='".$row['q5clean_a']."', q5clean_b='".$row['q5clean_b']."', q5clean_c='".$row['q5clean_c']."', q6a='".$row['q6a']."', q6b='".$row['q6b']."', q7a='".$row['q7a']."', q7b='".$row['q7b']."', q7c='".$row['q7c']."', q7d='".$row['q7d']."', q8a='".$row['q8a']."', q8b='".$row['q8b']."', q8c='".$row['q8c']."', q9a='".$row['q9a']."', q9b='".$row['q9b']."', q9c='".$row['q9c']."', q9d='".$row['q9d']."', p9e='".$row['q9e']."', p10a='".$row['p10a']."', p11a='".$row['p11a']."', p12a='".$row['p12a']."', p12b='".$row['p12b']."', p12c='".$row['p12c']."', q13a='".$row['q13a']."', q13b='".$row['q13b']."', q13c='".$row['q13c']."', q13d='".$row['q13d']."', q13e='".$row['q13e']."', q14a='".$row['q14a']."', q14b='".$row['q14b']."', q14c='".$row['q14c']."', q14d='".$row['q14d']."', q14e='".$row['q14e']."', q14f='".$row['q14f']."', q14g='".$row['q14g']."', q15a='".$row['q15a']."', q15b='".$row['q15b']."', q15c='".$row['q15c']."', q15d='".$row['q15d']."', q15e='".$row['q15e']."', q16a='".$row['q16a']."', q16b='".$row['q16b']."', q17a='".$row['q17a']."', q17b='".$row['q17b']."', q18a='".$row['q18a']."', q18b='".$row['q18b']."', q19a='".$row['q19a']."', q19b='".$row['q19b']."', q19c='".$row['q19c']."', q19d='".$row['q19d']."', q19e='".$row['q19e']."', q19f='".$row['q19f']."', q19g='".$row['q19g']."', q19h='".$row['q19h']."', blog_1='".$row['blog_1']."', blog_2='".$row['blog_2']."', blog_3='".$row['blog_3']."', blog_4='".$row['blog_4']."', blog_5='".$row['blog_5']."', blog_6='".$row['blog_6']."', blog_7='".$row['blog_7']."', blog_8='".$row['blog_8']."', blog_9='".$row['blog_9']."', blog_10='".$row['blog_10']."', highlight_blog_1='".$row['highlight_blog_1']."', highlight_blog_2='".$row['highlight_blog_2']."', highlight_blog_3='".$row['highlight_blog_3']."', highlight_blog_4='".$row['highlight_blog_4']."', highlight_blog_5='".$row['highlight_blog_5']."', highlight_blog_6='".$row['highlight_blog_6']."', highlight_blog_7='".$row['highlight_blog_7']."', highlight_blog_8='".$row['highlight_blog_8']."', highlight_blog_9='".$row['highlight_blog_9']."', highlight_blog_10='".$row['highlight_blog_10']."', insp_result='".$row['insp_result']."', temp_milk_tank='".$row['temp_milk_tank']."', temp_hot_water='".$row['temp_hot_water']."', hauler='".$row['hauler']."', last_scc='".$row['last_scc']."', last_antibiotic='".$row['last_antibiotic']."', insp_status='".$row['insp_status']."', scoring='".$row['scoring']."', grade='".$row['grade']."', results='".$row['results']."', timestamp='".$row['timestamp']."', active='".$row['active']."', localts='".$row['localts']."', serverts='".$row['serverts']."' where id='".$row['id']."' and farm_id='".$row['farm_id']."'";
		$which1=$handle_db1;
		mysql_query($query2,$which1);
		$updatedid++;
	}
	mysql_free_result(mysql_query($query1,$which1));
}

// Lab Quality Download
$query="select * from lab_quality where serverts>'".$lab_quality_serverts."' or serverts='0000-00-00 00:00:00'"; $which=$handle_db2;
$sql=mysql_query($query,$which);
$addlqd=0;
$updatelqd=0;
while($row=mysql_fetch_array($sql))
{
	$query1="select * from lab_quality where serverts<='".$lab_quality_serverts."' and id='".$row['id']."' and farm_id='".$row['farm_id']."'";  $which1=$handle_db1;
	$row1=mysql_query($query1,$which1);
	if(mysql_fetch_row($row1)==0)
	{
		$query2="insert into lab_quality values(".$row['farm_id'].", ".$row['tank_number'].", ".$row['pu_date'].", ".$row['plate_date'].", ".$row['butterfat'].", ".$row['protein'].", ".$row['other_solids'].", ".$row['scc'].", ".$row['antibiotic'].", ".$row['cryo'].", ".$row['pi'].", ".$row['temp'].", ".$row['bacteria'].", ".$row['coop_num'].", ".$row['start_date'].", ".$row['snf'].", ".$row['mun'].", ".$row['lactose'].", ".$row['sediment'].", ".$row['inhibitor'].", ".$row['lcp'].", ".$row['coli'].", ".$row['ta'].", ".$row['manifest_number'].", ".$row['load_seq'].", ".$row['hauler_id'].", ".$row['truck_number'].", ".$row['route_number'].", ".$row['driver_number'].", ".$row['sample_label'].", ".$row['amended'].", ".$row['status'].", ".$row['thresholdviolate'].", ".$row['wt'].", ".$row['grade'].", ".$row['lab_id'].", ".$row['active'].", ".$row['timestamp'].", ".$row['source'].", ".$row['maint_stamp'].", ".$row['localts'].", ".$row['serverts'].")";
		$which1=$handle_db1;
		mysql_query($query2,$which1);
	}
	else
	{
		$query2="update lab_quality set farm_id='".$row['farm_id']."', tank_number='".$row['tank_number']."', pu_date='".$row['pu_date']."', plate_date='".$row['plate_date']."', butterfat='".$row['butterfat']."', protein='".$row['protein']."', other_solids='".$row['other_solids']."', scc='".$row['scc']."', antibiotic='".$row['antibiotic']."', cryo='".$row['cryo']."', pi='".$row['pi']."', temp='".$row['temp']."', bacteria='".$row['bacteria']."', coop_num='".$row['coop_num']."', start_date='".$row['start_date']."', snf='".$row['snf']."', mun='".$row['mun']."', lactose='".$row['lactose']."', sediment='".$row['sediment']."', inhibitor='".$row['inhibitor']."', lcp='".$row['lcp']."', coli='".$row['coli']."', ta='".$row['ta']."', manifest_number='".$row['manifest_number']."', load_seq='".$row['load_seq']."', haulder_id='".$row['hauler_id']."', truck_number='".$row['truck_number']."', route_number='".$row['route_number']."', driver_number='".$row['driver_number']."', sample_label='".$row['sample_label']."', amended='".$row['amended']."', status='".$row['status']."', thresholdviolate='".$row['thresholdviolate']."', wt='".$row['wt']."', grade='".$row['grade']."', lab_id='".$row['lab_id']."', active='".$row['active']."', timestamp='".$row['timestamp']."', source='".$row['source']."', maint_stamp='".$row['maint_stamp']."', localts='".$row['localts']."', serverts='".$row['serverts']."'  where id='".$row['id']."' and farm_id='".$row['famr_id']."'";
		$which1=$handle_db1;
		mysql_query($query2,$which1);
		$updatelqd++;
	}
	mysql_free_result(mysql_query($query1,$which1));
}

?>
josh
DevNet Master
Posts: 4872
Joined: Wed Feb 11, 2004 3:23 pm
Location: Palm beach, Florida

Re: Writing To multiple databases within a php script

Post by josh »

Did you know Mysql does this for you already?
mattbranch12
Forum Newbie
Posts: 18
Joined: Thu Jul 09, 2009 3:14 pm
Location: Hagerstown, MD

Re: Writing To multiple databases within a php script

Post by mattbranch12 »

No I did not. I was using Maatkits mk-table sync prior to this but it seems to be slow. Please explain how this is done through mysql.
josh
DevNet Master
Posts: 4872
Joined: Wed Feb 11, 2004 3:23 pm
Location: Palm beach, Florida

Re: Writing To multiple databases within a php script

Post by josh »

Well there is master slave replication which replicates every INSERT, UPDATE, etc..

If one becomes out of date, by lets say an hour, it can still catch up by continuing to process the binary log. Although it is designed for real time replication. Not sure if you needed to actually sync the rows, but your script seemed really ad-hoc either way (like you were typing out every single table/row name in a script)
mattbranch12
Forum Newbie
Posts: 18
Joined: Thu Jul 09, 2009 3:14 pm
Location: Hagerstown, MD

Re: Writing To multiple databases within a php script

Post by mattbranch12 »

Yea the rows need to be synced. Yea the script is very ad-hoc. I have 3 tables that i only want to sync. I broke down the script to a very simple portion.
Just trying to insert a row. For what ever reason it will not insert the row even though i can print the array to the screen from the if statement.

Code: Select all

<?php 
$handle_db1 = mysql_connect("localhost:8893","root","i!7@nC0p#U");
$handle_db2 = mysql_connect("hagerstownsoccer.com:3306","root","i!7@nC0p#U",true);

// give each handle it's own database to work with, permanently.
mysql_select_db("ddsl",$handle_db1);
mysql_select_db("dds",$handle_db2);

//Get sync table data FROM local machine
// Querie for when they last synced.
$query = "SELECT * FROM sync"; $which = $handle_db1;
$sql=mysql_query($query,$which);
while($sync=mysql_fetch_array($sql))
{
$lab_quality_localts=$sync['lab_quality_localts'];
$dairy_master_localts=$sync['dairy_master_localts'];
$dairy_insp_localts=$sync['dairy_insp_localts'];
$lab_quality_serverts=$sync['lab_quality_serverts'];
$dairy_master_serverts=$sync['dairy_master_serverts'];
$dairy_insp_serverts=$sync['dairy_insp_serverts'];
}

//Look for rows that have not been synced since the last time or have never been synced.
$query="SELECT * FROM `dairy_insp` WHERE serverts>'".$dairy_insp_serverts."' or serverts='0000-00-00 00:00:00'"; $which=$handle_db1;
$sql=mysql_query($query,$which);
$adddi=0;
$UPDATEdi=0;
while($row=mysql_fetch_array($sql))
{
	$query1="SELECT * FROM `dairy_insp` WHERE serverts<='".$dairy_insp_serverts."' and id='".$row['id']."' and farm_id='".$row['farm_id']."'";  $which1=$handle_db2;
	$row1=mysql_query($query1,$which1);
//if no match has been found on server then the row needs to be inserted.
	if(mysql_fetch_row($row1)==0)
	{
		echo $row['id'];
				$query2="INSERT INTO `dairy_insp` (premise_number, farm_id) VALUES (".$row['premise_number'].", ".$row['farm_id'].")";
		$which1=$handle_db2;
		mysql_query($query2,$which1);
		$adddi++;
	}

	}
?>
josh
DevNet Master
Posts: 4872
Joined: Wed Feb 11, 2004 3:23 pm
Location: Palm beach, Florida

Re: Writing To multiple databases within a php script

Post by josh »

Try.. mysql_query( $query ) or die(mysql_error());
mattbranch12
Forum Newbie
Posts: 18
Joined: Thu Jul 09, 2009 3:14 pm
Location: Hagerstown, MD

Re: Writing To multiple databases within a php script

Post by mattbranch12 »

Yea, my own stupid fault with syntax errors. Sorry to even bother you guys. But the script it self runs much faster than maatkit's mk-table sync using their bi-directional option. I'll post the script when I finish. Thanks Josh for the help.
mattbranch12
Forum Newbie
Posts: 18
Joined: Thu Jul 09, 2009 3:14 pm
Location: Hagerstown, MD

Re: Writing To multiple databases within a php script

Post by mattbranch12 »

Once again thanks for the help, Here is the script for reference if anyone else that may need.

Code: Select all

<?php

$handle_db1 = mysql_connect("localhost:XXXX","user","pass");
$handle_db2 = mysql_connect("sumhost","user","pass",true);

// give each handle it's own database to work with, permanently.
mysql_select_db("ddsl",$handle_db1);
mysql_select_db("dds",$handle_db2);

//Create timestamp
date_default_timezone_set('America/New_York');
$ts=date("Y-m-d : H:i:s", time()); 

//Get sync table data FROM local machine
$query = "SELECT * FROM sync"; $which = $handle_db1;
$sql=mysql_query($query,$which);
while($sync=mysql_fetch_array($sql))
{
$lab_quality_localts=$sync['lab_quality_localts'];
$dairy_master_localts=$sync['dairy_master_localts'];
$dairy_insp_localts=$sync['dairy_insp_localts'];
$lab_quality_serverts=$sync['lab_quality_serverts'];
$dairy_master_serverts=$sync['dairy_master_serverts'];
$dairy_insp_serverts=$sync['dairy_insp_serverts'];
}

//`dairy_master` Upload
$query="SELECT * FROM `dairy_master` WHERE TIMESTAMP(serverts)>TIMESTAMP('".$dairy_master_serverts."') or serverts='0000-00-00 00:00:00'"; $which=$handle_db1;
$sql=mysql_query($query,$which);
$adddm=0;
$updatedm=0;
while($row=mysql_fetch_array($sql))
{
	$query1="SELECT * FROM `dairy_master` WHERE TIMESTAMP(serverts)<=TIMESTAMP('".$row['serverts']."') AND id='".$row['id']."'";  $which1=$handle_db2;
	$row1=mysql_query($query1,$which1);
	
	if(mysql_fetch_row($row1)==0)
	{
		
		$adddm++;
		mysql_query("INSERT INTO `dairy_master` (edit_date, farm_id, farm_name, address_1, address_2 , city, state, zip, plus4, township, county, primary_contact, phone_direct, premise_number, rBST_free, rBST_expire, cow_number, milking_number, brucellosis_type, tuberculosis_type, watertest_current, watertest_cur_result, watertest_previous, water_source, field_rep, field_rep_name, sanitarian, hauler, del_site, handler, test_card, vote_privilege, meeting_notice, phone_pin, phone_pass, daily_prod, btu, active, grazing, timestamp, primary_contact_title, primary_contact_email, localts) VALUES ('".$row['edit_date']."', '".$row['farm_id']."', '".$row['farm_name']."', '".$row['address_1']."', '".$row['address_2']."', '".$row['city']."', '".$row['state']."', '".$row['zip']."', '".$row['plus4']."', '".$row['township']."', '".$row['county']."', '".$row['primary_contact']."', '".$row['phone_direct']."', '".$row['premise_number']."', '".$row['rBST_free']."', '".$row['rBST_expire']."', '".$row['cow_number']."', '".$row['milking_number']."', '".$row['brucellosis_type']."', '".$row['tuberculosis_type']."', '".$row['watertest_current']."', '".$row['watertest_cur_result']."', '".$row['watertest_previous']."', '".$row['water_source']."', '".$row['field_rep']."', '".$row['field_rep_name']."', '".$row['sanitarian']."', '".$row['hauler']."', '".$row['del_site']."', '".$row['handler']."', '".$row['test_card']."', '".$row['vote_privilege']."', '".$row['meeting_notice']."', '".$row['phone_pin']."', '".$row['phone_pass']."', '".$row['daily_prod']."', '".$row['btu']."', '".$row['active']."', '".$row['grazing']."', '".$row['timestamp']."', '".$row['primary_contact_title']."', '".$row['primary_contact_email']."', '".$row['localts']."')",$handle_db2);
	}
	else
	{		
		mysql_query("UPDATE `dairy_master` SET edit_date='".$row['edit_date']."', farm_id='".$row['farm_id']."', farm_name='".$row['farm_name']."', address_1='".$row['address_1']."', address_2='".$row['address_2']."', city='".$row['city']."', state='".$row['state']."', zip='".$row['zip']."', plus4='".$row['plus4']."', township='".$row['township']."', county='".$row['county']."', primary_contact='".$row['primary_contact']."', phone_direct='".$row['phone_direct']."', premise_number='".$row['premise_number']."', rBST_free='".$row['rBST_free']."', rBST_expire='".$row['rBST_expire']."', cow_number='".$row['cow_number']."', milking_number='".$row['milking_number']."', brucellosis_type='".$row['brucellosis_type']."', tuberculosis_type='".$row['tuberculosis_type']."', watertest_current='".$row['watertest_current']."', watertest_cur_result='".$row['watertest_cur_result']."', watertest_previous='".$row['watertest_previous']."', water_source='".$row['water_source']."', field_rep='".$row['field_rep']."', field_rep_name='".$row['field_rep_name']."', sanitarian='".$row['sanitarian']."', hauler='".$row['hauler']."', del_site='".$row['del_site']."', handler='".$row['handler']."', test_card='".$row['test_card']."', vote_privilege='".$row['vote_privilege']."', meeting_notice='".$row['meeting_notice']."', phone_pin='".$row['phone_pin']."', phone_pass='".$row['phone_pass']."', daily_prod='".$row['daily_prod']."', btu='".$row['btu']."', active='".$row['active']."', grazing='".$row['grazing']."', timestamp='".$row['timestamp']."', primary_contact_title='".$row['primary_contact_title']."', primary_contact_email='".$row['primary_contact_email']."', localts='".$row['localts']."' WHERE id='".$row['id']."'",$handle_db2);
		$updatedm++;
		
	}
	mysql_free_result(mysql_query($query1,$which1));
}

//Dairy Insp Upload

$query="SELECT * FROM `dairy_insp` WHERE TIMESTAMP(serverts)>TIMESTAMP('".$dairy_insp_serverts."') OR serverts='0000-00-00 00:00:00'"; $which=$handle_db1;
$sql=mysql_query($query,$which);
$adddi=0;
$updatedi=0;
while($row=mysql_fetch_array($sql))
{
	$query1="SELECT * FROM `dairy_insp` WHERE TIMESTAMP(serverts)<=TIMESTAMP('".$row['serverts']."') AND id='".$row['id']."'";  $which1=$handle_db2;
	$row1=mysql_query($query1,$which1);
	if(mysql_fetch_row($row1)==0)
	{
				mysql_query("INSERT INTO `dairy_insp` (id, premise_number, farm_id, farm_name, address_1, address_2, city, state, zip, plus4, township, county, phone, cow_number, milking_number, date, time, production, milk_now, brucellosis_type, brucellosis_date, insp_type, tuberculosis_type, tuberculosis_date, buyer, buyer_btu, watertest_previous, watertest_current, watertest_cur_result, water_source, agent, field_rep, field_rep_name, reinspect_days, q1a, q1b, q1c, q2a, q2b, q2c, q2d, q2e, q3a, q3b, q3c, q4a, q4b, q4c, q4d, q5floors_a, q5floors_b, q5floors_c, q5walls_a, q5walls_b, q5lights_a, q5lights_b, q5lights_c, q5lights_d, q5misc_a, q5misc_b, q5misc_c, q5misc_d, q5misc_e, q5misc_f, q5clean_a, q5clean_b, q5clean_c, q6a, q6b, q7a, q7b, q7c, q7d, q8a, q8b, q8c, q9a, q9b, q9c, q9d, q9e, p10a, p11a, p12a, p12b, p12c, q13a, q13b, q13c, q13d, q13e, q14a, q14b, q14c, q14d, q14e, q14f, q14g, q15a, q15b, q15c, q15d, q15e, q16a, q16b, q17a, q17b, q18a, q18b, q19a, q19b, q19c, q19d, q19e, q19f, q19g, q19h, blog_1, blog_2, blog_3, blog_4, blog_5, blog_6, blog_7, blog_8, blog_9, blog_10, highlight_blog_1, highlight_blog_2, highlight_blog_3, highlight_blog_4, highlight_blog_5, highlight_blog_6, highlight_blog_7, highlight_blog_8, highlight_blog_9, highlight_blog_10, insp_result, temp_milk_tank, temp_hot_water, hauler, last_scc, last_antibiotic, insp_status, scoring, grade, results, timestamp, active, localts) VALUES ('".$row['id']."', '".$row['premise_number']."', '".$row['farm_id']."', '".$row['farm_name']."', '".$row['address_1']."', '".$row['address_2']."', '".$row['city']."', '".$row['state']."', '".$row['zip']."', '".$row['plus4']."', '".$row['township']."', '".$row['county']."', '".$row['phone']."', '".$row['cow_number']."', '".$row['milking_number']."', '".$row['date']."', '".$row['time']."', '".$row['production']."', '".$row['milk_now']."', '".$row['brucellosis_type']."', '".$row['brucellosis_date']."', '".$row['insp_type']."', '".$row['tuberculosis_type']."', '".$row['tuberculosis_date']."', '".$row['buyer']."', '".$row['buyer_btu']."', '".$row['watertest_previous']."', '".$row['watertest_current']."', '".$row['watertest_cur_result']."', '".$row['water_source']."', '".$row['agent']."', '".$row['field_rep']."', '".$row['field_rep_name']."', '".$row['reinspect_days']."', '".$row['q1a']."', '".$row['q1b']."', '".$row['q1c']."', '".$row['q2a']."', '".$row['q2b']."', '".$row['q2c']."', '".$row['q2d']."', '".$row['q2e']."', '".$row['q3a']."', '".$row['q3b']."', '".$row['q3c']."', '".$row['q4a']."', '".$row['q4b']."', '".$row['q4c']."', '".$row['q4d']."', '".$row['q5floors_a']."', '".$row['q5floors_b']."', '".$row['q5floors_c']."', '".$row['q5walls_a']."', '".$row['q5walls_b']."', '".$row['q5lights_a']."', '".$row['q5lights_b']."', '".$row['q5lights_c']."', '".$row['q5lights_d']."', '".$row['q5misc_a']."', '".$row['q5misc_b']."', '".$row['q5misc_c']."', '".$row['q5misc_d']."', '".$row['q5misc_e']."', '".$row['q5misc_f']."', '".$row['q5clean_a']."', '".$row['q5clean_b']."', '".$row['q5clean_c']."', '".$row['q6a']."', '".$row['q6b']."', '".$row['q7a']."', '".$row['q7b']."', '".$row['q7c']."', '".$row['q7d']."', '".$row['q8a']."', '".$row['q8b']."', '".$row['q8c']."', '".$row['q9a']."', '".$row['q9b']."', '".$row['q9c']."', '".$row['q9d']."', '".$row['q9e']."', '".$row['p10a']."', '".$row['p11a']."', '".$row['p12a']."', '".$row['p12b']."', '".$row['p12c']."', '".$row['q13a']."', '".$row['q13b']."', '".$row['q13c']."', '".$row['q13d']."', '".$row['q13e']."', '".$row['q14a']."', '".$row['q14b']."', '".$row['q14c']."', '".$row['q14d']."', '".$row['q14e']."', '".$row['q14f']."', '".$row['q14g']."', '".$row['q15a']."', '".$row['q15b']."', '".$row['q15c']."', '".$row['q15d']."', '".$row['q15e']."', '".$row['q16a']."', '".$row['q16b']."', '".$row['q17a']."', '".$row['q17b']."', '".$row['q18a']."', '".$row['q18b']."', '".$row['q19a']."', '".$row['q19b']."', '".$row['q19c']."', '".$row['q19d']."', '".$row['q19e']."', '".$row['q19f']."', '".$row['q19g']."', '".$row['q19h']."', '".$row['blog_1']."', '".$row['blog_2']."', '".$row['blog_3']."', '".$row['blog_4']."', '".$row['blog_5']."', '".$row['blog_6']."', '".$row['blog_7']."', '".$row['blog_8']."', '".$row['blog_9']."', '".$row['blog_10']."', '".$row['highlight_blog_1']."', '".$row['highlight_blog_2']."', '".$row['highlight_blog_3']."', '".$row['highlight_blog_4']."', '".$row['highlight_blog_5']."', '".$row['highlight_blog_6']."', '".$row['highlight_blog_7']."', '".$row['highlight_blog_8']."', '".$row['highlight_blog_9']."', '".$row['highlight_blog_10']."', '".$row['insp_result']."', '".$row['temp_milk_tank']."', '".$row['temp_hot_water']."', '".$row['hauler']."', '".$row['last_scc']."', '".$row['last_antibiotic']."', '".$row['insp_status']."', '".$row['scoring']."', '".$row['grade']."', '".$row['results']."', '".$row['timestamp']."', '".$row['active']."', '".$row['localts']."')",$handle_db2);

		$adddi++;
	}
	else
	{
				mysql_query("UPDATE `dairy_insp` SET premise_number='".$row['premise_number']."', farm_id='".$row['farm_id']."', farm_name='".$row['farm_name']."', address_1='".$row['address_1']."', address_2='".$row['address_2']."', city='".$row['city']."', state='".$row['state']."', zip='".$row['zip']."', plus4='".$row['plus4']."', township='".$row['township']."', county='".$row['county']."', phone='".$row['phone']."', cow_number='".$row['cow_number']."', milking_number='".$row['milking_number']."', date='".$row['date']."', time='".$row['time']."', production='".$row['production']."', milk_now='".$row['milk_now']."', brucellosis_type='".$row['brucellosis_type']."', brucellosis_date='".$row['brucellosis_date']."', insp_type='".$row['insp_type']."', tuberculosis_type='".$row['tuberculosis_type']."', tuberculosis_date='".$row['tuberculosis_date']."', buyer='".$row['buyer']."', buyer_btu='".$row['buyer_btu']."', watertest_previous='".$row['watertest_previous']."', watertest_current='".$row['watertest_current']."', watertest_cur_result='".$row['watertest_cur_result']."', water_source='".$row['water_source']."', agent='".$row['agent']."', field_rep='".$row['field_rep']."', field_rep_name='".$row['field_rep_name']."', reinspect_days='".$row['reinspect_days']."', q1a='".$row['q1a']."', q1b='".$row['q1b']."', q1c='".$row['q1c']."', q2a='".$row['q2a']."', q2b='".$row['q2b']."', q2c='".$row['q2c']."', q2d='".$row['q2d']."', q2e='".$row['q2e']."', q3a='".$row['q3a']."', q3b='".$row['q3b']."', q3c='".$row['q3c']."', q4a='".$row['q4a']."', q4b='".$row['q4b']."', q4c='".$row['q4c']."', q4d='".$row['q4d']."', q5floors_a='".$row['q5floors_a']."', q5floors_b='".$row['q5floors_b']."', q5floors_c='".$row['q5floors_c']."', q5walls_a='".$row['q5walls_a']."', q5walls_b='".$row['q5walls_b']."', q5lights_a='".$row['q5lights_a']."', q5lights_b='".$row['q5lights_b']."', q5lights_c='".$row['q5lights_c']."', q5lights_d='".$row['q5lights_d']."', q5misc_a='".$row['q5misc_a']."', q5misc_b='".$row['q5misc_b']."', q5misc_c='".$row['q5misc_c']."', q5misc_d='".$row['q5misc_d']."', q5misc_e='".$row['q5misc_e']."', q5misc_f='".$row['q5misc_f']."', q5clean_a='".$row['q5clean_a']."', q5clean_b='".$row['q5clean_b']."', q5clean_c='".$row['q5clean_c']."', q6a='".$row['q6a']."', q6b='".$row['q6b']."', q7a='".$row['q7a']."', q7b='".$row['q7b']."', q7c='".$row['q7c']."', q7d='".$row['q7d']."', q8a='".$row['q8a']."', q8b='".$row['q8b']."', q8c='".$row['q8c']."', q9a='".$row['q9a']."', q9b='".$row['q9b']."', q9c='".$row['q9c']."', q9d='".$row['q9d']."', q9e='".$row['q9e']."', p10a='".$row['p10a']."', p11a='".$row['p11a']."', p12a='".$row['p12a']."', p12b='".$row['p12b']."', p12c='".$row['p12c']."', q13a='".$row['q13a']."', q13b='".$row['q13b']."', q13c='".$row['q13c']."', q13d='".$row['q13d']."', q13e='".$row['q13e']."', q14a='".$row['q14a']."', q14b='".$row['q14b']."', q14c='".$row['q14c']."', q14d='".$row['q14d']."', q14e='".$row['q14e']."', q14f='".$row['q14f']."', q14g='".$row['q14g']."', q15a='".$row['q15a']."', q15b='".$row['q15b']."', q15c='".$row['q15c']."', q15d='".$row['q15d']."', q15e='".$row['q15e']."', q16a='".$row['q16a']."', q16b='".$row['q16b']."', q17a='".$row['q17a']."', q17b='".$row['q17b']."', q18a='".$row['q18a']."', q18b='".$row['q18b']."', q19a='".$row['q19a']."', q19b='".$row['q19b']."', q19c='".$row['q19c']."', q19d='".$row['q19d']."', q19e='".$row['q19e']."', q19f='".$row['q19f']."', q19g='".$row['q19g']."', q19h='".$row['q19h']."', blog_1='".$row['blog_1']."', blog_2='".$row['blog_2']."', blog_3='".$row['blog_3']."', blog_4='".$row['blog_4']."', blog_5='".$row['blog_5']."', blog_6='".$row['blog_6']."', blog_7='".$row['blog_7']."', blog_8='".$row['blog_8']."', blog_9='".$row['blog_9']."', blog_10='".$row['blog_10']."', highlight_blog_1='".$row['highlight_blog_1']."', highlight_blog_2='".$row['highlight_blog_2']."', highlight_blog_3='".$row['highlight_blog_3']."', highlight_blog_4='".$row['highlight_blog_4']."', highlight_blog_5='".$row['highlight_blog_5']."', highlight_blog_6='".$row['highlight_blog_6']."', highlight_blog_7='".$row['highlight_blog_7']."', highlight_blog_8='".$row['highlight_blog_8']."', highlight_blog_9='".$row['highlight_blog_9']."', highlight_blog_10='".$row['highlight_blog_10']."', insp_result='".$row['insp_result']."', temp_milk_tank='".$row['temp_milk_tank']."', temp_hot_water='".$row['temp_hot_water']."', hauler='".$row['hauler']."', last_scc='".$row['last_scc']."', last_antibiotic='".$row['last_antibiotic']."', insp_status='".$row['insp_status']."', scoring='".$row['scoring']."', grade='".$row['grade']."', results='".$row['results']."', timestamp='".$row['timestamp']."', active='".$row['active']."', localts='".$row['localts']."' WHERE id='".$row['id']."'",$handle_db2);
		$updatedi++;
	}
	mysql_free_result(mysql_query($query1,$which1));
}

//Dairy Master Download
$query="SELECT * FROM `dairy_master` WHERE TIMESTAMP(serverts)>TIMESTAMP('".$dairy_master_serverts."') or serverts='0000-00-00 00:00:00'"; $which=$handle_db2;
$sql=mysql_query($query,$which);
$adddmd=0;
$updatedmd=0;
while($row=mysql_fetch_array($sql))
{
	$query1="SELECT * FROM `dairy_master` WHERE TIMESTAMP(serverts)<=TIMESTAMP('".$row['serverts']."') and id='".$row['id']."'";  $which1=$handle_db1;
	$row1=mysql_query($query1,$which1);
	if(mysql_fetch_row($row1)==0)
	{
		mysql_query("INSERT INTO `dairy_master` (edit_date, farm_id, farm_name, address_1, address_2 , city, state, zip, plus4, township, county, primary_contact, phone_direct, premise_number, rBST_free, rBST_expire, cow_number, milking_number, brucellosis_type, tuberculosis_type, watertest_current, watertest_cur_result, watertest_previous, water_source, field_rep, field_rep_name, sanitarian, hauler, del_site, handler, test_card, vote_privilege, meeting_notice, phone_pin, phone_pass, daily_prod, btu, active, grazing, timestamp, primary_contact_title, primary_contact_email, localts) VALUES ('".$row['edit_date']."', '".$row['farm_id']."', '".$row['farm_name']."', '".$row['address_1']."', '".$row['address_2']."', '".$row['city']."', '".$row['state']."', '".$row['zip']."', '".$row['plus4']."', '".$row['township']."', '".$row['county']."', '".$row['primary_contact']."', '".$row['phone_direct']."', '".$row['premise_number']."', '".$row['rBST_free']."', '".$row['rBST_expire']."', '".$row['cow_number']."', '".$row['milking_number']."', '".$row['brucellosis_type']."', '".$row['tuberculosis_type']."', '".$row['watertest_current']."', '".$row['watertest_cur_result']."', '".$row['watertest_previous']."', '".$row['water_source']."', '".$row['field_rep']."', '".$row['field_rep_name']."', '".$row['sanitarian']."', '".$row['hauler']."', '".$row['del_site']."', '".$row['handler']."', '".$row['test_card']."', '".$row['vote_privilege']."', '".$row['meeting_notice']."', '".$row['phone_pin']."', '".$row['phone_pass']."', '".$row['daily_prod']."', '".$row['btu']."', '".$row['active']."', '".$row['grazing']."', '".$row['timestamp']."', '".$row['primary_contact_title']."', '".$row['primary_contact_email']."', '".$row['localts']."')",$handle_db1);
	}
	else
	{
		mysql_query("UPDATE `dairy_master` SET edit_date='".$row['edit_date']."', farm_id='".$row['farm_id']."', farm_name='".$row['farm_name']."', address_1='".$row['address_1']."', address_2='".$row['address_2']."', city='".$row['city']."', state='".$row['state']."', zip='".$row['zip']."', plus4='".$row['plus4']."', township='".$row['township']."', county='".$row['county']."', primary_contact='".$row['primary_contact']."', phone_direct='".$row['phone_direct']."', premise_number='".$row['premise_number']."', rBST_free='".$row['rBST_free']."', rBST_expire='".$row['rBST_expire']."', cow_number='".$row['cow_number']."', milking_number='".$row['milking_number']."', brucellosis_type='".$row['brucellosis_type']."', tuberculosis_type='".$row['tuberculosis_type']."', watertest_current='".$row['watertest_current']."', watertest_cur_result='".$row['watertest_cur_result']."', watertest_previous='".$row['watertest_previous']."', water_source='".$row['water_source']."', field_rep='".$row['field_rep']."', field_rep_name='".$row['field_rep_name']."', sanitarian='".$row['sanitarian']."', hauler='".$row['hauler']."', del_site='".$row['del_site']."', handler='".$row['handler']."', test_card='".$row['test_card']."', vote_privilege='".$row['vote_privilege']."', meeting_notice='".$row['meeting_notice']."', phone_pin='".$row['phone_pin']."', phone_pass='".$row['phone_pass']."', daily_prod='".$row['daily_prod']."', btu='".$row['btu']."', active='".$row['active']."', grazing='".$row['grazing']."', timestamp='".$row['timestamp']."', primary_contact_title='".$row['primary_contact_title']."', primary_contact_email='".$row['primary_contact_email']."', localts='".$row['localts']."' WHERE id='".$row['id']."'",$handle_db1);
		$updatedmd++;
	}
	mysql_free_result(mysql_query($query1,$which1));
}

//Dairy Insp Download

$query="SELECT * FROM `dairy_insp` WHERE TIMESTAMP(serverts)>TIMESTAMP('".$dairy_insp_serverts."') or serverts='0000-00-00 00:00:00'"; $which=$handle_db2;
$sql=mysql_query($query,$which);
$adddid=0;
$updatedid=0;
while($row=mysql_fetch_array($sql))
{
	$query1="SELECT * FROM `dairy_insp` WHERE TIMESTAMP(serverts)<=TIMESTAMP('".$row['serverts']."') and id='".$row['id']."'";  $which1=$handle_db1;
	$row1=mysql_query($query1,$which1);
	if(mysql_fetch_row($row1)==0)
	{
		$adddid++;
		mysql_query("INSERT INTO `dairy_insp` (id, premise_number, farm_id, farm_name, address_1, address_2, city, state, zip, plus4, township, county, phone, cow_number, milking_number, date, time, production, milk_now, brucellosis_type, brucellosis_date, insp_type, tuberculosis_type, tuberculosis_date, buyer, buyer_btu, watertest_previous, watertest_current, watertest_cur_result, water_source, agent, field_rep, field_rep_name, reinspect_days, q1a, q1b, q1c, q2a, q2b, q2c, q2d, q2e, q3a, q3b, q3c, q4a, q4b, q4c, q4d, q5floors_a, q5floors_b, q5floors_c, q5walls_a, q5walls_b, q5lights_a, q5lights_b, q5lights_c, q5lights_d, q5misc_a, q5misc_b, q5misc_c, q5misc_d, q5misc_e, q5misc_f, q5clean_a, q5clean_b, q5clean_c, q6a, q6b, q7a, q7b, q7c, q7d, q8a, q8b, q8c, q9a, q9b, q9c, q9d, q9e, p10a, p11a, p12a, p12b, p12c, q13a, q13b, q13c, q13d, q13e, q14a, q14b, q14c, q14d, q14e, q14f, q14g, q15a, q15b, q15c, q15d, q15e, q16a, q16b, q17a, q17b, q18a, q18b, q19a, q19b, q19c, q19d, q19e, q19f, q19g, q19h, blog_1, blog_2, blog_3, blog_4, blog_5, blog_6, blog_7, blog_8, blog_9, blog_10, highlight_blog_1, highlight_blog_2, highlight_blog_3, highlight_blog_4, highlight_blog_5, highlight_blog_6, highlight_blog_7, highlight_blog_8, highlight_blog_9, highlight_blog_10, insp_result, temp_milk_tank, temp_hot_water, hauler, last_scc, last_antibiotic, insp_status, scoring, grade, results, timestamp, active, localts) VALUES ('".$row['id']."', '".$row['premise_number']."', '".$row['farm_id']."', '".$row['farm_name']."', '".$row['address_1']."', '".$row['address_2']."', '".$row['city']."', '".$row['state']."', '".$row['zip']."', '".$row['plus4']."', '".$row['township']."', '".$row['county']."', '".$row['phone']."', '".$row['cow_number']."', '".$row['milking_number']."', '".$row['date']."', '".$row['time']."', '".$row['production']."', '".$row['milk_now']."', '".$row['brucellosis_type']."', '".$row['brucellosis_date']."', '".$row['insp_type']."', '".$row['tuberculosis_type']."', '".$row['tuberculosis_date']."', '".$row['buyer']."', '".$row['buyer_btu']."', '".$row['watertest_previous']."', '".$row['watertest_current']."', '".$row['watertest_cur_result']."', '".$row['water_source']."', '".$row['agent']."', '".$row['field_rep']."', '".$row['field_rep_name']."', '".$row['reinspect_days']."', '".$row['q1a']."', '".$row['q1b']."', '".$row['q1c']."', '".$row['q2a']."', '".$row['q2b']."', '".$row['q2c']."', '".$row['q2d']."', '".$row['q2e']."', '".$row['q3a']."', '".$row['q3b']."', '".$row['q3c']."', '".$row['q4a']."', '".$row['q4b']."', '".$row['q4c']."', '".$row['q4d']."', '".$row['q5floors_a']."', '".$row['q5floors_b']."', '".$row['q5floors_c']."', '".$row['q5walls_a']."', '".$row['q5walls_b']."', '".$row['q5lights_a']."', '".$row['q5lights_b']."', '".$row['q5lights_c']."', '".$row['q5lights_d']."', '".$row['q5misc_a']."', '".$row['q5misc_b']."', '".$row['q5misc_c']."', '".$row['q5misc_d']."', '".$row['q5misc_e']."', '".$row['q5misc_f']."', '".$row['q5clean_a']."', '".$row['q5clean_b']."', '".$row['q5clean_c']."', '".$row['q6a']."', '".$row['q6b']."', '".$row['q7a']."', '".$row['q7b']."', '".$row['q7c']."', '".$row['q7d']."', '".$row['q8a']."', '".$row['q8b']."', '".$row['q8c']."', '".$row['q9a']."', '".$row['q9b']."', '".$row['q9c']."', '".$row['q9d']."', '".$row['q9e']."', '".$row['p10a']."', '".$row['p11a']."', '".$row['p12a']."', '".$row['p12b']."', '".$row['p12c']."', '".$row['q13a']."', '".$row['q13b']."', '".$row['q13c']."', '".$row['q13d']."', '".$row['q13e']."', '".$row['q14a']."', '".$row['q14b']."', '".$row['q14c']."', '".$row['q14d']."', '".$row['q14e']."', '".$row['q14f']."', '".$row['q14g']."', '".$row['q15a']."', '".$row['q15b']."', '".$row['q15c']."', '".$row['q15d']."', '".$row['q15e']."', '".$row['q16a']."', '".$row['q16b']."', '".$row['q17a']."', '".$row['q17b']."', '".$row['q18a']."', '".$row['q18b']."', '".$row['q19a']."', '".$row['q19b']."', '".$row['q19c']."', '".$row['q19d']."', '".$row['q19e']."', '".$row['q19f']."', '".$row['q19g']."', '".$row['q19h']."', '".$row['blog_1']."', '".$row['blog_2']."', '".$row['blog_3']."', '".$row['blog_4']."', '".$row['blog_5']."', '".$row['blog_6']."', '".$row['blog_7']."', '".$row['blog_8']."', '".$row['blog_9']."', '".$row['blog_10']."', '".$row['highlight_blog_1']."', '".$row['highlight_blog_2']."', '".$row['highlight_blog_3']."', '".$row['highlight_blog_4']."', '".$row['highlight_blog_5']."', '".$row['highlight_blog_6']."', '".$row['highlight_blog_7']."', '".$row['highlight_blog_8']."', '".$row['highlight_blog_9']."', '".$row['highlight_blog_10']."', '".$row['insp_result']."', '".$row['temp_milk_tank']."', '".$row['temp_hot_water']."', '".$row['hauler']."', '".$row['last_scc']."', '".$row['last_antibiotic']."', '".$row['insp_status']."', '".$row['scoring']."', '".$row['grade']."', '".$row['results']."', '".$row['timestamp']."', '".$row['active']."', '".$row['localts']."')",$handle_db1);
	}
	else
	{
				mysql_query("UPDATE `dairy_insp` SET premise_number='".$row['premise_number']."', farm_id='".$row['farm_id']."', farm_name='".$row['farm_name']."', address_1='".$row['address_1']."', address_2='".$row['address_2']."', city='".$row['city']."', state='".$row['state']."', zip='".$row['zip']."', plus4='".$row['plus4']."', township='".$row['township']."', county='".$row['county']."', phone='".$row['phone']."', cow_number='".$row['cow_number']."', milking_number='".$row['milking_number']."', date='".$row['date']."', time='".$row['time']."', production='".$row['production']."', milk_now='".$row['milk_now']."', brucellosis_type='".$row['brucellosis_type']."', brucellosis_date='".$row['brucellosis_date']."', insp_type='".$row['insp_type']."', tuberculosis_type='".$row['tuberculosis_type']."', tuberculosis_date='".$row['tuberculosis_date']."', buyer='".$row['buyer']."', buyer_btu='".$row['buyer_btu']."', watertest_previous='".$row['watertest_previous']."', watertest_current='".$row['watertest_current']."', watertest_cur_result='".$row['watertest_cur_result']."', water_source='".$row['water_source']."', agent='".$row['agent']."', field_rep='".$row['field_rep']."', field_rep_name='".$row['field_rep_name']."', reinspect_days='".$row['reinspect_days']."', q1a='".$row['q1a']."', q1b='".$row['q1b']."', q1c='".$row['q1c']."', q2a='".$row['q2a']."', q2b='".$row['q2b']."', q2c='".$row['q2c']."', q2d='".$row['q2d']."', q2e='".$row['q2e']."', q3a='".$row['q3a']."', q3b='".$row['q3b']."', q3c='".$row['q3c']."', q4a='".$row['q4a']."', q4b='".$row['q4b']."', q4c='".$row['q4c']."', q4d='".$row['q4d']."', q5floors_a='".$row['q5floors_a']."', q5floors_b='".$row['q5floors_b']."', q5floors_c='".$row['q5floors_c']."', q5walls_a='".$row['q5walls_a']."', q5walls_b='".$row['q5walls_b']."', q5lights_a='".$row['q5lights_a']."', q5lights_b='".$row['q5lights_b']."', q5lights_c='".$row['q5lights_c']."', q5lights_d='".$row['q5lights_d']."', q5misc_a='".$row['q5misc_a']."', q5misc_b='".$row['q5misc_b']."', q5misc_c='".$row['q5misc_c']."', q5misc_d='".$row['q5misc_d']."', q5misc_e='".$row['q5misc_e']."', q5misc_f='".$row['q5misc_f']."', q5clean_a='".$row['q5clean_a']."', q5clean_b='".$row['q5clean_b']."', q5clean_c='".$row['q5clean_c']."', q6a='".$row['q6a']."', q6b='".$row['q6b']."', q7a='".$row['q7a']."', q7b='".$row['q7b']."', q7c='".$row['q7c']."', q7d='".$row['q7d']."', q8a='".$row['q8a']."', q8b='".$row['q8b']."', q8c='".$row['q8c']."', q9a='".$row['q9a']."', q9b='".$row['q9b']."', q9c='".$row['q9c']."', q9d='".$row['q9d']."', q9e='".$row['q9e']."', p10a='".$row['p10a']."', p11a='".$row['p11a']."', p12a='".$row['p12a']."', p12b='".$row['p12b']."', p12c='".$row['p12c']."', q13a='".$row['q13a']."', q13b='".$row['q13b']."', q13c='".$row['q13c']."', q13d='".$row['q13d']."', q13e='".$row['q13e']."', q14a='".$row['q14a']."', q14b='".$row['q14b']."', q14c='".$row['q14c']."', q14d='".$row['q14d']."', q14e='".$row['q14e']."', q14f='".$row['q14f']."', q14g='".$row['q14g']."', q15a='".$row['q15a']."', q15b='".$row['q15b']."', q15c='".$row['q15c']."', q15d='".$row['q15d']."', q15e='".$row['q15e']."', q16a='".$row['q16a']."', q16b='".$row['q16b']."', q17a='".$row['q17a']."', q17b='".$row['q17b']."', q18a='".$row['q18a']."', q18b='".$row['q18b']."', q19a='".$row['q19a']."', q19b='".$row['q19b']."', q19c='".$row['q19c']."', q19d='".$row['q19d']."', q19e='".$row['q19e']."', q19f='".$row['q19f']."', q19g='".$row['q19g']."', q19h='".$row['q19h']."', blog_1='".$row['blog_1']."', blog_2='".$row['blog_2']."', blog_3='".$row['blog_3']."', blog_4='".$row['blog_4']."', blog_5='".$row['blog_5']."', blog_6='".$row['blog_6']."', blog_7='".$row['blog_7']."', blog_8='".$row['blog_8']."', blog_9='".$row['blog_9']."', blog_10='".$row['blog_10']."', highlight_blog_1='".$row['highlight_blog_1']."', highlight_blog_2='".$row['highlight_blog_2']."', highlight_blog_3='".$row['highlight_blog_3']."', highlight_blog_4='".$row['highlight_blog_4']."', highlight_blog_5='".$row['highlight_blog_5']."', highlight_blog_6='".$row['highlight_blog_6']."', highlight_blog_7='".$row['highlight_blog_7']."', highlight_blog_8='".$row['highlight_blog_8']."', highlight_blog_9='".$row['highlight_blog_9']."', highlight_blog_10='".$row['highlight_blog_10']."', insp_result='".$row['insp_result']."', temp_milk_tank='".$row['temp_milk_tank']."', temp_hot_water='".$row['temp_hot_water']."', hauler='".$row['hauler']."', last_scc='".$row['last_scc']."', last_antibiotic='".$row['last_antibiotic']."', insp_status='".$row['insp_status']."', scoring='".$row['scoring']."', grade='".$row['grade']."', results='".$row['results']."', timestamp='".$row['timestamp']."', active='".$row['active']."', localts='".$row['localts']."' WHERE id='".$row['id']."'",$handle_db1);
		$updatedid++;
	}
	mysql_free_result(mysql_query($query1,$which1));
}


// Lab Quality Download
$query="SELECT * FROM `lab_quality` WHERE TIMESTAMP(serverts)>TIMESTAMP('".$lab_quality_serverts."') or serverts='0000-00-00 00:00:00'"; $which=$handle_db2;
$sql=mysql_query($query,$which);
$addlqd=0;
$updatelqd=0;
while($row=mysql_fetch_array($sql))
{
	$query1="SELECT * FROM `lab_quality` WHERE TIMESTAMP(serverts)<=TIMESTAMP('".$row['serverts']."') and id='".$row['id']."'";  $which1=$handle_db1;
	$row1=mysql_query($query1,$which1);
	if(mysql_fetch_row($row1)==0)
	{
		$addlqd++;
		mysql_query("INSERT INTO `lab_quality` (farm_id, tank_number, pu_date, plate_date, butterfat, protein, other_solids, scc, antibiotic, cryo, pi, temp, bacteria, coop_num, start_date, snf, mun, lactose, sediment, inhibitor, lcp, coli, ta, manifest_number, load_seq, hauler_id, truck_number, route_number, driver_number, sample_label, amended,status, thresholdviolate, wt, grade, lab_id, active, timestamp, source, maint_stamp, localts) VALUES('".$row['farm_id']."', '".$row['tank_number']."', '".$row['pu_date']."', '".$row['plate_date']."', '".$row['butterfat']."', '".$row['protein']."', '".$row['other_solids']."', '".$row['scc']."', '".$row['antibiotic']."', '".$row['cryo']."', '".$row['pi']."', '".$row['temp']."', '".$row['bacteria']."', '".$row['coop_num']."', '".$row['start_date']."', '".$row['snf']."', '".$row['mun']."', '".$row['lactose']."', '".$row['sediment']."', '".$row['inhibitor']."', '".$row['lcp']."', '".$row['coli']."', '".$row['ta']."', '".$row['manifest_number']."', '".$row['load_seq']."', '".$row['hauler_id']."', '".$row['truck_number']."', '".$row['route_number']."', '".$row['driver_number']."', '".$row['sample_label']."', '".$row['amended']."', '".$row['status']."', '".$row['thresholdviolate']."', '".$row['wt']."', '".$row['grade']."', '".$row['lab_id']."', '".$row['active']."', '".$row['timestamp']."', '".$row['source']."', '".$row['maint_stamp']."', '".$row['localts']."')",$handle_db1);
	}
	else
	{
		mysql_query("UPDATE `lab_quality` SET farm_id='".$row['farm_id']."', tank_number='".$row['tank_number']."', pu_date='".$row['pu_date']."', plate_date='".$row['plate_date']."', butterfat='".$row['butterfat']."', protein='".$row['protein']."', other_solids='".$row['other_solids']."', scc='".$row['scc']."', antibiotic='".$row['antibiotic']."', cryo='".$row['cryo']."', pi='".$row['pi']."', temp='".$row['temp']."', bacteria='".$row['bacteria']."', coop_num='".$row['coop_num']."', start_date='".$row['start_date']."', snf='".$row['snf']."', mun='".$row['mun']."', lactose='".$row['lactose']."', sediment='".$row['sediment']."', inhibitor='".$row['inhibitor']."', lcp='".$row['lcp']."', coli='".$row['coli']."', ta='".$row['ta']."', manifest_number='".$row['manifest_number']."', load_seq='".$row['load_seq']."', hauler_id='".$row['hauler_id']."', truck_number='".$row['truck_number']."', route_number='".$row['route_number']."', driver_number='".$row['driver_number']."', sample_label='".$row['sample_label']."', amended='".$row['amended']."', status='".$row['status']."', thresholdviolate='".$row['thresholdviolate']."', wt='".$row['wt']."', grade='".$row['grade']."', lab_id='".$row['lab_id']."', active='".$row['active']."', timestamp='".$row['timestamp']."', source='".$row['source']."', maint_stamp='".$row['maint_stamp']."', localts='".$row['localts']."' WHERE id='".$row['id']."'",$handle_db1);
		$updatelqd++;
	}
	mysql_free_result(mysql_query($query1,$which1));
}

echo $updatedid;
//Dairy Master

if($adddm>0 or $updatedm>0)
{
	mysql_query('UPDATE sync SET dairy_master_serverts="'.$ts.'" WHERE dairy_master_serverts="'.$dairy_master_serverts.'"',$handle_db1);
}

if($adddmd>0 or $updatedmd>0)
{
	mysql_query('UPDATE sync SET dairy_master_serverts="'.$ts.'" WHERE dairy_master_serverts="'.$dairy_master_serverts.'"',$handle_db1);
}
//Dairy Insp
if($adddi>0 or $updatedi>0)
{
	mysql_query('UPDATE sync SET dairy_insp_serverts="'.$ts.'" WHERE dairy_insp_serverts="'.$dairy_insp_serverts.'"',$handle_db1);
}

if($adddid>0 or $updatedid>0)
{
	mysql_query('UPDATE sync SET dairy_insp_serverts="'.$ts.'" WHERE dairy_insp_serverts="'.$dairy_insp_serverts.'"',$handle_db1);
}

//Lab Quality

if($addlqd>0 or $updatelqd>0)
{
	mysql_query('UPDATE sync SET lab_quality_serverts="'.$ts.'" WHERE lab_quality_serverts="'.$lab_quality_serverts.'"',$handle_db1);
}
?>
Post Reply