使用 PHP 在新站点上显示来自 MySQL 的记录 - Display records from MySQL on a new site using PHP?

Display records from MySQL on a new site using PHP?

我想从mysql获取新闻（记录）并使用PHP显示在我的网站中。这是我的代码（PHP）：

<?php
    include ("header.php");
    mysql_connect ("localhost", "root", "") or die (mysql_error());
    mysql_select_db ("geek-art") or die (mysql_error());
    $newsy = mysql_query ("SELECT * FROM newsy order by id desc");
    // With this WHILE loop, I want to display all of my news :)
    while ($rekord = mysql_fetch_array ($newsy)) {
        $id = $rekord['id'];
        $tytul = $rekord['tytul'];
        $tresc = $rekord['tresc'];
        $autor = $rekord['autor'];
        $data = $rekord['data'];
        $obrazek = $rekord['obr-news'];
        echo '<div class="artykul">';
            echo "<h2><a href='"index.php?news=$id'">".$tytul.'</a></h2>';
            echo '<span>Autor: '.$autor.' Data: '.$data.'</span>';
            echo '<p>'.nl2br($tresc).'</p>';
        echo '</div>';
    }
    // With this WHILE loop, I want to display my news :)
    $newsy_osobne = mysql_query("SELECT * FROM newsy where id=".(int)@$_GET['news']."");
    while($rekordy_osobne = mysql_fetch_array($newsy_osobne)){
        if(isset($_GET['news'])){
            $id = $rekordy_osobne['id'];        
            $tytul = $rekordy_osobne['tytul'];
            $tresc = $rekordy_osobne['tresc'];
            $autor = $rekordy_osobne['autor'];
            $data = $rekordy_osobne['data'];
            echo '<div class="artykul">';
                echo "<h2>".$tytul.'</a></h2>';
                echo '<span>Autor: '.$autor.' Data: '.$data.'</span>';
                echo '<p>'.nl2br($tresc).'</p>';
            echo '</div>';
        }else{
            echo 'Nie znaleziono takiego newsa.';
        }
    }
    include ("footer.php");
?>

我

做了一个简短的视频，我展示了我的问题到底是什么:)

试试这个，如果你的 id 不是主键，我刚刚将您的查询限制更改为 1，而不是返回多条记录的可能性，所以这会将其减少到一条。

// With this WHILE loop, I want to display my news :)
    $newsy_osobne = mysql_query("SELECT * FROM newsy where id='".$_GET['news']."' order by id desc limit 1");
    while($rekordy_osobne = mysql_fetch_array($newsy_osobne)){
        if(isset($_GET['news'])){
            $id = $rekordy_osobne['id'];        
            $tytul = $rekordy_osobne['tytul'];
            $tresc = $rekordy_osobne['tresc'];
            $autor = $rekordy_osobne['autor'];
            $data = $rekordy_osobne['data'];
            echo '<div class="artykul">';
                echo "<h2>".$tytul.'</a></h2>';
                echo '<span>Autor: '.$autor.' Data: '.$data.'</span>';
                echo '<p>'.nl2br($tresc).'</p>';
            echo '</div>';
        }else{
            echo 'Nie znaleziono takiego newsa.';
        }
    }