CREATE TABLE students (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(50) NOT NULL,
phone VARCHAR(15),
province VARCHAR(20),
score INT
);
]]>
// Python Flask 示例代码
@app.route('/submit', methods=['POST'])
def submit():
data = request.json
student_province = get_student_province(data['student_id'])
school_province = get_school_province(data['school_id'])
if student_province == school_province:
save_to_database(data)
return jsonify({'status': 'success'})
else:
return jsonify({'status': 'fail', 'message': 'Province mismatch!'})
]]>