PHP scheduled task not working

[richclever]

Hi All,

I am trying to get a php sceduled task to update a remote database and ftp some files.

I can't see why the file doesn't do what it's supposed to do (even when I call it in firefox) as it worked fine on my local server.

All the table and field names are correct (case sensitive) and the logon details are right but it just doesn't transfer any of the database or files.

server="localhost";
$abadmin="username";
$abpass="password";
$abbdd="dbase";
$abnewbdd="dbase1";
$frenchhost="remote host";
$frenchuser="remote user";
$frenchpass="remote pass";
$i=0;
$tablefield[1]="title";
$tablefield[2]="short";
$tablefield[3]="fulldesc";
$tablefield[4]="status";
$tablefield[5]="department";
$tablefield[6]="region";
$tablefield[7]="type";
$tablefield[8]="condition";
$tablefield[9]="seller";
$tablefield[10]="beds";
$tablefield[11]="price";
$tablefield[12]="lot_size";
$tablefield[13]="sq_feet";
$elementstatus = "For Sale";
$elementregion="Languedoc Roussillon";
$elementcondition="Good";
$elementseller ="Agent Listing";

// set up basic connection
$ftp_server = "hostname";
$ftp_user_name = "username";
$ftp_user_pass = "password";
$conn_id = ftp_connect($ftp_server);

// login with username and password
$login_result = ftp_login($conn_id, $ftp_user_name, $ftp_user_pass);

// check connection
if ((!$conn_id) || (!$login_result)) {
echo "FTP connection has failed!";
echo "Attempted to connect to $ftp_server for user $ftp_user_name";
exit;
} else {
echo "Connected to $ftp_server, for user $ftp_user_name";
} ;

if (@ftp_chdir($conn_id, "/images/listing_photos/")) {
echo "Current directory is now : ", ftp_pwd($conn_id), "\n";
} else {
echo "Couldn't change directory\n";
}




$mysql=mysql_connect($abserver,$abadmin,$abpass)
or die ('I cannot connect to the database because: ' . mysql_error());

$select=mysql_select_db($abbdd,$mysql)
or die ('I cannot select the database because: ' . mysql_error());

$query = "SELECT sale_or_rent,id_com,id_num,department,prix,type_prop,surface_h,surface_t,nb_chambres,head_desc_en,short_desc_en,desc_en,etat FROM ventes WHERE sale_or_rent='S' and etat='1'";
$result = @mysql_query ($query);
//$row = mysql_fetch_array ($result);
while (list($sale_or_rent,$id_com,$id_num,$department,$prix,$type_prop,$surface_h,$surface_t,$nb_chambres,$head_desc_en,$short_desc_en,$desc_en,$etat ) = mysql_fetch_row($result)){

$i++;
$title[$i] = $head_desc_en . " " . $sale_or_rent . $id_com . $id_num;
$propid=$sale_or_rent . $id_com . $id_num;
$short_desc[$i] = $short_desc_en;
$full_desc[$i] = $desc_en;
$status[$i] = "For Sale";
$departmentid[$i]=$department;
$region[$i] = "Languedoc Roussillon";
$type[$i] = $type_prop;
$condition[$i] = "Good";
$seller[$i]= "Agent Listing";
$beds[$i]=$nb_chambres;
$price[$i]=$prix;
$lot_size[$i]=$surface_h;
$sq_feet[$i]=$surface_t;
$imageidnum[$i] = $id_num;
if ($id_num < 10){
$imageidnum[$i] = "00" . "$id_num";
} elseif ($id_num < 100){
$imageidnum[$i] = "0" . "$id_num";
};

$propimagename[$i] = "$sale_or_rent" . "$id_com" . "0" . "$imageidnum[$i]";

};

$mysql1=mysql_connect ($frenchhost, $frenchuser, $frenchpass)
or die ('I cannot connect to the database because: ' . mysql_error());

$select=mysql_select_db($abnewbdd,$mysql1)
or die ('I cannot select the database because: ' . mysql_error());
$query2 = "delete from listingsDB where user_ID = 444";
$result2 = @mysql_query ($query2);
$query4 = "delete from listingsDBElements where user_id = 444";
$result4 = @mysql_query ($query4);
$l=10000;
$dbcount=100000;
$idvalue="$dbcount";
$imagecounter=10000;
$imagesdeletequery = "delete from listingsImages where user_ID = 444";
$imagesqueryresult = @mysql_query ($imagesdeletequery);
$count=1;
while ($count <= $i){
$query1 = "insert into listingsDB (ID,user_ID,Title,expiration,notes,creation_date,last_modified,hitcount,featured,leaseb,depno,active) values ('$l','444','$title[$count]','2006-01-01',' ','2005-01-01','NULL','1','no','no','$departmentid[$i]','yes')" ;
$result1 = @mysql_query ($query1);
$elementcount=1;
$idvalue++;
$queryelement="insert into listingsDBElements (ID, field_name, field_value, listing_id, user_id)values ('$idvalue', '$tablefield[$elementcount]', '$title[$count]', '$l', '444')";
$result10 = @mysql_query ($queryelement);
$elementcount++;
$idvalue++;
$queryelement="insert into listingsDBElements (ID, field_name, field_value, listing_id, user_id)values ('$idvalue', '$tablefield[$elementcount]', '$short_desc[$i]', '$l', '444')";
$result10 = @mysql_query ($queryelement);
$elementcount++;
$idvalue++;
$queryelement="insert into listingsDBElements (ID, field_name, field_value, listing_id, user_id)values ('$idvalue', '$tablefield[$elementcount]', '$full_desc[$i]', '$l', '444')";
$result10 = @mysql_query ($queryelement);
$elementcount++;
$idvalue++;
$queryelement="insert into listingsDBElements (ID, field_name, field_value, listing_id, user_id)values ('$idvalue', '$tablefield[$elementcount]', 'For Sale', '$l', '444')";
$result10 = @mysql_query ($queryelement);
$elementcount++;
$idvalue++;
$queryelement="insert into listingsDBElements (ID, field_name, field_value, listing_id, user_id)values ('$idvalue', '$tablefield[$elementcount]', '$departmentid[$i]', '$l', '444')";
$result10 = @mysql_query ($queryelement);
$elementcount++;
$idvalue++;
$queryelement="insert into listingsDBElements (ID, field_name, field_value, listing_id, user_id)values ('$idvalue', '$tablefield[$elementcount]', 'Languedoc Roussillon', '$l', '444')";
$result10 = @mysql_query ($queryelement);
$elementcount++;
$idvalue++;
$queryelement="insert into listingsDBElements (ID, field_name, field_value, listing_id, user_id)values ('$idvalue', '$tablefield[$elementcount]', '$type[$i]', '$l', '444')";
$result10 = @mysql_query ($queryelement);
$elementcount++;
$idvalue++;
$queryelement="insert into listingsDBElements (ID, field_name, field_value, listing_id, user_id)values ('$idvalue', '$tablefield[$elementcount]', 'Good', '$l', '444')";
$result10 = @mysql_query ($queryelement);
$elementcount++;
$idvalue++;
$queryelement="insert into listingsDBElements (ID, field_name, field_value, listing_id, user_id)values ('$idvalue', '$tablefield[$elementcount]', 'Agent Listing', '$l', '444')";
$result10 = @mysql_query ($queryelement);
$elementcount++;
$idvalue++;
$queryelement="insert into listingsDBElements (ID, field_name, field_value, listing_id, user_id)values ('$idvalue', '$tablefield[$elementcount]', '$beds[$i]', '$l', '444')";
$result10 = @mysql_query ($queryelement);
$elementcount++;
$idvalue++;
$queryelement="insert into listingsDBElements (ID, field_name, field_value, listing_id, user_id)values ('$idvalue', '$tablefield[$elementcount]', '$price[$i]', '$l', '444')";
$result10 = @mysql_query ($queryelement);
$elementcount++;
$idvalue++;
$queryelement="insert into listingsDBElements (ID, field_name, field_value, listing_id, user_id)values ('$idvalue', '$tablefield[$elementcount]', '$lot_size[$i]', '$l', '444')";
$result10 = @mysql_query ($queryelement);
$elementcount++;
$idvalue++;
$queryelement="insert into listingsDBElements (ID, field_name, field_value, listing_id, user_id)values ('$idvalue', '$tablefield[$elementcount]', '$sq_feet[$i]', '$l', '444')";
$result10 = @mysql_query ($queryelement);
$elementcount=1;
$imagescounter=1;

while ($imagescounter <= 5){

$imagefilename = "$propimagename[$count]" . "_" . "$imagescounter" . ".jpg";
$queryimage ="insert into listingsImages (ID, user_id, caption, filename, thumb_filename, decription, listing_id, rank, active) values ('$imagecounter', '444', ' ', '$imagefilename', '$imagefilename', ' ', '$l', '1', 'yes')";
$imageresult = @mysql_query ($queryimage);
// upload the file
$imagesourcepath = "/path to files/image/" . "$imagefilename ";
//echo "$imagesourcepath";
$upload = ftp_put($conn_id, $imagefilename, $imagesourcepath, FTP_IMAGE);

// check upload status
if (!$upload) {
echo "FTP upload has failed!";
} else {
echo "Uploaded $imagefilename to $ftp_server as $imagefilename";
} ;

$imagescounter++;
$imagecounter++;
};

$count++;

$l++;
};

ftp_close($conn_id);

?>


Any help is much appreciated

Rich

 

[vbkris]

does ti throw any errors???

Known is handfull, Unknown is worldfull

 

[richclever]

Unfortunately not. It connects to the ftp server then nothing else appears. The remote database doesn't change and no files are ftp'd.

 

[richclever]

I have just run a script that opens the first connection and then the second and it seems that the second never opens (although I don't get an error message).

I've even used mysql_close to close the first one but to no avail.

Richard

 

[litton1]

could it be that it doesn't throw errors because of all the error suppressants '@' ?

Binary Intelligence, true or false?

 

[richclever]

Problem identified (not resolved though!!)

My host doen't allow incoming or outgoing external connections to mysql. Probably on the firewall as I have opened all access hosts for the database but doesn't make a difference. Can't access the database from outside or connect to a remote database.

Thanks for your help

Richard