Update static/testSearch.html, templates/OurSpaces.html, templates/Space.html,...

Update static/testSearch.html, templates/OurSpaces.html, templates/Space.html, WorkSpaces.sql, db.sqbpro

Closes #7 (closed)

templates/Space.html

+{%extends 'OurSpaces.html'%}
+<form id='myForm' action='/Load/CodeBase>' method ='post'>
+  {% block titleBlock%}
+  {%if data%}
+    {{data[0][0]}} <br>
+  {%endif%}
+  {%endblock%}
+
+  {% block addressBlock%}
+  <h2>Address info</h2>
+  <iframe src="https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d4957.954181608377!2d-2.999839445369478!3d51.58698324808131!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x4871e6cc3bd82553%3A0x684c1227f14b4a15!2sNational%20Software%20Academy%20(Cardiff%20University)!5e0!3m2!1sen!2suk!4v1669722978098!5m2!1sen!2suk"
+   width="600" height="450" style="border:0;" allowfullscreen="" loading="lazy" referrerpolicy="no-referrer-when-downgrade"></iframe>
+   <br>
+  <h3>
+  {%if data%}
+    {{data[0][1]}}
+  {%endif%}
+</h3>
+  {%endblock%}
+
+
+
+  {% block descriptionBlock%}{%if data%}{{data[0][4]}}{%endif%}{%endblock%}
+
+  {% block imageBlock%}{%if data%}{{data[0][2]}}{%endif%}{%endblock%}
+
+  {% block addimageBlock%}{%if data%}{{data[0][3]}}{%endif%}{%endblock%}
+
+  {% block timeBlock%}{%if data%}{{data[0][8]}}{%endif%}{%endblock%}
+
+  {% block WebsiteBlock%}{%if data%}{{data[0][5]}}{%endif%}{%endblock%}
+<span id='txt'></span>
+
+<script>
+  function loadSpace() {
+    var Name = document.forms["coworking_spaces"]["Name"].value;
+    var Address = document.forms["coworking_spaces"]["Address"].value;
+    var Main_Photo = document.forms["coworking_spaces"]["Main_Photo"].value;
+    var Additional_photos = document.forms["coworking_spaces"]["Main_Photo"].value;
+    var Description = document.forms["coworking_spaces"]["Description"].value;
+    var Website = document.forms["coworking_spaces"]["Website"].value;
+    var Opening_Hours = document.forms["coworking_spaces"]["Opening_Hours"].value;
+
+    var xhttp = new XMLHttpRequest();
+
+    xhttp.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
+    xhttp.onload = function() {
+      if (xhttp.readyState === 4 && xhttp.status === 200) {
+        console.log(xhttp.responseText);
+        document.getElementById("txt").innerHTML = xhttp.responseText;
+      } else {
+        console.error(xhttp.statusText);
+      }
+    };
+    xhttp.send(params);
+    return false;
+  }
+
+</script>
+
+
+</form>