[MySQL Date time]

I currently have the date time in this format:

 

2015-07-05T09:50:38.0870000Z

 

How can I convert this into

 

2015-07-05 09:50:38, such that I can import this into mysql database?

[Multinational Array]

Hi All,

 

Thanks for your support on this. I can confirm the issue is to do with me sending many http request on average it will take 1s for me to send and read a http request.

 

I am currently using curl and need to because I am adding a key which allows me to use the api. I am unable to insert the key thus unable to compare speeds with file_get_content.

 

Currently working on a cache system for the data.

[Multinational Array]

Cant use in_array since this does not work on multi dimensional arrays.

 

I found the reason for my code taking a while. For each image I want to display and am sending one http request. So If I want to get 9 images I send 9 http requests.

 

Hard to say if this is directly related to my internet connection or code. will try to test  on another network and compare the speeds

[Multinational Array]

There will be 9 items in an array the order is not always the same. The if statement will only match once and this is where I print the html

[Multinational Array]

 

I disagree

 

Here, you break out of the 2nd loop ONLY if the condition passes, which returns you to the original first loop where you have already overridden the original array. If the condition never passes in the 2nd loop, it also returns to the first original loop.

if ($val2['Purpose'] == "BoxArt" && $val2['Height'] == 300) {
  $url = $val2['Url'];
  $htmlxbox .= "<img src=\" $url \" title= Current Game Score:". $val['currentGamerscore'] . ">";
  break;
}

 

Sorry I don't understand this fully.

 

This if statement will always be true. As every game has a Box Art image with height of 300. 

 

Since the 2nd loop is indented and I have begun the loop I don't think I am overwriting $xbox360Games.

 

I have now changed this variable in the 2nd loop as I am confusing myself now .

 

Also, Please can some help me with the sleep of this algorithm as I am still experiencing upto 9 seconds for each cycle in the 2nd loop.

 

Thanks

[Multinational Array]

foreach($xbox360Games['titles'] as $val) {
// ...
  $xbox360Games = getGameInfo(dechex($val['titleId']));  //Don't create a new $xbox360Games here, you're wiping out the original array that you're looping over above!
}

 

 

I agree. However, I do not reuse the top level $xbox360Games again inside the loop.

[Multinational Array]

So I am currently using: https://xboxapi.com/

 

My aim to get the game image image of a users played game.

foreach($xbox360Games['titles'] as $val) { //This Loop gets all xbox360 games from a userid


		if ($val['currentGamerscore'] > 0 ){ //this rules out non game appes iplayer,twitch etc
		
			$xbox360Games = getGameInfo(dechex($val['titleId'])); 
//GetGameInfo is a fuction which will return the array for each game as listed in my original post
			
			foreach($xbox360Games['Items'][0]['Images']as $val2) {
			
				
				if ($val2['Purpose'] == "BoxArt" && $val2['Height'] ==   300) { 
				
					$url = $val2['Url'];
					$htmlxbox .=  "<img src=\" $url  \"  title= Current Game Score:".    $val['currentGamerscore'] . ">";
					break;

				}

			}
		}	
	
	}	

[Multinational Array]

there is no way that running that code should take 9 seconds unless your doing it on a 386. either you're not giving all the info or something somewhere is seriously wrong with your setup.

 

There can be up to 10 values in the array list. I only included two for my example.

[Multinational Array]

Apologies for the multiple post was having issues when posting this.

[Multinational Array]

Array

(

    [0] => Array

        (

            [Height] => 64

            [Purpose] => Thumbnail

            [Purposes] => Array

                (

                    [0] => Thumbnail

                )

 

            [ResizeUrl] => http://demo/demo.png

            => http://demo/demo.png

            [Width] => 64

        )

 [1] => Array

        (

            [Height] => 95

            [Purpose] => SellImage

            [Purposes] => Array

                (

                    [0] => SellImage

                )

 

            [ResizeUrl] => http://demo/demo.png

            => http://demo/demo.png

            [Width] => 420

        )

)

 

 

 

I am currently trying go get the Array value if Purposes = Thumbnail. 

 

To do this I have setup a for each loop and if statement:

 

foreach(Array as $key => $val) {

    if ($val['Purpose'] == "Thumbnail") {
       print_r($val[url]);
    }
}

 

I have done some testing and I have seen this take over 9 seconds to return the url.

 

My question is their a better way to get $val?