Wordpress数据库连接插件

Question

I made a kind of plugin just for the database connection it works but if i activate my plugin the page wil go a little bit down so actually my site will become ugly

 $servername = "xxxx";  // naam of ip van de machine ... 127.0.0.1
          $username = "xxxx";  //naam van gebruiker
          $password = "xxxx"; // wachtwoord
          $dbname = "xxxx"; //db naam
          $conn = mysqli_connect($servername, $username, $password, $dbname);
          if (!$conn) {
            die("Connection failed: " . mysqli_connect_error());
        }
                    if (isset($_GET["code"]) )
    {
    $code = $_GET['code'];
    }
    else
    {
        $code = '';
    }
    //$naam = '%DR%';

    //$sql = "SELECT * FROM docenten WHERE naam=\"$naam\"";
    $sql = "SELECT * FROM `cadeaubon` WHERE Kortingscode like \"$code\"";

    //echo $sql; //debuggen
    echo "<BR>";

    $result = mysqli_query($conn, $sql);

    if (mysqli_num_rows($result) > 0) {
        // output data of each row
        echo "<table>";
        while($row = mysqli_fetch_assoc($result)) {
            echo "- ID: " . $row["ID"]. " - Kortingscode: " . $row["Kortingscode"]. " - Aantal personen: " . $row["AantPersonen"] . " - Naam: " . $row["Naam"] . " -  Achternaam: " . $row["Achternaam"] . " - Leeftijd: " . $row["Leeftijd"] . " - Datum: " . $row["Datum"]."<br>";
        }
        echo "</table>";
    } else {
        echo "";
    }

    mysqli_close($conn);

this is my code and i thought maybe it will help if the result will display at the bottom of the page but i dont know how

Answer 1

I guess you left there <br> from your debug echo:

//echo $sql; //debuggen
echo "<BR>";

However I don't know where in code this gets executed and how it integrates with WordPress. If the following table is shown inside content area of the page, the <br> shouldn't affect your site design other than pushing the table one line down.

It also seems to be a bit of overkill to create your own database connection - I would think WordPress already is connected and it would be preferable to use its own connection, unless it is a completely different database.