PHP - Save Variable From Remote Server Using Xmlhttprequest

This isn't exactly an application design question, but rather a system design one.   I am about to install an Inventory Control System inside this store I work in.   The store itself also owns a Linode VPS running Centos 6.4 which hosts our website.   This new Inventory System will come built in with a Microsoft SQL Server, and supposedly it is a SQL Anywhere database, but I'm not too sure what that means.     I need to make this database publicly accessible, but only via the Linode VPS.  Surely, setting restrictions is easy enough to address that issue.  That isn't my question.   My first idea is to put this server into the DMZ, easy.  But it doesn't exactly sound safe.  So my next idea was to put a middleman server in the DMZ, this way the Linode can send queries to that middleman server and it will send that data to the SQL Server and back.  This is very vaguely described I know, but I don't want to get too much into details, but rather, understand how I can create that middleman server, and what could Install onto it that would allow me to securely process queries?   My first thought was to install a webservice, that accepts an XML/JSON request and returns an XML/JSON response. Then, I realized directly afterwards that I don't have any experience setting up a webservice like that. What kind of options are there out there?
  Ultimately, my question is, should I just put the Server in the DMZ or should I create the middleman, and if so, can someone point me in the right direction as to getting a webservice set up?
Edited by Zane, 15 July 2014 - 11:28 PM.

I'm trying to save images from a directory into mine. To get the image I am having to take the email from a database, split it and take whatever it is before the '@' sign and add it to "-S.jpg". I wrote the script and when I echo the variable it shows the correct thing, but when it tries to save it , it is trying to find the image as "script>-S.jpg". It looks like it is taking whatever is after the last '/' which in the variable since I am running javascript it is going to be </script> if you look at my variable $url. Here is the code below. Any help is appreciated.


while($rows=mysql_fetch_array($result)){
$email=$rows['email'];

 
$url= "<SCRIPT LANGUAGE=\"javascript\">
var url;
var email = \"$email\";
function emailsplit () 
{ 
var userid = email.split(\"@\"); 
var url = userid[0]; 
var imgid = \"http://my.snu.edu/images/idpictures/\" + url + \"-S.jpg\"; 
return url;
}  
document.write(emailsplit());
</script>
";

         $img[]= 'http://my.snu.edu/images/idpictures/'.$url.'-S.jpg';
  
   

}

  
       
    
      function save_image($img,$fullpath='basename'){
 
          if($fullpath=='basename'){
 
              $fullpath = basename($img);
  
          }
          $ch = curl_init ($img);
          curl_setopt($ch, CURLOPT_HEADER, 0);
          curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
          curl_setopt($ch, CURLOPT_BINARYTRANSFER,1);
          $rawdata=curl_exec($ch);
          curl_close ($ch);
          if(file_exists($fullpath)){
              unlink($fullpath);
          }
          $fp = fopen($fullpath,'x');
          fwrite($fp, $rawdata);
          fclose($fp);
      }

  
      foreach($img as $i){
   
          save_image($i); 
   
          if(getimagesize(basename($i))){
   
              echo '<h3 style="color: green;">Image ' . basename($i) . ' Downloaded OK</h3>';
  
          }else{
  
              echo '<h3 style="color: red;">Image ' . basename($i) . ' Download Failed</h3>';
  
          }
 
      }

What's the proper way to check if a file exists on a remote server? I know file_exists() works for you local files.

I think i need to use something like the following. BUT if the file is not found PHP throws a warning. I know i can put a '@' before fopen() but that just masks the error.

Code: [Select]
<?php
if(fopen("http://www.othersite.com/imageXYZ.jpg", "r"))
{
echo "File exists.";
}
else
{
echo "File does not exist.";
}
?>

Hi,
 My program works on WAMP (PHP Version 5.5.12) running on my machine. However, the same program will not run on remote server (PHP Version 5.4.32). Basically, I'm trying to insert values obtained from a form into a database. I've checked and rechecked the table I'm inserting into and I can't find anything wrong with it. The trouble is it's hard to debug a PHP program. Unlike, say, C++ which requires a compiler, you can trace the program line by line to look for errors. That's not possible with PHP and makes it so much harder to look for faults.
 The relevant functions used to send data to database are shown below. insert() is returning false every time and I can't understand why! I wonder if anyone can suggest where things might be going wrong. I would be very grateful.
 

public function insert($table, $fields = array())
   { if(count($fields)) //true if $fields holds data
     { $keys = array_keys($fields);

       $values = '';  //to put inside query
       
       $x = 1;

      foreach($fields as $field)
      { $values .= '?';
        if($x < count($fields))
        { $values .= ', ';
        }
        $x++;
      }
   $sql = "INSERT INTO {$table} (`".implode('`, `', $keys) . "`) VALUES({$values})";
      if(!$this->query($sql, $fields)->error())
      { return true;
      }
     }
     return false;
   }

  public function query($sql, $darams = array())
  {
    $this->_error = false;   //reset error
    if($this->_query = $this->_pdo->prepare($sql))
    { $x = 1;
      if(count($darams))
      { foreach($darams as $param)
        { $this->_query->bindValue($x, $param);
          $x++;
        }
      }
      if($this->_query->execute())
      { $this->_results = $this->_query->fetchAll(PDO::FETCH_OBJ);
        $this->_count = $this->_query->rowCount();
      }
      else      //an error has occured in SQL query
      { $this->_error = true;
      }
    }
    return $this;
  }

  public function error()
  { return $this->_error;
   }

   public function count()
   { return $this->_count;
   }

I am trying to get a php script on a remote server to execute on my server but im having problems getting it to work, and i am not sure if it is even feasible
i have had a look on google but i cant find much information on it.

This is what i have tried up to now

I saved a php script as a txt file on y remote server.
then used file_get_contents on my home server

$curl_scraped_page = file_get_contents('http://www.remote_server.com/script.txt');

the content of the txt file was

$sum = 1+1;

then i tried to echo $sum on the home server but i did not work can anyone point me in the right direction or is what i am trying to do even feasible?

Thanks in advanced