How can SQL be effectively used to store and retrieve news entries in a PHP application?

To effectively store and retrieve news entries in a PHP application using SQL, you can create a database table to store the news entries with fields such as title, content, date, and author. You can then use SQL queries to insert new news entries, retrieve existing entries, and display them on your PHP application. 

// Connect to the database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "news_database";

$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Insert a new news entry
$title = "Breaking News";
$content = "This is a breaking news story.";
$date = date("Y-m-d H:i:s");
$author = "John Doe";

$sql = "INSERT INTO news_entries (title, content, date, author) VALUES ('$title', '$content', '$date', '$author')";

if ($conn->query($sql) === TRUE) {
    echo "New news entry created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

// Retrieve news entries
$sql = "SELECT * FROM news_entries";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        echo "Title: " . $row["title"]. " - Content: " . $row["content"]. " - Date: " . $row["date"]. " - Author: " . $row["author"]. "<br>";
    }
} else {
    echo "0 results";
}

// Close the connection
$conn->close();

Keywords

SQL PHP application news entries store retrieve

Related Questions