PHP - Json Formatting

how can i also output $pages number into the json as well so i can use it for jquery

Code: [Select]
<?php

// Start Buffer
ob_start();
     
// Load Settings
require '../../includes/config.inc.php'; 

    // Require the database connection:
    require(MYSQL); 

// Number of records to show per page:
$display = 6;

// Determine how many pages there are...
if (isset($_GET['p']) && is_numeric($_GET['p'])) { // Already been determined.

$pages = $_GET['p'];

}else{ // Need to determine.

// Default Query
$count_q = "SELECT COUNT(id) FROM deals";
                    
    // Count the number of records:
$r = @mysqli_query ($dbc, $count_q);
$row = @mysqli_fetch_array ($r, MYSQLI_NUM);
$records = $row[0];
// Calculate the number of pages...
if ($records > $display) { // More than 1 page.
$pages = ceil ($records/$display);
} else {
$pages = 1;
}

} // End of p IF.

// Determine where in the database to start returning results...
if (isset($_GET['s']) && is_numeric($_GET['s'])) {
$start = $_GET['s'];
} else {
$start = 0;
}

// Make the query:
$q = "SELECT id, url, views, deal_img, title, savings, DATE_FORMAT(expiry, '%a, %d %b %Y') AS expr FROM deals ORDER BY created_on DESC LIMIT $start, $display";

$r = @mysqli_query ($dbc, $q); // Run the query.
if (mysqli_num_rows($r) > 0) { // Available.

/* create one master array of the records */
$offers = array();

    while ($offer = mysqli_fetch_array($r, MYSQLI_ASSOC)) {

$offers[] = array("id" => $offer["id"],
  "url" => BASE_APP_URL.'offer/'.$offer["url"].'/',
  "views" => $offer["views"],
  "image" => BASE_URL.'niftyuk-deal/'.$offer["deal_img"],
  "title" => $offer["title"],
  "savings" => $offer["savings"],
  "expr" => $offer["expr"]);
  
} // End of WHILE loop.

}

    /* output in necessary format */
    header('Content-type: application/json');
    echo json_encode($offers);
  

?>

I have some PHP which sends some user provided data to the client:

<?php
header('Content-type: application/json');
$data=array(
array('id'=>10,'firstname'=>'John','lastname'=>'Doe'),
array('id'=>14,'firstname'=>'Jane','lastname'=>'Doe'),
array('id'=>19,'firstname'=>'XSS!','lastname'=>'XSS!'),
);
echo(json_encode($data));
?>

The client then displays the data:

$.getJSON('getJSON.php', {
        something: 123
    },
    function(list) {
        var string = '';
        for (var i in list) {
            string += '<li>< a href = "index.php?id=' + list[i]['id'] + '">' + list[i]['firstname'] + '</a></li>';
        }
        $("#MyElem").html(string);
    });

Does this represent any XSS risk?  If so, how do I prevent it?

Hi,

I have two select boxes on my site like this:

Language - Level

and the user can keep adding more sets of select boxes. I need the data posted to be JSON encoded like this:

{"LANG1":["German","Beginner"],"LANG2":["Polish","Advanced"]} etc

How can i make this happen?

Hey guys I am Posting data over to a server file in Json and I need to know how I can add to the XML file. here is both codes. 

function validate() {
	$xml = simplexml_load_file("stock.xml");
	$sxe = new SimpleXMLElement($xml->asXML());
	
	for($i = 1; $i < 801; $i++)
	{
		$newItem->addChild("name" , "null");
	}
	
	$sxe->asXML("stock.xml");
	echo $sxe->asXML();
	
    $response = $_POST;

    $response["items"] = "Test output";
    $response["description"] = "test 42 ";
    
    $response["json"] = json_encode($response);
    echo json_encode($response);
}

The red text is what I want this json script to do. Do I have to return back to my form to add to the XML file? Can json add to a xml file on its own? Thanks for your time! have a good day!  

Hi, I am working on a project to help me learn more about JSON and JQuery and how they interact. I am able to pull in my JSON data fine and it displays in an HTML table. What isn't working is I want the tables rows to be striped, and normally this works, but I didn't know if it isn't working b/c it is AJAX or if I have something wrong with my JQuery. Also, I was hoping to add a reference to an image path in the JSON file as well, but wasn't sure how that is done or if it could be done at the JSON level.   Here is my code that I am working on:

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8" />
    <title>JSON Presidents</title>
	<style type="text/css">
        
        body{
            font-family:arial, helvetica, sans-serif;
        text-align:center;
            width:100%;
            margin:200px 0 0 0;
        }
        
	#PresidentInfo{
	width:75%;
	margin:0 auto;
       
        
	}
        
        table#data{
            width:100%;
        }
        
        table#data th{
            background:#333;
            color:#fff;
            text-align:center;
            text-shadow:1px 1px 1px rgba(0,0,0,1);
            padding:5px;
        }
        
        table#data td{
            border:1px solid #333;
            border-collapse:collapse;
            padding:10px;
            margin:0 5px 0 5px;
            text-align:center;
        }
        
        .odd {
   background: #ccc;
}
            
	

	
	
	</style>
</head>
<body>
        
    <div id="PresidentInfo">
  
    </div>

    <script src="http://code.jquery.com/jquery-1.7.1.min.js"></script>
	   <script>
           (function ($) {
$(document).ready (function(){
   $("tr:odd").addClass("odd");
    });
});
})(jQuery);
</script>
    <script>
  $.getJSON('data.json', function(data) {
        var output="<table id='data'><tr><th>First Name:</th><th>Last Name:</th><th>Month of Inauguration:</th><th>Year of Inauguration:</th></tr>";
        for (var i in data.Presidents) {
            output+="<tr><td>" + data.Presidents[i].firstName + "</td><td>" + data.Presidents[i].lastName + "</td><td>" + data.Presidents[i].YearInauguratedPresident.month +  "</td><td>" + data.Presidents[i].YearInauguratedPresident.year + "</td></tr>";
        }

        output+="</tr></table>";
        document.getElementById("PresidentInfo").innerHTML=output;
  });
    </script>
 
</body>
</html>

{"Presidents":[
        {
            "firstName":"Barack",
            "lastName":"Obama",
            "YearInauguratedPresident": {
                "month":"January",
                "day":20,
                "year":2009
            }
        },
        {
            "firstName":"George W",
            "lastName":"Bush",
            "YearInauguratedPresident": {
                "month":"January",
                "day":20,
                "year":2001
				}
            },
			     {
            "firstName":"Bill",
            "lastName":"Clinton",
            "YearInauguratedPresident": {
                "month":"January",
                "day":20,
                "year":1993
				}
            },
			     {
            "firstName":"George",
            "lastName":"H.W Bush",
            "YearInauguratedPresident": {
                "month":"January",
                "day":20,
                "year":1989
            }
        }
]}

Hi there, Hoping some one can help. I am new to using PDO and i am trying to get data from my db to json

I can get the data down to my $result so i know that part is working, my issue is with encoding it to json, if i pull a single record then it works if i pull all records then it doesn't, an i am not sure why

$result = $page->read($_GET['pageid']); 
     
	 //check for data
    if ($result) {
        //page array
         $page_arr['pages'] = array();
        while ($row =$result->fetch(PDO::FETCH_ASSOC)) {
            extract($row);
            $page_item = array(
            'id'=> $id,
            'title' => $title,
            'pageid' => $pageid,
            'pagecontent' =>html_entity_decode($pagecontent),
            'mdkeywords' => $mdkeywords,
            'description' =>$description,
            'date_added' =>$date_added,
            'hasAudio' => $hasAudio,
            'excludeSearch' =>$excludeSearch
            );

            //push to data
            array_push($page_arr['pages'], $page_item);
         }
         //print_r($page_arr['pages']); //If i enable this then i can see all the data
         //turn to  json
        echo json_encode($page_arr['pages'], JSON_FORCE_OBJECT);
         //This is where my page is blank.

    }
} else {
    echo json_encode(array('message'=>'nothing here!.'));
}

 

I am writing a simple connector for an android application and my json_encode is outputting  enclosing the array with []. This is throwing an error during the decode process because the array needs to start with a {. I know this has to do with the $output[] in the loop, but I dont know how to pass the values into the array any other way. I even tried to trim after doing the encode.
 Here is my code:
Code: [Select]
<?php
require_once ('includes/config.php');
require_once ('includes/connect.php');
$agency= mysql_query("SELECT agencyname FROM agency WHERE status ='Prospect' ORDER BY agencyname DESC")or die(mysql_error());
while($ageinfo = mysql_fetch_assoc($agency))
{
    $output[] = $ageinfo;
}

print(json_encode($output));
?>

im trying to get this ajax function working but for some reason it runs the error function...I've corresponded with the manual and I can't see a fault...any advise would be great...thanks

$(document).ready(function() 
{
	$.ajax(
	{
		url: "items.php",
		dataType: "json",
		data: '<?php echo $data; ?>',
		timeout: '2000',
		cache: false,

		error: function(data) 
		{ 
                  alert('error');
	    },

		success: function(data)
		{ 
			$.each(data, function() 
			{
				$("#table").append('<div class="row"><span class="cell">'+ data.title +'</span><span class="cell"></span><span class="cell"></span></div>');
			});
		}
	 });
});

Hello   This may seem like a silly question but if you never ask you never know...   Lets say I json encode a php array. When I echo out the encoded json string into a JS variable it looks something like this in the resultant markup:

var arr = ["cow - Copy (10).jpg","cow - Copy (2).jpg"];

So in this instance the string I've echoed out is equivalent to a JS array and I can use it straight away.   My questions:   1) Is it valid to do what I've done above? 2) Since I can use the array right away is there any need to JSON.parse? 3) When would you use JSON.parse?   Thanks,   Drongo

Hello,

I am trying to understand how to post several actions and return 1 call. I am new to this so I thank you for your understanding.

Here is the full story, I have the Jquery working now that 1 "onSelect" will post to 6 php files, but it takes forever for all the calls to return to the div. From my reading, I need to put the 6 php files into one php file, and then return this with JSON... here is where my trouble begins.

Now here is the current php file that I have put into 1 php file (placed as they were working when in 6 files to the Jquery below)

<?php  
$choice = (isset($_POST['choice'])) ? date("Y-m-d",strtotime($_POST['choice'])) : date("Y-m-d"); 
$con = mysql_connect("xxxxxx","xxxxxx","xxxxxx");  
if (!$con)  {  
die('Could not connect: ' . mysql_error());  
}  
mysql_select_db("inverters", $con);  
$sql = "SELECT sum(power/1000) AS choice FROM feed WHERE date = '".$dayPower."' group by date";$res = mysql_query($sql) or die('sql='.$sql."\n".mysql_error()); 
$d = array();
while($row = mysql_fetch_assoc($res)) {; 
echo json_encode($d);  
}
?>
<?php
$choice = (isset($_POST['choice'])) ? date("Y-m-d",strtotime($_POST['choice'])) : date("Y-m-d"); 
$con =$con = mysql_connect("xxxxxx","xxxxxx","xxxxxx"); mysql_connect("localhost","root","mackie1604");  
if (!$con)  {  
die('Could not connect: ' . mysql_error());  
}  
mysql_select_db("inverters", $con);  
$sql = " SELECT HOUR(time) as h, power 
FROM feed  
WHERE date = '".$choice."'  
ORDER BY HOUR(time)";  
$res = mysql_query($sql) or die('sql='.$sql."\n".mysql_error()); 
$daypower = array();
while($row = mysql_fetch_assoc($res)) { 
$daypower[] = $row['power'];  
}
?>
<script type="text/javascript">
$(document).ready(function() {
var chart = new Highcharts.Chart({
    chart: {
        renderTo: 'apDiv4',
         defaultSeriesType: "column",  
},
  events: {
  marginTop: 1,
  marginRight: 1,
  marginBottom: 1,
  marginLeft: 4
  },
       credits: {
     enabled: false,
   },
      title: {
         text: null,
      },
      subtitle: {
         text: null,
      },
      xAxis: {
  labels: {
                y: 15
           },
         categories: ['00', '01', '02', '03', '04', '05', '06', '07', '08', '09', '10', '11', '12', '13', '14', '15', '16', '17', '18', '19', '20', '21', '22', '23']
      },
      yAxis: {
         min: 0,
 max: 2000,
         title: {
            text: null
         },
  labels: {
             align: 'left'
         }
      },
      legend: {
         enabled: false
      },
      tooltip: {
         formatter: function() {
            return ''+
               this.x +': '+ this.y +' Watt hr';
         }
      },
      plotOptions: {
         column: {
            pointPadding: 0.02,
            borderWidth: 0
         }
      },
           series: [{
         name: '',
 color: '#50B432', 
         data: [<?php echo join($daypower, ', '); ?>]
      }]   
   });  
});
</script>

<?php 
$choice = (isset($_POST['choice'])) ? date("m",strtotime($_POST['choice'])) : date("m"); 
$con = mysql_connect("xxxxxx","xxxxxx","xxxxxx"); 
if (!$con)  {  
die('Could not connect: ' . mysql_error());  
}  
mysql_select_db("inverters", $con);  
$sql = "SELECT sum(power/1000) AS choice FROM feed WHERE month(date) = '".$choice."'";
$res = mysql_query($sql) or die('sql='.$sql."\n".mysql_error()); 
$row = mysql_fetch_assoc($res); 
echo $row['choice'].'<br />';  
?>

<?php
$choice = (isset($_POST['choice'])) ? date("m",strtotime($_POST['choice'])) : date("m"); 
$con = mysql_connect("xxxxxx","xxxxxx","xxxxxx");  
if (!$con)  {  
die('Could not connect: ' . mysql_error());  
}  
mysql_select_db("inverters", $con);  
$sql = " SELECT MONTH(date) AS m, SUM(power/1000) AS monthpower 
FROM feed  
WHERE MONTH(date) = '".$choice."' 
GROUP BY DAY(date)
ORDER BY DAY(date)";  
$res = mysql_query($sql) or die('sql='.$sql."\n".mysql_error());  
$monthpower = array();
while($row = mysql_fetch_assoc($res)) { 
$monthpower[] = $row['monthpower'];  
}
?>
<script type="text/javascript">
$(document).ready(function() {
   var chart = new Highcharts.Chart({
    chart: {
        renderTo: 'apDiv9',
         defaultSeriesType: "column"
},
  events: {
  marginTop: 1,
  marginRight: 0,
  marginBottom: 0,
  marginLeft: 1
  },
      title: {
         text: null,
      },
      subtitle: {
         text: null,
      },
      xAxis: {
  labels: {
   y: 15
           },
         categories: ['1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12', '13', '14', '15', '16', '17', '18', '19', '20', '21', '22', '23', '24', '25', '26', '27', '28', '29', '30', '31']
      },
      yAxis: {
         min: 0,
 max: 20,
         title: {
            text: null
         },
  labels: {
             align: 'left'
         }
      },
      legend: {
         enabled:false
      },
      tooltip: {
         formatter: function() {
            return ''+
               this.x +': '+ this.y +' kWh';
   fontWeight: 'normal'
   fontSize: '1px'
         }
      },
      plotOptions: {
         column: {
            pointPadding: 0.2,
            borderWidth: 0
         }
      },
           series: [{
         name: '',
 color: '#50B432', 
         data: [<?php echo join($monthpower, ', '); ?>]
      }],
  credits: {
 enabled:false,
    },
   });  
});
</script>

<?php 
$choice = (isset($_POST['choice'])) ? date("Y",strtotime($_POST['choice'])) : date("Y"); 
$con = mysql_connect("xxxxxx","xxxxxx","xxxxxx");  
if (!$con)  {  
die('Could not connect: ' . mysql_error());  
}  
mysql_select_db("inverters", $con);  

$sql = "SELECT sum(power/1000) AS choice FROM feed WHERE year(date) = '".$choice."'";
$res = mysql_query($sql) or die('sql='.$sql."\n".mysql_error()); 
$row = mysql_fetch_assoc($res); 
echo $row['choice3'].'<br />';  
?>

<?php
$choice = (isset($_POST['choice'])) ? date("Y",strtotime($_POST['choice'])) : date("Y"); 
$con = mysql_connect("xxxxxx","xxxxxx","xxxxxx"); 
if (!$con)  {  
die('Could not connect: ' . mysql_error());  
}  
mysql_select_db("inverters", $con);  

$sql = " SELECT MONTH(date) AS y, SUM(power/1000) AS yearpower 
FROM feed  
WHERE YEAR(date) = '".$choice."' 
GROUP BY MONTH(date)
ORDER BY MONTH(date)";  
$res = mysql_query($sql) or die('sql='.$sql."\n".mysql_error());  
$yearpower = array();
while($row = mysql_fetch_assoc($res)) { 
$yearpower[] = $row['yearpower'];     
}
?>
<script type="text/javascript">
$(document).ready(function() {
    var chart = new Highcharts.Chart({
    chart: {
        renderTo: 'apDiv10',
         defaultSeriesType: "column"
},
  events: {
  marginTop: 1,
  marginRight: 1,
  marginBottom: 1,
  marginLeft: 1
  },
       credits: {
     enabled: false,
   },
      title: {
         text: null,
      },
      subtitle: {
         text: null,
      },
      xAxis: {
  labels: {
                y: 15
           },
         categories: ['1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12']
      },
      yAxis: {
         min: 0,
 max: 500,
         title: {
            text: null
         },
  labels: {
             align: 'left'
         }
      },
      legend: {
         enabled: false
      },
      tooltip: {
         formatter: function() {
            return ''+
               this.x +': '+ this.y +' kWh';
         }
      },
      plotOptions: {
         column: {
            pointPadding: 0.2,
            borderWidth: 0
         }
      },
           series: [{
         name: '',
 color: '#50B432', 
         data: [<?php echo join($yearpower, ', '); ?>]
      }]
   });  
});
</script>

Here is the Jquery that was working to send to the 6 different php files (to help you understand what my goal is...

Code: [Select]
$('#datepicker').datepicker({maxDate: 0, dateFormat: 'yy-mm-dd', onSelect: function(dateText) {
            var myDate = $(this).datepicker('getDate');
            $('#apDiv1').html($.datepicker.formatDate('DD, d', myDate));
            $('#apDiv5').html($.datepicker.formatDate('MM', myDate));
            $('#apDiv7').html($.datepicker.formatDate('yy', myDate));
           
$('#apDiv2').load('dayPower.php', {choice: dateText}, function() {
                  $(this).show();
            });
            $('#apDiv4').load('dayGraph.php', {choice: dateText}, function() {
                  $(this).show();
            });
            $('#apDiv6').load('monthPower.php', {choice: dateText}, function() {
                  $(this).show();
            });
            $('#apDiv9').load('monthGraph.php', {choice: dateText}, function() {
                  $(this).show();
            });
            $('#apDiv8').load('yearPower.php', {choice: dateText}, function() {
                  $(this).show();
            });
            $('#apDiv10').load('yearGraph.php', {choice: dateText}, function() {
                  $(this).show();
            });
      }});
});
I am back to this as what I was changing became a mess, and I am starting from what was working....

 How do I get JSON to send and return from the one PHP file.

Thank You,

Alan

help required for noobie(no hair left)
all i want to be able to do is use the individual elements of the array in javascript eg companyname or companyimage
but just getting my head in my hand.

mysql_select_db("herefordinfo") or die(mysql_error());
echo "Connected to Database";

$dbQuery = 'SELECT * FROM  companies';
$dbResult = mysql_query($dbQuery) or die ("Could not read data because " . mysql_error());
$RowCount = mysql_numrows($dbResult);

while ($pubs = mysql_fetch_assoc($dbResult))
{
 $array[] = "{  {$pubs['id']}, {$pubs['companyname']}, {$pubs['companyinfo']},  {$pubs['companyimage']} }";
 
}
echo 'var pub = [' . implode(', ', $array) . '];'; // this

?>
<html>
<head>

<script type="text/javascript">
 var jsArray = <?php echo json_encode($array); ?>; 
 document.write(jsArray); //this
</script>
</head>
<boby></body>
</html>

both php and javescritp output the results below
{ 1, lichfield vaults, 10 church street hereford , lich.jpg },{ 2, Black Lion, bridge street, blacklion.jpg },{ 3, Saracens Head, st martins street, saracens.jpg }

I'm having problems with enabling the sort functions of jqgrid.  I think I've narrowed the problem down to the way MSSQL is returning the data to the SQL query.

In an effort to troubleshoot, I've drastically simplified the problem.  The query I'm using is below.

Code: [Select]
SELECT * FROM dbo.test ORDER BY locationName
When I run the query directly in MSSQL Management Studio, the top 5 ID entries are 132, 1309, 1295, 1281, 1267.

When I run the corresponding code in PHP, the top 5 ID entries are 1266, 1267, 1268, 1269, 1270 - it seems to be ignoring my order by clause.  Is there something I need to do to force it to honor the ORDER BY locationName?

Code: [Select]
$kpiQuery = "SELECT * FROM dbo.test ORDER BY locationName";
$result = mssql_query($kpiQuery);
while($kpiRow = mssql_fetch_array($kpiResult)) {
echo $kpiRow[plDataID]."<br>";
}

I was pointed in this direction by a friend so firstly, hello   I'm having some teething problems (basically can't get my head around it) and wondered if anyone would be able to have a look at a script for me (beer money may be provided)   I'm currently using a php script which grabs information from a API with curl (JSON format). I'm limited to a number of requests an hour so my plan was to read the file, insert the data into a mysql table so that I could re-read over and over again with no limitations. Then use a script to run every few hours to grab the data.   The script I created works however it's a bit buggy with regards to what it does if information is already in the table. If there isn't a previous entry then it inserts everything fine.   The JSON data is a multi depth array, and deals with images as well as data so for me, it's rather complex.   What I want the script to do is this. Each item is a property (letting agent website)   Check to see if the property exists in the database and the JSON. If there is no record in the database, then insert in. If there is a record in the database, update that record. If there is a property in the database which isn't in the JSON file, then delete it from the database.   This is basically the same plan for each sub array (pictures, floorplans, etc) however the images are copied from the url given (hosted on amazon) to my own host in order to speed up loading times, etc.   i've added a copy of the code but obviously its going to be stupidly hard to understand.   Is there any way this could be split into different functions to try and sort it out? haha

<?php


  	$ch = curl_init(); /* Section 1 */
  	curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
  	curl_setopt($ch, CURLOPT_POST, 1);
  	curl_setopt($ch, CURLOPT_URL, 'URL');
  	//prepare the field values being posted to the service
  	$data = array("appkey" => "KEY","account" => "ACCOUNT" );
  	curl_setopt($ch, CURLOPT_POSTFIELDS, $data);

  	//make the request
  	$result = curl_exec($ch);
	$properties = json_decode($result, true);
	$properties = $properties['properties'];
	//pr($parsed_json);
	
	
	foreach($properties as $key => $value) {


		/* Set the vars */
		$microTime = microtime();
		$time = time();
		$cat_id = $value['category_id'];
		$price = $value['price'];
		if ($value['category_id'] == "1") { $price_after = $value['qualifier_name']; } else { $price_after = $value['freq_name']; }
		$full_address = $value['full_address'];
		$address_1 = $value['address_1'];
		$address_2 = $value['address_2'];
		$address_3 = $value['address_3'];
		$address_4 = $value['address_4'];
		$address_5 = $value['address_5'];
		$bedrooms = $value['bedrooms'];
		$bathrooms = $value['bathrooms'];
		$summary = $value['summary'];
		$description = $value['description'];
		$type_name = $value['type_name'];
		$status = $value['status'];
		$feature_1 = $value['feature_1'];
		$feature_2 = $value['feature_2'];
		$feature_3 = $value['feature_3'];
		$feature_4 = $value['feature_4'];
		$lat = $value['lat'];
		$long = $value['lng'];
		
		
		/* Delete the properties from the database which can't be found in the file */
		$searchProp = "SELECT property_id FROM props WHERE property_address_full = '$full_address' AND property_catid = '$cat_id'";
		if ($result = mysqli_query ($linkq, $searchProp)) {
			if (!$whereStatement) { $whereStatement = "WHERE property_id != $row[property_id]"; } else { $whereStatement .= " OR property_id != $row[property_id]"; } // Set the whereStatement for deleting properties with no ID
			$deleteProp = "DELETE FROM props $whereStatement";
			if ($result = mysqli_query ($linkq, $deleteProp)) {
				$totalPropsDeleted++;
				echo "Properties deleted $deleteProp";

				$deleteimg = "DELETE FROM props_images $whereStatement";
				if ($result = mysqli_query ($linkq, $deleteimg)) {
					echo ("Images Deleted Successfully<br />\n");
				} else {
					echo ("Error Deleting");
				}
	
				$deleteepc = "DELETE FROM props_epcs $whereStatement";
				if ($result = mysqli_query ($linkq, $deleteepc)) {
					echo ("EPCs Deleted Successfully<br />\n");
				} else {
					echo ("Error Deleting");
				}
	
				$deletepdf = "DELETE FROM props_pdf $whereStatement";
				if ($result = mysqli_query ($linkq, $deletepdf)) {
					echo ("PDFs Deleted Successfully<br />\n");
				} else {
					echo ("Error Deleting");
				}
	
				$deletefloorplan = "DELETE FROM props_floorplans $whereStatement";
				if ($result = mysqli_query ($linkq, $deletefloorplan)) {
					echo ("Floorplans Deleted Successfully<br />\n");
				} else {
					echo ("Error Deleting");
				}
				
			} else {
				echo "Nothing to delete";
			}
		}
		
		
		echo "<br />";
		
		
		/* Check to see if the property exists currently */
		$existCheck = "SELECT * FROM props WHERE property_address_full LIKE '%$full_address%' AND property_catid = '$cat_id'";
		if ($result = mysqli_query ($linkq, $existCheck)) {
			$row_cnt = mysqli_num_rows($result);
			if ($row_cnt) {
				while ($row = $result->fetch_array(MYSQLI_ASSOC)) {
					echo "Property Exists - $full_address";
					
                    
					if (($row[property_price] != $price) || ($row[property_summary] != $summary) || ($row[property_description] != $description)) {
						$dateUpdated = "property_updated = $microTime,";
					} else {
						$dateUpdated = "property_updated = property_updated,";
					}
														
					/* Property exists so update the property info */							
					$updateProp = "UPDATE props SET property_advertised = property_advertised,
					$dateUpdated
					property_catid = '$cat_id',
					property_price = '$price',
					property_price_after = '$price_after',
					property_address_full = '$full_address',
					property_address_1 = '$address_1',
					property_address_2 = '$address_2',
					property_address_3 = '$address_3',
					property_address_4 = '$address_4',
					property_address_5 = '$address_5',
					property_bedrooms = '$bedrooms',
					property_bathrooms = '$bathrooms',
					property_summary = '$summary',
					property_description = '$description',
					property_type = '$type_name',
					property_status = '$status',
					property_feature_1 = '$feature_1',
					property_feature_2 = '$feature_2',
					property_feature_3 = '$feature_3',
					property_feature_4 = '$feature_4',
					property_lat = '$lat',
					property_long = '$long' WHERE property_id = '$row[property_id]'";
					if (mysqli_query ($linkq, $updateProp)) {
						$totalPropsUpdated++;
						echo (" & Updated");
					} else {
						echo (" & Error Updating");
					}			
				
					echo ("<br />\n");
					
					/* Delete all the photos for this property as it doesn't matter if they are added again */
					$deletePhotos = mysqli_query ($linkq, "DELETE FROM props_images WHERE property_id = $row[property_id] OR property_id = ''");
					printf("Images Deleted: %d\n", mysqli_affected_rows($linkq));
					printf("<br />\n");
					
					/* Loop the current images and add back to the database and asign the property id */
					$primaryimg = 0;
					$totalimg = count($value['images']);
					for ($x = 0; $x < $totalimg; $x++) {
												
						$imagename = $value['images'][$x];	
						if (!$primaryimg) {	$image_main = "1"; } else { $image_main = "0"; }		
						$insertphoto = "INSERT into props_images VALUES ('', '$row[property_id]', '$imagename', '$image_main', '')";
						if (mysqli_query ($linkq, $insertphoto)) {
							echo ("- Inserted ($row[property_id]) ($imagename) ($image_main)\n");
														
							if (!file_exists('images/props/'. $imagename .'.jpg')) {
							
								/* Try and copy the image from the url */
								$file = 'https://utili-media.s3-external-3.amazonaws.com/stevemorris/images/' . $imagename . '_1024x1024.jpg';
								$newfile = 'images/props/' . $imagename . '.jpg';

								if (!copy($file, $newfile)) {
    								echo "- Failed to Copy\n";
								} else {
									echo "- Image Copied";
									/* Resize the image and create a thumb nail */
									$image = new SimpleImage();
									$image->load('images/props/' . $imagename . '.jpg');
									$image->resizeToWidth(240);
									$image->save('images/props/thumb/' . $imagename . '.jpg');
								}
								
							} else {
								echo ("- Nothing to upload, image exists");
							}
							
							echo "<br />\n";							
							
						} else {
							echo ("- Image Insert Error\n");
						}
						
						$primaryimg++;

					} /* close the image loop */
					
					/* Delete all the epcs for this property as it doesn't matter if they are added again */
					$deleteEpcs = mysqli_query ($linkq, "DELETE FROM props_epcs WHERE property_id = $row[property_id]");
					printf("EPCs Deleted: %d\n", mysqli_affected_rows($linkq));
					printf("<br />\n");
					
					/* Loop the current EPCs and insert into the database */
					$totalepc = count($value['epcs']);
					for ($y = 0; $y < $totalepc; $y++) {
												
						$epcname = $value['epcs'][$y];	
						$insertepc = "INSERT into props_epcs VALUES ('', '$new_property_id', '$epcname')";
						if (mysqli_query ($linkq, $insertepc)) {
							echo ("- Inserted EPC ($new_property_id) ($epcname)<br />\n");
						} else {
							echo ("- EPC Insert Error\n");
						}

					} /* close the epc loop */
					
					/* Delete all the pdfs for this property as it doesn't matter if they are added again */
					$deletePdfs = mysqli_query ($linkq, "DELETE FROM props_pdf WHERE property_id = $row[property_id]");
					printf("PDFs Deleted: %d\n", mysqli_affected_rows($linkq));
					printf("<br />\n");
					
					/* Loop the current PDFs and insert into the database */
					$totalpdf = count($value['pdfs']);
					for ($v = 0; $v < $totalpdf; $v++) {
												
						$pdfname = $value['epcs'][$v];	
						$insertpdf = "INSERT into props_pdf VALUES ('', '$new_property_id', '$pdfname')";
						if (mysqli_query ($linkq, $insertpdf)) {
							echo ("- Inserted PDF ($new_property_id) ($pdfname)<br />\n");
						} else {
							echo ("- PDF Insert Error\n");
						}

					} /* close the PDF loop */
					
					/* Delete all the pdfs for this property as it doesn't matter if they are added again */
					$deleteFloorplan = mysqli_query ($linkq, "DELETE FROM props_floorplans WHERE property_id = $row[property_id]");
					printf("Floorplans Deleted: %d\n", mysqli_affected_rows($linkq));
					printf("<br />\n");
					
					/* Loop the current Floorplans and insert into the database */
					$totalfloorplan = count($value['floorplans']);
					for ($v = 0; $v < $totalfloorplan; $v++) {
												
						$floorplanname = $value['floorplans'][$v];	
						$insertfloorplan = "INSERT into props_floorplans VALUES ('', '$new_property_id', '$floorplanname')";
						if (mysqli_query ($linkq, $insertfloorplan)) {
							echo ("- Inserted Floorplan ($new_property_id) ($floorplanname)<br />\n");
						} else {
							echo ("- Floorplan Insert Error\n");
						}
						
					} /* close the Floorplan loop */
					
				}	 /* close the property while loop */

			} else { /* close the if row exists loop */
		
				/* Insert the property as it doesn't exist in the database */			
				$insert = "INSERT INTO props VALUES ('', '$time', '', '$cat_id', '$price', '$price_after', '$full_address', '$address_1', '$address_2', '$address_3', '$address_4', '$address_5', '$bedrooms', '$bathrooms', '$summary', '$description', '$type_name', '$status', '$feature_1', '$feature_2', '$feature_3', '$feature_4', '$lat', '$long', '', '')";
				if (mysqli_query ($linkq, $insert)) {
					$totalPropsAdded++;
					echo ("Property Inserted - $value[full_address]<br />");
					
					/* get the property ID from the newly added property */
					$getPropID = mysqli_query ($linkq, "SELECT property_id FROM props ORDER BY property_id DESC LIMIT 1");
					while ($rowNew = $getPropID->fetch_array(MYSQLI_ASSOC)) {
						$new_property_id = $rowNew[property_id];
					}	
														
					/* Loop the current images and add to the database and asign the property id */
					$primaryimg = 0;
					$totalimg = count($value['images']);
					for ($x = 0; $x < $totalimg; $x++) {
												
						$imagename = $value['images'][$x];	
						if (!$primaryimg) {	$image_main = "1"; } else { $image_main = "0"; }			
						$insertphoto = "INSERT into props_images VALUES ('', '$new_property_id', '$imagename', '$image_main', '')";
						if (mysqli_query ($linkq, $insertphoto)) {
							echo ("- Inserted Image ($new_property_id) ($imagename) ($image_main)<br />\n");
						} else {
							echo ("- Image Insert Error\n");
						}
						
						$primaryimg++;

					} /* close the images loop */
					
					/* Loop the current epcsand add to the database and asign the property id */
					$totalepc = count($value['epcs']);
					for ($y = 0; $y < $totalepc; $y++) {
												
						$epcname = $value['epcs'][$y];	
						$insertepc = "INSERT into props_epcs VALUES ('', '$new_property_id', '$epcname')";
						if (mysqli_query ($linkq, $insertepc)) {
							echo ("- Inserted EPC ($new_property_id) ($epcname)<br />\n");
						} else {
							echo ("- EPC Insert Error\n");
						}

					} /* close the epcs loop */
					
					/* Loop the current pdfs and add to the database and asign the property id */
					$totalpdf = count($value['pdfs']);
					for ($v = 0; $v < $totalpdf; $v++) {
												
						$pdfname = $value['epcs'][$v];	
						$insertpdf = "INSERT into props_pdf VALUES ('', '$new_property_id', '$pdfname')";
						if (mysqli_query ($linkq, $insertpdf)) {
							echo ("- Inserted PDF ($new_property_id) ($pdfname)<br />\n");
						} else {
							echo ("- PDF Insert Error\n");
						}

					} /* close the pdfs loop */
					
					/* Loop the current floorplans and add to the database and asign the property id */
					$totalfloorplan = count($value['floorplans']);
					for ($v = 0; $v < $totalfloorplan; $v++) {
												
						$floorplanname = $value['floorplans'][$v];	
						$insertfloorplan = "INSERT into props_floorplans VALUES ('', '$new_property_id', '$floorplanname')";
						if (mysqli_query ($linkq, $insertfloorplan)) {
							echo ("- Inserted Floorplan ($new_property_id) ($floorplanname)<br />\n");
						} else {
							echo ("- Floorplan Insert Error\n");
						}

					} /* close the floorplans loop */
			
				} else {	
							
					echo ("Insert Error");
					
				} /* close the insert property */
			
				
			}  /* close the row count loop */
			
			
		} /* close the property exists loop */
		
	}
			

	/* close everything */
	curl_close($ch);	
	mysqli_close ($linkq);
	
?>

Edited by Jam0r, 08 December 2014 - 10:51 AM.

Hello 

Can you please show me how can i parse this JSON in PHP?

{"status":"error","error":{"error_code":700,"error_message":"Recognition failed: you didn't send file via POST or file url as `url` param."},"requested_params":{"method":"recognize"}}

 

I need to setup a condition :

If(status="error) than 

$errorcode=700

errormessage=Recognition failed: you didn't send file via POST or file url as `url` param

errorMethod= "recognize"

Hello everyone, I'm new here. Amazing forum, I found some help in the past by searching google.   Now I am looking for some help with the following code, I use this code to grab a JSON Feed and list the items in my page, this code works fine to get all the items, but I need to limit the number of items, otherwise It will load more than 500 items in my page and never stop loading.   Is there a way to limit the number of items grabbed from the JSON Feed?   Let's say, list 50 items in page 1, another 50 in page 2 and so on?

<?php 
$data = file_get_contents('http://json-url.com/type=json');
$decode = json_decode($data, true); 
	foreach($decode as $d) {
		if($d['status'] == true){
			echo '<div class="div">';
				echo '<a href="'.$d['item_url'].'">';
				echo '<img src="'.$d['item_image']['jpeg_thumbnail'].'" />';
				echo '<span>'.$d['item_name'].'</span>';
				echo '</a>';
			echo '</div>';
			
		}
	}
?>

Thanks!