vacanthomes_api/postdata.php at master · codeforireland2/vacanthomes_api · 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
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
<?php
require_once("./mysqli_connection.php");

$propertyType = "";
$houseNo = "";
$streetName = "";
$townName = "";
$county = "";
$eircode = "";
$geoLocateText = "";
$vacantTime = "";
$saleRentSign = "";
$grassOvergrown = "";
$roofDamaged = "";
$windowsBoarded = "";
$paintPeeling = "";
$propertyActivity = "";
$wasteBins = "";
$accessToProperty = "";
$aboutYou = "";
$message = "";
$canContact = "";
$editName = "";
$editEmail = "";
$editPhone = "";
$tandc = "";

$json = file_get_contents('php://input');
$obj = json_decode($json);


$sqlFields = "property_type,
house_no,
street_name,
town_name,
county,
eircode,
geo_locate_text,
vacant_time,
sale_rent_sign,
grass_overgrown,
roof_damaged,
windows_boarded,
paint_peeling,
property_activity,
waste_bins,
access_to_property,
about_you,
message,
can_contact,
edit_name,
edit_email,
edit_phone,
tandc,
picture,
ip_address";

$sqlValues = "";
$geoLocateText = "";
$propertyType = "";
$houseNo = "";
$streetName = "";
$townName = "";
$county = "";
$eircode = "";
$vacantTime = "";
$saleRentSign = "";
$grassOvergrown = "";
$roofDamaged = "";
$windowsBoarded = "";
$paintPeeling = "";
$propertyActivity = "";
$wasteBins = "";
$accessToProperty = "";
$aboutYou = "";
$message = "";
$canContact = "";
$editName = "";
$editEmail = "";
$editPhone = "";
$editEmail = "";
$tandc = "";
$image = "";

foreach($obj as $key => $value){
    if ($key == "geoLocateText") {
        $geoLocateText = "'".addslashes(str_replace("Geolocation:", "", $value))."', ";
    } else if ($key == "propertyType") {
        $propertyType = stripslashes($value);
    } else if ($key == "houseNo") {
        $houseNo = stripslashes($value);
    } else if ($key == "streetName") {
        $streetName = stripslashes($value);
    } else if ($key == "townName") {
        $townName = stripslashes($value);
    } else if ($key == "county") {
        $county = stripslashes($value);
    } else if ($key == "eircode") {
        $eircode = stripslashes($value);
    } else if ($key == "vacantTime") {
        $vacantTime = stripslashes($value);
    } else if ($key == "saleRentSign") {
        $saleRentSign = stripslashes($value);
    } else if ($key == "grassOvergrown") {
        $grassOvergrown = stripslashes($value);
    } else if ($key == "roofDamaged") {
        $roofDamaged = stripslashes($value);
    } else if ($key == "windowsBoarded") {
        $windowsBoarded = stripslashes($value);
    } else if ($key == "paintPeeling") {
        $paintPeeling = stripslashes($value);
    } else if ($key == "propertyActivity") {
        $propertyActivity = stripslashes($value);
    } else if ($key == "wasteBins") {
        $wasteBins = stripslashes($value);
    } else if ($key == "accessToProperty") {
        $accessToProperty = stripslashes($value);
    } else if ($key == "aboutYou") {
        $aboutYou = stripslashes($value);
    } else if ($key == "message") {
        $message = stripslashes($value);
    } else if ($key == "canContact") {
        $canContact = stripslashes($value);
    } else if ($key == "editName") {
        $editName = stripslashes($value);
    } else if ($key == "editEmail") {
        $editEmail = stripslashes($value);
    } else if ($key == "editPhone") {
        $editPhone = stripslashes($value);
    } else if ($key == "editEmail") {
        $editEmail = stripslashes($value);
    } else if ($key == "tandc") {
        $tandc = stripslashes($value);
    } else if ($key == "image") {
        $image = stripslashes($value);
    }

}

$sqlValues = '"'.$propertyType.'", "'.$houseNo.'", "'.$streetName.'", "'.$townName.'", "'.$county.'", "'.$eircode.'", "'.$geoLocateText.'", "'.$vacantTime.'", "'.$saleRentSign.'", "'.$grassOvergrown.'", "'.$roofDamaged.'", "'.$windowsBoarded.'", "'.$paintPeeling.'", "'.$propertyActivity.'", "'.$wasteBins.'", "'.
$accessToProperty.'", "'.$aboutYou.'", "'.$message.'", "'.$canContact.'", "'.$editName.'", "'.$editEmail.'", "'.$editPhone.'", "'.$tandc. '", "'.$image.'", "'.$_SERVER['REMOTE_ADDR'] .'"';

$sql = "insert into properties (".$sqlFields.") values (".$sqlValues.")";

connectQueryClose($sql);

/*
$fp = fopen('test.txt', 'w');
fwrite($fp, $sql);
fclose($fp);
*/

echo "ok";