커뮤니티
포인트
쿠폰
내 강의실
국비 신청 내역
증명서
계정
로그아웃
학습 질문
개발 일지
나의 활동
답변 완료
4주차 8강 > 화성땅공동구매 > POST연습 > Alert(저장완료!) 미노출 문의
undefined주차
북마크
이*연
댓글
3
추천
0
조회수
11
조회수
11
답변 완료

* 겪고 있는 문제 상황을 최대한 자세하게 작성해주세요.

* 문제 해결을 위해 어떤 시도를 해보았는지 구체적으로 함께 알려주세요.


4주차 8강 > 화성땅공동구매 > POST연습 중

Alert(Get 연결 완료!)는 노출되는데

스파르타 즉문즉답

이름 입력&주소 입력&평수 선택 > 주문하기 버튼 선택 시

Alert(저장완료!) 미노출되어 문의드립니다.

스파르타 즉문즉답


스파르타 즉문즉답스파르타 즉문즉답



1. app.py

from flask import Flask, render_template, request, jsonify
app = Flask(__name__)


from pymongo import MongoClient
client = MongoClient('mongodb+srv://sparta:test@cluster0.xkwehfr.mongodb.net/?retryWrites=true&w=majority')
db = client.dbsparta


@app.route('/')
def home():
    return render_template('index.html')


@app.route("/mars", methods=["POST"])
def mars_post():
    name_receive = request.form['name_give']
    address_receive = request.form['address_give']
    size_receive = request.form['size_give']


    doc = {
        'name': name_receive,
        'address': address_receive,
        'size': size_receive
    }
    db.mars.insert_one(doc)
    return jsonify({'msg': '저장완료!'})


@app.route("/mars", methods=["GET"])
def mars_get():
    return jsonify({'msg':'GET 연결 완료!'})


if __name__ == '__main__':
    app.run('0.0.0.0', port=5000, debug=True)

2. index.html

<!DOCTYPE html>
<html lang="en">


<head>
    <meta charset="UTF-8" />
    <meta http-equiv="X-UA-Compatible" content="IE=edge" />
    <meta name="viewport" content="width=device-width, initial-scale=1.0" />


    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/css/bootstrap.min.css" rel="stylesheet"
        integrity="sha384-EVSTQN3/azprG1Anm3QDgpJLIm9Nao0Yz1ztcQTwFspd3yD65VohhpuuCOmLASjC" crossorigin="anonymous" />
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/js/bootstrap.bundle.min.js"
        integrity="sha384-MrcW6ZMFYlzcLA8Nl+NtUVF0sA7MsXsP1UyJoMp4YLEuNSfAP+JcXn/tWtIaxVXM"
        crossorigin="anonymous"></script>


    <link href="https://fonts.googleapis.com/css2?family=Gowun+Batang:wght@400;700&display=swap" rel="stylesheet" />


    <title>선착순 공동구매</title>


    <style>
        * {
            font-family: "Gowun Batang", serif;
            color: white;
        }


        body {
            background-image: linear-gradient(0deg,
                    rgba(0, 0, 0, 0.5),
                    rgba(0, 0, 0, 0.5)),
                url("https://cdn.aitimes.com/news/photo/202010/132592_129694_3139.jpg");
            background-position: center;
            background-size: cover;
        }


        h1 {
            font-weight: bold;
        }


        .order {
            width: 500px;
            margin: 60px auto 0px auto;
            padding-bottom: 60px;
        }


        .mybtn {
            width: 100%;
        }


        .order>table {
            margin: 40px 0;
            font-size: 18px;
        }


        option {
            color: black;
        }
    </style>
    <script>
        $(document).ready(function () {
            show_order();
        });
        function show_order() {
            fetch('/mars').then((res) => res.json()).then((data) => {
                console.log(data)
                alert(data['msg'])
            })
        }
        function save_order() {
            let name = $('#name').val()
            let address = $('#address').val()
            let size = $('#size').val()


            let formData = new FormData();
            formData.append("name_give", name);
            formData.append("address_give", address);
            formData.append("size_give", size);


            fetch('/mars', { method: "POST", body: formData }).then((res) => res.json()).then((data) => {
                alert(data["msg"]);
            });
        }
    </script>
</head>


<body>
    <div class="mask"></div>
    <div class="order">
        <h1>화성에 땅 사놓기!</h1>
        <h3>가격: 평 당 500원</h3>
        <p>
            화성에 땅을 사둘 수 있다고?<br />
            앞으로 백년 간 오지 않을 기회. 화성에서 즐기는 노후!
        </p>
        <div class="order-info">
            <div class="input-group mb-3">
                <span class="input-group-text">이름</span>
                <input id="name" type="text" class="form-control" />
            </div>
            <div class="input-group mb-3">
                <span class="input-group-text">주소</span>
                <input id="address" type="text" class="form-control" />
            </div>
            <div class="input-group mb-3">
                <label class="input-group-text" for="size">평수</label>
                <select class="form-select" id="size">
                    <option selected>-- 주문 평수 --</option>
                    <option value="10평">10평</option>
                    <option value="20평">20평</option>
                    <option value="30평">30평</option>
                    <option value="40평">40평</option>
                    <option value="50평">50평</option>
                </select>
            </div>
            <button onclick="save_order()" type="button" class="btn btn-warning mybtn">
                주문하기
            </button>
        </div>
        <table class="table">
            <thead>
                <tr>
                    <th scope="col">이름</th>
                    <th scope="col">주소</th>
                    <th scope="col">평수</th>
                </tr>
            </thead>
            <tbody id="order-box">
                <tr>
                    <td>홍길동</td>
                    <td>서울시 용산구</td>
                    <td>20평</td>
                </tr>
                <tr>
                    <td>임꺽정</td>
                    <td>부산시 동구</td>
                    <td>10평</td>
                </tr>
                <tr>
                    <td>세종대왕</td>
                    <td>세종시 대왕구</td>
                    <td>30평</td>
                </tr>
            </tbody>
        </table>
    </div>
</body>


</html>

3. app.py pythone 터미널 오류

source /Users/doyeon.lee/Desktop/sparta/웹개발종합반/4주차/projects/02.mars/venv/bin/activate


The default interactive shell is now zsh.
To update your account to use zsh, please run `chsh -s /bin/zsh`.
For more details, please visit https://support.apple.com/kb/HT208050.
SSG-doyeon:02.mars doyeon.lee$ source /Users/doyeon.lee/Desktop/sparta/웹개발종합반/4주차/projects/02.mars/venv/bin/activate
(venv) SSG-doyeon:02.mars doyeon.lee$ /Users/doyeon.lee/Desktop/sparta/웹개발종합반/4주차/projects/02.mars/venv/bin/python /Users/doyeon.lee/Desktop/sparta/웹개발종합반/4주차/projects/02.mars/app.py
 * Serving Flask app 'app'
 * Debug mode: on
WARNING: This is a development server. Do not use it in a production deployment. Use a production WSGI server instead.
 * Running on all addresses (0.0.0.0)
 * Running on http://127.0.0.1:5000
 * Running on http://10.202.182.24:5000
Press CTRL+C to quit
 * Restarting with stat
 * Debugger is active!
 * Debugger PIN: 756-197-425
/Users/doyeon.lee/Desktop/sparta/웹개발종합반/4주차/projects/02.mars/venv/bin/python /Users/doyeon.lee/Desktop/sparta/웹개발종합반/4주차/projects/02.mars/app.py
127.0.0.1 - - [29/Apr/2023 16:41:36] "POST /mars HTTP/1.1" 500 -
Traceback (most recent call last):
  File "/Users/doyeon.lee/Desktop/sparta/웹개발종합반/4주차/projects/02.mars/venv/lib/python3.8/site-packages/flask/app.py", line 2213, in __call__
    return self.wsgi_app(environ, start_response)
  File "/Users/doyeon.lee/Desktop/sparta/웹개발종합반/4주차/projects/02.mars/venv/lib/python3.8/site-packages/flask/app.py", line 2193, in wsgi_app
    response = self.handle_exception(e)
  File "/Users/doyeon.lee/Desktop/sparta/웹개발종합반/4주차/projects/02.mars/venv/lib/python3.8/site-packages/flask/app.py", line 2190, in wsgi_app
    response = self.full_dispatch_request()
  File "/Users/doyeon.lee/Desktop/sparta/웹개발종합반/4주차/projects/02.mars/venv/lib/python3.8/site-packages/flask/app.py", line 1486, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "/Users/doyeon.lee/Desktop/sparta/웹개발종합반/4주차/projects/02.mars/venv/lib/python3.8/site-packages/flask/app.py", line 1484, in full_dispatch_request
    rv = self.dispatch_request()
  File "/Users/doyeon.lee/Desktop/sparta/웹개발종합반/4주차/projects/02.mars/venv/lib/python3.8/site-packages/flask/app.py", line 1469, in dispatch_request
    return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)
  File "/Users/doyeon.lee/Desktop/sparta/웹개발종합반/4주차/projects/02.mars/app.py", line 23, in mars_post
    db.mars.insert_one(doc)
  File "/Users/doyeon.lee/Desktop/sparta/웹개발종합반/4주차/projects/02.mars/venv/lib/python3.8/site-packages/pymongo/collection.py", line 628, in insert_one
    self._insert_one(
  File "/Users/doyeon.lee/Desktop/sparta/웹개발종합반/4주차/projects/02.mars/venv/lib/python3.8/site-packages/pymongo/collection.py", line 569, in _insert_one
    self.__database.client._retryable_write(acknowledged, _insert_command, session)
  File "/Users/doyeon.lee/Desktop/sparta/웹개발종합반/4주차/projects/02.mars/venv/lib/python3.8/site-packages/pymongo/mongo_client.py", line 1475, in _retryable_write
    with self._tmp_session(session) as s:
  File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/contextlib.py", line 113, in __enter__
    return next(self.gen)
  File "/Users/doyeon.lee/Desktop/sparta/웹개발종합반/4주차/projects/02.mars/venv/lib/python3.8/site-packages/pymongo/mongo_client.py", line 1757, in _tmp_session
    s = self._ensure_session(session)
  File "/Users/doyeon.lee/Desktop/sparta/웹개발종합반/4주차/projects/02.mars/venv/lib/python3.8/site-packages/pymongo/mongo_client.py", line 1740, in _ensure_session
    return self.__start_session(True, causal_consistency=False)
  File "/Users/doyeon.lee/Desktop/sparta/웹개발종합반/4주차/projects/02.mars/venv/lib/python3.8/site-packages/pymongo/mongo_client.py", line 1685, in __start_session
    self._topology._check_implicit_session_support()
  File "/Users/doyeon.lee/Desktop/sparta/웹개발종합반/4주차/projects/02.mars/venv/lib/python3.8/site-packages/pymongo/topology.py", line 538, in _check_implicit_session_support
    self._check_session_support()
  File "/Users/doyeon.lee/Desktop/sparta/웹개발종합반/4주차/projects/02.mars/venv/lib/python3.8/site-packages/pymongo/topology.py", line 554, in _check_session_support
    self._select_servers_loop(
  File "/Users/doyeon.lee/Desktop/sparta/웹개발종합반/4주차/projects/02.mars/venv/lib/python3.8/site-packages/pymongo/topology.py", line 238, in _select_servers_loop
    raise ServerSelectionTimeoutError(
pymongo.errors.ServerSelectionTimeoutError: ac-ubalxd3-shard-00-02.xkwehfr.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1108),ac-ubalxd3-shard-00-01.xkwehfr.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1108),ac-ubalxd3-shard-00-00.xkwehfr.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1108), Timeout: 30s, Topology Description: <TopologyDescription id: 644cca03dffcf0f34b9cb536, topology_type: ReplicaSetNoPrimary, servers: [<ServerDescription ('ac-ubalxd3-shard-00-00.xkwehfr.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-ubalxd3-shard-00-00.xkwehfr.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1108)')>, <ServerDescription ('ac-ubalxd3-shard-00-01.xkwehfr.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-ubalxd3-shard-00-01.xkwehfr.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1108)')>, <ServerDescription ('ac-ubalxd3-shard-00-02.xkwehfr.mongodb.net', 27017) server_type: Unknown, rtt: None, error=AutoReconnect('ac-ubalxd3-shard-00-02.xkwehfr.mongodb.net:27017: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1108)')>]>


취소
 공유
취소
댓글 0
댓글 알림
나의얼굴