def update(request, data_id):
    if request.session.is_empty():
        return redirect(login)
    else:
        data_id_unchanged = data_id
        if request.method == "POST":

            name = request.POST['name']
            phone_no = request.POST['phone_no']
            nid = request.POST['nid']
            address = request.POST['address']
            room = request.POST['room']
            discount = request.POST['discount']
            doe = request.POST['doe']

            print(address)
            address = processed_string(address)
            address = unprocessed_string_address(address)
            name = unprocessed_string_name(name)

            sql = "UPDATE CUSTOMER_INFO SET NAME=%s , PHONE_NO=%s, NID_PASSPORT=%s, ADDRESS=%s, ROOM=%s, DISCOUNT = %s, ENTRY_DATE=%s WHERE ID=%s;"

            cursor = connection.cursor()
            cursor.execute(sql, [name, phone_no, nid, address, room, discount, doe, data_id_unchanged])
            connection.commit()
            cursor.close()

            return redirect(load)
        else:
            sql = "SELECT * FROM CUSTOMER_INFO WHERE ID=%s"

            cursor = connection.cursor()
            cursor.execute(sql, [data_id])
            result = cursor.fetchall()
            cursor.close()

            print("123456789")

            cid = result[0][0]
            name = result[0][1]
            phone_no = result[0][2]
            nid = result[0][3]
            address = result[0][4]
            room = result[0][5]
            discount = result[0][6]
            doe = result[0][7]

            name = processed_string(name)
            address = processed_string(address)

            print(type(doe))
            print(doe)
            doe = str(doe)

            #doe = datetime.strptime(doe, '%Y-%m-%d %H:%M:%S')
            print(name)
            print(doe)

            return render(request, 'update.html',
                          {'cid': cid, 'name': name, 'phone_no': phone_no, 'nid': nid, 'address': address, 'room': room,
                           'discount': discount, 'doe':doe})