CS_Web_Engineering_2/prop.php at master · chr11031/CS_Web_Engineering_2 · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
<?php
   if($_POST['searchById'] == '')
   header("Location: users.php");
   session_start();
   if(!isset($_SESSION["realty_status"]))
     $_SESSION["realty_status"] = "Visitor";
   else {
     if($_SESSION["realty_status"] == "Member") {
        //header("Location: results.php"); // DO SOMEThing else... This will be fleshed out with the rest of the website
     }
   }
?>

<!DOCTYPE html>
<html>
  <head>
    <link href="css/bootstrap.min.css" rel="stylesheet">
    <link href="css/custom.css" rel="stylesheet">
    <title>REAL-T Market</title>
    <script type="text/javascript" src = "js/links.js">
    </script>
    <!--Check out google fonts for additional styling optiolns-->
  </head>
  <body id = "houseTexture">
    <div class = "navbar navbar-default" id="houseBar">
      <div class = "container-fluid"  id="housecontainer">
	<!--LOGO-->
	<div class ="navbar-header">
	  <a href ="realty.php" class = "navbar-brand" id="real-t">REAL-T</a>
	  <ul class = "nav navbar-nav">
	  <li id="news" onmouseover="onHouse('news','houseLink1')" onmouseout="offHouse('news','houseLink1')">
	    <a id = "houseLink1" href ="realty.php">News</a></li>
	  <li id="marketplace" onmouseover="onHouse('marketplace','houseLink2')" onmouseout="offHouse('marketplace','houseLink2')">
	    <a id = "houseLink2" href ="market.php">Marketplace</a></li>
	  <li id ="users" onmouseover="onHouse('users','houseLink3')" onmouseout="offHouse('users','houseLink3')">
	    <a id = "houseLink3" href ="users.php">Users</a></li>
	  <li id ="join" onmouseover="onHouse('join','houseLink4')" onmouseout="offHouse('join','houseLink4')">
	    <a id = "houseLink4" href ="join.php">Join</a></li>
	  </ul>
	</div>
      </div>
    </div>
    <div class = "container-fluid">
      <div class = "jumbotron" id="houseBody">
	<h2><b>Matching Results</b>:</h2>
 	      <?php
	      try
	      {
	      $host = getenv('OPENSHIFT_MYSQL_DB_HOST');
	      $port = getenv('OPENSHIFT_MYSQL_DB_PORT');
	      $user = getenv('OPENSHIFT_MYSQL_DB_USERNAME');
	      $password = getenv('OPENSHIFT_MYSQL_DB_PASSWORD');

	      $db = new PDO("mysql:host=$host:$port;dbname=housing", $user, $password);

	      $input = $_POST['searchById'];

	      // Get the user_id of the user we are querying for
	      $queryString = 'SELECT user_id FROM users WHERE username ' . "='" . $input . "'";
	      $result = $db->query($queryString);
	      $temp = $result->fetch(PDO::FETCH_ASSOC);
	      $input = $temp['user_id'];
	      if($input == "")
	      {
		echo "<h3 id = \"indent\">No matches found.</h3>";
		return;
	      }

	      //Querying the database
	      $queryString = 'SELECT COUNT(*) FROM properties WHERE user_id ' . "='" . $input . "'";
	      $result = $db->prepare($queryString);
	      $result->execute();
	      $firstRow = $result->fetchColumn();

	      if($firstRow == 0) {
		echo "<h3 id = \"indent\">This user owns no properties.</h3>";
	      }
	      else {
	      	$queryString = 'SELECT * FROM properties WHERE user_id ' . "='" . $input . "'";
		$result = $db->query($queryString);

	      	echo "<table class = \"table table-bordered\"  id = \"houseTable\"";
     	        echo "<thead><tr id = \"houseTable\"><td  id = \"houseTable\">Title</td><td  id = \"houseTable\">Address, Town, & State</td><td id = \"houseTable\">SQ FT</td><td id = \"houseTable\">Photo</td><td id = \"houseTable\">Description</td></tr></thead>";
	        while ($row = $result->fetch(PDO::FETCH_ASSOC)) {
		      echo "<tr id = \"houseTable\"><td id = \"houseTable\">" .
		       $row['title'] .
		       "</td><td id = \"houseTable\">" .
		       $row['address'] . ', ' . $row['town'] .', ' . $row['state'] .
		       "</td><td id = \"houseTable\">" .
		       $row['sq_ft'] .
		       "</td><td id = \"houseTable\"><img src=\"" .
                       $row['photo_url'] . "\" width=\"180px\" height=\"120px\">" .
		       "</td><td id = \"houseTable\">" .
		       $row['description'] .
		       "</td></tr>";
		       }
	        echo '</table>';
	        }
              }
	      catch (PDOException $ex)
	      {
	      echo 'Error!: ' . $ex->getMessage();
	      die();
	      }
	      ?>
      </div>
    </div>
  </body>
</html>