PHP - Reading A File From Remote Server And Returning The Content.

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.

Hello  all,
I am trying to read a remote xml file on a file server which requires username and password. I can access the xml file fine through HTTP authentication like

\\111.11.11.111\\pdrs\fileserver\FullText\12345\12345_CLEANUP.xml

But when i try to read it with PHP, I recieved a warning message:
"Warning: simplexml_load_file() [function.simplexml-load-file]: I/O warning : failed to load external entity"

allow_url_fopen is ON
This is part of my code.

        Code: [Select]
$test=rawurldecode("http://username:password@\\\\111.11.11.111\\pdrs\\fileserver\\" . $number . "\\FullText\\" .  $number  . "_CLEANUP.xml");
echo $test;
$xml_filename = simplexml_load_file(rawurldecode("($test)"));

echo $xml_filename;
print_r($xml_filename);
Am I missing something here? Is there any other way to read/save/load a remote xml file which requires authentications? I am new to php so any help is appreciated!
Thanks,

I'm trying to create a simple search engine bot and have found the biggest issue is that of performance, it takes several hours to index all the links and ideally I need to run it once a day, the bottleneck occurs when pulling the data from the remote urls in terms of network transfer time. This could obviously be reduced massively if I could read from several url's simultaneously. Does anyone know how I could do this. I'm aware that in PHP5 there is thread functionality which may solve the problem but this is only available from the CLI.  I heard that it could be done with CURL without having to go down the threaded route, does anyone know how nthis can be done or know of any examples on the net that I could look at?

As a cheeky follow up,   I was also thinking a potential problem could be the script getting out of hand and opening too many connections and I don't to cause a DOS attack! Is there a way that the number of connections could be limited to 10 for example. Is there a way of detecting when a CURL connection has finished reading a file so that a connection manager class could then start the next connection asap?

Thanks for any helpn people, I've been looking for this stuff for days!!

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

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'm getting the error below when I run my script on my remote server.  I'm providing a relative path to this file and it works on my local server (XAMPP).  I've researched it a bit and I think it has to do with how I indicate the path to the file on the remote server.  I don't know what to do about it, however.  I hope someone can help me.  The file is in the indicated directory on the remote server and there are no permissions issues that I am aware of.  The mystery phrase is:

include_path='.:/opt/cpanel/ea-php73/root/usr/share/pear'

 

--Kenoli

Warning: require(bootstrap/start.php): failed to open stream: No such file or directory in /home4/ournight/public_html/tio-new/__classes/pi_admin.php on line 3
Warning: require(bootstrap/start.php): failed to open stream: No such file or directory in /home4/ournight/public_html/tio-new/__classes/pi_admin.php on line 3
Fatal error: require(): Failed opening required 'bootstrap/start.php' (include_path='.:/opt/cpanel/ea-php73/root/usr/share/pear') in /home4/ournight/public_html/tio-new/__classes/pi_admin.php on line 3

 

I have this XML...
Code: [Select]
$xml = '<?xml version="1.0" encoding="utf-8"?>' .
       '<LeadImportDatagram>'.
           '<CompanyKey>' . $companyKey . '</CompanyKey>' .
           '<NotificationEmailTo>garysaldutti@gmail.com</NotificationEmailTo>' .
           '<LeadInfo>';
           '<City>Osweeego</City>';
          '</LeadInfo>' .
        '</LeadImportDatagram>';

and I need to use PHP to submit that XML to a remote server at a address in this format (http://XX.XXX.XXX.XXX/xml/importlead.asp) so that the remote server can process the info.

Can anyone out there tell me how to do that?  It seems like I have to use cURL and I've tried multiple times but keep getting "bad request" errors.

SIDE NOTE: Is my syntax wrong?  Someone else helped me write that $xml variable, but it seems weird to me that some lines end with periods and some end with semicolons.

I've been looking for a function or a couple of functions which will allow me to get the Certificate Expiration date for a given website. I've tried openSSL, but their functions only seem to work on the current server, which is useless to me because my server doesn't allow SSL or certificates. I just want the certificate of an external website, e.g. www.gna.org has a certificate (signed by themselves, but a certificate nonetheless).
I've also tried cURL, since that allows you to access a remote server, but that will just check their certificate - it doesn't offer any functionality for e.g. checking when it will expire.

This seems like a simple enough question, but I haven't found anything about it anywhere, so I'm asking here.

Thanks a bunch in advance,
-IsmAvatar

I have seen a couple of other threads relatively similar but I still find my problem unique so I hope you guys give me a chance. What I want to do: use proxy to bypass same origin policy and to save these values (that changes and need to be checked by timer) into variables that can be modified. A server contains data.asp which looks something like this and updates from time to time (although with a bit more data):

{ "Title":"Tile of song" ,"Artist":"The artist" ,"Album":"The album" ,"CDCover":"/covers/randomcover.jpg" }

The method I have tried is like the one on http://qnimate.com/s...Policy_for_AJAX. In case you guys don't want to follow the link I've posted the data here as well.

<script>
function loadXMLDoc()
{
var xmlhttp;
if (window.XMLHttpRequest)
{
xmlhttp=new XMLHttpRequest();
}
else
{
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
document.getElementById("myDiv").innerHTML=xmlhttp.responseText;
}
}
xmlhttp.open("GET","http://www.qnimate.com/ajaxdata.php",true);
xmlhttp.send();
}
</script>
</head>
<body>

<button type="button" onclick="loadXMLDoc()">Request data</button>
<div id="myDiv"></div>

And the proxy file:

<?php
echo file_get_contents('http://www.qscutter.com/ajaxdata.txt');
?>

So what I want to do is store the data into variables that I can alter, not show it inside a div using innerHTML. Preferably check this ever so often for changes as well.   Suggestions? I can add that I have the permission from the server owner to retrieve the information and to use it but no possibility to add script to their server, hence the proxy bypass attempt.

hello I wanna replicate one table in a database test(in localhost-master) to another database table(slave) on remote server(on the internet) in godaddy.com. I was really tried my best to make it work. but it doesn't seems to be working. I red the MySQL documentation as well.   database name- test master table - attendance -on the localhost(127.0.0.1) slave table - attendance - on the internet(godaddy  184.x.x.x)    I want to copy data from my attendance table on the localhost to slave table on the internet. Please help me to configure these settings. Thank you

i need to count the number of image files on a remote server not in my network.  ive come across a suggestion to use

@getimagesize($img_url)

the above works but is really slow.  anyone able to suggest a better method?

Here is my code:

Code: [Select]
<?php
    $con = ssh2_connect('crm.idea.com.bd','4321');
    ssh2_auth_password($con, 'username', 'password');
    $response = ssh2_exec($con, 'pwd');
    echo $response;

    ?>
I can connect to that server using that username, password and port address. But when I load this script it don't work. It shows loading and loading continues. No error message is given.

N: B: Please help me. I am a newbie.

Hi All - I'm trying to see if the below is possible using PHP.

is it possible for php to allow a user to check if a port is open/listening on a remote server/PC, from their local machine. I've seen scripts on the web that talk about opening cmd.exe - this won't work as not all of my users will be on windows. Also saw fsock.. but the remote server is not serving http page(s). Also saw telnet, but again, some of my users may not have that windows feature enabled.

Desired workflow:

1. user enters the server hostname/IP and a port

2. my php webapp will emulate checking if that hostname and port is open from the local user's computer.

 

thanks!

Hello,

I need to execute a remote web page (distant server) every X seconds.

How is it possible and is there any way to make it look exactly like a normal user request through a standard browser like Firefox, Chrome, etc. ?

I've heard of cURL, but it seems that servers may block it, so there must be somehow a difference between a usual user request and a cURL execution.

Thank you for any help ! :-)
Matthew

Hey All,

I will be marketing a simple php script shortly and would like to Obfuscate my code and have it check to see if the person is running the script on the proper domain, much like other Purchased Scripts, you have to buy licenses and some are limited to a Per Domain basis.

Could I use cURL to run a script on another server (mine) that takes the URL it came from, and a variable "the auth key" and check if the person is using the script on the proper domain?  If the domain and auth key don't match in the DB i would return a message saying invalid key or something, else continue to execute the script.


<?php
//authkey would be defined in config file
$authkey = "769870afhljkzxf90436";

$curl_handle=curl_init();
curl_setopt($curl_handle,CURLOPT_URL,"http://example.com/page.php?authkey=$authkey");
curl_setopt($curl_handle,CURLOPT_CONNECTTIMEOUT,2);
curl_setopt($curl_handle,CURLOPT_RETURNTRANSFER,1);
$buffer = curl_exec($curl_handle);
curl_close($curl_handle);

if (empty($buffer))
{
    print "Sorry, AuthServ is performing maintenance.....<p>";
}
else
{
    print $buffer;
}
?>



Is there a smarter way to do this?  I don't have an extra 300 bucks to use something like ioncube,  just looking for a general proper direction on going about this as I am totally clueless.

thanks