Print Money-budget to HTML

MuathOthman commented 1 year ago

Print Money-budget to the HTML. You find Money-budget from database (SQL) and print it here:

HUOM! Test it in your own file before pushing it to the production

Agrinsadon commented 1 year ago


async function getAirportData(name) {
  const response = await fetch('http://127.0.0.1:5000/wallet/' + name);
  console.log('response', response);
  const data = await response.json();
  console.log('data', data)
  return data;
}
async function main() {
  const name = prompt('Enter your name:');
  // async funktio palauttaa promisen
  const airportData = await getAirportData(name);
  console.log('määrä', airportData);
  document.querySelector('#p').innerHTML = name+ ' has ' + JSON.stringify(airportData.money) + '$ in the wallet.';

}
main();```

Agrinsadon commented 1 year ago


from flask import Flask
import mysql.connector
from flask_cors import CORS

def connect_db():
    return mysql.connector.connect(
        host='127.0.0.1',
        port=3306,
        database='flight_game',
        user='root',
        password='kirkuk123',
        autocommit=True
    )
def wallet(name):
    sql = f"select money from game where screen_name ='{name}'"
    cursor = connection.cursor()
    cursor.execute(sql)
    result_set = cursor.fetchone()
    if cursor.rowcount > 0:
        return {"money": result_set[0]}
    else:
        return {"Error": "Give me a correct name"}

connection = connect_db()
app = Flask(__name__)
cors = CORS(app)
app.config['CORS_HEADERS'] = 'Content-Type'

@app.route('/wallet/<name>')
def money(name):
    response = wallet(name)
    return response

if __name__ == '__main__':
    app.run(use_reloader=True, host='127.0.0.1', port=5000)```

Agrinsadon commented 1 year ago


<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Wallet</title>
    <script defer src="lentopeli.js"></script>
</head>
<body>
<p style="color: darkblue" id="p"></p>
</body>
</html>```

MuathOthman / ClearSkies

Print Money-budget to HTML #8