Page 145 - MDP2022-2
P. 145
android:layout_width="match_parent"
android:layout_height="match_parent"
android:clickable="false"
app:layout_constraintBottom_toBottomOf="parent"
app:layout_constraintEnd_toEndOf="parent"
app:layout_constraintHorizontal_bias="0.0"
app:layout_constraintStart_toStartOf="parent"
app:layout_constraintTop_toTopOf="parent"
app:layout_constraintVertical_bias="0.0">
</WebView>
</androidx.constraintlayout.widget.ConstraintLayout>
로그인 화면(php)
<?php
include_once "server.inc";
$con = mysqli_connect();
if (!empty($_POST["id"]) && !empty($_POST["pwd"])) {
$sql = "select id from addre where id='" . $_POST["id"] . "';";
$result = mysqli_query($db_connect, $sql);
$record = mysqli_fetch_assoc($result);
if($record) {
$sql = "select id from addre where id='" . $_POST["id"] . "' and pwd='" . $_POST["
pwd"] . "';";
$result = mysqli_query($db_connect, $sql);
$record = mysqli_fetch_assoc($result);
if($record) {
$sql = "SELECT * FROM addre WHERE addre.id = '" . $_POST["id"] . "';";
$result = mysqli_query($db_connect, $sql);
$record = mysqli_fetch_assoc($result);
$sql = "UPDATE `address`.`addre` SET `lg` = '1',temperature_want = " . $reco
rd["temperature_now"] . " WHERE `addre`.`id` ='" . $_POST["id"] . "';";
mysqli_query($db_connect, $sql);
$sql = "SELECT * FROM addre WHERE addre.id = '" . $_POST["id"] . "';";
$result = mysqli_query($db_connect, $sql);
$record = mysqli_fetch_assoc($result);
echo $record["name"] . "," . $record["temperature_now"] . "," . $record["moist"]
. "," . $record["temperature_want"] . "," . $record["id"] . "," . $record["pwd"] . "," . $record["ph
one"];