Virker, virker ikke, virker!
Det lidt længe siden jeg sidst har gjort noget med php, så jeg skal lige hjælpes lidt: Er ved at lave lidt tabelgymnastik i wordpress med et plugin "PHP Code For Posts"Den her virkede i går, men ikke nu.
Fatal error: Call to a member function query() on null in C:\xampp\htdocs\wordpress\wp-content\plugins\php-code-for-posts\Classes\Shortcode.php(81) : eval()'d code on line 20
Linie 20 er denne: $result = $conn->query($sql);
<?php
Function forbind_til_database() {
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "wordpress";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {die("Connection failed: " . $conn->connect_error);} else {echo "Forbindelse er ok";}
}
function vis_tillidshverv() {
$sql = "SELECT * FROM wp_cer_tillidshverv ORDER BY wp_cer_tillidshverv.sortering";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// Udskriv data
echo "<table>" .
"<tr>" .
"<td>" . ID . "</td>" .
"<td>" . Sortering . "</td>" .
"<td>" . Hverv . "</td>" .
"<td>" . Beskrivelse . "</td>" .
"</tr>";
while($row = $result->fetch_assoc()) {
echo "<tr>" .
"<td width='10%'>" . $row["ID"] . "</td> " .
"<td width='10%'>" . $row["sortering"] . "</td>" .
"<td width='30%'>" . $row["tillidshverv"] . "</td>" .
"<td width='50%'>" . $row["beskrivelse"] . "</td>" .
"</tr>";
}
echo "</table>";
} else {
echo "0 results";
}
$conn->close();
}
forbind_til_database();
vis_tillidshverv();
?>
Den her virker lige nu:
<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "wordpress";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {die("Connection failed: " . $conn->connect_error);} else {echo "Forbindelse er ok";}
$sql = "SELECT * FROM wp_cer_tillidshverv ORDER BY wp_cer_tillidshverv.sortering";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// Udskriv data
echo "<table>" .
"<tr>" .
"<td>" . ID . "</td>" .
"<td>" . Sortering . "</td>" .
"<td>" . Hverv . "</td>" .
"<td>" . Beskrivelse . "</td>" .
"</tr>";
while($row = $result->fetch_assoc()) {
echo "<tr>" .
"<td width='10%'>" . $row["ID"] . "</td> " .
"<td width='10%'>" . $row["sortering"] . "</td>" .
"<td width='30%'>" . $row["tillidshverv"] . "</td>" .
"<td width='50%'>" . $row["beskrivelse"] . "</td>" .
"</tr>";
}
echo "</table>";
} else {
echo "0 results";
}
$conn->close();
?>