|
PHP - Add Php Array To Json Array
Hello. I was wondering how can I add a php array to a js array containing json values.
var availableTags = [ "AppleScript", "Asp", "BASIC", "C", "C++", "Clojure", "COBOL", "ColdFusion", "Erlang", "Fortran", "Groovy", "Haskell", "Java", "JavaScript", "Lisp", "Perl", "PHP", "Python", "Ruby", "Scala", "Scheme" ];I want to add this to the js array:
<?php $arr = array('red', 'green', 'blue'); ?>
I've tried doing this, but its definitely the wrong approach as it just sums everything up into one element "redgreenblue"
var availableTags = [
"<?php foreach($arr as $row) { echo $row; } ?>",
"AppleScript",
"Asp",
"BASIC",
....
Thanks for any kind of help!
Edited by Pain, 19 August 2014 - 05:17 PM. Similar TutorialsHello all, I have yet again trouble finding a logical solution to my problem. I'm fetching an array which can hold 1 or more values. The problem is, I want these values to ouput in my json_encode function, but this also needs to happen dynamically depending on the amount of values. I can't explain it further, so here's the code so far: Code: (php) [Select] $files = mysql_fetch_array($get_files); $a = count($files); $i = 1; while ($files) { $variablename = 'fileName' . $i; $$variablename = $files['fileName']; $i++; } $output = array( OTHER VALUES , 'fileName1' => $fileName1, 'fileName2' => $fileName2, 'fileName3' => $fileName3, ............); // How do I add the fileNames dynamically depending on how many there are? This got me thinking, I also need to dynamically GET the values with jQuery. How would I do that, when the above eventually works? Thank you. I have a json file returned by facebook e.g { "data": [ { "name": "Support! Muffin the fool (Oldham Chronicle FAKE)", "category": "Community", "id": "181377645219010", "access_token": "102650199811234|060d3610d4dba63953209fa5-637782927|181377645219010|MvOBJKYtO7eT8JxMLtJ00HtGNxo" }, { "name": "Northplanet", "category": "Local business", "id": "132483460132622", "access_token": "102650199811234|060d3610d4dba63953209fa5-637782927|132483460132622|AHXPNTZx7aihyQS_A9W6pR115U4" }, { "name": "Social Media Manger", "category": "Application", "id": "102650199811234", "access_token": "102650199811234|060d3610d4dba63953209fa5-637782927|102650199811234|KeH0n1OKzZFtCkpa0lX1yJZ7NBE" }, { "name": "Top Ten Things To Remember Me By!", "category": "Application", "id": "375102030458", "access_token": "102650199811234|060d3610d4dba63953209fa5-637782927|375102030458|H-mpQWrksu_2FzZ_eBNVzeD2Z1Y" } ] } $graph_url = "https://graph.facebook.com/$uid/comments=" . $access_token; $api = json_decode(file_get_contents($graph_url)); $name = $api->data->name; // this bit not storing the name not sure why 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)); ?> i am brand new to php and thought a project looking at the weather undergound api would be a great place to "cut my teeth" and i am following up on a recent post i saw here http://www.phpfreaks.com/forums/index.php?topic=354658.msg1675207#msg1675207 the responder excellently described how to use the foreach function however i am not sure this is right for my application the project i am trying to accomplish is defining the freeze thaw cycle for the next ten days which i can accomplish in excel but thought this is a good way to learn to code. so my question is how should i do this, i have tried and failed with trying to pick out individual highs and lows data and define them as above or below freezing but i can't figure out how to pick out the right number my code for this part of the project is $json_line = file_get_contents("http://api.wunderground.com/api/{key}/geolookup/forecast10day/q/$zipcode.json"); $parsed_line = json_decode($json_line); echo $parsed_json->{'forecast'}->{'simpleforecast'}->{'forecastday'}->{'date'}->{'weekday'}; $temp_h = $parsed_line->{'forecast'}->{'simpleforecast'}->{'forecastday'}->{'high'}->{'farenheit'}; $temp_l = $parsed_json->{'forecast'}->{'simpleforecast'}->{'forecastday'}->{'low'}->{'farenheit'}; echo "Forecast for ${day} is:\n"; echo "High Temp is ${temp_h}<br />"; echo "Low Temp is ${temp_l}\n"; another road i was looking at going down was trying to do an array shift any help would be greatly appreciated thanks jeremy Havent posted here in a while, been learning lots but im stuck on trying to unset/replace arrays that contain awkward key values.
[0] => 2021-06-02T19:40:00Z
[1] => 2021-06-03T02:10:00Z
[2] => 2021-06-03T01:10:00Z
[3] => 2021-06-02T23:05:00Z
[4] => 2021-06-02T23:05:00Z
[5] => 2021-06-02T23:07:00Z
[6] => 2021-06-02T23:20:00Z
[7] => 2021-06-02T18:20:00Z
[8] => 2021-06-03T00:10:00Z
[9] => 2021-06-03T00:40:00Z
The json Im using is constantly updated, not sure why tmrw's dates June 3rd are at the top for their API design =[ Not good at regex. preg_replace/etc. Im desperate id use array search manually if I knew how to simple parse out tmrw's dates. I have unlimited API calls so I reckon it don't matter, here's what Ive been playing with
$oddsdata = 'https://pinnacle.datafeeds.net/api/json/odds/pinnacle/v3/60/baseball/mlb/moneyline?api-key=a71b8fe8e9eb957db549aaa5d99797a4';
$readodds = file_get_contents($oddsdata);
$odds = json_decode($readodds, true);
$today = date("Y-m-d");
$tmrw = date('Y-m-d', strtotime( $today . " +1 days"));
foreach($odds['games'] as $key => $val):
$gidRE[$key]["gid"] = $val["gameUID"];
$startOdds[$key]["start"] = $val["startDate"];
$homeTeams[$key]["hteam"] = $val["homeTeam"];
$awayTeams[$key]["ateam"] = $val["awayTeam"];
$Price[$key]["betPrice"] = $val["betPrice"];
$BookOdds[$key]["book"] = $val["sportsbook"];
$BetName[$key]["betName"] = $val["betName"];
$Live[$key]["Live"] = $val["isLive"];
endforeach;
$endgidd = end(array_keys($gidRE)) + '1';
$endz = end(array_keys($odds['games']));
for ($l = 0; $l < $endz; ++$l) {
$OddsAll[] = array_merge($gidRE[$l], $startOdds[$l], $homeTeams[$l], $awayTeams[$l], $Price[$l], $BetName[$l]);
}
Hello everyone. I'm a self learner that is very new to programming. I'm trying to print out the value of ["mid"] from a json_decode variable in the code shown below: I'm trying to use for each to access the value of "mid'. using foreach function. I know I'm not doing it the right way. please help me or show me an easy was to go around it.
/////the json resopnd form the url is :
{"terms":"http://www.xe.com/legal/dfs.php","privacy":"http://www.xe.com/privacy.php","from":"USD","amount":1.195,"timestamp":"2021-02-09T16:52:00Z","to":[{"quotecurrency":"NGN","mid":454.6559871014}]}
/////////////////////////////////////////////////
<?php
$auth = base64_encode("username:password");
$context = stream_context_create([
"http" => [
"header" => "Authorization: Basic $auth"
]
]);
$homepage = file_get_contents("https://xecdapi.xe.com/v1/convert_from?to=NGN&amount=1.195", false, $context );
$json = json_decode($homepage, TRUE);
foreach ($json as $price){
echo $price['mid'];
};
?>
<?php
ini_set('display_errors', 0);
function escapeArray($array)
{
foreach ($array as $key => $val)
{
if(is_array($val)){
$array[$key]=escapeArray($val);
}
else{
$array[$key]=addslashes($val);
}
}
return $array;
}
$request_type=$_SERVER['REQUEST_METHOD'];
$api_key=$_SERVER['HTTP_X_API_KEY'];
$res=array();
if($api_key!=="643256432"){
$res['msg']="Failu Invalid API KEY";
echo json_encode($res);
die;
}
// Connects to the orcl service (i.e. database) on the "localhost" machine
//$conn = oci_connect('SCOTT', 'admin123', 'localhost/orcl');
$conn = oci_connect('test', 'test', '192.168.10.43/test.test.com');
if (!$conn) {
$e = oci_error();
trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
}
$request=file_get_contents("php://input");
$request=escapeArray(json_decode($request,true));
print_r($request);
// die;
if($request_type=="POST"){//for creation of invoice
echo $CONTACT_ID=isset($request['CONTACT_ID'])?$request['CONTACT_ID']:"";
$INV_SERIAL_NO=isset($request['INV_SERIAL_NO'])?$request['INV_SERIAL_NO']:"";
$NAME=isset($request['NAME'])?$request['NAME']:"";
$INV_DATE=isset($request['INV_DATE'])?$request['INV_DATE']:"";
$DUE_DATE=isset($request['DUE_DATE'])?$request['DUE_DATE']:"";
$CURRENCY=isset($request['CURRENCY'])?$request['CURRENCY']:"";
$SUBTOTAL=isset($request['SUBTOTAL'])?$request['SUBTOTAL']:"";
$TAX_TOTAL=isset($request['TAX_TOTAL'])?$request['TAX_TOTAL']:"";
echo $SHIP_SERIAL_NO=isset($request['SHIP_SERIAL_NO'])?$request['SHIP_SERIAL_NO']:"";
$MASTER_NO=isset($request['MASTER_NO'])?$request['MASTER_NO']:"";
$HOUSE_NO=isset($request['HOUSE_NO'])?$request['HOUSE_NO']:"";
$shipment_data=isset($request['shipment_data'])?$request['shipment_data']:"";
if($CONTACT_ID==""){
$res['msg']="CONTACT_ID is required";
}
else if($INV_SERIAL_NO==""){
$res['msg']="INV_SERIAL_NO is required";
}
else if($NAME==""){
$res['msg']="NAME is required";
}
else if($INV_DATE==""){
$res['msg']="INV_DATE is required";
}
else if($DUE_DATE==""){
$res['msg']="DUE_DATE is required";
}
else if($CURRENCY==""){
$res['msg']="CURRENCY is required";
}
else if($SUBTOTAL==""){
$res['msg']="SUBTOTAL is required";
}
else if($TAX_TOTAL==""){
$res['msg']="TAX_TOTAL is required";
}
else if($MASTER_NO==""){
$res['msg']="MASTER_NO is required";
}
else if($HOUSE_NO==""){
$res['msg']="HOUSE_NO is required";
}
else if($SHIP_SERIAL_NO==""){
$res['msg']="SHIP_SERIAL_NO is required";
}
else{
$stid = oci_parse($conn, "Select * from FL_HDR_INVOICE where CONTACT_ID='$CONTACT_ID'");
(oci_execute($stid));
oci_fetch_all($stid, $out);
if(count($out['CONTACT_ID'])==0){
$stid = oci_parse($conn, "Insert into FL_HDR_INVOICE (CONTACT_ID,INV_SERIAL_NO,NAME,INV_DATE,DUE_DATE,CURRENCY,SUBTOTAL,TAX_TOTAL) Values ('$CONTACT_ID','$INV_SERIAL_NO','$NAME',TO_DATE('$INV_DATE','YYYY-MM-DD'),TO_DATE('$DUE_DATE','YYYY-MM-DD'),'$CURRENCY','$SUBTOTAL','$TAX_TOTAL')");
oci_execute($stid);
$stid_2 = oci_parse($conn, "Insert into FL_SHIPMENT_DATA (CONTACT_ID,INV_SERIAL_NO,SHIP_SERIAL_NO,MASTER_NO,HOUSE_NO) Values ('$CONTACT_ID','$INV_SERIAL_NO','$SHIP_SERIAL_NO','$MASTER_NO','$HOUSE_NO')");
oci_execute($stid_2);
if(oci_num_rows($stid)>0){
$res['msg']="Invoice created successfully against this contact_id:".$CONTACT_ID;
}
else{
$res['msg']="Something going wrong please try again later";
}
}
else{
$res['msg']="contact_id must be unique";
}
}
echo json_encode($res);
die;
}
I need to read json data inside an array. Please help correct my code.. i am trying to do an API. Hi, I have been banging my head against a brick wall the past few days trying to figure this out after reading so many tutorial and forum post but I still can't figure it out. I would be very grateful if someone could help me out. Basically I am being supplied with this JSON Data structu $json='{ "countries": { "country": [ { "@attributes": { "Name": "Germany", "Lat": "52.6847077739394", "Lng": "-6.81976318359375", "ZoomLevel": "7" } }, { "@attributes": { "Name": "Sweeden", "Lat": "54.00131186464818", "Lng": "-7.36358642578125", "ZoomLevel": "8" } } ] } }'; I decode the JSON data structure as a PHP array and I print out the contents of the array for debugging purposes: $json_array=json_decode($json,true); print_r($json_array); Heres what the outputed array looks like: Code: [Select] Array ( [countries] => Array ( [country] => Array ( [0] => Array ( [@attributes] => Array ( [Name] => Germany [Lat] => 52.6847077739394 [Lng] => -6.81976318359375 [ZoomLevel] => 7 ) ) [1] => Array ( [@attributes] => Array ( [Name] => Sweeden [Lat] => 54.00131186464818 [Lng] => -7.36358642578125 [ZoomLevel] => 8 ) ) ) ) ) I want to be able to access all the country names contained in [Name] Can anyone please help me on how to do this correctly as I've tried lots of code with multi-dimensional arrays but I've had no luck. I am not able to acces the variable correctly. Thanks in advance. i am trying to get values from the json array that get direct messages from twitter but i am getting the message error "Parse error: syntax error, unexpected T_AS, expecting '(' " in relation to the line "foreach (array as $direct_message) {" Also should i convert the array into a linear php array? Code: [Select] // create new instance $OAuth = new TwitterOAuth($consumer_key,$consumer_secret, $oAuthToken, $oAuthSecret); $direct_message = $OAuth->get('https://api.twitter.com/1/direct_messages.json?count=1&page='); function write_into_database ($direct_message) { $conn = mysql_connect("127.0.0.1", "Diego", "frafra") or die(mysql_error()); mysql_select_db('bot', $conn) or die(mysql_error()); foreach(array as $direct_message) { mysql_query("INSERT INTO 'followers' ('user_id', 'user_alias'), VALUES ('{$direct_message->sender_id}', '{$direct_message->sender_screen_name}, INSERT INTO 'd_messages'('message_id', 'message'), VALUES ('{$direct_message->id}' ,'{$direct_message->text})"); } write_into_database($direct_message); Hi, I have the following code that takes a list from a mySQL db and puts it into an array that shows 'gig date, venue, city' per entry: - Code: [Select] while ($row = mysql_fetch_array($result,MYSQL_ASSOC)) { $array[] = ($row['date'].', '.$row['gl_venue'].', '.$row['gl_city']); } $output = json_encode($array); this outputs JSON like so: Code: [Select] ["06-05-2011, O'neills, Southend","07-05-2011, Power League, Peterborough","14-05-2011, Queen Victoria hall, Oundle",.......] how do I add keys into the array so I get something like: Code: [Select] {"gigs":[ { "gig": "date, venue, city",} ]} at least I think so anyway!?! What I want to do is eventually be able to parse a JSON listing into Objective-C and be able to call key/pairs into various different parts of an app. I'm pretty new to this so any advice would be great. I have a simple ajax that passes data to a php script using jquery serialize. This is working good but where I am getting stuck is trying to pass json array into mysql. The json is outputting the correct data, but when I insert into db, it just says Array in the field. How can I convert(if that is the right term) json array to use in mysql. In the code I have posted, $box is an array from jquery which I normally use foreach to loop through array. What I need to do is convert $box after is has been encoded. Thanks Code: [Select] $box = $_POST['BRVbrtrv_boxnumber']; $list = array("activity" => $activity, "mobile" => $mobile, "company" => $company, "authorised" => $authorised, "service" => $service, "department" => $department, "address" => $address, "boxcount" => $boxcount, "box" => $box); $c = json_encode($list); echo $c; I have this array of items in my php file.
$items = array(
array("id" => 100,"categorypath" => "level1/powders", "product" => "Mens powder"),
array("id" => 200,"categorypath" => "level1/oils/sunflower", "product" => "XYZ oil"),
array("id" => 300,"categorypath" => "level1/eatable/vegetables", "product" => "carrot"),
array("id" => 400,"categorypath" => "level1/oils/sunflower", "product" => "ABC oil"),
array("id" => 500,"categorypath" => "level1/eatable/fruits", "product" => "mango"),
array("id" => 600,"categorypath" => "level1/eatable/vegetables", "product" => "spinach"),
array("id" => 700,"categorypath" => "level2/baby items/toys", "product" => "puzzle block"),
array("id" => 800,"categorypath" => "level2/baby items/toys", "product" => "trucks and cars"),
array("id" => 900,"categorypath" => "level2/baby items/clothes", "product" => "shirts"),
array("id" => 1000,"categorypath" => "level1/powders", "product" => "Womens powder"),
array("id" => 1100,"categorypath" => "level1/oils/groundnut", "product" => "GN oil"),
);
Using the above array I am trying to generate a JSON file that will have the following structu
{
"category":[
{
"categoryName":"level1",
"category":[
{
"categoryName":"powders",
"products":[
{
"id":"100",
"path":"level1/powders",
"prodname":"Mens powder"
},
{
"id":"1000",
"path":"level1/powders",
"prodname":"Womens powder"
}
]
},
{
"categoryName":"oils",
"category":[
{
"categoryName":"sunflower",
"products":[
{
"id":"200",
"path":"level1/oils/sunflower",
"prodname":"XYZ oil"
},
{
"id":"400",
"path":"level1/oils/sunflower",
"prodname":"ABC oil"
}
]
},
{
"categoryName":"groundnut",
"products":[
{
"id":"1100",
"path":"level1/oils/groundnut",
"prodname":"GN oil"
}
]
}
]
},
{
"categoryName":"eatable",
"category":[
{
"categoryName":"vegetables",
"products":[
{
"id":"300",
"path":"level1/eatable/vegetables",
"prodname":"carrot"
},
{
"id":"600",
"path":"level1/eatable/vegetables",
"prodname":"spinach"
}
]
},
{
"categoryName":"fruits",
"products":[
{
"id":"500",
"path":"level1/eatable/fruits",
"prodname":"mango"
}
]
}
]
}
},
{
"categoryName":"level2",
"category":[
{
"categoryName":"baby items",
"category":[
{
"categoryName":"toys",
"products":[
{
"id":"700",
"path":"level2/baby items/toys",
"prodname":"puzzle blocks"
},
{
"id":"800",
"path":"level2/baby items/toys",
"prodname":"trucks and cars"
}
]
},
{
"categoryName":"clothes",
"products":[
{
"id":"900",
"path":"level2/baby items/clothes",
"prodname":"shirts"
}
]
}
]
}
]
}
Not being an expert in php, I have somehow managed to reach thus far in my code, but can not quite arrive at the correct logic. Having trouble with handling associative arrays and objects in php. (Javascripting is much easier I feel) So far I have managed to fix all the errors/warning in my code. Here is my full php code:
$items = array(
array("id" => 100,"categorypath" => "level1/powders", "product" => "Mens powder"),
array("id" => 200,"categorypath" => "level1/oils/sunflower", "product" => "XYZ oil"),
array("id" => 300,"categorypath" => "level1/eatable/vegetables", "product" => "carrot"),
array("id" => 400,"categorypath" => "level1/oils/sunflower", "product" => "ABC oil"),
array("id" => 500,"categorypath" => "level1/eatable/fruits", "product" => "mango"),
array("id" => 600,"categorypath" => "level1/eatable/vegetables", "product" => "spinach"),
array("id" => 700,"categorypath" => "level2/baby items/toys", "product" => "puzzle block"),
array("id" => 800,"categorypath" => "level2/baby items/toys", "product" => "trucks and cars"),
array("id" => 900,"categorypath" => "level2/baby items/clothes", "product" => "shirts"),
array("id" => 1000,"categorypath" => "level1/powders", "product" => "Womens powder"),
array("id" => 1100,"categorypath" => "level1/oils/groundnut", "product" => "GN oil"),
);
$jsonStruct = array();
function jsonCreateStruct(){
GLOBAL $items;
for($c=0; $c<count($items); $c++){
$categ = $items[$c]["categorypath"];
insertJson($categ, $items[$c]);
}
}
function insertJson($catg, $itm){
GLOBAL $jsonStruct;
$exp = explode("/",$catg);
print_r("\n\n\n $catg \n");
if(count($exp) == 1){
print_r("Level 1 \n");
if(!isset($jsonStruct[0])){
$jsonStruct[0]["categoryName"] = $exp[0];
$jsonStruct[0]["products"] = array($itm);
print_r("\nCreated:: $exp[0]");
}else{
$notFound = true;
for($j=0; $j<count($jsonStruct); $j++){
$catgName = $jsonStruct[$j]["categoryName"];
print_r("\nFound: $catgName");
if($catgName == $exp[0]){
$notFound = false;
if($jsonStruct[$j]["products"]){
array_push($jsonStruct[$j]["products"],array($itm));
}else{
$jsonStruct[$j]["products"] = array();
array_push($jsonStruct[$j]["products"],array($itm));
}
}
}
if($notFound){
print_r("\nNotFound\n");
array_push($jsonStruct,array("categoryName"=> $exp[0], "products" => array($itm)));
}
}
}
if(count($exp) == 2){
print_r("Level 2 \n");
if(!isset($jsonStruct[0])){
$jsonStruct[0]["categoryName"] = $exp[0];
$jsonStruct[0]["categorypath"] = array("categoryName" => $exp[1], "products" => array($itm));
print_r("\nCreated:: $exp[0] / $exp[1]");
}else{
$notFound1 = true;
$notFound2 = true;
$indexLevel = null;
for($j=0; $j<count($jsonStruct); $j++){
$catgName1 = $jsonStruct[$j]["categoryName"];
print_r("\nFound: $catgName1");
if($catgName1 == $exp[0]){
$notFound1 = false;
$indexLevel = $j;
if(isset($jsonStruct[$j]["categorypath"])){
$level1 = $jsonStruct[$j]["categorypath"];
for($m=0; $m<count($level1); $m++){
if(isset($level1[$m]["categoryName"])){
$catgName2 = $level1[$m]["categoryName"];
print_r("\nFound: $catgName2");
if($catgName2 == $exp[1]){
$notFound2 = false;
if($level1[$m]["products"]){
array_push($jsonStruct[$j]["categorypath"][$m]["products"],array($itm));
}else{
$jsonStruct[$j]["categorypath"][$m]["products"] = array();
array_push($jsonStruct[$j]["categorypath"][$m]["products"],array($itm));
}
}
}
}
}
}
}
if($notFound1){
print_r("\nNotFound1\n");
array_push($jsonStruct,array("categoryName"=> $exp[0], "categorypath" => array("categoryName" => $exp[1],"products" => array($itm))));
}else if($notFound2){
print_r("\nNotFound2\n");
// $jsonStruct[$indexLevel]["categorypath"] = array("categoryName"=> $exp[1], "products" => array($itm));
$jsonStruct[$indexLevel]["categorypath"] = array();
array_push($jsonStruct[$indexLevel]["categorypath"], array("categoryName"=> $exp[1], "products" => array($itm)));
}
}
}
if(count($exp) == 3){
print_r("Level 3 \n");
if(!isset($jsonStruct[0])){
$jsonStruct[0]["categoryName"] = $exp[0];
$jsonStruct[0]["categorypath"] = array("categoryName" => $exp[1], "categorypath" => array("categoryName" => $exp[2], "products" => array($itm)));
print_r("\nCreated:: $exp[0] / $exp[1] / $exp[2]");
}else{
$notFound1 = true;
$notFound2 = true;
$notFound3 = true;
$indexLevel1 = null;
$indexLevel2 = null;
for($j=0; $j<count($jsonStruct); $j++){
$catgName1 = $jsonStruct[$j]["categoryName"];
print_r("\nFound: $catgName1");
if($catgName1 == $exp[0]){
$notFound1 = false;
$indexLevel1 = $j;
if(isset($jsonStruct[$j]["categorypath"])){
$level2 = $jsonStruct[$j]["categorypath"];
for($m=0; $m<count($level2); $m++){
if(isset($level2[$m]["categoryName"])){
$catgName2 = $level2[$m]["categoryName"];
print_r("\nFound: $catgName2");
if($catgName2 == $exp[1]){
$notFound2 = false;
$indexLevel2 = $m;
if(isset($level2[$m]["categorypath"])){
$level3 = $level2[$m]["categorypath"];
for($n=0; $n<count($level3); $n++){
//print_r($level3["categoryName"]);
if(isset($level3["categoryName"])){
$catgName3 = $level3["categoryName"];
print_r("\ncatgName3: ". $catgName3);
if($catgName3 == $exp[2]){
$notFound3 = false;
if($level3["products"]){
print_r("\npushing into array\n");
array_push($jsonStruct[$j]["categorypath"][$m]["categorypath"]["products"],array($itm));
}else{
print_r("\ncreate new and pushing into array\n");
$jsonStruct[$j]["categorypath"][$m]["categorypath"][$n]["products"] = array();
array_push($jsonStruct[$j]["categorypath"][$m]["categorypath"]["products"],array($itm));
}
}
}
}
}
}
}
}
}
}
}
if($notFound1){
print_r("\nNotFound1\n");
array_push($jsonStruct, array("categoryName"=> $exp[0], "categorypath" => array("categoryName" => $exp[1],"products" => array($itm))));
}else if($notFound2){
print_r("\nNotFound2\n");
if(!$jsonStruct[$indexLevel1]["categorypath"]){
$jsonStruct[$indexLevel1]["categorypath"] = array();
}
array_push($jsonStruct[$indexLevel1]["categorypath"], array("categoryName"=> $exp[1], "categorypath" => array("categoryName" => $exp[2], "products" => array($itm))));
}else if($notFound3){
print_r("\nNotFound3\n");
//$jsonStruct[$indexLevel1]["categorypath"][$indexLevel2]["categorypath"] = array("categoryName"=> $exp[2], "products" => array($itm));
if(!$jsonStruct[$indexLevel1]["categorypath"][$indexLevel2]["categorypath"]){
$jsonStruct[$indexLevel1]["categorypath"][$indexLevel2]["categorypath"] = array();
}
array_push($jsonStruct[$indexLevel1]["categorypath"][$indexLevel2]["categorypath"], array("categoryName"=> $exp[2], "products" => array($itm)));
}
}
}
}
jsonCreateStruct();
print_r("----------------------------------------");
print_r($jsonStruct);
// echo json_encode($jsonStruct);
I have now reached a point where I desperately need help from experts.
hello, i want to extract the sender_id, sender_alias and text from the array that should be returned when requesting access to direct messages via API. I get the error "Fatal error: Call to undefined method TwitterOAuth::request() " referring to the line $direct_message = $OAuth->request('GET', $OAuth->url('https://api.twitter.com/1/direct_messages.json'), array('sender_id','screen_name' ,'text')); Code: [Select] // create new instance $OAuth = new TwitterOAuth($consumer_key,$consumer_secret, $oAuthToken, $oAuthSecret); $direct_message = $OAuth->request('GET', $OAuth->url('https://api.twitter.com/1/direct_messages.json'), array('sender_id','screen_name' ,'text')); $direct_message = json_decode($OAuth->response['response'], true); echo response;
An affiliate marketer refers some products which are stored in a simple array. $all_items_sold = '{"7777":{"item":"hammer","price":"4.99"},"8888":{"item":"nail","price":"1.99"},"9999":{"item":"apple","price":"2.00"}}';
$referred_by_Affiliate = array('1234','8888','7777');
So, out of all the 3 items that sold, only 2 of them were referred by the affiliate marketer.
Currently I do this:
Is there a "best practices" way to accomplish this?
Thank you. Hello.
I am new here.
I have a sligh problem, i saw a few results here which however did not lead to the desired result.
The problem is , i have this Json Response from a API:
Array
(
[0] => Array
(
[isoid] => 0
[omschrijving] => - leeg -
)
[1] => Array
(
[isoid] => 64
[omschrijving] => ArchLinux 2013.5
)
[2] => Array
(
[isoid] => 75
[omschrijving] => AsteriskNOW 3.0.0 64b
)
[3] => Array
(
[isoid] => 67
[omschrijving] => CentOS 5.9 32b
)
[4] => Array
(
[isoid] => 2
[omschrijving] => CentOS 6.3 64b
)
[5] => Array
(
[isoid] => 96
[omschrijving] => CentOS 7.0 64b
)
[6] => Array
(
[isoid] => 4
[omschrijving] => Clear OS 5.2 64b
)
[7] => Array
(
[isoid] => 93
[omschrijving] => CloudLinux 6.4
)
[8] => Array
(
[isoid] => 1
[omschrijving] => Debian GNU/Linux 6.0 / Squeeze 64b
)
[9] => Array
(
[isoid] => 79
[omschrijving] => Debian GNU/Linux 7.0 / Wheezy 32b
)
[10] => Array
(
[isoid] => 71
[omschrijving] => Debian GNU/Linux 7.0 / Wheezy 64b
)
[11] => Array
(
[isoid] => 63
[omschrijving] => Fedora 18 64b
)
[12] => Array
(
[isoid] => 82
[omschrijving] => FreeBSD 10 64b
)
[13] => Array
(
[isoid] => 77
[omschrijving] => FreeBSD 9.2 64b
)
[14] => Array
(
[isoid] => 10
[omschrijving] => FreePBX 5.211.65-12
)
[15] => Array
(
[isoid] => 76
[omschrijving] => GParted Live CD
)
[16] => Array
(
[isoid] => 3
[omschrijving] => KVM Virtio drivers voor Windows
)
[17] => Array
(
[isoid] => 66
[omschrijving] => MailCleaner 2012v6 64b
)
[18] => Array
(
[isoid] => 68
[omschrijving] => Manjaro KDE 0.8.6 64b
)
[19] => Array
(
[isoid] => 78
[omschrijving] => Microsoft Windows 7 Pro 64b
)
[20] => Array
(
[isoid] => 69
[omschrijving] => Microsoft Windows Server 2003 EN
)
[21] => Array
(
[isoid] => 8
[omschrijving] => Microsoft Windows Server 2008R2 EN
)
[22] => Array
(
[isoid] => 7
[omschrijving] => Microsoft Windows Server 2008R2 NL
)
[23] => Array
(
[isoid] => 70
[omschrijving] => Microsoft Windows Server 2012 NL 64b
)
[24] => Array
(
[isoid] => 84
[omschrijving] => Microsoft Windows Server 2012R2 NL
)
[25] => Array
(
[isoid] => 83
[omschrijving] => NOC PS 1.0r11
)
[26] => Array
(
[isoid] => 11
[omschrijving] => OpenBSD 5.2
)
[27] => Array
(
[isoid] => 80
[omschrijving] => OpenBSD 5.4
)
[28] => Array
(
[isoid] => 94
[omschrijving] => OpenBSD 5.5 64b
)
[29] => Array
(
[isoid] => 72
[omschrijving] => OpenSUSE 12.3 64b
)
[30] => Array
(
[isoid] => 95
[omschrijving] => Slackware 13.37
)
[31] => Array
(
[isoid] => 12
[omschrijving] => System Rescue CD
)
[32] => Array
(
[isoid] => 18
[omschrijving] => Turnkey Appflower
)
[33] => Array
(
[isoid] => 19
[omschrijving] => Turnkey ASP.net/Apache
)
[34] => Array
(
[isoid] => 20
[omschrijving] => Turnkey Bugzilla
)
[35] => Array
(
[isoid] => 21
[omschrijving] => Turnkey CodeIgniter
)
[36] => Array
(
[isoid] => 22
[omschrijving] => Turnkey Django
)
[37] => Array
(
[isoid] => 23
[omschrijving] => Turnkey Dokuwiki
)
[38] => Array
(
[isoid] => 24
[omschrijving] => Turnkey DomainControler
)
[39] => Array
(
[isoid] => 25
[omschrijving] => Turnkey Drupal7
)
[40] => Array
(
[isoid] => 26
[omschrijving] => Turnkey Fileserver
)
[41] => Array
(
[isoid] => 27
[omschrijving] => Turnkey Gallery
)
[42] => Array
(
[isoid] => 28
[omschrijving] => Turnkey Gitlab
)
[43] => Array
(
[isoid] => 15
[omschrijving] => Turnkey Google AppEngine Go
)
[44] => Array
(
[isoid] => 16
[omschrijving] => Turnkey Google AppEngine Java
)
[45] => Array
(
[isoid] => 17
[omschrijving] => Turnkey Google AppEngine Python
)
[46] => Array
(
[isoid] => 29
[omschrijving] => Turnkey IceScrum
)
[47] => Array
(
[isoid] => 30
[omschrijving] => Turnkey Joomla2.5
)
[48] => Array
(
[isoid] => 31
[omschrijving] => Turnkey LAMP
)
[49] => Array
(
[isoid] => 32
[omschrijving] => Turnkey Lighttpd/PHP/FastCGI
)
[50] => Array
(
[isoid] => 33
[omschrijving] => Turnkey Magento
)
[51] => Array
(
[isoid] => 34
[omschrijving] => Turnkey Mediawiki
)
[52] => Array
(
[isoid] => 35
[omschrijving] => Turnkey MongoDB
)
[53] => Array
(
[isoid] => 36
[omschrijving] => Turnkey MySQL
)
[54] => Array
(
[isoid] => 37
[omschrijving] => Turnkey NGINX/PHP/FastCGI
)
[55] => Array
(
[isoid] => 38
[omschrijving] => Turnkey OpenLDAP
)
[56] => Array
(
[isoid] => 39
[omschrijving] => Turnkey OpenPhoto
)
[57] => Array
(
[isoid] => 40
[omschrijving] => Turnkey OSCommerce
)
[58] => Array
(
[isoid] => 41
[omschrijving] => Turnkey OTRS
)
[59] => Array
(
[isoid] => 42
[omschrijving] => Turnkey Owncloud
)
[60] => Array
(
[isoid] => 43
[omschrijving] => Turnkey PHPBB
)
[61] => Array
(
[isoid] => 44
[omschrijving] => Turnkey PHPList
)
[62] => Array
(
[isoid] => 45
[omschrijving] => Turnkey PHPNuke
)
[63] => Array
(
[isoid] => 46
[omschrijving] => Turnkey Postgresql
)
[64] => Array
(
[isoid] => 47
[omschrijving] => Turnkey Prestashop
)
[65] => Array
(
[isoid] => 48
[omschrijving] => Turnkey Rails
)
[66] => Array
(
[isoid] => 49
[omschrijving] => Turnkey Redmine
)
[67] => Array
(
[isoid] => 50
[omschrijving] => Turnkey SiTracker
)
[68] => Array
(
[isoid] => 51
[omschrijving] => Turnkey StatusNET
)
[69] => Array
(
[isoid] => 52
[omschrijving] => Turnkey SugarCRM
)
[70] => Array
(
[isoid] => 53
[omschrijving] => Turnkey Symfony
)
[71] => Array
(
[isoid] => 54
[omschrijving] => Turnkey Tomcat
)
[72] => Array
(
[isoid] => 55
[omschrijving] => Turnkey Tomcat/Apache
)
[73] => Array
(
[isoid] => 56
[omschrijving] => Turnkey TRAC
)
[74] => Array
(
[isoid] => 57
[omschrijving] => Turnkey TWiki
)
[75] => Array
(
[isoid] => 58
[omschrijving] => Turnkey Typo3
)
[76] => Array
(
[isoid] => 59
[omschrijving] => Turnkey Wordpress
)
[77] => Array
(
[isoid] => 60
[omschrijving] => Turnkey Zencart
)
[78] => Array
(
[isoid] => 13
[omschrijving] => Ubuntu 10.04 32b
)
[79] => Array
(
[isoid] => 6
[omschrijving] => Ubuntu 10.04 64b
)
[80] => Array
(
[isoid] => 14
[omschrijving] => Ubuntu 12.04 32b
)
[81] => Array
(
[isoid] => 61
[omschrijving] => Ubuntu 12.04 64b
)
[82] => Array
(
[isoid] => 62
[omschrijving] => Ubuntu 12.10 64b
)
[83] => Array
(
[isoid] => 89
[omschrijving] => Ubuntu 14.04 LTS 64b
)
[84] => Array
(
[isoid] => 5
[omschrijving] => Windows Password Reset
)
[85] => Array
(
[isoid] => 81
[omschrijving] => Zen Loadbalancer 3.03
)
[86] => Array
(
[isoid] => 74
[omschrijving] => Zentyal 3.2
)
)
how would i go to fill it automatically in a option value like
<option value='74'>Zentyal 3.2</option>Thank you in advance Hello, Having a bit of a tough time understanding what is going on in my brain! I'm basically pulling some data from an API using CuRL, which is working fine. The structure of the data is: [data][tickets] - tickets being an array of support tickets in the system, which then contains ticketNumber, title, content. I want to display these values in a list, I have this code currently:
if ($err) {
echo "cURL Error #:" . $err;
} else {
$return = json_decode($response, true);
foreach($return as $key) {
echo $key["tickets"][1]['ticketNumber']." - ";
echo $key["tickets"][1]['title']." - ";
echo $key["tickets"][1]['content'];
}
}
Which obviously returns the ticketNumber, title & content of the first support ticket in the array, but I want to loop through and display that information for each ticket! Can anyone advise as to where I am going wrong? I think I need to utilise the ["tickets"][x] but not sure how!
Thanks in advance! Steve Hi, sorry if this has been covered elsewhere but I'm stuck. I'm trying to output individual headers when converted from json into an array. The array contains 6 headers eg. description, url etc but my result looks like the json_decode isn't working. The raw data looks fine when I output from print_r on the page. The code looks like this: -------------------------------------------------------------------- $json_array = json_decode($json,true); //print_r ($json_array); foreach ($json_array as $row) { echo $row["description"]." = ".$row["url"]."<br />"; ---------------------------------------------------------------------- the result is: ----------------------------------------------------------------------- C = C h = h = 0 = 0 c = c C = C ----------------------------------------------------------------------- Can anyone help or point me to a tutorial I can work though. Thanks Jogga Hello everyone.
please I have problem with printing out a value from inside an array of a nested json. ive tried several ways its always returns "index not define".
$valr= "https://ice3.com/api/v1/orderbook/ticker"; ////////////////////////////source
$valrGet = file_get_contents($valr);
$valrD = json_decode($valrGet, true);
$valrSell = ["ask"] ["price"];
Here is the structure of the json from the source :
{"errors":false,"response":{"entities":[{"pair_id":3,"pair_name":"BTC\/ZAR","ask":{"price":"179382.54","amount":"0.05357142"},"bid":{"price":"177229.4286563","amount":"0.0011"}},{"pair_id":4,"pair_name":"BTC\/NGN","ask":{"price":"8890000.00","amount":"0.10"},"bid":
my target is to output the value of ("price") from "pair_name" BTC\/ZAR please help. Thanks in advance hi i am trying to make a payroll calculator script that takes employee info, calculates pay, displays submitted info in a table, stores info in an array, and updates the array when new info is submitted. i have most of these accomplished, i am having trouble with the "store into an array, and update the array when new info is submitted" parts of the project. i am still not very fluent in php so there may be easier ways to achieve what i have so far. any pointers would be a great help, this part has got me stumped. NOTE - Please read the information first as it contains important information to understand the problem. Rules → • There are 9 Columns(C1,C2,C3,C4,C5,C6,C7,C8,C9) [ Max columns will be 9] • The number of Rows can vary from 3,6,9,12,15,18 (Max). In this case Number of Rows shall be 12 Number of Rows = No of Tickets (Max Allowed 6) x Rows Per Ticket (Max Allowed 3). Thus, Max Rows can be 18 • Each Row is required to have 4 Blank Spaces and 5 Filled with Numbers • All numbers available in the Column Array have to be utilized • This configuration of an shall create a matrix of 9 Columns & 12 Rows (3 x 4 Tickets), which is 108 MATRIX BLOCKS where only a maximum of 60 numbers can be filled out of 108 available blocksrandomly with the above conditions being met 100%. • The numbers in column must be arranged / sorted in ASCENDING ORDER (For coding logic purpose, as soon as the number is assigned to the new MATRIX MAP use array_shift() or unset() the number so as to avoid repetition Example - Row 1 and Column 1 shall generate a MATRIX BLOCK - R1C1 Row 3 and Column 7 shall generate a MATRIX BLOCK - R3C7 Matrix Block can also be termed as Matrix Cell for your ease (if needed) MASTER SET OF ARRAY WITH NUMBERS array( "C1"=> array( 1, 2, 3, 5, 6, 7, 9 ), //7 Numbers "C2"=> array( 13, 14, 15, 17, 18, 19 ), //6 Numbers "C3"=> array( 21, 22, 23, 24, 25, 26, 30 ), //7 Numbers "C4"=> array( 31, 33, 34, 36, 37, 38, 39 ), //7 Numbers "C5"=> array( 41, 42, 46, 47, 48, 49, 50 ), //7 Numbers "C6"=> array( 51, 52, 53, 54, 55, 57, 58 ), //7 Numbers "C7"=> array( 61, 62, 64, 65, 69, 70 ), //6 Numbers "C8"=> array( 71, 74, 75, 76, 77, 78 ), //6 Numbers "C9"=> array( 82, 83, 85, 87, 88, 89, 90 ) //7 Numbers ); The above array has 60 Numbers to be filled out of 108 MATRIX BLOCK / CELL which meets the condition that for a FULL BLOCK containing 4 MINI BLOCKS WITH 3 ROWS (max. allowed) EACH I have been able to generate this without any issue meeting all the conditions of the Columns My Allocation Matrix Array will look like array( "R1"=> array( "C1"=> true, // Means that MATRIX BLOCK R1C1 will be NOT EMPTY "C2"=> false, // Means that MATRIX BLOCK R1C2 will be EMPTY "C3"=> true, "C4"=> false, "C5"=> true, "C6"=> false, "C7"=> true, "C8"=> true, "C9"=> false ), "R2"=> array( "C1"=> false, "C2"=> true, "C3"=> false, "C4"=> true, "C5"=> false, "C6"=> true, "C7"=> true, "C8"=> true, "C9"=> false ), "R3"=> array( "C1"=> true, "C2"=> true, "C3"=> true, "C4"=> true, "C5"=> false, "C6"=> false, "C7"=> false, "C8"=> false, "C9"=> true ), "R4"=> array( "C1"=> true, "C2"=> true, "C3"=> true, "C4"=> false, "C5"=> true, "C6"=> true, "C7"=> false, "C8"=> false, "C9"=> false ), "R5"=> array( "C1"=> false, "C2"=> false, "C3"=> false, "C4"=> false, "C5"=> true, "C6"=> true, "C7"=> true, "C8"=> true, "C9"=> true ), "R6"=> array( "C1"=> true, "C2"=> true, "C3"=> false, "C4"=> true, "C5"=> false, "C6"=> true, "C7"=> false, "C8"=> false, "C9"=> true ), "R7"=> array( "C1"=> false, "C2"=> false, "C3"=> true, "C4"=> false, "C5"=> true, "C6"=> false, "C7"=> true, "C8"=> true, "C9"=> true ), "R8"=> array( "C1"=> true, "C2"=> false, "C3"=> false, "C4"=> true, "C5"=> false, "C6"=> false, "C7"=> true, "C8"=> true, "C9"=> true ), "R9"=> array( "C1"=> true, "C2"=> false, "C3"=> true, "C4"=> false, "C5"=> true, "C6"=> true, "C7"=> false, "C8"=> false, "C9"=> true ), "R10"=> array( "C1"=> false, "C2"=> true, "C3"=> true, "C4"=> true, "C5"=> true, "C6"=> false, "C7"=> true, "C8"=> false, "C9"=> false ), "R11"=> array( "C1"=> false, "C2"=> true, "C3"=> false, "C4"=> true, "C5"=> true, "C6"=> true, "C7"=> false, "C8"=> true, "C9"=> false ), "R12"=> array( "C1"=> true, "C2"=> false, "C3"=> true, "C4"=> true, "C5"=> false, "C6"=> true, "C7"=> false, "C8"=> false, "C9"=> true ) ); In the above array R stands for Row, C for Column, TRUE/FALSE (Boolean) means that if TRUE a Number can be filled in the resulting MATRIX BLOCK / CELL ( Row[Number]Column[Number] ) else if FALSE the MATRIX BLOCK / CELL shall be EMPTY The result for the above shall be
PROBLEM : I am unable to understand what should possibly be the logic & loop used here for creating a MATRIX ALLOCATION MAP as shown above I have tried while, foreach & for but unable determine the perfect combination which would meet the conditions. (Tried all of the above with Nested Loops also) Edited May 1, 2020 by AlphaMikeTags |
|||||||