English
English
With the development of the internet, friend links have become an important means of website promotion. They help websites increase external traffic and enhance brand exposure. For CMS systems, the friend link function plays a crucial role. This article will guide you on how to implement this function using PHP, facilitating website promotion and collaboration.
To implement the friend link function, you first need to design the database table to store relevant link information, including the name, URL, and description. Here is an example of a database table design:
CREATE TABLE links (<br> id int(11) NOT NULL AUTO_INCREMENT,<br> name varchar(255) NOT NULL,<br> url varchar(255) NOT NULL,<br> description text NOT NULL,<br> created_at timestamp NOT NULL DEFAULT current_timestamp(),<br> updated_at timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),<br> PRIMARY KEY (id)<br>) ENGINE=InnoDB DEFAULT CHARSET=utf8;
In the CMS system’s backend, there is usually a form that allows the administrator to add new friend links. Below is an example of how to submit link information through a form:
<form action="add_link.php" method="POST"><br><label for="name">Link Name</label><br><input type="text" name="name" id="name" required><br><label for="url">Link URL</label><br><input type="text" name="url" id="url" required><br><label for="description">Link Description</label><br><textarea name="description" id="description" required></textarea><br><input type="submit" value="Add Link"><br></form>
When the form is submitted, a PHP file will receive and process the data. Below is the PHP code to handle the link addition by saving the link information into the database:
<?php<br>// Connect to database<br>$host = "localhost";<br>$dbname = "your_database_name";<br>$username = "your_username";<br>$password = "your_password";<br>$conn = new PDO("mysql:host=$host;dbname=$dbname", $username, $password);<br>// Get form data<br>$name = $_POST['name'];<br>$url = $_POST['url'];<br>$description = $_POST['description'];<br>// Insert data into database<br>$stmt = $conn->prepare("INSERT INTO links (name, url, description) VALUES (:name, :url, :description)");<br>$stmt->bindParam(':name', $name);<br>$stmt->bindParam(':url', $url);<br>$stmt->bindParam(':description', $description);<br>$stmt->execute();<br>// Display success message<br>echo "Link has been successfully added!";<br>?>To display the added friend links, we can create a PHP page to query and show the links from the database. Below is an example of displaying the links:
<?php<br>// Connect to database<br>$host = "localhost";<br>$dbname = "your_database_name";<br>$username = "your_username";<br>$password = "your_password";<br>$conn = new PDO("mysql:host=$host;dbname=$dbname", $username, $password);<br>// Query link information<br>$stmt = $conn->prepare("SELECT * FROM links");<br>$stmt->execute();<br>$links = $stmt->fetchAll(PDO::FETCH_ASSOC);<br>// Display links<br>foreach ($links as $link) {<br> echo "<a href=" . $link['url'] . ">" . $link['name'] . "</a> - " . $link['description'] . "<br>";<br>}<br>?>Through the guide in this article, you can easily implement the friend link function in a CMS system. By combining PHP and database operations, managing and displaying friend links becomes simple and efficient. You can further optimize the code and add features such as editing and deleting links to meet different business needs.
