PHP - Problem With Parsing Curl Result

I have a situation were I need to just get a simple location.

I don't want any while loops or any of that jazz. 

I just want 1 string location every time. 

<?php

$ider = $_GET['id'];

        $conn = mysqli_connect("localhost", "Me", "pass", "MyDB"); 
        // Check connection
        if ($conn->connect_error) {
            die("Connection failed: " . $conn->connect_error);
            }
            
        $sql = "SELECT Location FROM LifeSaver1 WHERE id =$ider";
        $result = $conn->query($sql);
        $obj = mysqli_fetch_object($result);
        $obj2 = $obj->Location;
        var_dump($obj);
?>

This is what it outputs 

Quote

string(11) "Boston"

I just need Boston. Can anyone give me a hint? 

Folks,

I want to parse a particular element from an array and nothing else.

Here is the Class (RecursiveTwitterSearch.php):

<?
/**
 * Wrapper class around the Twitter Search API for PHP
 * Based on the class originally developed by David Billingham
 * and accessible at http://twitter.slawcup.com/twitter.class.phps
 * @author Ryan Faerman <ryan.faerman@gmail.com>
 * @version 0.2
 * @package PHPTwitterSearch
 */
class TwitterSearch {
/**
 * Can be set to JSON (requires PHP 5.2 or the json pecl module) or XML - json|xml
 * @var string
 */
var $type = 'json';

/**
 * It is unclear if Twitter header preferences are standardized, but I would suggest using them.
 * More discussion at http://tinyurl.com/3xtx66
 * @var array
 */
var $headers=array('X-Twitter-Client: PHPTwitterSearch','X-Twitter-Client-Version: 0.1','X-Twitter-Client-URL: http://ryanfaerman.com/twittersearch');

/**
 * Recommend setting a user-agent so Twitter knows how to contact you inc case of abuse. Include your email
 * @var string
 */
var $user_agent='';

/**
 * @var string
 */
var $query='';

/**
 * @var array
 */
var $responseInfo=array();

/**
 * Use an ISO language code. en, de...
 * @var string
 */
var $lang;

/**
 * The number of tweets to return per page, max 100
 * @var int
 */
var $rpp;

/**
 * The page number to return, up to a max of roughly 1500 results
 * @var int
 */
var $page;

/**
 * Return tweets with a status id greater than the since value
 * @var int
 */
var $since;

/**
 * Returns tweets by users located within a given radius of the given latitude/longitude, where the user's location is taken from their Twitter profile. The parameter value is specified by "latitide,longitude,radius", where radius units must be specified as either "mi" (miles) or "km" (kilometers)
 * @var string
 */
var $geocode;

/**
 * When "true", adds "<user>:" to the beginning of the tweet. This is useful for readers that do not display Atom's author field. The default is "false"
 * @var boolean
 */
var $show_user = false;

/**
* @param string $query optional
*/
function TwitterSearch($query=false) {
$this->query = $query;
}

/**
* Find tweets from a user
* @param string $user required
* @return object
*/
function from($user) {
$this->query .= ' from:'.str_replace('@', '', $user);
return $this;
}

/**
* Find tweets to a user
* @param string $user required
* @return object
*/
function to($user) {
$this->query .= ' to:'.str_replace('@', '', $user);
return $this;
}

/**
* Find tweets referencing a user
* @param string $user required
* @return object
*/
function about($user) {
$this->query .= ' @'.str_replace('@', '', $user);
return $this;
}

/**
* Find tweets containing a hashtag
* @param string $user required
* @return object
*/
function with($hashtag) {
$this->query .= ' #'.str_replace('#', '', $hashtag);
return $this;
}

/**
* Find tweets containing a word
* @param string $user required
* @return object
*/
function contains($word) {
$this->query .= ' '.$word;
return $this;
}

/**
* Set show_user to true
* @return object
*/
function show_user() {
$this->show_user = true;
return $this;
}

/**
* @param int $since_id required
* @return object
*/
function since($since_id) {
$this->since = $since_id;
return $this;
}

/**
* @param int $language required
* @return object
*/
function lang($language) {
$this->lang = $language;
return $this;
}

/**
* @param int $n required
* @return object
*/
function rpp($n) {
$this->rpp = $n;
return $this;
}

/**
* @param int $n required
* @return object
*/
function page($n) {
$this->page = $n;
return $this;
}

/**
* @param float $lat required. lattitude
* @param float $long required. longitude
* @param int $radius required. 
* @param string optional. mi|km
* @return object
*/
function geocode($lat, $long, $radius, $units='mi') {
$this->geocode = $lat.','.$long.','.$radius.$units;
return $this;
}

/**
* Build and perform the query, return the results.
* @param $reset_query boolean optional.
* @return object
*/
function results($reset_query=true) {
$request  = 'http://search.twitter.com/search.'.$this->type;
$request .= '?q='.urlencode($this->query);

if(isset($this->rpp)) {
$request .= '&rpp='.$this->rpp;
}

if(isset($this->page)) {
$request .= '&page='.$this->page;
}

if(isset($this->lang)) {
$request .= '&lang='.$this->lang;
}

if(isset($this->since)) {
$request .= '&since_id='.$this->since;
}

if($this->show_user) {
$request .= '&show_user=true';
}

if(isset($this->geocode)) {
$request .= '&geocode='.$this->geocode;
}

if($reset_query) {
$this->query = '';
}

return $this->objectify($this->process($request))->results;
}

/**
* Returns the top ten queries that are currently trending on Twitter.
* @return object
*/
function trends() {
$request  = 'http://search.twitter.com/trends.json';

return $this->objectify($this->process($request));
}

/**
 * Internal function where all the juicy curl fun takes place
 * this should not be called by anything external unless you are
 * doing something else completely then knock youself out.
 * @access private
 * @param string $url Required. API URL to request
 * @param string $postargs Optional. Urlencoded query string to append to the $url
 */
function process($url, $postargs=false) {
$ch = curl_init($url);
if($postargs !== false) {
curl_setopt ($ch, CURLOPT_POST, true);
curl_setopt ($ch, CURLOPT_POSTFIELDS, $postargs);
        }
        
        curl_setopt($ch, CURLOPT_VERBOSE, 1);
        curl_setopt($ch, CURLOPT_NOBODY, 0);
        curl_setopt($ch, CURLOPT_HEADER, 0);
        curl_setopt($ch, CURLOPT_USERAGENT, $this->user_agent);
        curl_setopt($ch, CURLOPT_FOLLOWLOCATION,1);
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
        curl_setopt($ch, CURLOPT_HTTPHEADER, $this->headers);

        $response = curl_exec($ch);
        
        $this->responseInfo=curl_getinfo($ch);
        curl_close($ch);
        
        if( intval( $this->responseInfo['http_code'] ) == 200 )
return $response;    
        else
            return false;
}

/**
 * Function to prepare data for return to client
 * @access private
 * @param string $data
 */
function objectify($data) {
if( $this->type ==  'json' )
return (object) json_decode($data);

else if( $this->type == 'xml' ) {
if( function_exists('simplexml_load_string') ) {
$obj = simplexml_load_string( $data );

$statuses = array();
foreach( $obj->status as $status ) {
$statuses[] = $status;
}
return (object) $statuses;
}
else {
return $out;
}
}
else
return false;
}
}






class RecursiveTwitterSearch extends TwitterSearch {
    var $request_count = 0;
    var $max_request_count = 5;
    var $max_id;
 
    function recursive_results() {
        $request  = 'http://search.twitter.com/search.'.$this->type;
        $request .= '?q='.urlencode($this->query);
 
        if(isset($this->rpp)) {
            $request .= '&rpp='.$this->rpp;
        }
 
        if(isset($this->page)) {
            $request .= '&page='.$this->page;
        }
 
        if(isset($this->lang)) {
            $request .= '?='.$this->lang;
        }
 
        if(isset($this->since)) {
            $request .= '&since_id='.$this->since;
        }
 
        if($this->show_user) {
            $request .= '&show_user=true';
        }
 
        if(isset($this->geocode)) {
            $request .= '&geocode='.$this->geocode;
        }
 
        if(isset($this->max_id)) {
            $request .= '&max_id='.$this->max_id;
        }
 
        $response = $this->objectify($this->process($request));
        $this->request_count++;
        if ($response) {
            $results = $response->results;
            if(!empty($response->next_page)) {
                preg_match('|\?page=([0-9]*)&max_id=([0-9]*)&|', $response->next_page, $matches);
                $this->page = $matches[1];
                $this->max_id = $matches[2];
                if ($this->request_count < $this->max_request_count) {
                    $results = array_merge($results, $this->recursive_results());
                }
            }
            return $results;
        }
        else return false;
    }
    function max_request_count($n) {
        $this->max_request_count = $n;
        return $this;
    }
}











?>



Here is how i am calling it:

<?php
require ("RecursiveTwitterSearch.php");
    $rts = new RecursiveTwitterSearch('paintball mask');
    echo '<pre>';
    print_r($rts->recursive_results());
    echo '</pre>';
    echo 'It took ' . $rts->request_count . ' request(s) to get this result.';
?>


If you observer the Output, u will see lot of array, i want to extract only "[text]" portion. 

So the desired output should be like:
Quote

vPaintball Mask http://bit.ly/czBA6S
The Paintball Republic does a short video about mask safety. LEARN. http://fb.me/KkMvjDWF
airsoft vs paintball mask http://goo.gl/fb/tyoxk
@mmorgansmithh like wearing a paintball mask on your head to starbucks
Tippmann US Army Ranger Paintball Goggle Mask - Camo: Tippmann US Army Ranger Paintball Goggle Mask - Camo ... http://bit.ly/9hFi3p

and so on.........





Infact, i prfer to use "foreach" to each each element so i can do further operation on it.

Can anyone help to achieve this?

Natty

I'm practicing some code

here

Code: [Select]
reset($_POST);

while (list ($key, $val) = each ($_POST)) {
if ($val == "";)  $val = "NULL";
$arVals[$key] = (get_magic_qqotes_gpc())  ? $val : addslashes($val);

if($val == "NULL")
$_SESSION[$key] = NULL;
else
$_SESSION[$key] = $val;


if ($key != "access_period" && $key != "passwd")
$arVals[$key] = "'".$arVals[$key]."'";


}

And it's giving me error

Quote

Parse error: parse error in C:\wamp\www\php\user_registration\registered.php on line 26



line 26 is the
Code: [Select]
if ($val == "";)  $val = "NULL";

I wonder what the problem is...

First, apologies if this is in the wrong section, basically I am not sure what language my problem lies!

Here is the general over view.

I have a jquery script that automatically selects a group of sub categorys and pus them in a select list depending on the input of a first select list, so you can choose you main cat and then the sub cats for this cat appear in the next list, this all works fine, the basic code is below:
Code: [Select]
<script type="text/javascript">
$(document).ready(function() {
$('#wait_1').hide();
$('#drop_1').change(function(){
  $('#wait_1').show();
  $('#result_1').hide();
      $.get("scripts/func.php", {
func: "drop_1",
drop_var: $('#drop_1').val()
      }, function(response){
        $('#result_1').fadeOut();
        setTimeout("finishAjax('result_1', '"+escape(response)+"')", 400);
      });
    return false;
});
});

function finishAjax(id, response) {
  $('#wait_1').hide();
  $('#'+id).html(unescape(response));
  $('#'+id).fadeIn();
}
</script>
<form action='do.php' method='post'>
<select name="drop_1" id="drop_1">
                <option value="" selected="selected" disabled="disabled">Select a Category</option>
                <?php getTierOne(); ?>
                </select>
                 <span id="wait_1" style="display: none;">
                 <img alt="Please Wait" src="images/ajax-loader.gif"/>
                 </span>
                 <span id="result_1" style="display: none;"></span>

This calls scripts/func.php
Code: [Select]
<?php
//**************************************
//     Page load dropdown results     //
//**************************************
function getTierOne()
{
$result = mysql_query("SELECT * FROM blog_cats") 
or die(mysql_error());

  while($tier = mysql_fetch_array( $result )) 
  
{
   echo '<option value="'.$tier['cat_id'].'">'.$tier['cat_name'].'</option>';
}

}

//**************************************
//     First selection results     //
//**************************************
if($_GET['func'] == "drop_1" && isset($_GET['func'])) { 
   drop_1($_GET['drop_var']); 
}

function drop_1($drop_var)
{  
    include_once('../connect.php');
$result = mysql_query("SELECT * FROM blog_subs WHERE cat_id='$drop_var'") 
or die(mysql_error());

echo '<select name="tier_two" id="tier_two">
      <option value=" " disabled="disabled" selected="selected">Select Sub Catergory</option>';

   while($drop_2 = mysql_fetch_array( $result )) 
{
  echo '<option value="'.$drop_2['sub_id'].'">'.$drop_2['sub_name'].'</option>';
}

echo '</select> ';
    
}
?>

The problem I am having is getting the second select (tier_two) to pass to my form processing page.

I just get an undefined variable error

Many Thanks

Hallo

I'm having a problem inserting $messageorder into mysql datebase.  Otherwise works good. So there is no problem with database itself or mysql command too.
I suspect there must be something in this code that mysql doesnt like. Also have to say that im able to sent email with $messageorder.

Please take a look at the codee.

Code: [Select]


$messageorder = "\r\n" . 'Order:' .
                    '<br><br><table>' . "\r\n";


$result3 = mysql_query("SELECT * FROM orderslist WHERE supplier='$supplier'") or die(mysql_error());
$data = array();
$data['' . $row3['id']] = $_POST['' . $row3['id']];

while($row3=mysql_fetch_array($result3))
{
$value = $_POST['' . $row3['id']];
if ( $value == ""){

}
else {

$messageorder .= "
<tr>
    <td class='H4'><strong>$row3[name]</strong></td>
<td class='H4' align='center'>$value</td>
<td class='H4'>$row3[unit]</td>
</tr>
";
}

 }
$messageorder .= "</table>";


echo $messageorder;

date_default_timezone_set('Europe/London');
$supplier=$_GET['order'];

$delivery=$_POST['delivery'];
$timestamp = date("H:i:s");
$datestamp = date('Y/m/d');

mysql_query ("INSERT INTO orders (id, datestamp, timestamp, supplier, ordertext, delivery )

  VALUES ('', '$datestamp', '$timestamp', '$supplier', '$messageorder', '$delivery')");

If someone could help to find a solution I will appriciate !

Thank you very much

Hey there,

I am using prototype to send JSON information to a PHP file which will then use the data to update a database, the AJAX presently looks as follows:

Code: [Select]
function saveprofile()
{
var email = document.getElementById("email").value;

var profileDetails =
{
"email":email,
"titleitalic":titleitalic,
"profileDetails":titlefontcolor,
"titlefontcolor":titleunderline,
"titleoffsettop":titleoffsettop,
"titleoffsetleft":titleoffsetleft,
"aboutbackgroundcolour":aboutbackgroundcolour,
"aboutunderline":aboutunderline,
"aboutfontfamily":aboutfontfamily,
"aboutbold":aboutbold,
"aboutitalic":aboutitalic,
"aboutfontcolor":aboutfontcolor,
"aboutoffsettop":aboutoffsettop,
"aboutoffsetleft":aboutoffsetleft,
"statusoffsetleft":statusoffsetleft,
"statusinfooffsetright":statusinfooffsetright,
"pictureoffsetleft":pictureoffsetleft,
"profilebold":profilebold,
"profileunderline":profileunderline,
"profileitalic":profileitalic,
"profilefontcolor":profilefontcolor,
"profilefontfamily":profilefontfamily,
"profilebackgroundcolour":profilebackgroundcolour
}

var jsonstring = JSON.stringify(profileDetails);
alert(jsonstring);

   var request = new Ajax.Request
        ('scripts/updateprofile.php',
            { method: 'POST',
              parameters: jsonstring,
              onComplete: responseReturned }
        );
}


Which outputs the following JSON which has been tested on http://www.jsonlint.com/ as valid:

Code: [Select]
{
    "email": "l-wilson-1986@hotmail.co.uk",
    "titleitalic": "normal",
    "profileDetails": "#d0deea",
    "titlefontcolor": "none",
    "titleoffsettop": 100,
    "titleoffsetleft": 100,
    "aboutbackgroundcolour": "transparent",
    "aboutunderline": "none",
    "aboutfontfamily": "Arial",
    "aboutbold": "normal",
    "aboutitalic": "normal",
    "aboutfontcolor": "#d0deea",
    "aboutoffsettop": 325,
    "aboutoffsetleft": 100,
    "statusoffsetleft": 450,
    "statusinfooffsetright": 250,
    "pictureoffsetleft": 100,
    "profilebold": "normal",
    "profileunderline": "none",
    "profileitalic": "normal",
    "profilefontcolor": "#fff",
    "profilefontfamily": "Arial",
    "profilebackgroundcolour": "#2c3c49"
}

The PHP file which receives the JSON looks as follows:

Code: [Select]
<?php

$myjson = $_POST['jsonstring'];
$jsonchars = json_decode(($myjson), true);

$json_errors = array(
    JSON_ERROR_NONE => 'No error has occurred',
    JSON_ERROR_DEPTH => 'The maximum stack depth has been exceeded',
    JSON_ERROR_CTRL_CHAR => 'Control character error, possibly incorrectly encoded',
    JSON_ERROR_SYNTAX => 'Syntax error',
);
 echo 'Last error : ', $json_errors[json_last_error()], PHP_EOL, PHP_EOL;

// do something with the data

?>

The problem is the PHP constantly returns the following error: Last error : Syntax error and any attempts to access the JSON data returns NULL values. I have looked at several online examples and cannot see where I might be going wrong, and although users have had problems with syntax errors it normally relates to incorrect JSON.

Any advice on this topic would be greatly appeciated

Leanne

I'm trying to submit to my site using this script that I made:
<?php
session_start();
$title = "<title>CS</title>";
$url =  "http://cheatskape.com/wtag/sendchat.php";
$token = md5(uniqid(rand(), true));
$_SESSION['token'] = $token;
$ch = curl_init(); //Initalize a new cURL session
$name = "PROBLEM";
$msg = "LOL";
$postfields = "token=".$token."&name=".$name."&url=&message=".$msg."";
echo $title; //set the title of the window
curl_setopt($ch, CURLOPT_POST, 1); //set the type,
curl_setopt($ch, CURLOPT_POSTFIELDS, $postfields); //and what fields to use
curl_setopt($ch, CURLOPT_URL, $url);//Set the URL to use
curl_exec($ch); //execute it
echo "<br /><br /><br />"; 
print_r(curl_getinfo($ch)); //Print info of the cURL execution
curl_close($ch); //Close our current cURL session
?>
However, it refuses to post..

What am I doing wrong? This is my first time using cURL

the curl info shows me this:
Quote

Array ( [url] => http://cheatskape.com/wtag/sendchat.php [content_type] => text/xml; charset=UTF-8 [http_code] => 200 [header_size] => 439 [request_size] => 208 [filetime] => -1 [ssl_verify_result] => 0 [redirect_count] => 0 [total_time] => 0.39 [namelookup_time] => 0 [connect_time] => 0.188 [pretransfer_time] => 0.188 [size_upload] => 68 [size_download] => 2039 [speed_download] => 5228 [speed_upload] => 174 [download_content_length] => 2039 [upload_content_length] => 0 [starttransfer_time] => 0.39 [redirect_time] => 0 [certinfo] => Array ( ) )

Hi
I made a curl and don't know what to do with the string I got back, I would need the id and the name of each, should I explode, don't know how to do that, here is what I got as answer:

Quote

string(596) "{"data":[{"name":"Esoterik Forum","category":"Community","id":"180883525283576"},{"name":"Hellsehen und Wahrsagen","category":"Company","id":"177967172214131"},{"name":"Spirituelle Lebensberatung","category":"Website","id":"164411270264299"},{"name":"Esoterik","category":"Website","id":"164524456919432"},{"name":"Kartenlegen und Hellsehen","category":"Company","id":"173933135951523"},{"name":"Exchange","category":"Application","id":"190533567633445"},{"name":"Astrologie","category":"Website","id":"164928140213920"},{"name":"Esoterik Forum","category":"Application","id":"184577371575355"}]}"

Hello,

hello i need use curl with proxy. but i get "undefined variable offset 1" error . here is the standart code i use.
please help me about it

thanks


curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_HEADER, $header); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch, CURLOPT_PROXY, $proxy); curl_setopt($ch, CURLOPT_HTTPPROXYTUNNEL, 1); curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, $timeout); curl_setopt($ch, CURLOPT_REFERER, $referer); curl_setopt($ch, CURLOPT_USERAGENT, $agent);

Hey guys,
I have developed an script which opens or fetches a page using curl, now the problem is the url i am trying to fetch follows lot of redirects(say 302) and in between it stores several cookies also which i don't know or guess.
So i was just thinking, is there any way so that i can automatically store the cookies in a particular file which server wants to store, and let it sent in request as per the asking of a request  in request header?

I hope you would have got what i mean to say here, for example
suppose i want to open http://www.example.com
and now that above url faces lot of redirects probably 5-6 and then ends up on http://www.test.com

now in between it stores some cookies in clients computer and then it fetches them also. Since i don't know which cookie it gonna store, I must put this responsibility to PHP itself to store and send the requested cookies in request headers.

Also i want to send the referrer also in request header, and it must be the last page that or request sent to the server, no matter whether it's in betwen redirects or to the final page.

In short i mean to create the complete emulation of browser for this URL.

Hi,   I'd stumbled upon a problem around doing curl on an asp website which use cookie.   I use username n session id to determine the cookie file, on a case when a second browser open up it should have different session id, hence it may create new cookies instead of using the active previously-made cookie file, please do correct me if I'm wrong.   So question is....how to detect a user is logged or not in such situation ? Or perhaps how is the proper way to determine a cookie file in such situation ?     Thanks in advance,

I have this code


curl_setopt($ch, CURLOPT_POST, 0);
curl_setopt($ch, CURLOPT_URL, $link);
$wall = curl_exec($ch);


but the $link is a facebook wall page that takes a couple of seconds to load fully. and you have to scroll down the page before more loads or you have to click older posts

when i run the script the $wall doesnt have the full page.

Is there a way that i can delay the $link from saving the file so that it reads more of the page??

i cannot figure out why my first result is not displaying properly it successfully shows all results but me first
myurl.com/other.php?id=2 now showing any thing kindly help to solved this problem! 

it seems like problem is in variable $http$ids but dunno how to combine them to get result $Ids always b numeric number

<?php
ini_set ("display_errors", "1"); 
error_reporting(E_ALL);

$http = "myurl.com/other.php?id=" ;

$conn=odbc_connect('greeting','','');
if (!$conn)
  {exit("Connection Failed: " . $conn);}
$sql="SELECT * FROM mytable";
$rs=odbc_exec($conn,$sql);
if (!$rs)
  {exit("Error in SQL");}
echo "<table border= 1><tr>";
echo "<th>ID</th>";
echo "<th>Like</th>";
echo "<th>title</th></tr>";
while (odbc_fetch_row($rs))
  {
  $ids=odbc_result($rs,"ID");
  $title=odbc_result($rs,"title");
  echo "<tr><td>$ids</td>";
  echo "<td><fb:like href=\"$http$ids\" layout=\"button_count\"  show_faces=\"false\" width=\"100\" font=\"tahoma\" colorscheme=\"dark\"></fb:like> </td>";
  echo "<td>$title</td></tr>";
  }
echo "</table>";
odbc_close($conn);
?>