PHP - Xmlrpc - Echo The Response

Hi All,

I'm trying to echo the response from an SLA query, the query works and returns the data when I test it on an SQL application.. but when I run it on my webpage it won't echo the result.

Please help?

<?php   
$mysqli = mysqli_connect("removed", "removed", "removed", "removed");  
$sql = "SELECT posts.message FROM posts INNER JOIN threads ON posts.pid=threads.firstpost WHERE threads.firstpost='1'";  
$result = mysqli_query($mysqli, $sql);   
echo {$result['message']}; 
?>

When I submit the login form its not returning anything and it was working until I added in the $remember part so I'm wondering why its still not returning TRUE.

Code: [Select]
/**
* Login user on the site. Return TRUE if login is successful
* (user exists and activated, password is correct), otherwise FALSE.
*
* @param string
* @param string
* @param int
* @return bool
*/
    function login($username, $password, $remember)
    {   
        $this->ci->load->model('kow_auth/users');
        $user_data = $this->ci->users->get_user_by_username($username);
       
        if ($user_data)
        {
            $regenFromPostPW = $this->ci->genfunc->reGenPassHash($password, $user_data->password2);
            if ($regenFromPostPW == $user_data->password)
            {
                $this->ci->session->set_userdata(array(
                                'xtr'       => 'yes',
'user_id' => $user_data->user_id,
'username' => $user_data->username,
'status' => $user_data->users_statuses_id,
                                'role'  => $user_data->users_roles_id
));
                if ($remember == 1)
                {
                    $timeTOexpire = time()+(60*60*24*31*2);
                    $this->input->set_cookie('xtrcook', '1', $timeTOexpire);
                }
                else
                {
                    $cookie = trim(get_cookie('xtrcook'));
                    if ($cookie || is_numeric($cookie))
                    {
                        delete_cookie('xtrcook');
                    }
                }
                $this->clear_login_attempts($user_data->user_id);
                $this->ci->users->insert_session($this->ci->session->userdata('session_id'), $this->ci->session->userdata('user_id'), $this->ci->genfunc->getRealIpAddr(), $this->ci->genfunc->getUserOS());
                return TRUE;
            }
            else
            {
                $this->increase_login_attempt($user_data->user_id);
            }
        }
        else
        {
            return NULL;
        }   
    }

Folks,

I have a mysql tbl called "links".

In it a column named "keywords".

The row 0 has a keyword "search" in the "keywords" column.

I am doing a search for the words "search" in the html form. Clicking the button gives no response! What is wrong ?

I get no mysql connection error. Nor any php error. So it should work and respond!

	<form name = "search" method = "POST" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<label for="keywords">Keywords:*</label>
<input type="text" name="keywords" id="keywords" placeholder="Input Keywords" required>
<br>
<input type="button" name="search_links" id="search_links" value="Search Links!">
<br>
<input type="reset">
<br>
</form>
	

 

Full short code ...

	<?php
//include('error_reporting.php');
ini_set('error_reporting','E_ALL');//Same as: error_reporting(E_ALL);
ini_set('display_errors','1');
ini_set('display_startup_errors','1');
?>
	<form name = "search" method = "POST" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<label for="keywords">Keywords:*</label>
<input type="text" name="keywords" id="keywords" placeholder="Input Keywords" required>
<br>
<input type="button" name="search_links" id="search_links" value="Search Links!">
<br>
<input type="reset">
<br>
</form>
	<?php
	if($_SERVER['REQUEST_METHOD'] === 'POST')
{
    if(ISSET($_POST['search_links']))
    {
        if(ISSET($_POST['keywords']))
        {
            $keywords = $_POST['keywords'];
        }        
        
        mysqli_report(MYSQLI_REPORT_ALL|MYSQLI_REPORT_STRICT);
        mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
        
        $conn = mysqli_connect("localhost","root","","test");
        $db_server = 'localhost';
        $db_user = 'root';
        $db_password = '';
        $db_database = 'test';
        $conn->set_charset('utf8mb4');//Always use Charset.
        
        if (!$conn)
        {
            //Error Message to show user in technical/development mode to see errors.
            die("Database Error : " . mysqli_error($conn));
            
            //Error Message to show User in Layman's mode to see errors.
            die("Database error.");
            exit();
        }
	        $query = "SELECT page_url,link_anchor_text,page_description,keyphrases,keywords FROM links WHERE keywords = ?";
	        $stmt = mysqli_stmt_init($conn);
	        if(mysqli_stmt_prepare($stmt,$query))
        {
            mysqli_stmt_bind_param($stmt,'s',$keywords);
	            $result = mysqli_stmt_bind_result($stmt,$page_url,$link_anchor_text,$page_description,$keyphrase,$keywords);
            mysqli_stmt_execute($stmt);
            
            mysqli_stmt_fetch($stmt);
            
            while(mysqli_stmt_fetch($result))
            {
                echo "url"; echo "<br>";
                echo "anchor_text"; echo "<br>";
                echo "description"; echo "<br>";
                echo "keyphrases"; echo "<br>";
                echo "keywords"; echo "<br>";
                echo "|";
                echo "<br>";
            }
            
            mysqli_stmt_close($stmt);
            mysqli_close($conn);
        }
        else
        {
            echo "1. QUERY failed!";
        }
	        if(mysqli_stmt_prepare($stmt,$query))
        {
            mysqli_stmt_bind_param($stmt,'s',$keywords);
            mysqli_stmt_execute($stmt);
            
            $result = mysqli_stmt_get_result($stmt);
            
            while($row = mysqli_fetch_array($result,mysqli_assoc))
            {
                $page_url = $row['page_url']; echo $page_url; echo "<br>";
                $link_anchor_text = $row['link_anchor_text']; echo $link_anchor_text; echo "<br>";
                $page_description = $row['page_description']; echo $page_description; echo "<br>";
                $keyphrases = $row['keyphrases']; echo $keyphrases; echo "<br>";
                $keywords = $row['keywords']; echo $keywords; echo "<br>";
                echo "|";
                echo "<br>";
            }
            
            mysqli_stmt_close($stmt);
            mysqli_close($conn);
        }
        else
        {
            die("2. QUERY failed!");
        }
    }
}
	
?>
	

Hello All,

Just working with PHP's snap v1 functions I can use snmpget fine but snmpset produces the following error;

Warning: snmpset() [function.snmpset]: No response from 192.....

Code

Code: [Select]
<?PHP

echo 'File started <br />';

$ip = '192.168.1.100';
echo 'Read:<br />';
      $sysdescr = snmpget($ip, 'public', '.1.3.6.1.4.1.17095.3.4.0', 300);

   
   echo $sysdescr;
   echo 'Write Started:<br />';
   snmpset("$ip", 'public', '.1.3.6.1.4.1.17095.4.7.2.0', 's', 'sam@samtwilliams.co.uk', 300);

?>
Like i said the get works fine just the set does not.

Does anyone have any ideas?

Sam

Hello,

I'm trying to get webservice response in xml format. I'm getting the response but it's not in xml. It's just text.

Can someone please look at the code ?

<?php

$targeturl="https://api.com";

$DevKey= "xxxxx";

// return xml feed

$ch = curl_init($targeturl);
curl_setopt($ch, CURLOPT_POST, FAlSE);
curl_setopt($ch, CURLOPT_HTTPHEADER, array('Authorization: '.$DevKey));
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE);
$response = curl_exec($ch);
$xml = new SimpleXMLElement($response);
curl_close($ch);
echo $response; // will print in browser all country codes in an xml format

/*

ADD YOUR OWN CODE HERE TO DO WHAT YOU WANT WITH THE RESPONSE.  MAYBE SAVE RESULTS TO A FILE OR THE PARSE THE RESULTS INTO A DATABASE?

*/

?> 

How can I receive a response from the server with JSON data, when the function that retrieves the data and returns it to the browser has been completely commented out? 

I am making an AJAX request for JSON formatted data and for some reason it returns a response when it shouldn't as there is no function? 

Hello All, running into a situation that I have not seen before.  I have been seeing in multiple areas of my application that the response received from the server has 2 JSON responses in it.  Here is a sample function:

private function getCatalogItems(){

$start = ($_REQUEST["start"] == null)? 0 : $_REQUEST["start"];

$count = ($_REQUEST["limit"] == null)? 20 : $_REQUEST["limit"];

$q = "SELECT c.`id`, c.`catalog_number`, c.`long_description`, CONCAT(c.`catalog_number`, ' - ', c.`long_description`) AS `display` 

FROM catalog c";

if(!empty($_REQUEST['query'])){

$q .= " WHERE c.`catalog_number` LIKE '%".$_POST['query']."%'";

}

$q .= " ORDER BY c.`catalog_number` ASC LIMIT ".$start.",".$count;

$rs = $this->db->get_results($q);

$total = $this->db->num_rows;

$buff = '{"total":"'.$total.'","data":'.json_encode($rs).'}';

$this->c->returnJSON($buff);

}

The "returnJSON" function looks like this.

public function returnJSON($json){

 

$contentType = "application/json; charset=utf-8";

header("Content-Type: {$contentType}");

header("Content-Size: " . strlen($json));

echo $json;

 

}

As you can see this simply sets the headers of the response.  It has been a real head scratcher.  Anyone come across something like this before?

I send off this:


<?php
$data = "<egateway>
<eCardExpiryMonth>01</eCardExpiryMonth>
<eCardExpiryYear>04</eCardExpiryYear>
<eCardHoldersName>Joe Bloke</eCardHoldersName>
<eCardNumber>4444333322221111</eCardNumber>
<eCVN>123</eCVN>
<eTotalAmount>100</eTotalAmount>
</egateway>
";
$ch = curl_init();
curl_setopt($ch, CURLOPT_POSTFIELDS, $edata);
curl_setopt($ch, CURLOPT_URL, "https://www.example.com/gateway_cvn/testpage.asp");
curl_exec($ch);
curl_close($ch);
?>


In return, I get the following XML:

Code: [Select]
<eResponse>
<eTrxnStatus>True</eTrxnStatus>
<eTrxnNumber>20219</eTrxnNumber>
<eAuthCode>123456</eAuthCode>
<eReturnAmount>100</eReturnAmount>
<eTrxnError>00,Transaction Approved(Test CVN Gateway)</eTrxnError>
</eResponse>

Is there a way to make it so this does not show, and instead I can make PHP do something like:

if (eTrxnStatus == True) {// do stuff};

?

I have this php file that processes Form field entries. Apparently I need to modify it, I'm told, to "validate the input and then send some response back":

<?php
if($_POST){
	$to = 'chrisj...@.....com';
	$subject = 'Thank you for your info';
	$name = $_POST['name'];
	$email = $_POST['email'];
	$message = $_POST['message'];
	$message1 = $_POST['message'];
	$headers = $name;
	$headers = 'from: info@.....com';
	$message1 .= "\r\n\r\nName: ".$_POST['name']." \r\n Email: ".$_POST['email']." ";
	$message = "Hello {$_POST['name']}, ~ Thank you for your input\r\n\r\n";
   		mail( $to, $subject, $message1, $headers );
   		mail( $email, $subject, $message, $headers );
		header('Location: https://....');
   exit;
}
?>

The corresponding js looks like this:

$.ajax({
  url: 'https://...../submit.php',
  method: 'post',
  data: {
    name: $('#name').val(),
    email: $('#email').val()
  },
  success: function (response) {
    console.log(response);
    if (response.success) {
      alert('Success');
    } else {
      alert('Error');
    }
  }
});

I look forward to any guidance with adding "validate the input and then send some response back".

 

I have an application which receives multiple requests at once and it advantageous to process them as a group.

I am thinking I should be doing something like the following, however, as I just came up with it on my own, would appreciate a critique.  Is this a common design pattern or should I be doing something differently?  Note that I have three questions asking specific questions in the below code (look for the comments with question marks).

Thanks
 

<?php
class Request
{
    private $response, $data;

    public function __construct(array $data)
    {
        $this->data=$data;
        return $this->response=new Response($this);
    }    

    public function getResponse():Response
    {
        return $this->response;
    }

    public function updateResponse($results):self
    {
        $this->response->setResults($results);
        return $this;
    }
}

<?php
class Response
{
    private $request, $results;

    public function __construct(Request $request)
    {
        //I don't really see the need for this.  Any need?
        $this->request=$request;
    }

    public function setResults($results):self
    {
        $this->results=$results;
        return $this;
    }

    public function getResults()
    {
        return $this->results;        
    }
}

 

<?php
class Container implements \Iterator
{
    private $position = 0;
    private $requests, $response;

    public function __construct(WorkerObject $worker, array $inputArray)
    {
        $this->requests=[];
        $this->responses=[];
        foreach($inputArray as $i =>$inputData) {
            $this->requests[$i]=new Request($inputData);
            $this->responses[]=$this->responses[$i]->getResponse();
        }

        //Should WorkerObject be responsible to execute Request::updateResponse() method? 
        $worker->process_requests(...$this->requests);

        //Or should I iterate over my requests upon completion and execute updateResponse() method? 
    }

    public function __construct() {
        $this->position = 0;
    }

    public function rewind() {
        $this->position = 0;
    }

    public function current() {
        return $this->responses[$this->position];
    }

    public function key() {
        //Will this work?
        return $this->requests[$this->position];
    }

    public function next() {
        ++$this->position;
    }

    public function valid() {
        return isset($this->responses[$this->position]);
    }
}

<?php
//...
$container=new Container(new WorkerObject, $inputArray);
foreach($container as $request => $response) {
    //...
}

 

I have a soap client written up that works well on small requests, but on large ones I face out of memory issues.

I want to be able to write the response directly to a file as an xml document, so I can use something like xpath.

When I try this even on small responses it seems to go into a loop:
  $infile = $client->Retrieve($criteria);
  $outfile = fopen('./sites/all/modules/cvent/data.txt', 'w');
  while (!feof($infile)) {
    fwrite($outfile, fread($infile, 2048));
    }

how can I put the data into a file straight from the response and still be economical on memory?

Hi   I'm having this issue, when i put an url who must show me records i have blank html page

<?php
error_reporting(E_ALL | E_NOTICE);
ini_set('display_errors', '1');
require_once 'database_connection.php';
	$post=array(
		'limit'=>(isset($_REQUEST['rows']))?$_REQUEST['rows']:'',
		'page'=>(isset($_REQUEST['page']))?$_REQUEST['page']:'',
		'orderby'=>(isset($_REQUEST['sidx']))?$_REQUEST['sidx']:'',
		'orden'=>(isset($_REQUEST['sord']))?$_REQUEST['sord']:'',
		'search'=>(isset($_REQUEST['_search']))?$_REQUEST['_search']:'',
	);
	$se ="";
	if($post['search'] == 'true'){
		$b = array();
		$search['like']=elements(array('utilizador','email'),$_REQUEST);
		foreach($search['like'] as $key => $value){
			if($value != false) $b[]="$key like '%$value%'";
		}
		$search['where']=elements(array('nome','utilizador','email'),$_REQUEST);
		foreach($search['where'] as $key => $value){
			if($value != false) $b[]="$key = '$value'";
		}
		$se=" where ".implode(' and ',$b );		
	}
	$query = mysql_query("select count(*) as t from utilizador".$se);
	if(!$query)
		echo mysql_error();
	$count = mysql_result($query,0);
	if( $count > 0 && $post['limit'] > 0) {
		$total_pages = ceil($count/$post['limit']);
		if ($post['page'] > $total_pages) $post['page']=$total_pages;
		$post['offset']=$post['limit']*$post['page'] - $post['limit'];
	} else {
		$total_pages = 0;
		$post['page']=0;
		$post['offset']=0;
	}
	$sql = "SELECT idutilizador, nome, utilizador, telefone, email, password FROM utilizador  ".$se;
	if( !empty($post['orden']) && !empty($post['orderby']))
	$sql .= " ORDER BY $post[orderby] $post[orden] ";
	if($post['limit'] && $post['offset']) $sql.=" limit $post[offset], $post[limit]";
	elseif($post['limit']) $sql .=" limit 0,$post[limit]";
	$query = mysql_query($sql);
	if(!$query)
	echo mysql_error();
	$result = array();
	$i = 0;
	while($row = mysql_fetch_object($query)){
		$result[$i]['id']=$row->idutilizador;
		$result[$i]['cell']=array($row->idutilizador,$row->nome,$row->utilizador,$row->telefone,$row->email,$row->password);
		$i++;	
	}
	$json = new stdClass();
	$json->rows=$result;
	$json->total=$total_pages;
	$json->page=$post['page'];
	$json->records=$count;
	echo json_encode($json);	
	function elements($items, $array, $default = FALSE)
	{
		$return = array();
		if ( ! is_array($items)){
			$items = array($items);
		}
		foreach ($items as $item){
			if (isset($array[$item])){
				$return[$item] = $array[$item];
			}else{
				$return[$item] = $default;
			}
		}
		return $return;
	}
?>

*Update   It works if i put

$result[$i]['cell']=array($row->idutilizador,$row->telefone,$row->email,$row->password);

So i'm think it's because in $nome(ex: Luis Miguel) and $utlizador(ex Susana Maria)  don't accept this (space between words) it is correct?
Edited by alphasil, 19 January 2015 - 08:54 AM.

Hi,   I'm getting the following response using:

$json_object = json_decode($unparsed_json, true);

array(1) {
  ["google.com"]=>
  array(2) {
    ["status"]=>
    string(16) "regthroughothers"
    ["classkey"]=>
    string(6) "domcno"
  }
}

How do I echo the attribute of the ['status']? I have tried using:

echo $json_object->['status'];

Thanks,   MoFish

It's been quite a while since I have coded in PHP and I am running into difficulties looping through the returned response from an API.  I am pretty comfortable in my PHP skills, but for some reason I keep getting caught up trying to loop through the following... Many of the returns from the API include several more layers of Objects, the example below is about the most simplistic return from the API.     I'm sure I'm just missing something easy and any help or example code simply looping through and echoing each result would be greatly appreciated!!  Ideally I would like to be able to loop through both of the scenarios below.     I did a var_dump on the response and here is what I get:

array (size=1)
  'Body' => 
    object(stdClass)[6]
      public 'userContext' => 
        object(stdClass)[8]
          public 'convCred' => 
            object(stdClass)[10]
              ...
          public 'valid' => boolean true
          public 'isPasswordExpired' => boolean false
          public 'cbId' => int 0083802121
          public 'cnId' => int 1000545
          public 'locale' => string 'en_US' (length=5)
          public 'tncVersion' => int 2
          public 'applicationId' => string 'ECFDA1FDBC00270772870CDC1786FFED' (length=32)
          public 'cbConvCred' => 
            object(stdClass)[9]
              ...
          public 'preferenceInfo' => 
            object(stdClass)[7]
              ...
      public 'lastLoginTime' => int 1406729928
      public 'loginCount' => int 282
      public 'passwordRecovered' => boolean false
      public 'emailAddress' => string 'abc@123.com' (length=11)
      public 'loginName' => string 'TEST' (length=8)
      public 'userId' => int 15932274
      public 'userType' => 
        object(stdClass)[14]
          public 'userTypeId' => int 1
          public 'userTypeName' => string 'normal_user' (length=11)
      public 'isConfirmed' => boolean false

 If I jsonencode and jsondecode the response this is what I get:

object(stdClass)[13]
  public 'Body' => 
    object(stdClass)[17]
      public 'userContext' => 
        object(stdClass)[18]
          public 'convCred' => 
            object(stdClass)[19]
              ...
          public 'valid' => boolean true
          public 'isPasswordExpired' => boolean false
          public 'cbId' => int 0083802121
          public 'cnId' => int 1000545
          public 'locale' => string 'en_US' (length=5)
          public 'tncVersion' => int 2
          public 'applicationId' => string 'ECFDA1FDBC00270772870CDC1786FFED' (length=32)
          public 'cbConvCred' => 
            object(stdClass)[20]
              ...
          public 'preferenceInfo' => 
            object(stdClass)[21]
              ...
      public 'lastLoginTime' => int 1406729953
      public 'loginCount' => int 283
      public 'passwordRecovered' => boolean false
      public 'emailAddress' => string 'abc@123.com' (length=11)
      public 'loginName' => string 'TEST' (length=8)
      public 'userId' => int 15932274
      public 'userType' => 
        object(stdClass)[24]
          public 'userTypeId' => int 1
          public 'userTypeName' => string 'normal_user' (length=11)
      public 'isConfirmed' => boolean false