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"];
   140   141   142   143   144   145   146   147   148   149   150