PHP - Php Cli Remote Debugging

Hey all,
  I'm having some trouble running some mysql statements through mysqli. I've tried to debug them various ways, but to no avail. This is the offending code:
class DBOPS {
protected $config, $mysqli;

public function __construct () {
$this->config = array (...snip...);
$this->mysqli = new mysqli ($this->config['server'], $this->config['username'], $this->config['password'], $this->config['database']);
session_start();
}

public function Login ($username, $password) {
$toreturn = NULL;

//Problem area is from here...

$encryptedpassword = hash(...snip...);

print_r(array(
$this->config['usertable']['username'],
$username,
$this->config['usertable']['password'],
$encryptedpassword));

$statement = $this->mysqli->stmt_init();
$statement->prepare('SELECT * FROM users WHERE ? = ? AND ? = ?');
$statement->bind_param(
'ssss',
$this->config['usertable']['username'],
$username,
$this->config['usertable']['password'],
$encryptedpassword);

$statement->execute();

print_r($statement->affected_rows);

//To here.

if ($statement->affected_rows == 1) {
$_SESSION[$this->config['sessiondata']['username']] = $username;
$_SESSION[$this->config['sessiondata']['lastactivity']] = time();

$toreturn = TRUE;
} else {
$toreturn = FALSE;
}

$statement->close();

return $toreturn;
}

The print_r($statement->affected_rows); statement always returns -1, which means a query error. Is there a problem with the syntax of the predefined query in $statement->prepare('SELECT * FROM users WHERE ? = ? AND ? = ?') ? I really can't seem to find the problem in this code. There are no errors returned. The output from the print_r() statements are
Code: [Select]
Array ( [0] => Name [1] => Trey [2] => Password [3] => ...snip... )from the first print_r and
Code: [Select]
-1from the second.

And lastly, I know that DIY login systems are generally discouraged, but this is more of a research project. I would greatly appreciate any help with this.

Thanks.

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=322069.0

Hey people!

I'm currently working on an free API that i will be sharing with the web community in the next few months and had a question that much of this project hinges upon:

Is there a way to allow a remote include of one php file from my server?

Case:
I am allowing 2 ways for users to access the APi:

1. Using AJAX or cURL accessing a REST method over POST or GET (This part is already functional)
2. Allowing an include of the API Library
    I'm not sure if it will be completely opensource yet, only free, this is why I don't want to simply provide the source files to users.

Example of what I would like to do:

<?php
include('http://mysite.com/myAPI/classLib.php');
?>


Anybody have a solution for that??


Thanks in advance,

E

On my website, I have a download folder containing several files ranging in size from 6Mb to 700Mb. Users have no problems downloading the smaller files but often have problems downloading the files over 500Mb. We also have an archive of all the files located on a sub-domain on a server in England. Those users that are having problems downloading large files from the main site usually have no problem downloading the large files if we send them the URL for the archive. I've added a button that calls the following script so the users can choose where to download from but have no idea how to code the script.

Here's what I've tried:

// ukdloader script
<?php

$php_scripts = '../../php/';
require $php_scripts . 'PDO_Connection_Select.php';
require $php_scripts . 'GetUserIpAddr.php';
function ukdloader($l_filename=NULL)

{
$ip = GetUserIpAddr();
if (!$pdo = PDOConnect("foxclone_data"))
{    
    exit;
}

    if( isset( $l_filename ) ) {  
        echo <a href="http://foxclone.org/".$l_filename">   /* This is the archive site */
        
        $ext = pathinfo($l_filename, PATHINFO_EXTENSION);
        $stmt = $pdo->prepare("INSERT INTO download (address, filename,ip_address) VALUES (?, ?, inet_aton('$ip'))");
        $stmt->execute([$ip, $ext]) ; 

        $test = $pdo->query("SELECT id FROM lookup WHERE INET_ATON('$ip') BETWEEN start AND end ORDER BY start DESC, end DESC");
        $ref = $test->fetchColumn();
        $ref = intval($ref);

        $stmt = $pdo->prepare("UPDATE download SET ref = '$ref' WHERE address = '$ip'");
        $stmt->execute() ;         
       }
        
    else {
        echo "isset failed";
        }  
}
ukdloader($_GET["f"]);
exit;

Thanks in advance.

Hi,

I'm writing some software and I'm wanting to store user statistics on my web-server remotely. My application outputs the statistics into a txt file and asks the user if they would like to submit this data to my server to help the project (statistics gathering  ) and if they submit it I want the information stored in a mysql database on my web-server. I was thinking about passing the data in through the url in an http request to the page, but there's too much data.

I'm interested in finding out if it's possible to upload a file directly to a php script. I could use FTP to place it on my server, but that would require me putting the ftp login into the program, which I don't feel safe about doing that. At least with a php script I'm able to filter and process any input before it's inserted into the database. Is it actually possible to upload directly to my server from a php file in an http request from an application though?

Hi guys,
I have this problem and id appreciate all your advice in helping solve it.

I'm working on a service with is "cloud" hosted.
However I want it so when a person employed by Corporation A logs onto myservice.corporationa.com they enter their Corporation A LDAP details but somehow that sends them to myservice.com and authenticates them. I know how to do the get LDAP details part to put on myservice.corporationa.com but no idea how to do the rest and make it send back etc.

Any ideas?

Many many thanks in advance.

(PS - If this all makes sense please do let me know)

Ok, the database I have been working on the past few days is located on my websites server (1&1) and today I am trying to get a connection to it on a website that is on a different server, but I am getting my echo statement of saying it can't find the database even though I changed it from "localhost" to the physical address of the database.  Any ideas?

Hi everyone,

I've been trying to load a remote URL using the following;

Code: [Select]
$url = 'http://api.ean.com/ean-services/rs/hotel/v3/list?cid=55505&minorRev=12&apiKey=2hkhej72gxyas3ky6hhjtsga&locale=en_US&currencyCode=USD&customerIpAddress=10.184.2.9&customerUserAgent=Mozilla/5.0+(Windows;+U;+Windows+NT+6.1;+en-US;+rv:1.9.2.25)+Gecko/20111212+Firefox/3.6.25&customerSessionId=&xml=<HotelListRequest><arrivalDate>01/22/2012</arrivalDate><departureDate>01/24/2012</departureDate><RoomGroup><Room><numberOfAdults>1</numberOfAdults><numberOfChildren>1</numberOfChildren><childAges>4</childAges></Room></RoomGroup><city>Amsterdam</city><countryCode>NL</countryCode><supplierCacheTolerance>MED</supplierCacheTolerance></HotelListRequest> ';
$xml = simplexml_load_file($url);

But I get met with this error;

Code: [Select]
Warning: simplexml_load_file() [function.simplexml-load-file]: http://api.ean.com/ean-services/rs/hotel/v3/list?cid=55505&minorRev=12&apiKey=2hkhej72gxyas3ky6hhjtsga&locale=en_US&currencyCode=USD&customerIpAddress=10.184.2.9&customerUserAgent=Mozilla/5.0%2B(Windows;%2BU;%2BWindows%2BNT%2B6.1;%2Ben-US;%2Brv:1.9.2.25)%2BGecko/20111212%2BFirefox/3.6.25&customerSessionId=&xml=%3CHotelListRequest%3E%3CarrivalDate%3E01/22/2012%3C/arrivalDate%3E%3CdepartureDate%3E01/24/2012%3C/departureDate%3E%3CRoomGroup%3E%3CRoom%3E%3CnumberOfAdults%3E1%3C/numberOfAdults%3E%3CnumberOfChildren%3E1%3C/numberOfChildren%3E%3CchildAges%3E4%3C/childAges%3E%3C/Room%3E%3C/RoomGroup%3E%3Ccity%3EAmsterdam%3C/city%3E%3CcountryCode%3ENL%3C/countryCode%3E%3CsupplierCacheTolerance%3EMED%3C/supplierCacheTolerance%3E%3C/HotelListRequest%3E%20:1: parser error : Start tag expected, '<' not found in C:\Program Files\XAMPP\xampplite\htdocs\hotel\results.php on line 29

I was told that URL I am trying to access;

Code: [Select]
http://api.ean.com/ean-services/rs/hotel/v3/list?cid=55505&minorRev=12&apiKey=2hkhej72gxyas3ky6hhjtsga&locale=en_US&currencyCode=USD&customerIpAddress=10.184.2.9&customerUserAgent=Mozilla/5.0+(Windows;+U;+Windows+NT+6.1;+en-US;+rv:1.9.2.25)+Gecko/20111212+Firefox/3.6.25&customerSessionId=&xml=<HotelListRequest><arrivalDate>01/22/2012</arrivalDate><departureDate>01/24/2012</departureDate><RoomGroup><Room><numberOfAdults>1</numberOfAdults><numberOfChildren>1</numberOfChildren><childAges>4</childAges></Room></RoomGroup><city>Amsterdam</city><countryCode>NL</countryCode><supplierCacheTolerance>MED</supplierCacheTolerance></HotelListRequest>

...is a JSON response.

So I was then told to do this;

Code: [Select]
<?php
$context  = stream_context_create(array('http' => array('header' => 'Accept: application/xml')));
$url = 'http://api.ean.com/ean-services/rs/hotel/v3/list?cid=55505&minorRev=12&apiKey=2hkhej72gxyas3ky6hhjtsga&locale=en_US&currencyCode=USD&customerIpAddress=10.184.2.9&customerSessionId=&xml=<HotelListRequest><arrivalDate>01/22/2012</arrivalDate><departureDate>01/24/2012</departureDate><RoomGroup><Room><numberOfAdults>1</numberOfAdults><numberOfChildren>1</numberOfChildren><childAges>4</childAges></Room></RoomGroup><city>Amsterdam</city><countryCode>NL</countryCode><supplierCacheTolerance>MED</supplierCacheTolerance></HotelListRequest> ';

$xml = file_get_contents($url, false, $context);
$xml = simplexml_load_string($xml);
print_r($xml);
?>

This then prints the array to screen.

The data I am trying to access is from the Expedia Affiliate Travel Network. The URL above is from their XML Sandbox.

My question is;

How is the above data that gets returned a JSON response when it should be XML?

and

How can I access the data in the returned array without printing the array to screen? (I've tried things like echo $xml->hotelId[0] and using a foreach statement to no avail).

I'm just a little confused here and have spent quite a number of hours trying to figure this out and reading other resources around the web on SimpleXML (including the PHP Manual). When working with other examples found elsewhere I seem to be ok but when dealing with this URL I seem to be out of my depth.

The XML Sandbox from the EAN network is located: http://ean.mashery.com/docs/hotels/assets/XML_Sandbox

The URL I am using is supposed to return a well formed XML result set.

Thanks for your assistance.

Bob

I need to check a file's size with php and ssh.  Everything I've seen online for remote files uses curl and port 80.  I'll be checking a LAN computer that isn't running a webserver, but is running an SSH server.

How can I do this?

I've tried this:

Code: [Select]
<?php
$tomorrow = date ('n-j-y');
echo system(ssh root@192.168.2.169 ls -lah "/MacRadio X/WMIS Logs/WMIS $tomorrow Log" | awk {print $5});
?>

but it didn't work.  I got a T_VARIAABLE error.  This was the same command I used right from the command line, and it worked.

I'll also need to add a check to the file size, and if it's less than 175K, send me an email...but I'll work on that after I have the first part working.

Thanks!

Hello

I am in need of writting to a txt file on a remote server. When trying  I get this error:

"failed to open stream: HTTP wrapper does not support writeable connections in /home....."

How can I write to a siply txt file on a remote server?

Hi guys,
I am after some code (PHP/AJAX/jQuery) that will let me send a command to a AJAX listener on another pc (or even eventually browser window), a bit like doing remote command/control.

I thought about how does IM services do it and after research found they are dependent on a file or a db, any way to not be dependent on those? Or do I need to be?

Furthermore if I do, anyone have a clean example (even a step by step tutorial) of an IM code with AJAX listener etc that I can use as an example and guide to modify into what I need?

All help is greatly appreciated.

Hope you all had a good NYE _

Cheers

I have been searching for hours to try and figure out how I could print a remote page using PHP.

I know in javascript, you can print the current page with:
Code: [Select]
<a href="javascript:window.print()">Print Page</a>
But what I want to do is "javascript:window.print(http://some-link.com)", but would be nice if I could do it using PHP, if it's even possible.

Hey guys i'm using the following code to POST data to the HTTPS url given below. But I m unable to perform a remote login and access the rest of the website. Can u find out the flaws in the code snippet and rectify it ? Or suggest a new code snippet.

Also can anyone suggest how to open/read the contents of the login restricted pages on a successful login .



$fullurl = "https://premium.rpnet.biz/login.php/";
$postFields="username=&password=&cookieval=on&login=";
$username="";
$password="";
$ch = curl_init();
curl_setopt($ch, CURLOPT_HEADER, 1);
curl_setopt($ch, CURLOPT_VERBOSE, 1);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
curl_setopt($ch, CURLOPT_FAILONERROR, 0);
curl_setopt($ch, CURLOPT_USERPWD, "$username:$password");
curl_setopt($ch, CURLOPT_POSTFIELDS,$postFields);
curl_setopt($ch, CURLOPT_URL, $fullurl);
curl_setopt($ch, CURLOPT_COOKIEFILE, "cookie.txt"); # The name of the file containing the cookie data.
curl_setopt($ch, CURLOPT_COOKIEJAR, "cookie.txt");
$returned = curl_exec($ch);
curl_close ($ch);
var_dump($returned);

---------------------------------------------------------------
Output:

HTTP/1.1 200 OK Date: Fri, 05 Nov 2010 16:27:58 GMT Server: Apache/2.2.3 (CentOS) X-Powered-By: PHP/5.3.3 Set-Cookie: PHPSESSID=nthfd25gn6vpm89k18fpgamgc6; path=/ Expires: Thu, 19 Nov 1981 08:52:00 GMT Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0 Pragma: no-cache Content-Length: 6336 Connection: close Content-Type: text/html; charset=UTF-8

================================================
If I change the url to https://premium.rpnet.biz/usercp.php/
then the output is

HTTP/1.1 302 Found Date: Fri, 05 Nov 2010 16:28:00 GMT Server: Apache/2.2.3 (CentOS) X-Powered-By: PHP/5.3.3 Expires: Thu, 19 Nov 1981 08:52:00 GMT Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0 Pragma: no-cache Set-Cookie: lo[uname]=deleted; expires=Thu, 05-Nov-2009 16:27:59 GMT; path=/; domain=premium.rpnet.biz Set-Cookie: lo[pass]=deleted; expires=Thu, 05-Nov-2009 16:27:59 GMT; path=/; domain=premium.rpnet.biz Location: https://premium.rpnet.biz/login.php Content-Length: 0 Connection: close Content-Type: text/html; charset=UTF-8 bool(true)

The title may be a bit misleading, but essentially what I have is a custom CMS I built in PHP.  What I want to do next is to build some sort of authentication to ensure my code was not copied and reused on another server.
I need some way to communicate between my CMS and an external script to ensure that it is valid.

I was thinking of putting a file on a domain. A simple function that accepts an url this function takes the url, searches the db, if it finds it, send back an result.

My CMS obviously queries this function with the current url of the domain and if the url is in my db, the software works, otherwise it displays a message saying it was illegally copied.

How do I build this interaction between the two?  I could use AJAX, but i need something a bit more robust so that your average developer doesn't figure it out too easily.

Hello everyone
I was working on a code i found on the internet to remotely download a file on my server but for some reason, nothing is been downloaded.
You help is required.

index.php

<html>

<head>

<title>Remote Upload Page</title>

</head>

<body>

<form method="post" action="download.php">

<p align="center"><b><font face="Tahoma">Enter Download URL :</font></b></p>
<p align="center"> <input type="text" name="Link" size="50" dir="ltr">&nbsp;
<input type="submit" name="submit" value="Upload" dir="ltr"> </p>
</body>

</html>


download.php

<?php
define('BUFSIZ', 4095);
$url = $_post['Link'];
$dir = 'files/';
$rfile = fopen($url, 'r');
$lfile = fopen($dir . basename($url), 'w');
fwrite($lfile, fread($rfile, BUFSIZ), BUFSIZ);
fclose($rfile);
fclose($lfile);
echo '<p align="center"><b><font face="Tahoma" size="5" color="#339933">File Remote Download Complete !</font></b></p>';
?> 


I hope anyone can fix this.

Thanks in advance