|
PHP - First Steps In Json
Hi all,
I am sure this is simple, but I just can't wrap my head around a suitable way of doing this! Basically I have my JSON result as something like : Code: [Select] Array ( [result] => success [source] => gotBits [success] => 64 ) What I simply want to do is get the [success] output and store it as a variable. I have been looking at json_decode, but I cant find any examples for arrays, just strings? Can you push me in the right direction? Similar TutorialsSo I've recently started looking into Character Encoding, after never really bothering with it, and I've got a few questions. After checking out my site it seems I've been using UTF-8 without really realising it, and I'm going to stick with UTF-8. However, when I jump into phpMyAdmin to check out my MySQL tables I run into a few problems. Originally, for my database, the collation was set to latin1_swedish_ci. I have since changed this to utf8_general_ci. This however only affects newly created tables, not the 150 or so tables I currently have which are still latin1_swedish_ci. Do I need to convert the collation of these already existing tables to UTF-8, and if so what's the best method? This takes me to my text editor, NetBeans 7. Do I need to alter anything here, I've not been successful with finding information relating to this? Cheers guys. I am creating an add on to a 3rd party CMS called Concrete5. Normally, when I have client issues, I can trace them to the server and fix them, however, this not doing so well on these issues. The following errors are being displayed in Chrome console:
Checking the server’s folder directory, it is true there is no concrete/fonts directory but there is a concrete/css/fonts directory with a couple of the missing files (but not glyphiconshalflings-regular.woff2).
Back to the errors, clicking the line number (i.e. 927, 3115, and 1), chrome blames apparently innocent line numbers.
What steps would you recommend taking to identify the cause and fix these errors? i am trying to make a range of numbers which have a step of 11 then 7 then 11 which can then be compared. the result im after is 1, 12, 19, 30. Is there a way i could do this without storing the sets in an array and looping though them? Any help would be greatly appreciated, thanks. Hello guys. I'm in need of help. I want to know who to make a full working session. When a player logs in, the session starts. There will be a new button "My Page", he can go there at any time. When he logs off, that button disappears ( Session over ). I'm so bad at explaining stuff. Hope y'all really understood me. This piece of code is used to log the user in: Code: [Select] <?php session_start(); include("config.php"); if(isset($_SESSION["Username"])) { $user = $_SESSION["Username"]; $pass = md5($_SESSION["Password"]); } else { $user = $_POST["User"]; $pass = md5($_POST["Password"]); $_SESSION['Username'] = $user; $_SESSION['Password'] = $pass; $escuser = mysql_real_escape_string($user); $escpass = mysql_real_escape_string($pass); } $result = mysql_query("SELECT * FROM playerinfo WHERE user = '$escuser'"); $num_rows = mysql_num_rows($result); if($num_rows == 0) { echo('That username does not exist...'); echo '<a href="http://yu-ki-ko.com/fsns/""> Go back!</a>'; unset($_SESSION['Username']); unset($_SESSION['Password']); die; } $row = mysql_fetch_row($result); if($row[1] !== $escpass) { echo('Wrong Password!...'); echo '<a href="http://yu-ki-ko.com/fsns/""> Go Back!</a>'; unset($_SESSION['Username']); unset($_SESSION['Password']); die; } ?> Not sure if its working properly or not. I'm stuck at that part. A friend of mine is looking at relaunching a site he used to run and I am going to try to persuade him to move over to a dynamic site. The site is a Football Clubs history site and contains around 2,000 games and several hundred players. The obvious advantage of a dynamic site is that even the bits I just mentioned run to around 2,500 static pages, which could be reduced to just 2 pages if dynamically driven. I am fairly confident that I can do the conversion, but there is one thing that I already know I may struggle with and that is the page which shows game, births and deaths on this day in history. A rough example (using a very heavy Javascript code) can be found at http://follyball.co.uk/jeff/. In a simplified form (ignoring for now the foreign keys to relationships that these tables actually have) there will be two tables GAMES game_id | date | competition | opponent | score | attendance PLAYERS player_id | surname | firstname | date of birth | date of death What I would be looking for is a way to take todays date, and find any corresponding records in games.date, players.date of birth, players.date of death on the same date in previous years. This would be simple to do as three different queries but as I would like to actually mix the three and show them in date order, I would like to do it in one query, presumably using UNIONS. On top of this, I would also like a slightly different output for each different set, for example, if it was a game I would like year, competition, opponent, score, attendance, Whereas if it is a players birth or death, I would like it to show something like firstname surname was born in year Before I go delving too deep into how it may be done, I would like to know if it can be done! I cannot see why it would not be able to generate this but if it is going to be way out of my ability, then I will look for another option! Thanks in advance Steve 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? Please see http://www.socialnewsoffice.com/blog_posts?&display=2&api_key=b5cbd66dca99c49d1a6c3d which out puts a json response like this Code: [Select] [{ "blog_id":"3", "post_date":"Sat, 14 April 2012", "post_title":"Facebook's New Fan Page Learn How To Use Features", "article_img":"http:\/\/www.socialnewsoffice.com\/uploads\/17963.jpg", "post_content":"<p>This week saw the release of Facebook's latest functionality changes (Timeline for Businesses) that will shape the future of how businesses will market their campaigns, through the social media giant Facebook. A number of marketers are wondering how they will incorporate the new features in an attempt to progress and move forward with their online social media presence.<\/p>\r\n<p>Taking all the key changes in to consideration we have managed to create a guide on how to smoothly move with the times and embrace the new Facebook layout.<\/p>\r\n<p>Please read on below for helpful tips and tricks on how to excel with 'Timeline for Brands'<\/p>\r\n<h2>New Features Announced at the Facebook Marketing Conference:<\/h2>\r\n<p><strong>View and Apps:<\/strong> What was once known as Application pages has changed to 'Tabs'. These can now have customizable images linked with them and the order of them can be changed too. Below you can see from the screenshot what a customized Facebook Timeline looks like.<\/p>\r\n<p><strong>Pinning Content:<\/strong> With this new feature you can 'pin' a post to the very top of your Facebook Timeline. This is Very effective when working on a new campaign and is a great way to entice increased traffic to your tab or application page.<\/p>\r\n<p><strong>Featured 'Starred' Content:<\/strong> This feature allows you to select key content or imagery and extend it so it fits across your entire page. Therefore giving you featured content on your Facebook Timeline and making it more visible.<\/p>\r\n<p><strong>Cover Photos:<\/strong> Cover Photos are another great new feature that allow you to announce your latest campaign, welcome your following community or just simply show visitors to your timeline what you can do. There are some slight flaws with this feature though and will be addressed below.<\/p>\r\n<p><strong>Page Dimensions:<\/strong> Dimensions of application pages has now changed with the release of Facebook Timeline. If you happen to be an SML user then you have all the tools necessary to update your page on your own. If your using Involvers App Suite then those applications will be updated soon.<\/p>\r\n<p><strong>Removal of Default Landing Pages:<\/strong> The commonly used Facebook landing pages have been removed and replaced with various options to allow brands to drive content to application pages. These options allow you to use your cover photo and pinned content to attract users to your personal application pages. Despite the changes it is however still possible to link directly to application pages from ads, posts and outside of Facebook.<\/p>\r\n<h2>Getting Started with Timeline For Brand:<\/h2>\r\n<p>Firstly when accessing and logging in to your New Facebook Brand Page, you will see this admin message displayed below:<\/p>\r\n<p>When will my Page change to the latest design?<\/p>\r\n<p>To see a preview of what your new pages will look like, simply click on the green button at the top of your current pages. A second option is to wait until March 30th 2012 when all pages will be upgraded automatically.<\/p>\r\n<p>Where can I visit to learn more about how to use the new Pages?<\/p>\r\n<p><strong>There are a number of places you can visit to learn all you need to know about Pages:<\/strong><\/p>\r\n<ul>\r\n<li>To find out more about new features, download the Pages Overview guide by clicking here.<\/li>\r\n<li>If your wondering how to get started with Pages then download Facebook's full Pages Product Guide by clicking here.<\/li>\r\n<li>The Pages Learning video allows you to walk through the key features with Facebook's product experts.<\/li>\r\n<li>If you need answers to specific questions, visit Facebook's Help Centre.<\/li>\r\n<\/ul>\r\n<h2>How should I choose a cover photo for my Page?<\/h2>\r\n<p>Firstly select a unique image that represents your page. Facebook itself recommends using a photo of a popular menu item, album artwork or an image of your product being used by someone. You need to experiment with a number of different images that your audience responds positively to. Few key elements of Cover Images:<\/p>\r\n<p><strong>Each Cover image must be at least 399 pixels wide and must not contain the following:<\/strong><\/p>\r\n<ul>\r\n<li>Prices \/ Purchase information and displaying offers such as \"60% off this month\" are not permitted. Also 'Download this from our website' is not allowed.<\/li>\r\n<li>No email addresses, web addresses and any other contact information.<\/li>\r\n<li>References to clicking on or the use of Facebook interface elements such as Like or Share or any other Facebook Features.<\/li>\r\n<li>\"Tell your friends\" or \"Get it now\" or any other calls to action are not allowed in the latest version of Facebook Timeline.<\/li>\r\n<\/ul>\r\n<p>All Timeline cover imagery is public and therefore means anyone visiting your Page will be able to see exactly which image you have chosen. The photos you display must not be deceptive, false or misleading any way that infringes on third party intellectual property. You must also not encourage of incentivize other fellow users, friends or business associates to display the same cover image as yours on personal Timelines.<\/p>\r\n<p>To sum up we are extremely excited about the latest Facebook feature release this week. They constantly deliver new services that are amazing and incredibly innovative to the market place.<\/p>\r\n<p>Here at Northplanet we are commited to provide you with the latest information on the hottest online topics around, to keep you ahead in the game. We would love to hear some feedback from you on the brand new Facebook 'Timeline for Brands' release and invite you to visit our very own <a href=\"https:\/\/www.facebook.com\/northplanet\">Northplanet Facebook Timline page by clicking here.<\/a><\/p>", "tags":"facebook, new fan page", "views":"463", "categorie_id":"2", "post_url":"facebooks-new-fan-page-learn-how-to-use-features" },{ "blog_id":"2", "post_date":"Mon, 23 January 2012", "post_title":"Northplanet Engages New Talent!", "article_img":"http:\/\/www.socialnewsoffice.com\/uploads\/1263.jpg", "post_content":"<p>Big piece of news for the start of 2012 is…… I have landed a full time role in a leading Web Design and Development agency based in Greater Manchester. After a successful interview on New Years Eve, I had another reason to celebrate bringing in the New Year!!<\/p>\r\n<p>I was first attracted to Northplanet when I came across there website when searching for jobs online. I was impressed not only by the standard of web work but the direction the company where going in. Growing year by year and providing exceptional web solutions for a number of businesses spread across the UK.<\/p>\r\n<p>I contacted them instantly and have done some freelance work a few times in the last year for Directors Danny and Mike and was able to build up a strong working relationship that helped me land the interview at the end of the year.<\/p>\r\n<p>I begin my career at Northplanet next week and will post all offers\/promotions and deals on here in the nearfuture.<\/p>\r\n<p>Time to sign off and prepare for my new career!!<\/p>", "tags":"engages new talent, new staff, northplanet staff, christian thomas mizon", "views":"271", "categorie_id":"1", "post_url":"northplanet-engages-new-talent" }] here is my code that does this Code: [Select] if (mysqli_num_rows($r) > 0) { // Available. while ($row = mysqli_fetch_array($r, MYSQLI_ASSOC)) { $results[] = array( 'blog_id' => ($row['ID']), 'post_date' => ($row['pd']), 'post_title' => (html_entity_decode($row['post_title'], ENT_QUOTES)), 'article_img' => ('http://www.socialnewsoffice.com/uploads/'.$row['article_img']), 'post_content' => ($row['post_content']), 'tags' => ($row['tags']), 'views' => ($row['views']), 'categorie_id' => ($row['categorie_id']), 'post_url' => ($row['post_url'])); } echo $json = Pretty_JSON(json_encode($results)); } i can access the json by using foreach($blog_posts as $post) { however what i need to do is add a value to the json like pages => 2 how could i do this? Okay so i know this is going to sound really stupid i just got out of school and now im in the real world here is the problem I dont know very much about how to work with JSON via PHP all i am trying to do is have the Script read data into an array from some text boxes then from the array into a JSON file the reading and the listing is all fine and dandy but only if i want the entire file how do i read data from a JSON file and only have it display data according to what i want so for example if i wanted to return data that matched an ID like you would do in MySQL like this ("SELECT * FROM catagories WHERE ID = '$id'") so how do i do that without a Database using a JSON File as a source for the data im trying to access code in Code: [Select] array(1) { [0]=> object(stdClass)#4 (1) { ["error"]=> array(1) { [0]=> object(stdClass)#5 (2) { ["message"]=> string(33) "no results found (error code 458)" ["code"]=> string(3) "458" } } } } ive tryed echo $blog_posts[0]->error->code; but all i get is Notice: Trying to get property of non-object in /home/sites/inspiredanceacademy.com/public_html/sno-blog-test/lib/social_news_office.php on line 173 Hello, I can't get a json call to work in my php... Hope some one can see where I am going wrong and push me in the right direction. I have 3 values I am trying to send from the php file to the html. The output looks as if it should work, but is does not... So here is the php variable that does give me a result, but I have no idea why it does not show in the div. <?php $choice = (isset($_POST['choice'])) ? date("Y-m-d",strtotime($_POST['choice'])) : date("Y-m-d"); $con = mysql_connect("localhost","root","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 = '".$choice."' group by date"; $res = mysql_query($sql) or die('sql='.$sql."\n".mysql_error()); $row = mysql_fetch_assoc($res); $dayPowerP = array( $row['choice']); ?> <?php $choice = (isset($_POST['choice'])) ? date("m",strtotime($_POST['choice'])) : date("m"); $con = mysql_connect("localhost","root","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); $monthPowerP = array($row['choice']); ?> <?php $choice = (isset($_POST['choice'])) ? date("Y",strtotime($_POST['choice'])) : date("Y"); $con = mysql_connect("localhost","root","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); $yearPowerP = array( $row['choice']); ?> <?php $outarr['dayPowerP'] = $dayPowerP; $outarr['monthPowerP'] = $monthPowerP; $outarr['yearPowerP'] = $yearPowerP; echo json_encode($outarr); ?> Now there are no errors, and this is what the output is so I would assume it should work as the right values are there and the right id..... Code: [Select] {"dayPowerP":["12.7240"],"monthPowerP":["145.0460"],"yearPowerP":["941.0370"]} I do not understand. Now the Jquery should be working as well... the ajax should be sending the post with json to carry the key data to make a clear result from the php and json should be doing it's job in the php file and the Jquery is do basic to have any issues, so that leaves my focus on the PHP at this time, but I do not see a proplem. Code: [Select] $(document).ready(function () { $('#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)); $.ajax({ type: "POST", url: "clickdates.php", data: {choice: dateText}, dataType: "json", success: function(json_data) { $('#apDiv2').html(json_data['dayPowerP']); $('#apDiv6').html(json_data['monthPowerP']); $('#apDiv8').html(json_data['yearPowerP']); } }) }}); }); The one thing that is odd. When I use 3 different php files, it works perfect, but that is not using json. Now that I am using json to return 1 call from the php, I am lost at this point, does anyone see what I can't... Thanks, Alan 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); ?> My script is not acting like it should. I believe its because of the recent change in the api, (the new error array)? Before there was only one.... <?php $gamertag = 'l RaH l'; $url = "http://api.xboxleaders.com/user_api.php?gamertag=".str_replace(' ', '%20', $gamertag); $output = file_get_contents($url); // try to convert the response into a PHP object $obj = json_decode($output); if(!is_object($obj)) die("Error parsing JSON response\n"); //define variables $avatar = ($obj->user->avatar); $gold = ($obj->user->gold); print $avatar; print $gold; ?> if you print_r $object; it displays this {"error":{"code":200,"desc":"OK"}},{"user":{"gold":1,"gamertag":"l RaH l","avatar":"http:\/\/avatar.xboxlive.com\/avatar\/l%20RaH%20l\/avatarpic-l.png","gamerscore":12508,"reputation":20},"recent_games":[{"recent_game":{"title":"Halo: Reach","link":"http:\/\/gamercard.xbox.com\/en-US\/GameCenter\/Achievements?titleId=1297287259&compareTo=l%20RaH%20l","image":"http:\/\/tiles.xbox.com\/tiles\/ih\/ew\/0Wdsb2JhbA9ECgR8GgMfVlohL2ljb24vMC84MDAwIAAAAAAAAP6fF5U=.jpg"}},{"recent_game":{"title":"Halo 3","link":"http:\/\/gamercard.xbox.com\/en-US\/GameCenter\/Achievements?titleId=1297287142&compareTo=l%20RaH%20l","image":"http:\/\/tiles.xbox.com\/tiles\/Us\/3e\/1Wdsb2JhbA9ECgR8GgMfWSpVL2ljb24vMC84MDAwIAAAAAAAAPrxzU0=.jpg"}},{"recent_game":{"title":"AC Brotherhood","link":"http:\/\/gamercard.xbox.com\/en-US\/GameCenter\/Achievements?titleId=1431504989&compareTo=l%20RaH%20l","image":"http:\/\/tiles.xbox.com\/tiles\/oK\/tp\/1Wdsb2JhbA9ECgUNGgMfVlonL2ljb24vMC84MDAwIAAAAAAAAPpGq78=.jpg"}},{"recent_game":{"title":"Fighters Uncaged","link":"http:\/\/gamercard.xbox.com\/en-US\/GameCenter\/Achievements?titleId=1431504974&compareTo=l%20RaH%20l","image":"http:\/\/tiles.xbox.com\/tiles\/v+\/Au\/0Wdsb2JhbA9ECgUNGgMfVlsmL2ljb24vMC84MDAwIAAAAAAAAP4B4KA=.jpg"}},{"recent_game":{"title":"Assassin's Creed","link":"http:\/\/gamercard.xbox.com\/en-US\/GameCenter\/Achievements?titleId=1431504852&compareTo=l%20RaH%20l","image":"http:\/\/tiles.xbox.com\/tiles\/L3\/mu\/0Wdsb2JhbA9ECgUNGgMfWStXL2ljb24vMC84MDAwIAAAAAAAAP6BeTA=.jpg"}}]} 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?
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
}
}
]}
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>"; } 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 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!
Hi Guys, One of my API providers has recently updated the way they output data in JSON to the following:
{
"ua":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64; rv:65.0) Gecko\/20100101 Firefox\/65.0",
"type":"browser",
"brand":null,
"name":null,
"url":"https:\/\/www.mozilla.org\/",
"os":{
"name":"Windows 10",
"code":"windows_10",
"url":"https:\/\/en.wikipedia.org\/wiki\/Windows_10",
"family":"Windows",
"family_code":"windows",
"family_vendor":"Microsoft Corporation.",
"icon":"https:\/\/assets.userstack.com\/icon\/os\/windows10.png",
"icon_large":"https:\/\/assets.userstack.com\/icon\/os\/windows10_big.png"
},
"device":{
"is_mobile_device":false,
"type":"desktop",
"brand":null,
"brand_code":null,
"brand_url":null,
"name":null
},
"browser":{
"name":"Firefox",
"version":"65.0",
"version_major":"65",
"engine":"Gecko"
},
"crawler":{
"is_crawler":false,
"category":null,
"last_seen":null
}
}
Previous the JSON data was not nested which means i now need to update my code to grab the values, I cant work out how to grab nested values, below is my code working off the old JSON output. How do i go about grabbing the data now with the new format?
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, "URL-REMOVED");
curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE);
$result = curl_exec($ch);
$http = curl_getinfo($ch, CURLINFO_HTTP_CODE);
curl_close($ch);
$apiresult = json_decode($result);
foreach($apiresult as $result) {
$ua_type = $result->ua_type;
$os_name = $result->os_name;
$os_version = $result->os_version;
$browser_name = $result->browser_name;
$browser_version = $result->browser_version;
$ua_brand = $result->ua_brand;
$ua_name = $result->ua_name;
}
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. |
|||||||