const express = require("express");
const mysql = require("mysql");
const cors = require("cors");
const fs = require("fs");
const app = express();
app.use(cors());
let arring = [];
var arrp;
const db =mysql.createPool({
host:"127.0.0.1",
user:"root",
password:"root",
database:"day23"
})
app.get("/music",(req,res)=>{
db.query("SELECT*FROM hhh",(err,results)=>{
// console.log(results);
console.log(results);
res.send(results);
}
)})
app.listen(81,()=>{
console.log("express服务启动成功");
})
js:
var x = document.getElementById("x");
var y = document.getElementById("y");
var song = document.querySelector("#song");
var zsc=parseInt(song.duration);
var bfsc= parseInt(song.currentTime);
console.log(song.zsc);
console.log(song.bfsc);
function bbf(a){
music=a;
song.src = music;
console.log(music);
}
function func1(){
// zt.style.visibility = "visible";
// bf.style.visibility = "hidden";
// x.src = "./小王爱听music/电台/暂停.png";
x.style.display = "none";
y.style.display = "block";
song.play();
}
function func2(){
// x.src = "./小王爱听music/图标/展开.png";
y.style.display = "none";
x.style.display = "block";
song.pause();
}
function func(){
var sum = Math.floor(Math.random()*124);
console.log(bbf(sing[sum].music));
bbf(sing[sum].musiccc);
func1();
}
ajax:
let base = "http://127.0.0.1:81"
var sing=[];
var music=""
var sum = 83;
$.ajax({
type:"get",
url:`${base}/music`,
async:false,
data:{
},
success:(req)=>{
console.log(req);
sing=req;
console.log(sing);
bbf(sing[sum].musiccc)
console.log(sing[sum].musiccc);
}
})