How to use PHP and CGI to develop a music player website

How to use PHP and CGI to develop a music player website

Introduction:
With the rapid development of the Internet, access to music resources has become more and more convenient, and more and more people have become accustomed to it. Enjoy and share music on the web. If you want to develop a fully functional music playing website, PHP and CGI have become indispensable tools. This article will introduce how to use PHP and CGI to develop a simple music player website.

1. Environment preparation
Before starting development, we need to build a suitable development environment. First, you need to install a web server, such as Apache, Nginx, etc.; secondly, you need to install a PHP interpreter, and it is recommended to use the latest version of the PHP interpreter for better performance and functional support; finally, you need to install a CGI interpreter, such as Perl , Python, etc.

2. Create database and data table
Music playing website cannot do without the support of database. In this example, we choose MySQL as the database management system. First, create a database named "music"; then, create a data table named "song_list". The structure of the data table is as follows:

CREATE TABLE song_list (
id int(11) NOT NULL AUTO_INCREMENT,
title varchar(255) NOT NULL,
artist varchar(255) NOT NULL,
url varchar(255) NOT NULL,
PRIMARY KEY ( id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

3. Write PHP code

1. Connect to the database:
   $dbhost = 'localhost';
   $dbuser = 'root';
   $dbpass = 'password';
   $dbname = 'music';

   $conn = mysqli_connect ($dbhost, $dbuser, $dbpass, $dbname);

   if (!$conn) {
   die("Database connection failed: " . mysqli_connect_error());
   }
   ?>

2. Query the database to get the music list:
   $sql = "SELECT * FROM song_list";
   $result = mysqli_query( $conn, $sql);

   if (mysqli_num_rows($result) > 0) {
   while ($row = mysqli_fetch_assoc($result)) {
   echo "

3. " . $row['title'] . " - " . $row['artist'] . "
";
}
} else {
echo "No music yet";
}

mysqli_close($conn);
?>

4. Write CGI script
CGI script is used to implement the music upload function. Taking Perl as an example, create a script file named "upload.cgi" with the following code:

!/usr/bin/perl

use strict;
use CGI;

my $cgi = CGI->new();

print $cgi->header();
print "

";

my $upload_dir = "/path/to/upload/directory/";

if ($cgi->param("file")) {
my $file = $cgi ->param("file");

my ($filename, $file_ext) = split(/./, $file);

my $upload_file = $upload_dir . $filename . "." . $file_ext;

if ($cgi->upload("file", $upload_file)) {

print "文件上传成功！";

} else {

print "文件上传失败！";

}
} else {
print $cgi->start_form(

-enctype => 'multipart/form-data',
-method => 'POST'

);

print $cgi->filefield(

-name => 'file'

);

print $cgi->submit(

-name => 'submit',
-value => '上传'

);

print $cgi->end_form();
}

print " ";

5. Improve website functions
In addition to the basic music list and upload functions, other functions of the website can also be improved, such as user registration, login, and comments. , likes, etc. You can use PHP's built-in functions and databases to implement these functions.

Conclusion:
This article introduces how to use PHP and CGI to develop a simple music player website. Through reasonable database design and written PHP and CGI codes, the music list display and upload functions can be realized. I hope this article is helpful to you, and I wish you success in development!

The above is the detailed content of How to use PHP and CGI to develop a music player website. For more information, please follow other related articles on the PHP Chinese website!