【IT168 专稿】jQuery的确是十分强大的工具,在网页上,你甚至可以用它配合其他jQuery插件设计一款在线网页播放器。本文就介绍了如何使用PHP,CSS和jQuery及一个开源的jQuery插件jPlayer,设计一个简单的在线网页音乐播放器。
一、准备数据库
首先,我们设计MYSQL数据库如下:
#div_code img{border:0px;}<!--
Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/
--> CREATE TABLE `songs` (
`song_id` int ( 11 ) NOT NULL AUTO_INCREMENT,
`url` varchar( 500 ) NOT NULL,
`artist` varchar( 250 ) NOT NULL,
`title` varchar( 250 ) NOT NULL,
PRIMARY KEY (`song_id`)
) ENGINE = MyISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT = 2 ;
Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/
--> CREATE TABLE `songs` (
`song_id` int ( 11 ) NOT NULL AUTO_INCREMENT,
`url` varchar( 500 ) NOT NULL,
`artist` varchar( 250 ) NOT NULL,
`title` varchar( 250 ) NOT NULL,
PRIMARY KEY (`song_id`)
) ENGINE = MyISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT = 2 ;
这里,url字段表示是mp3音乐的存放地址,artist是歌曲的演唱者,title是歌曲的名称。我们再加入一些样例数据,如下:
#div_code img{border:0px;}<!--
Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/
--> INSERT INTO `songs` (`song_id`, `url`, `artist`, `title`) VALUES ( '' , ' http://mysongs.com/songurl.mp3 ' , ' Artist name ' , ' Song name ' );
INSERT INTO `songs` (`song_id`, `url`, `artist`, `title`) VALUES ( '' , ' http://mysongs.com/anothersongurl.mp3 ' , ' Another artist ' , ' Another song ' );
INSERT INTO `songs` (`song_id`, `url`, `artist`, `title`) VALUES ( '' , ' http://mysongs.com/onemoresongurl.mp3 ' , ' One more artist ' , ' One more song ' );
Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/
--> INSERT INTO `songs` (`song_id`, `url`, `artist`, `title`) VALUES ( '' , ' http://mysongs.com/songurl.mp3 ' , ' Artist name ' , ' Song name ' );
INSERT INTO `songs` (`song_id`, `url`, `artist`, `title`) VALUES ( '' , ' http://mysongs.com/anothersongurl.mp3 ' , ' Another artist ' , ' Another song ' );
INSERT INTO `songs` (`song_id`, `url`, `artist`, `title`) VALUES ( '' , ' http://mysongs.com/onemoresongurl.mp3 ' , ' One more artist ' , ' One more song ' );
转载于:http://blog.itpub.net/25436212/viewspace-694821/