PHP - Differences In Servers?

I am trying to transfer some data from one Servers DB to a new server with cleaner tables. When i run my code the transfer seems to be working but the script just keeps running and never give the desired responses. First it collects the data (for testing i limited results by 1) then checks to see if the app is in the new DB, if so then it updates its contents. If not then it adds it. It seems to work for both updates and inserts but i must still be missing something. Thanks for any help.

Code: [Select]
<?php
function getTime()
    {
    $a = explode (' ',microtime());
    return(double) $a[0] + $a[1];
    }
$Start = getTime(); 
######################################################################
$connection1 = mysql_connect('','','');
if (!$connection1){
   die('Could not connect: ' . mysql_error());
}
$db_selected1 = mysql_select_db('', $connection1);
if (!$db_selected1) {
    die ('Could not connect: ' . mysql_error());
}

//if(isset($_REQUEST['appcounting'])){
//$appcounting = ($_REQUEST['appcounting'] + 1);
//$appnext = 1;
//$appgroup = $appcounting + $appnext;
//echo "Checked app $appcounting-$appgroup.<br />\n";
//}
//else{
//$appcounting = 0;
//$appnext = 1;
//}

$count = 0;
$appinfo = mysql_query("SELECT app_id, ipayAppID, Status, MID, BusinessContactName, BusinessContactPhone, BusinessEmail, BusinessWebsite, BusinessName, BusinessAddress, BusinessCity, BusinessState, BusinessZip, BusinessTaxID, BusinessMailingAddress, BusinessMailingCity, BusinessMailingState, BusinessMailingZip, agent_id, CreateTime, StatusChangeTime, ReceiveTime, ReviewTime, PayrollApprovalTime, PayrollPayTime, ApproveTime, DeclineTime, CancelTime, CancelDesc, PendingTime, PendingDesc FROM app ORDER BY app_id DESC LIMIT 0, 1") or die('SELECT ' . mysql_error());
while($row = mysql_fetch_array($appinfo))
{
$app_id[] = $row['app_id'];
$ipayAppID[] = $row['ipayAppID'];
$Status[] = $row['Status'];
$MID[] = $row['MID'];
$BusinessContactName[] = $row['BusinessContactName'];
$BusinessContactPhone[] = $row['BusinessContactPhone'];
$BusinessEmail[] = $row['BusinessEmail'];
$BusinessWebsite[] = $row['BusinessWebsite'];
$BusinessName[] = $row['BusinessName'];
$BusinessAddress[] = $row['BusinessAddress'];
$BusinessCity[] = $row['BusinessCity'];
$BusinessState[] = $row['BusinessState'];
$BusinessZip[] = $row['BusinessZip'];
$BusinessTaxID[] = $row['BusinessTaxID'];
$BusinessMailingAddress[] = $row['BusinessMailingAddress'];
$BusinessMailingCity[] = $row['BusinessMailingCity'];
$BusinessMailingState[] = $row['BusinessMailingState'];
$BusinessMailingZip[] = $row['BusinessMailingZip'];
$agent_id[] = $row['agent_id'];
$CreateTime[] = $row['CreateTime'];
$StatusChangeTime[] = $row['StatusChangeTime'];
$ReceiveTime[] = $row['ReceiveTime'];
$ReviewTime[] = $row['ReviewTime'];
$PayrollApprovalTime[] = $row['PayrollApprovalTime'];
$PayrollPayTime[] = $row['PayrollPayTime'];
$ApproveTime[] = $row['ApproveTime'];
$DeclineTime[] = $row['DeclineTime'];
$CancelTime[] = $row['CancelTime'];
$CancelDesc[] = $row['CancelDesc'];
$PendingTime[] = $row['PendingTime'];
$PendingDesc[] = $row['PendingDesc'];
$count++;
}

mysql_close($connection1);
######################################################################
$connection2 = mysql_connect('','','');
if (!$connection2){
die('Could not connect: ' . mysql_error());
}
$db_selected2 = mysql_select_db('', $connection2);
if (!$db_selected2){
    die ('Could not connect: ' . mysql_error());
}


$number = 0;
$count_insert = 0;
while($number <= $count)
{
$findapp = $app_id[$number];
$one = mysql_query("SELECT AppID FROM Apps WHERE `AppID`='$findapp'") or die('FIND ' . mysql_error());
$num_rows = mysql_num_rows($one);
if ($num_rows == 1){
$myBusinessContactName = $BusinessContactName[$number];
$myBusinessContactName = addslashes($myBusinessContactName);
$myBusinessName = $BusinessName[$number];
$myBusinessName = addslashes($myBusinessName);
$myBusinessCity = $BusinessCity[$number];
$myBusinessCity = addslashes($myBusinessCity);
$myBusinessMailingCity = $BusinessMailingCity[$number];
$myBusinessMailingCity = addslashes($myBusinessMailingCity);
$myPendingDesc = $PendingDesc[$number];
$myPendingDesc = addslashes($myPendingDesc);
$myCancelDesc = $CancelDesc[$number];
$myCancelDesc = addslashes($myCancelDesc);
$myBusinessAddress = $BusinessAddress[$number];
$myBusinessAddress = addslashes($myBusinessAddress);
$myBusinessMailingAddress = $BusinessMailingAddress[$number];
$myBusinessMailingAddress = addslashes($myBusinessMailingAddress);

mysql_query("UPDATE Apps SET `IpayAppID`='$ipayAppID[$number]', `Status`='$Status[$number]', `MID`='$MID[$number]', `ContactName`='$myBusinessContactName', `ContactPhone`='$BusinessContactPhone[$number]', `ContactEmail`='$BusinessEmail[$number]', `ContactWebsite`='$BusinessWebsite[$number]', `DBA`='$myBusinessName', `BusinessAddress`='$myBusinessAddress', `BusinessCity`='$myBusinessCity', `BusinessState`='$BusinessState[$number]', `BusinessZip`='$BusinessZip[$number]', `BusinessTaxID`='$BusinessTaxID[$number]', `MailingAddress`='$myBusinessMailingAddress', `MailingCity`='$myBusinessMailingCity', `MailingState`='$BusinessMailingState[$number]', `MailingZip`='$BusinessMailingZip[$number]', `Agent1ID`='$agent_id[$number]', `CreateTime`='$CreateTime[$number]', `StatusChangeTime`='$StatusChangeTime[$number]', `ReceivedTime`='$ReceiveTime[$number]', `ReviewedTime`='$ReviewTime[$number]', `PayrollApprovalTime`='$PayrollApprovalTime[$number]', `PayrollPayTime`='$PayrollPayTime[$number]', `ApproveTime`='$ApproveTime[$number]', `DeclineTime`='$DeclineTime[$number]', `CancelTime`='$CancelTime[$number]', `CancelDesc`='$myCancelDesc', `PendingTime`='$PendingTime[$number]', `PendingDesc`='$myPendingDesc' WHERE AppID='$app_id[$number]'") or die('UPDATE ' . mysql_error());
$number++;
}
elseif(isset($app_id[$number]) && isset($BusinessName[$number])){
echo "Transfered App $findapp<br />\n";
$myBusinessContactName = $BusinessContactName[$number];
$myBusinessContactName = addslashes($myBusinessContactName);
$myBusinessName = $BusinessName[$number];
$myBusinessName = addslashes($myBusinessName);
$myBusinessCity = $BusinessCity[$number];
$myBusinessCity = addslashes($myBusinessCity);
$myBusinessMailingCity = $BusinessMailingCity[$number];
$myBusinessMailingCity = addslashes($myBusinessMailingCity);
$myPendingDesc = $PendingDesc[$number];
$myPendingDesc = addslashes($myPendingDesc);
$myCancelDesc = $CancelDesc[$number];
$myCancelDesc = addslashes($myCancelDesc);
$myBusinessAddress = $BusinessAddress[$number];
$myBusinessAddress = addslashes($myBusinessAddress);
$myBusinessMailingAddress = $BusinessMailingAddress[$number];
$myBusinessMailingAddress = addslashes($myBusinessMailingAddress);

mysql_query("INSERT INTO Apps (AppID, IpayAppID, Status, MID, ContactName, ContactPhone, ContactEmail, ContactWebsite, DBA, BusinessAddress, BusinessCity, BusinessState, BusinessZip, BusinessTaxID, MailingAddress, MailingCity, MailingState, MailingZip, Agent1ID, CreateTime, StatusChangeTime, ReceivedTime, ReviewedTime, PayrollApprovalTime, PayrollPayTime, ApproveTime, DeclineTime, CancelTime, CancelDesc, PendingTime, PendingDesc) VALUES ('$app_id[$number]', '$ipayAppID[$number]', '$Status[$number]', '$MID[$number]', '$myBusinessContactName', '$BusinessContactPhone[$number]', '$BusinessEmail[$number]', '$BusinessWebsite[$number]', '$myBusinessName', '$myBusinessAddress', '$myBusinessCity', '$BusinessState[$number]', '$BusinessZip[$number]', '$BusinessTaxID[$number]', '$myBusinessMailingAddress', '$myBusinessMailingCity', '$BusinessMailingState[$number]', '$BusinessMailingZip[$number]', '$agent_id[$number]', '$CreateTime[$number]', '$StatusChangeTime[$number]', '$ReceiveTime[$number]', '$ReviewTime[$number]', '$PayrollApprovalTime[$number]', '$PayrollPayTime[$number]', '$ApproveTime[$number]', '$DeclineTime[$number]', '$CancelTime[$number]', '$myCancelDesc', '$PendingTime[$number]', '$myPendingDesc')") or die('INSERT ' . mysql_error());
$number++;
$count_insert++;
}
}


if($count_insert == 0){
echo "All apps have been found.<br />\n";
exit;
}

mysql_close($connection2);
######################################################################
$End = getTime();
echo "Time taken = ".number_format(($End - $Start),2)." secs<br />\n";
//header('Refresh: 60; url=transfer_apps.php?appcounting=$appcounting');

?>

Hi:

I have a login file where a user goes to a db based on the dbtype selected.
Now
$dbtype1 links to a db on Server 1 ( that is the server on which this script is running and
$dbtype2 links to a db on Server 2

I created a connection-link file connectlink.php as under but  while $dbtype1 works without a problem  , $dbtype2 gives me an error 'no access to db' and user dbun1@localhost not found on db1.db .

What am I missing in the connectlink.php file please ? Thanks

login.php
===========

<?
......
if($_POST['submit']){
$dbtype = $_POST['dbtype'];

if ($dbtype == 'type1') 
   { $section = 'type1';    
     require("../x/type1/type1.php");
     } 

if ($dbtype == 'type2') 
   { $section = 'type2';    
     require("../x/type2/connectlink.php"); //the dir 'x' is a common name on both the servers''
     } 
    
//then it processes $userfile and give this 


Click <a href="'.$section.'/'.$userFile.'?Userid='.$userid.'"> here 

?>

connectlink.php
==============

<?
//this file contains db info, log and checks if user is authorised to access the db - ist check.

error_reporting(E_ERROR | E_PARSE | E_CORE_ERROR);

 $dbusername2='a';
 $dbpassword2='b';
 $dbname2='c';
 $servername = 'ip address of server or localhost ?';
 $link2=mysql_connect ("$servername","$dbusername2","$dbpassword2", true);
 if(!$link2){  die("Could not connect to MySQL");}
 mysql_select_db("$dbname2",$link2) or die ("could not open db".mysql_error());
 

 $dbusername1='d';
 $dbpassword1='e';
 $dbname1='f';
 $servername = 'localhost';
 $link1=mysql_connect ("$servername","$dbusername1","$dbpassword1", true);
 if(!$link1){  die("Could not connect to MySQL");}
 mysql_select_db("$dbname1",$link1) or die ("could not open db".mysql_error());

 
$sql = "SELECT * FROM Users WHERE Userid='$userid'",$link2;

$result = mysql_query($sql);
if  ($myrow = mysql_fetch_array($result)){
$login_success = 'Yes'; 
$status = "On";
....
        
               $sql2= "insert into Log (....) values(.....)",$link2;;
$result2 = mysql_query($sql2) or die  ('no access to database: ' . mysql_error());
//        echo mysql_error();      }
}

else 
{
  $failureMessage = '<p class="data"><center><font face="Verdana" size="2" color="red">Login Failure.  You are not authorised to access this database .<br /></font></center></p>';
    print $failureMessage;
$logoutMessage = 'Click <a href="../NEWDBS/mainlogout.php"> here </a>to logout </p>';

print $logoutMessage;


     exit;
  
}


?>

I'm developing a kind of social network. I've got a question, say it to grow very quickly, I would have to run it across multiple servers to support all users, but I have no idea how I would do it. I'm basically using PHP / MySQL. Could anyone give me a hand? Thanks.

Hello everybody!   I'm here today with a mystery i can't solve... The problem i'm having is that i need to be able to transfer mysql data from one server to another one. Retrieving data from the one database is easy, but making it transfer to another server is not that easy for me. I have it printing out the data ATM   This is how i retrieve data from one server:

<?php 
$dbhost = "";
$dbname = "eg_xenforo";
$dbuser = "";
$dbpass = "";
$conn = mysqli_connect("$dbhost","$dbuser","$dbpass","$dbname") or die("Error " . mysqli_error($conn)); 

$sql=	"SELECT username
		FROM xf_user
		WHERE FIND_IN_SET('9',secondary_group_ids)
        UNION
		SELECT username
		FROM xf_user
		WHERE FIND_IN_SET('10',secondary_group_ids)
        UNION
		SELECT username
		FROM xf_user
		WHERE FIND_IN_SET('12',secondary_group_ids)";
$result = mysqli_query($conn, $sql);

if (mysqli_num_rows($result) > 0) {
    // output data of each row
    while($row = mysqli_fetch_assoc($result)) {
		$name = $row['username'];
        echo "$name <br>";
    }
} else {
    echo "0 results";
}

?>

This is what i get as result:

CosmonautBob 
ooglebrain 
JamieKG 
Quinnter16 
Jordan 
Zoehamp 
skynet1123 
misscupcake1306 
Sir Crimson

These are usernames that should be added onto another server in a database table. Any suggestions?   Thanks in advance!

Hello wize PHP dudes. I'm a fairly advanced PHP user, but I'm confused by STRTOTIME producing different results on two identical servers.
Both running PHP Version 5.2.6-3.

- Server 1: echo date("Y",strtotime('1763-03-24 00:00:00')); returns '1763'
- Server 2: echo date("Y",strtotime('1763-03-24 00:00:00')); returns '1970'

Why do you reckon Server 1 seems not to worry about the Unix Epoch date limit, and happily computes the 1763 date? I would really like Server 2 to do the same thing, but having gone through the php.ini I can't see any difference.

I would really like Server 2 to start working with older dates. I don't want a workaround, as server 1 has been working with just strtotime for years. I can't remember doing anything different on setup. Weird!

Thanks.