<?php
$hn=file_get_contents('/var/secrets/hostname.txt');
$hn=str_replace("n", "", $hn);
$pass=file_get_contents('/var/secrets/password.txt');
$pass=str_replace("n", "", $pass);
$cname=$_POST['name'];
$email=$_POST['email'];
$hostname=$hn;
$username='root';
$password=$pass;
$dbname='test';
$usertable='testuser';
$con=mysqli_connect($hostname,$username, $password) OR DIE ('Unable to connect to database! Please try again later.');
mysqli_select_db($con,$dbname);
$query = "select * from testuser";
$result = $con->query($query) or die("Not Updated!");
while($row = $result->fetch_assoc()) {
        echo "<tr><td> " . $row["name"] . "<td> " . $row["email"] . "</tr> ";
}
$con->close();
?>

apiVersion: v1
kind: Service
metadata:
  creationTimestamp: 2018-11-13T12:01:25Z
  labels:
    app: userdatabase
  name: userdatabase-service
  namespace: default
  resourceVersion: "32448"
  selfLink: /api/v1/namespaces/default/services/userdatabase-service
  uid: d85cf471-e73b-11e8-8506-42010aa60fca
spec:
  clusterIP: 10.7.255.80
  externalTrafficPolicy: Cluster
  ports:
  - nodePort: 30198
    port: 80
    protocol: TCP
    targetPort: 3306
  selector:
    app: userdatabase
  sessionAffinity: None
  type: LoadBalancer
status:
  loadBalancer:
    ingress:
    - ip: 35.228.105.176