PHP - If I Have Two Columns, Live Orientation Response

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};

?

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?

*/

?> 

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, 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?

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? 

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;
        }   
    }

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 posting a form using curl:

Code: [Select]
<?php

//create the final string to be posted using implode()
$post_str = implode ('&', $post_items);
  
//Initialize cURL and connect to the remote URL 
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, 'https://leads..html' );

//Instruct cURL to do a regular HTTP POST
curl_setopt($ch, CURLOPT_POST, TRUE);

//Specify the data which is to be posted
curl_setopt($ch, CURLOPT_POSTFIELDS, $post_str);

//Tell curl_exec to return the response output as a string
curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE);

//Follow 302 redirect
curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1);  

// Timeout in seconds
curl_setopt($ch, CURLOPT_TIMEOUT, 30);

//verify https
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);

//Execute the cURL session
$response = curl_exec($ch );

//Close cURL session and file
curl_close($ch);

echo $response;

$resp = explode("\n\r\n", $response);
$header = explode("\n", $resp[0]);

echo "<pre>";
print_r($header);
echo "</pre>";

?>

The response is:

success:  https://www-somesite.html

or

Array
(
    => success: https://www-somesite.html
)

My question is how to get the returned URL and redirect the user to it?

Probably easy but seems to be beyond my very limited php knowledge.

Thanks.

Hi,

I currently have this code:

Code: [Select]
<?php

function respond_xml($status, $message)
{
    $out = new XMLWriter();
    $out->openURI("php://output");
    $out->setIndent(true);

    $out->startDocument("1.0", "ISO-8859-1");

    $out->startElement("statuscheck");
    $out->writeElement("status", $status);
    $out->writeElement("message", $message);
    $out->endElement();

    $out->endDocument();
    
    $out->flush();
}

function main()
{
    header("Content-type: text/xml");

    if (!isset($_GET["file"]))
        respond_xml("ERROR", "File parameter missing");
    else if (file_exists($_GET["file"]))
            return respond_xml("OK", "File exists");
    else
           return respond_xml("NOT OK", "File does not exist");
}

main();

?>
This code works and gives a correct XML response when you type in for example "http://localhost:8080/php/script.php?file=test" it's says:
Code: [Select]
<statuscheck>
<status>NOT OK</status>
<message>File does not exist</message>
</statuscheck>

Now, I need it to be able to check it every 5 seconds so i've use this code
Code: [Select]
header("Refresh: 5; URL=http://localhost:8080/php/script.php?file=test");
Here's my problem:

The first 5 or 10 tries it should say "file not found".
After the 10th try it should automatically say "file found".
BUT it should also time out after like 50 tries and it hasn't found the file.
But i don't know how to do this..

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

I am making a simple login with jQuery ajax but I have a little problem. I get no response from my loginizer.php . 

My login page (index.php) contains the following code.

 

<form action="loginizer.php"  onsubmit="return submitForm();"  method="post" class="box">

<div id="error" ></div>

 <input id="matNo" name="matNo" class="input is-link is-rounded" type="text" placeholder="e.g. 2015/1/55852EE">
   <input id="password" name="password" class="input is-link is-rounded" type="password" placeholder="********">

 <button type="submit"  id="submit" name="submit" class="button is-link is-small">Login</button></form>

 

 

My loginizer php contains the code:

 

<?php
if(isset($_POST['submit'])){
require("db.php");
$table="Students";
$pUser=$_POST['matNo'];
$pPass=$_POST['password'];


$sql= $conn->prepare("SELECT * FROM  $table WHERE Email=?");
$sql->bind_param("s",$pUser);
$sql->execute();
$result = $sql->get_result();
$row = $result->fetch_assoc();
$user= $row['Email'];
$pass = $row['Password'];
$errMsg="Invalid Credentials";
$errMsg1="username doesn't exist";
$successMsg = "successLogin";
if($result->num_rows < 1)
{

echo json_encode($errMsg1);
exit;
}
elseif($pUser == $user && $pPass !== $pass)
{
echo json_encode($errMsg);
exit;
}
else{
echo json_encode($successMsg);
exit;
}
}
?>

 

Ans lastly myJquery.js file which contains:

 

 

function submitForm()
{

 var userid=$("#matNo").val();
 var pass=$("#password").val();
 if(userid!="" && pass!="")
 {

  $("#submit").html("Please Wait...");
  $.ajax
  ({
  type:'post',
  url:'loginizer.php',
  data:{
   matNo:userid,
   password:pass
  },
   dataType:'json',

  success:function(response) {

  if(response=="successLogin")
  {

    window.location.href="dash/home/";
  }
  else
  {

    $("#error").html(response);
    //alert("Wrong Details");
  }
 }

   });
 }

 else
 {
  alert("All details are required");
 }

 return false;
}

 

 

The issue is that I get blank response . If I also change the url in the jQuery/Ajax code to index.php, it comes back with a response consisting of the html of the index.php. If I remove the dataType: 'json', it's still no response.

 

Thanks for your help in advance!!!

Hi,
I submit form data as an xml string -  $strXML - using curl:

curl_setopt($ch, CURLOPT_HEADER, 0);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, '1');
curl_setopt($ch, CURLOPT_POST, true);
curl_setopt($ch, CURLOPT_POSTFIELDS, array('lead'=>$strXML));
$strResult = curl_exec($ch);
// close cURL resource, and free up system resources
curl_close($ch);

The xml response is:

<result>
       <posting_error>0</posting_error>
       <lead>0</lead>
       <valid>1</valid>
       <redirect_url>http://www.xxx.com</redirect_url>
</result>

and I need to redirect the user to <redirect_url>.

I am trying the following:

$xml = new SimpleXMLElement($strResult);
header("Location:" . $xml->result->redirect_url);

but with no joy.
Could anyone suggest how I can achieve what I want?
Thanks.

Ok this is driving me NUTS!

After using SoapClient() this is the response i get back...

Code: [Select]
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

    <soap:Body>
   
        <ns1:GetRegistrationURLResponse xmlns:ns1="http://impl.service.tempuri.com">
       
            <ns1:out>
           
                <errorCode xmlns="http://model.tempuri.com">0</errorCode>
               
                <errorMessage xmlns="http://model.tempuri.com" xsi:nil="true" />
               
                <registrationURL xmlns="http://model.tempuri.com">
                    https://www.tempuri.com/external/authenticate?org=orgname&amp;token=uXiqcPV4%2FuEifbaR80PVBTxH4Oqd3tF%2BiEYaz%2F1OHJG7b5oxN7Bi8AIulmtbwATnjri2P1vCNy%2Fu77OzQEV2lQ%3D%3D
                </registrationURL>
               
            </ns1:out>
               
        </ns1:GetRegistrationURLResponse>
       
    </soap:Body>

</soap:Envelope>

So all i really need to pull out of there is the <registrationURL>

I assign the response to a variable
Code: [Select]
<?php 
$xml_response = $client->__getLastResponse(); 
?>

use SimpleXML
Code: [Select]
<?php 
$xml = simplexml_load_string($xml_response,NULL,NULL,"http://schemas.xmlsoap.org/soap/envelope/"); 
?>

Using the code
Code: [Select]
print_r($xml);
displays this --> SimpleXMLElement Object ( [Body] => SimpleXMLElement Object ( ) )


I have tried many ways, what i have now is this:
Code: [Select]
<?php
$xml->registerXPathNamespace('soap', 'http://schemas.xmlsoap.org/soap/envelope/');
$xml->registerXPathNamespace('ns1', 'http://impl.service.tempuri.com');
#$xml->registerXPathNamespace('registrationURL', 'http://model.tempuri.com');


foreach ($xml->xpath('//ns1:GetRegistrationURLResponse/ns1:out') as $item)    
{ 
   echo $item->asXML();    
}
?>

but the result of that is

0https://www.tempuri.com/external/authenticate?org=nyit&token=uXiqcPV4%2FuEifbaR80PVBTxH4Oqd3tF%2BiEYaz%2F1OHJG7b5oxN7Bi8AIulmtbwATn3QmJanSYWqzS%2FgZM4eR%2Fcg%3D%3D

parsed by browser... actual source XML is

Code: [Select]
<ns1:out><errorCode xmlns="http://model.tempuri.com">0</errorCode><errorMessage xmlns="http://model.tempuri.com" xsi:nil="true"/><registrationURL xmlns="http://model.tempuri.com">https://www.tempuri.com/external/authenticate?org=orgname&amp;token=uXiqcPV4%2FuEifbaR80PVBTxH4Oqd3tF%2BiEYaz%2F1OHJG7b5oxN7Bi8AIulmtbwATn3QmJanSYWqzS%2FgZM4eR%2Fcg%3D%3D</registrationURL></ns1:out>

but i cannot for the life of me just pull out registrationURL so that i can somehow turn it into a link.

Any ideas?

Hi Guys,

I have this SOAP message to be parsed using SimpleXML:

<soap:envelope 
               xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" 
               xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
               xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <soap:body>
    <isokresponse xmlns="http://tempuri.org/">
      <isokresult>1</isokresult>
    </isokresponse>
  </soap:body>
</soap:envelope>

Then I load the XML:

$xml = simplexml_load_string($result);

I assume I need to register namespace e.g.

$xml->registerXPathNamespace("soap","http://schemas.xmlsoap.org/soap/envelope/");

But what's next? How do I get the value of the element isokresult?

Thank you so much

HI,

I need to know how to get the response objects from a webserve call.
I call the following webservice:

$params = array('mobiUser'=>"WJBASSON",'mobiPass'=>"83dop");

$soap = new SoapClient('http://172.18.22.182/csp/ampath/ReportGeneration.Mobi.Services.cls?WSDL'); 

$result = $soap->login($params);  



When I do var_dump($result)
I receive the following:



stdClass Object
(
    [loginResult] => stdClass Object
        (
            [MobiRegUserID] => 34
            [MobiRegUserName] => WJBasson
        )

)




I need to know how can I get the values of objects MobiRegUserID and MobiRegUserName ??