Traffic Light Information System

#!/usr/bin/php-cli

<?php
$UnixTime_green_1 = $argv[1];
$UnixTime_red_1 = $argv[2]; 
$UnixTime_green_2 = $argv[3];
$UnixTime_red_2 = $argv[4]; 
$DBServer = 'yourServerName'; 
$DBUser   = 'yourUserName';
$DBPass   = 'yourPassword';
$DBName   = 'yourDBName';  
$conn = new mysqli($DBServer, $DBUser, $DBPass, $DBName);
// check connection
if ($conn->connect_error) {
  trigger_error('Database connection failed: '  . $conn->connect_error, E_USER_ERROR);
}
$sql="UPDATE TrafficL_data SET UnixTime_green_1='$UnixTime_green_1', UnixTime_red_1='$UnixTime_red_1',UnixTime_green_2='$UnixTime_green_2', UnixTime_red_2='$UnixTime_red_2' WHERE id=1";
if($conn->query($sql) === false) {
  trigger_error('Wrong SQL: ' . $sql . ' Error: ' . $conn->error, E_USER_ERROR);
}
else{
echo "Data inserted!\n";
} 
?>

#!/usr/bin/php-cli
<?php
$Distance = $argv[1];
$DBServer = 'yourServerName';
$DBUser   = 'yourUserName';
$DBPass   = 'yourPassword';
$DBName   = 'yourDBName';
$conn = new mysqli($DBServer, $DBUser, $DBPass, $DBName);
// check connection
if ($conn->connect_error) {
  trigger_error('Database connection failed: '  . $conn->connect_error, E_USER_ERROR);
}
$sql="UPDATE TrafficL_data SET Distance='$Distance'WHERE id=1";

if($conn->query($sql) === false) {
  trigger_error('Wrong SQL: ' . $sql . ' Error: ' . $conn->error, E_USER_ERROR);
}
else{
echo "Distance inserted!\n";
}
?>

<?php
define('HOST','yourServerName');
define('USER','yourUserName');
define('PASS','yourPassword');
define('DB','yourDBName');
 
$con = mysqli_connect(HOST,USER,PASS,DB);
 
$sql = "select * from TrafficL_data";
 
$res = mysqli_query($con,$sql);
 
while($row = mysqli_fetch_array($res,MYSQLI_BOTH)){
printf('[
    {
        "TrafficLArray":[
                {
                "UnixTime_green_1":"%s",
                "UnixTime_red_1":"%s",
                "UnixTime_green_2":"%s",
                "UnixTime_red_2":"%s",
                "Distance":"%s"
            }
        ]
    }
]', $row['UnixTime_green_1'], $row['UnixTime_red_1'],$row['UnixTime_green_2'],$row['UnixTime_red_2'],$row['Distance']);
}
 
 
mysqli_close($con);
 
?>

package com.example.xxx.xxx;// change xxx xxx


import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;

import android.util.Log;
import android.widget.TextView;

import com.android.volley.RequestQueue;
import com.android.volley.Response;
import com.android.volley.VolleyError;
import com.android.volley.toolbox.JsonArrayRequest;
import com.android.volley.toolbox.Volley;
import org.json.JSONArray;
import org.json.JSONException;
import org.json.JSONObject;

//import java.text.DateFormat;
import java.util.Date;
import java.util.Timer;
//import java.util.TimerTask;
import java.util.concurrent.Executors;
import java.util.concurrent.Future;
import java.util.concurrent.ScheduledExecutorService;
import java.util.concurrent.TimeUnit;


public class MainActivity extends AppCompatActivity {
    // Will show the string "data" that holds the results
    TextView results;
    //The textview that holds the recommended speed
    TextView recSpeed;

    // URL of object to be parsed
    String JsonURL = "YourURLhere";

    // This string will hold the results
    String data = "";
    // Defining the Volley request queue that handles the URL request concurrently
    RequestQueue requestQueue;

    //timer object to uppdate the data every second
    //Timer timer;

    //The speedLimit (cm/s)
    private final static double maxSpeed = 18;
    //The recommended speed
    private double speed;

    //number of times in the table
    public final static int NUMBER_OF_ENTRIES = 2;
    //array with the times when it is green
    long[] unixTimesGreen = new long[NUMBER_OF_ENTRIES];
    //array with the times when it is red
    long[] unixTimesRed = new long[NUMBER_OF_ENTRIES];
    //variable which hold the distance
    private double distance;

    //variables for repeating updateTable
    private final ScheduledExecutorService scheduler = Executors.newSingleThreadScheduledExecutor();

    //for testing:
    private Future<?> timingTask;

    public void tick(long milliseconds) {
        timingTask = scheduler.scheduleAtFixedRate(new Runnable() {
            public void run() {
                updateTable();
            }
        }, 0, milliseconds, TimeUnit.MILLISECONDS);
    }

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        //textViews to cast results to
        results = (TextView) findViewById(R.id.jsonData);

        recSpeed = (TextView) findViewById(R.id.recommendedSpeed);

        //initialize table
        updateTable();

        //update app every 100 milliseconds
        tick(500);

        //for working with a timer object to repeatedly update
        /**
        timer = new Timer("Timer");
        timer.schedule(new UpdateTable(),(long)100,(long)100);
         */

    }

    //for working with timer object to repeatedly update
    /**
    private class UpdateTable extends TimerTask{
        public void run(){
            updateTable();
        }
    }
     */

    private void updateTable(){
        //reset String
        data = "";
        // Creates the Volley request queue
        requestQueue = Volley.newRequestQueue(this);

        //for testing
        /**
        // Casts results into the TextView found within the main layout XML with id jsonData
        results = (TextView) findViewById(R.id.jsonData);
         */


        // Creating the JsonArrayRequest class called arrayreq, passing the required parameters
        //JsonURL is the URL to be fetched from
        JsonArrayRequest arrayreq = new JsonArrayRequest(JsonURL,
                // The second parameter Listener overrides the method onResponse() and passes
                //JSONArray as a parameter
                new Response.Listener<JSONArray>() {


                    // Takes the response from the JSON request
                    @Override
                    public void onResponse(JSONArray response) {
                        try {
                            // Retrieves first JSON object in outer array
                            JSONObject TrafficLObj = response.getJSONObject(0);
                            // Retrieves "trafficArry" from the JSON object
                            JSONArray trafficArry = TrafficLObj.getJSONArray("TrafficLArray");
                            // Iterates through the JSON Array getting objects and adding them
                            //to the list view until there are no more objects in trafficArry
                            for (int i = 0; i < trafficArry.length(); i++) {
                                //gets each JSON object within the JSON array
                                JSONObject jsonObject = trafficArry.getJSONObject(i);

                                //arrays for storing the Strings
                                String[] green = new String[NUMBER_OF_ENTRIES];
                                String[] red = new String[NUMBER_OF_ENTRIES];

                                //String for distance
                                String distanceTemp = jsonObject.getString("Distance");

                                distance = (double)Long.parseLong(distanceTemp);

                                // Retrieves the string
                                // and converts them into javascript objects
                                green[0] = jsonObject.getString("UnixTime_green_1");
                                red[0] = jsonObject.getString("UnixTime_red_1");
                                green[1] = jsonObject.getString("UnixTime_green_2");
                                red[1] = jsonObject.getString("UnixTime_red_2");

                                // Converts Strings retrieved from JSon object to longs
                               for (int j = 0; j < unixTimesRed.length; j++){
                                   unixTimesGreen[j] = Long.parseLong(green[j]);
                                   unixTimesRed[j] = Long.parseLong(red[j]);
                               }

                                //for testing
                                /**
                                //create Date Objects to print out readable dates
                                Date green_1 = new Date(IntUnixTime_green*1000);
                                Date green_2 = new Date(IntUnixTime_green_2*1000);
                                Date red_1 = new Date(IntUnixTime_red*1000);
                                Date red_2 = new Date(IntUnixTime_red_2*1000);


                                /**
                                // Adds strings from the current object to the data string
                                //spacing is included at the end to separate the results from
                                //one another
                                data += "\nID " + (i + 1) +
                                        "\nUnixTime green:  " + green_1.toString() +
                                        "\nUnixTime red:  " + red_1.toString() +
                                        "\nUnixTime green_2:  " + green_2.toString() +
                                        "\nUnixTime red_2:  " + red_2.toString()
                                        +
                                        "\nSum = " + (new Date(currentTime)).toString();
                                 */
                            }//end for

                            // Adds the data string to the TextView "results"
                            //for testing
                            /**
                            results.setText(data);
                             */

                            updateTextView();

                        }//end try

                        // Try and catch are included to handle any errors due to JSON
                        catch (JSONException e) {
                            // If an error occurs, this prints the error to the log
                            e.printStackTrace();
                        }//end catch
                    }//end onResponse
                    //end response.listener
                },
                // The final parameter overrides the method onErrorResponse() and passes VolleyError
                //as a parameter
                new Response.ErrorListener() {
                    @Override
                    // Handles errors that occur due to Volley
                    public void onErrorResponse(VolleyError error) {
                        Log.e("Volley", "Error");
                    }
                }
        );
        // Adds the JSON array request "arrayreq" to the request queue
        requestQueue.add(arrayreq);
    }//end updateTable

    private void updateTextView(){
        //update time info
        StringBuilder builder = new StringBuilder("");

        for (int i = 0; i < unixTimesGreen.length; i++){
            builder.append("unixTimeGreen");
            builder.append(i);
            builder.append(": ");
            builder.append((new Date(unixTimesGreen[i]*1000)).toString());
            builder.append("\n");

            builder.append("unixTimeRed");
            builder.append(i);
            builder.append(": ");
            builder.append((new Date(unixTimesRed[i]*1000)).toString());
            builder.append("\n");
        }
        builder.append("distance: " + distance);

        //results.setText(builder.toString());

        //update speed
        speedCalc();
        String s = String.format("%.0f",speed);
        recSpeed.setText(s);
    }

    private void speedCalc(){

        int interval = 0;
        double time = (double)System.currentTimeMillis()/1000;
        double diff;

       for (int i = 0; i < NUMBER_OF_ENTRIES; i++){
           diff = unixTimesRed[interval] - time;
           speed = distance/((diff)/1000);
           interval++;
       }

        interval = interval-1;
        if(distance/((unixTimesGreen[interval]-time)) > maxSpeed)
            speed = maxSpeed;
        else
            speed = distance/((unixTimesGreen[interval]-time));

        speed = speed*5;
    }
}

<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
    package="com.example.xxx.xxx">// change xxx xxx

    <uses-permission android:name="android.permission.INTERNET"/>

    <application
        android:allowBackup="true"
        android:icon="@mipmap/ic_launcher"
        android:label="@string/app_name"
        android:supportsRtl="true"
        android:theme="@style/AppTheme">
        <activity android:name=".MainActivity">
            <intent-filter>
                <action android:name="android.intent.action.MAIN" />

                <category android:name="android.intent.category.LAUNCHER" />
            </intent-filter>
        </activity>
    </application>

</manifest>

<resources>
    <string name="app_name">NooitRood</string>
</resources>

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="wrap_content"
    android:layout_marginLeft="16dp"
    android:layout_marginRight="16dp"
    tools:context="com.example.xxx.xxx.MainActivity"// change xxx xxx
    android:orientation="vertical">

    <TextView
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_gravity="center_horizontal"
        android:paddingBottom="10dp"
        android:textAppearance="?android:attr/textAppearanceSmall"
        android:text="Aanbevolen snelheid:"
        android:textSize="20sp"
        android:textStyle="bold"
        android:id="@+id/jsonData"
        android:textColor="#000000" />

    <TextView
        android:layout_width="900px"
        android:layout_height="900px"
        android:layout_gravity="center_horizontal"
        android:paddingTop="10dp"
        android:id="@+id/recommendedSpeed"
        android:textSize="120sp"
        android:textColor="#000000"
        android:textStyle="bold"
        android:gravity="center"
        android:background="@drawable/gebodsbord"/>

</LinearLayout>