PHP - Internet of Things Web Logger

PHP - Internet of Things Web Logger

By Daniel
Fri, 06/30/2017 - Updated 9 months ago
2 comments

Server side PHP Script that captures any HTTP GET request data and stores in a CSV spreadsheet. Can be used with Raspberry PI circuits, Arduino, IntelGalileo, IntelEdison and even with Smartwatches that can connect to the internet using Ethernet cables, Bluetooth, USB or Wifi.

Description

This is a PHP script that records data from Internet of Things (IoT) devices in a CSV spreadsheet that can be opened from Excel. If you also need a web view for the log, check the CSV Viewer for Web Browsers.

Features

  • Input is automatically decoded from the URLs by using the HTTP GET standard (see examples below).
  • Records different variable sets in the same spreadsheet, each variable goes to the column it belongs.
  • If a new variable is set, a column for it will be automatically created.
  • No specific order required for the input data.
  • Records the timestamp of the request and the IP address of the client.
  • Output in the CSV format that can be directly opened in Excel.
  • Output is UTF-8 compatible (at lease should be).
  • If the log reaches the maximum size, older entries will be automatically purged.
  • Return TRUE if the record was set and FALSE in case of problems.
  • The parameter ?LogClear=TRUE clears the table data and columns.
  • Web display for the log available in CSV Viewer for Web Browsers.
  • If a password is set, the parameter ?LogPass=yourpassword will be required to allow data to be inserted in the table.

Requirements

  • Webserver with PHP 5.1.x or higher installed.
  • Permissions for the script to read, write and delete in the target CSV folder.

Installation

Just put the script in the folder and run it. There is a configuration section in the code for further adjustments.

Examples

  • Request 1: http://www.mysite.com/iotcsvlog.php
  • Request 2: http://www.mysite.com/iotcsvlog.php?Temperature=22
  • Request 3: http://www.mysite.com/iotcsvlog.php?Temperature=22&Humidity=60
  • Request 4: http://www.mysite.com/iotcsvlog.php?Humidity=80&Temperature=25
  • Request 5: http://www.mysite.com/iotcsvlog.php?Pressure=1000
  • Request 6: http://www.mysite.com/iotcsvlog.php?Temperature=30&Pressure=900&Humidity=50
  • Request 7 (with password set): http://www.mysite.com/iotcsvlog.php?Humidity=50&LogPass=correct_password
  • Request 8 (with password set): http://www.mysite.com/iotcsvlog.php?Humidity=50&LogPass=wrong_password
    Wrong pass! No data logged.
  • Request 9 (with password set): http://www.mysite.com/iotcsvlog.php?Humidity=50
    Wrong pass! No data logged.
  • Request 10: http://www.mysite.com/iotcsvlog.php?LogClear=TRUE
    New empty table is created.
  • Request 11 (with password set): http://www.mysite.com/iotcsvlog.php?LogClear=TRUE&LogPass=correct_password
    New empty table is created.
Output table from request 1, 10 and 11
Date and Time IP
2017-06-30 10:27:45 -0300 192.168.1.1

 

Output table from requests 1 and 2

Date and Time IP Temperature
2017-06-30 10:27:45 -0300 192.168.1.1  
2017-06-30 10:28:48 -0300 192.168.1.1 22

 

Output table from requests 1 to 9

Date and Time IP Temperature Humidity Pressure
2017-06-30 10:27:45 -0300 192.168.1.1      
2017-06-30 10:28:48 -0300 192.168.1.1 22    
2017-06-30 10:29:32 -0300 192.168.1.1 22 60  
2017-06-30 10:33:20 -0300 192.168.1.1 25 80  
2017-06-30 10:48:55 -0300 192.168.1.1     1000
2017-06-30 10:55:30 -0300 192.168.1.1 30 50 900
2017-06-30 10:59:19 -0300 192.168.1.1   50  

Known issues

The script was designed to output the CSV in the UTF-8 format so it could support a wide range of languages and character sets. Unfortunately not all systems support UTF-8 in the same way and some characters might still be displayed incorrectly. To solve this problem, configure the PHP script to output the result file in the .txt format and then open it in Excel using the Text Import function. This way you will be able to proper adjust the importation character encoding.

Source code

  1. <?php
  2. /* =============================================================
  3. / * Internet of Things IoT CSV Logger
  4. * Version 1.2 (04/07/2017)
  5. *
  6. * This application logs any HTTP GET requests in a CSV file that can be directly opened by Excel.
  7. * The GET variable names will be used as column headers and the values will sorted in the rows.
  8. * The application can log completely different GET requests in the same CSV file and will automatically add the timestamp and the IP address of the client.
  9. * In case of success return TRUE, in case of errors return FALSE.
  10. *
  11. * Developed by Daniel Brooke Peig - daniel@danbp.org
  12. * http://www.danbp.org
  13. * Copyright 2017 - Daniel Brooke Peig
  14. *
  15. * This software is distributed under the MIT License.
  16. * Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:
  17. *
  18. * The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.
  19. *
  20. * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
  21. *
  22. *
  23. /* =============================================================*/
  24.  
  25. //------------------------------------------------
  26. //Configurations
  27. //
  28. $fileName = "iotcsvlog.csv";
  29. date_default_timezone_set('America/Sao_Paulo');
  30. $delimiter = ";";
  31. $enclosure = '"';
  32. $maxLogSize = 10000; //Most Excel versions can read only about 16000 lines
  33. $password = ''; //Optional to prevent abuse. If set to [your_password] will require the &LogPass=[your_password] GET parameter to allow the data to be recorded.
  34. //------------------------------------------------
  35.  
  36. //Variable initialization
  37. $logLines = array();
  38. $inputLine = array();
  39. $responseMessage = "FALSE";
  40.  
  41. if($_GET["LogClear"] === "TRUE"){
  42. //If this is set, the source file will not be processed and will be erased after the new log entry is created
  43. }
  44. else if(file_exists($fileName)){ // File exists
  45.  
  46. // Reads lines of file to array
  47. $fileLines = file($fileName, FILE_IGNORE_NEW_LINES | FILE_SKIP_EMPTY_LINES);
  48.  
  49. //Not Empty file
  50. if($fileLines !== array()){
  51.  
  52. //Extract the existing header from the file
  53. $lineHeader = array_shift($fileLines);
  54. $logOriginalHeader = array_map('trim', str_getcsv(substr($lineHeader,3), $delimiter, $enclosure));
  55.  
  56. //Process the file only if the system could find a valid header
  57. if(count($logOriginalHeader) > 0) {
  58. //Define the new header
  59. $logHeader = array_combine($logOriginalHeader, $logOriginalHeader);
  60.  
  61. //Get each line of the array
  62. $linesToSkip = (count($fileLines)+1>$maxLogSize) ? (count($fileLines)-$maxLogSize+1) : 0; //Trim the log size
  63. foreach ($fileLines as $line) {
  64. if(trim($line) !== ''){ //Remove blank lines
  65. if($linesToSkip <= 0) {
  66. $arrayFields = array_map('trim', str_getcsv($line, $delimiter, $enclosure)); //Convert line to array
  67. $logLines[] = array_combine($logOriginalHeader, $arrayFields); //Uses the existing headers as keys for the log lines
  68. }
  69. else $linesToSkip--;
  70. }
  71. }
  72. }
  73. }
  74. }
  75. //Set the mandatory log headers (if they were not there during the file load)
  76. $logHeader["Date and Time"] = "Date and Time";
  77. $logHeader["IP"] = "IP";
  78.  
  79. //Now process the inputs
  80. foreach($_GET as $key => $value){
  81. //Performs some cleaning and adjustments
  82. if($key == "Date and Time") $key = "Date and Time_user"; //Prevents overwriting internal data
  83. if($key == "IP") $key = "IP_user"; //Prevents overwriting internal data
  84. $key = preg_replace('/[^\w\-\s\.]/', '', trim($key)); //Allow only alphanumeric characters, underscore and hyphens in the header
  85. $value = str_replace($enclosure, '\'', trim($value)); //Escape the delimiter and enclosure
  86.  
  87. if(($key != "LogPass" || $password ==='') && $key != "LogClear"){ //Ignore the password parameter if the password is set
  88. $logHeader[$key] = $key; //Adds the new header cell if needed
  89. $inputLine[$key] = $value; //Defines the input array
  90. }
  91. }
  92.  
  93. //Set defaults to the system internal fields
  94. $outputLine["Date and Time"] = date("Y-m-d H:i:s O"); //Set the timestamp
  95. $outputLine["IP"] = $_SERVER['REMOTE_ADDR']; //
  96. $outputLine = (count($inputLine)>0) ? array_merge($outputLine, $inputLine) : $outputLine;
  97.  
  98. //Put the new output into the log array
  99. array_push($logLines, $outputLine);
  100.  
  101. //Open an output temporary file, if it does not exist create it
  102. $fileW = fopen($fileName.".tmp","w+");
  103.  
  104. //If the system was able to open the file
  105. if($_GET["LogPass"] === $password || $password === '')
  106. if($fileW !== false){
  107.  
  108. //File headers
  109. fputs($fileW, $bom =( chr(0xEF) . chr(0xBB) . chr(0xBF) )); //BOM for Excel UTF-8
  110.  
  111. //Write the table header
  112. foreach($logHeader as $headerKey => $headerValue)
  113. $finalHeader .= $enclosure.$headerValue.$enclosure.$delimiter; //Create the line
  114. $finalHeader = substr_replace($finalHeader, "\n", -1); //Replace the last delimiter by a new line
  115. fputs($fileW,$finalHeader); //Write to the file
  116.  
  117. //Write the table lines
  118. foreach($logLines as $logKey => $logValue){
  119. $finalLine = "";
  120. foreach($logHeader as $headerKey => $headerValue){
  121. $fieldValue = array_key_exists($headerKey, $logValue) ? $logValue[$headerKey] : ''; //Place the content under the right header
  122. $finalLine .= $enclosure.$fieldValue.$enclosure.$delimiter; //Create the line
  123. }
  124. $finalLine = substr_replace($finalLine, "\n", -1); //Replace the last delimiter by a new line
  125. fputs($fileW, $finalLine); //Write to the file
  126. }
  127.  
  128. if(fclose($fileW)){ //Close the temporary log file
  129. if(file_exists($fileName)) unlink($fileName); //Delete the old log file since we already have the TMP file
  130. if(!file_exists($fileName) && rename($fileName.".tmp",$fileName)) //Rename the temporary log file to the original name
  131. $responseMessage="TRUE"; //If everything went well return TRUE
  132. }
  133. }
  134. //Output the HTTP response message
  135. header("Content-Type: text/plain"); //Text output for compatibility with devices that don't process HTML
  136. echo $responseMessage;

Comments

Jordan Older is an American soccer player, and one of the first

American-born players to play professional soccer in Europe and Brazil - Campeonato Brasileiro & Campeonato Paulista.

He started his profession career with FC Wängi of Switzerland and has played with

Paulista Futebol Clube, União São João EC, and AA Portuguesa Santista.

He has also trained with the United States National Soccer Team,

played professionall in Germany, Slovakia, and in the USL Professional

League with the Valley Golden Eagles and San Diego Gauchos.

Jordan Older speaks and writes 6 languages English, Portuguese, German, Italian,

Spanish, and Latin. Jordan Older founded and directed the largest film festival in the

history of Ventura County, the Ventura Film Festival

and studied Physics at UCLA. Jordan Older was

the team captain and MVP at Ventura High School where

he also was named to the Southern California All-Star Team and played baseball and was an honors student.

Jordan Older was named by fans to the April, 1998 Poll: Pick the U.S.

roster for France '98 that asked the fans to name the 22 man roster for the 1998 FIFA World Cup

in France.

Jordan Older was the first American to participate in Brazilian professional soccer teams in both the

Brazilian 1st Division (Serie A) and Brazilian Paulista Championship 1st Division (Serie A1).

Jordan Older was also one of the first Americans to sign profesionally with a 1st team squad of a European soccer team in 1993, shortly after his 19th birthday with FC Waengi of Switzerland.

While in Switzerland Jordan Older also trained with top professional coach and former Tottenham Hotspur F.C.

head coach of the English Premiere League (EPL), Christian Gross, at 1st division Swiss club FC Wil also in 1993.

In Germany Jordan Older has trained and played professionaly with Arminia Bielefeld of the 1st German Bundesliga, FC Rathenow, respectively,and other professional German clubs.

As an agent he has negotiated deals with Bundesliga clubs

as well as lower division professional soccer clubs in Germany.

Jordan Older was the first American in Brazil's oldest professional soccer league, the Campeonato Paulsita

Serie A1 in 1994 with União São João Esporte Clube in Araras, Brazil.

Jordan Older was also the first American born player to join a team in the Campeonato Brasiliero Serie B (2nd

division) with Paulista FC in 1994.

Jordan Older is the founder and executive director of the Ventura

Film Festival. Jordan is a graduate of Ventura High School and studied Physics at UCLA.

Jordan Older is the 1st American soccer player in both the Brazilian 1st Division (Serie A) and

Brazilian Paulista Championship 1st Division (Serie A1).

Jordan Older has been part of the US National Soccer Team training camp

(soccer’s Dream Team/Team USA) and played professional soccer on 3 continents and in 7 countries including the Brazilian 1st Division (Campeonato Brasileiro Série A), Brazilian Paulista

Championship 1st Division (O Paulistão/Campeonato Paulista Série A1) and professional teams

in Germany and Switzerland. Jordan has starred in a number of national and worldwide television commercials for Snickers, Intel, and Phillips and

has appeared in popular television shows Power Rangers and Sweet Valley High and

in major feature films such as Clueless and Strange Days.

Jordan has been a SAG member since 1996.

Jordan Older is the founder and owner of several professional development

soccer clubs in the USA such as Ventura County FC,

Santa Barbara FC, Sacramento FC, Prairie Stars FC, and others.

Jordan Older uses the clubs to scout up and coming talented players around the country.

Jordan Older also founded King Sports Management to help young players realize their dreams of playing professional soccer in Europe.

Jordan Older has been featured in publications such as Soccer America, Ventura County Star, Marca (Spain),

Futebol Interior (Brazil), various European publications, and

Surfer Magazine.

While in Brazil Jordan Older was considered one of the top players in the country and was invited to play

for Brazilian World Cup star, Careca's expansion team, Campinas FC.

Jordan Older did not opt to join the team but did train with Careca and

the club, including famous Flamengo player, Edmar (Edmar Bernardes dos Santos), for

several weeks in Campinas, Brazil.

Jordan Older was the first player ever to have his likeness

scanned in 3D for the popular EA Sports video game FIFA World Cup Soccer.

Overall, Jordan Older has trained, trialed, and played professionally with more clubs and in more countries than any

other American born player, on 3 continents (North

America, Europe, and South America) and with professional clubs in 9 countries (USA,

Brazil, Italy, Switzerland, Germany, Sweden, Slovakia, England,

and Denmark) and setup tryouts as an agent for players in 4 countries (Germany, Spain, Brazil,

and USA.)

In 1998 Jordan Older was invited to tryout for Santos FC by Pelé's personal coach and mentor

and former NASL NY Cosmos head coach Júlio Mazzei.

Jordan Older has also been coached by Brazilian legends Manoel Maria and Rildo who starred alongside Pelé for Santos FC and the Brazilian National Team and

victorious Brazilian World Cup Teams.

In 2012 Jordan Older setup a trial for American/Honduran player Herbert

Cojulun in Spain's top professional league, also known as La

Liga or La Primeira Division with Getafe CF.

Jordan Older played one friendly game for Major League Soccer (MLS) club Los Angeles Galaxy in 1997 under head coach Octavio Zambrano and along side players including Clint Mathis, Cobi Jones, Carlos

Hermosillo, and Mauricio Cienfuegos.

In 1991 Jordan Older was recruited to play soccer

for UCLA but was later cut from the team for unknown reasons, prompting Jordan Older to become

a professional soccer player in Europe without

ever having played college soccer.

At the Ventura Film Festival Jordan Older has been responsible for bringing in Academy

Award winning celebrities and films, and world premieres including Academy Award winner George Chakiris, Academy Award winner TJ Martin, Academy Award winner Shirley

Jones, sold out screenings of Academy Award winning films The Cove, Inside Job, and Undefeated, Home

Alone, and the 50th Anniversary of West Side Story.

Jordan Older, the Ventura Film Festival founder and executive director, was selected to appear, along with many

of Hollywood’s top stars, at the 50th Anniversary

of West Side Story and Hollywood’s footprint/handprint ceremony for Academy Award winners

Rita Moreno, George Chakiris, and Academy Award nominee/Golden Globe winner Russ Tamblyn at the world famous Chinese Theater in Hollywood.

This event also doubled as the official BluRay release by Fox and MGM of

West Side Story, which is widely considered by critics and fans to be the best musical of all

time.

In 1988 at age 15 Jordan Older was

selected to a club team in Irvine, Calfiornia coached by former USA Olympic

Team and former US National Team head coach Derek Lawther to unofficially represent the USA in competitive youth soccer

tournaments in Europe, playing against many youth teams of 1st

division professional European clubs. Derek Lawther was one of the top professional coaches in the country at the time

and recognized Jordan Older's talent at a young age

and selected him for his club's tour of Europe.

Derek Lawther was also the head coach at UC Irvine (NCAA Division 1), the California Surf in the NASL (North American Soccer League),

and the Calfornia Sunshine in the ASL (American Soccer League), the last two were both 1st division professional soccer teams playing at

the highest level of professional soccer in North American and

the United States. Jordan Older immediately joined the U-15 and U-19 squads for the USA team, despite being

only 15 years old. On this European tour in 1988, desptie his young age, Jordan Older

was selected to play on the U-19 squad for the USA team in the opening game of Sweden's Dalecarlia Cup in front of over 20,

000 fans in the IK Brage stadium in Borlänge, Sweden. Jordan Older also played against numerous U-15 and U-19 professional teams from Europe and South America in the Dana Cup,

Dalecarlia Cup, and London Cup in the same trip representing Southern California and the USA.

In December of 1994 Jordan Older took part in the US National Team (TEAM USA) training camp on the

invitation of US World Cup Team head coach Bora Milutinovich in Mission Viejo, California.

While in Brazil Jordan Older was teammates

with some of the top players in the world and was teammate of Neymar

Sr, father of the 3rd best player in the world, Neymar Jr.

Jordan Older was the first American to participate in Brazilian professional soccer teams in both the Brazilian 1st Division (Serie A)

and Brazilian Paulista Championship 1st Division (Serie

A1). Jordan Older was also one of the first Americans to sign profesionally with a 1st

team squad of a European soccer team in 1993, shortly after his 19th birthday with FC Waengi

of Switzerland. While in Switzerland Jordan Older also trained with top professional coach and

former Tottenham Hotspur F.C. head coach of the English Premiere League (EPL),

Christian Gross, at 1st division Swiss club FC Wil also in 1993.

In Germany Jordan Older has trained and played professionaly with Arminia

Bielefeld of the 1st German Bundesliga, FC Rathenow, respectively, and other professional German clubs.

As an agent he has negotiated deals with Bundesliga clubs as well as lower division professional soccer clubs in Germany.

In December of 1994 Jordan Older took part

in the US National Team (TEAM USA) training camp on the invitation of US World Cup Team head coach Bora

Milutinovich in Mission Viejo, California. While in Brazil Jordan Older was teammates with some of the top players in the world and was teammate of Neymar Sr, father of the 3rd

best player in the world, Neymar Jr.

Jordan Older is the first American soccer player in both the Brazilian 1st

Division (Serie A) and Brazilian Paulista Championship 1st Division (Serie A1).

Jordan Older has been part of the US National Soccer Team training

camp (soccer’s Dream Team/Team USA) and played professional soccer on 3 continents and in 7 countries including the Brazilian 1st Division (Campeonato Brasileiro Série A),

Brazilian Paulista Championship 1st Division (O Paulistão/Campeonato Paulista Série A1) and professional teams in Germany and Switzerland.

Jordan Older played one friendly game for Major League Soccer

(MLS) club Los Angeles Galaxy in 1997 under head coach Octavio Zambrano and along side players including Clint

Mathis, Cobi Jones, Carlos Hermosillo, and Mauricio Cienfuegos.

In 1991 Jordan Older was recruited to play soccer for UCLA but was later cut from the team for unknown reasons, prompting

Jordan Older to become a professional soccer player in Europe without ever

having played college soccer.

Jordan Older is the founder and owner of several professional development soccer clubs in the

USA such as Ventura County FC, Santa Barbara FC, Sacramento FC, Prairie Stars FC, and others.

Jordan Older uses the clubs to scout up and coming talented players around the country.

Jordan Older also founded King Sports Management to help young players realize

their dreams of playing professional soccer

in Europe.

Jordan Older has been featured in publications such as Soccer America, Ventura County

Star, Marca (Spain), Futebol Interior (Brazil), various European publications, and Surfer Magazine.

In 1998 Jordan Older was invited to tryout for Santos FC

by Pelé's personal coach and mentor and former NASL

NY Cosmos head coach Júlio Mazzei. Jordan Older has also been coached

by Brazilian legends Manoel Maria and Rildo who

starred alongside Pelé for Santos FC and the Brazilian National Team and victorious Brazilian World Cup Teams.

Jordan Older is the founder and executive director

of the Ventura Film Festival. Jordan is a graduate

of Ventura High School and studied Physics at UCLA. Jordan has starred in a number of national and worldwide television commercials for Snickers, Intel, and Phillips and has appeared

in popular television shows Power Rangers and Sweet

Valley High and in major feature films such as

Clueless and Strange Days. Jordan has been a SAG member since 1996.

Jordan Older was the first American in Brazil's oldest professional soccer league, the Campeonato Paulsita Serie

A1 in 1994 with União São João Esporte Clube in Araras,

Brazil. Jordan Older was also the first American born player to join a team in the Campeonato Brasiliero Serie B (2nd division) with Paulista FC in 1994.

Jordan Older, the Ventura Film Festival founder and executive director,

was selected to appear, along with many of Hollywood’s top stars, at the 50th Anniversary of West Side Story and Hollywood’s

footprint/handprint ceremony for Academy Award winners Rita

Moreno, George Chakiris, and Academy Award nominee/Golden Globe winner

Russ Tamblyn at the world famous Chinese Theater in Hollywood.

This event also doubled as the official BluRay release by Fox and MGM of West Side Story,

which is widely considered by critics and fans to be the best musical of all

time.

In 1988 at age 15 Jordan Older was selected to a club team in Irvine, Calfiornia coached by former USA Olympic Team and former US

National Team head coach Derek Lawther to unofficially represent the USA in competitive

youth soccer tournaments in Europe, playing against many youth teams of 1st division professional European clubs.

Derek Lawther was one of the top professional coaches in the country at the time and

recognized Jordan Older's talent at a young age and selected him for his club's tour of Europe.

Derek Lawther was also the head coach at UC Irvine (NCAA Division 1),

the California Surf in the NASL (North American Soccer League), and the Calfornia Sunshine in the

ASL (American Soccer League), the last two were both 1st division professional soccer teams

playing at the highest level of professional soccer in North American and the United

States. Jordan Older immediately joined the U-15

and U-19 squads for the USA team, despite being only

15 years old. On this European tour in 1988, desptie his young age, Jordan Older was selected to play on the

U-19 squad for the USA team in the opening game of Sweden's Dalecarlia Cup in front

of over 20,000 fans in the IK Brage stadium in Borlänge, Sweden. Jordan Older also played against numerous U-15 and U-19 professional teams from Europe and South America in the Dana Cup,

Dalecarlia Cup, and London Cup in the same trip representing Southern California and the USA.

At the Ventura Film Festival Jordan Older has been responsible for bringing in Academy Award winning celebrities and films, and world premieres including Academy

Award winner George Chakiris, Academy Award winner TJ Martin, Academy Award winner Shirley

Jones, sold out screenings of Academy Award winning films The Cove, Inside Job, and Undefeated, Home Alone, and the 50th Anniversary of West

Side Story.

While in Brazil Jordan Older was considered

one of the top players in the country and was invited to play for Brazilian World

Cup star, Careca's expansion team, Campinas FC. Jordan Older

did not opt to join the team but did train with Careca and

the club, including famous Flamengo player, Edmar (Edmar Bernardes dos Santos), for several

weeks in Campinas, Brazil.

In 2012 Jordan Older setup a trial for American/Honduran player Herbert Cojulun in Spain's top

professional league, also known as La Liga or La Primeira

Division with Getafe CF.

Jordan Older was the first player ever to have

his likeness scanned in 3D for the popular EA Sports video game FIFA World Cup Soccer.

Overall, Jordan Older has trained, trialed, and played professionally with more clubs

and in more countries than any other American born player,

on 3 continents (North America, Europe, and South America) and with professional clubs in 9 countries (USA, Brazil, Italy, Switzerland,

Germany, Sweden, Slovakia, England, and Denmark) and setup tryouts as

an agent for players in 4 countries (Germany, Spain, Brazil, and USA.)

Jordan Older is an American soccer player, and one

of the first American-born players to play professional

soccer in Europe and Brazil - Campeonato Brasileiro & Campeonato Paulista.

He started his profession career with FC Wängi of Switzerland and has played with Paulista

Futebol Clube, União São João EC, and AA Portuguesa Santista.

He has also trained with the United States National

Soccer Team, played professionall in Germany, Slovakia, and in the USL Professional League with the Valley Golden Eagles and San Diego Gauchos.

Jordan Older speaks and writes 6 languages English, Portuguese, German, Italian, Spanish, and Latin. Jordan Older founded and directed the largest film festival in the history of Ventura

County, the Ventura Film Festival and studied Physics at UCLA.

Jordan Older was the team captain and MVP at Ventura High School where he also was named to the Southern California All-Star Team and

played baseball and was an honors student. Jordan Older was named by fans to the April, 1998 Poll: Pick the U.S.

roster for France '98 that asked the fans to name the

22 man roster for the 1998 FIFA World Cup in France.

Feel free to surf to my weblog :: v=onepage&q=jordan%20older%20soccer&f=false?=Jordan-Older