I’m not familiar with “php everywhere”. I see you’ve posted in their forum, too.
1) How/where are you inserting the code? Shortcode or something else?
2) Show your code on pastebin.com or gist.github.com and put a link here.
The table appears *after* the footer content in your page source.
Joy
(@joyously)
Hi Steve, thank you for your reply. php everywhere adds a block to page editing to paste your code into and then on the main content block in the editor you just call [php everywhere] where you want the code to display.
The php code is this:
<?php
include(“Getit.php”);
$famname = htmlspecialchars($_POST[‘familyname’]);
$firstn = htmlspecialchars($_POST[‘firstname’]);
$year = htmlspecialchars($_POST[‘year’]);
$war = htmlspecialchars($_POST[‘war’]);
$cemetery=htmlspecialchars($_POST[‘cemetery’]);
$conn = new mysqli($host, $user, $pass, $db_name);
// Check connection
if ($conn_connect_error) {
die(“Connection failed: ” . $conn_connect_error);
}
$sql = “select * from memorials where Surname like ‘$famname%’ and FirstName like ‘$firstn%’ and Cemetery like ‘%$cemetery%’ and Date_Of_Death like ‘$year%’ and War like ‘$war%’ ORDER BY Surname”;
$result = $conn->query($sql);
if ($result->num_rows > 0) {
echo”
<table class=’pdres’ width=’100%’>
<thead>
<th class=’sresh’ style=’color:#733b17; border: 1px #733b17 solid;’>Surname</th>
<th class=’sresh’ style=’color:#733b17; border: 1px #733b17 solid;’>First Name</th>
<th class=’sresh’ style=’color:#733b17; border: 1px #733b17 solid;’>Cemetery</th>
<th class=’sresh’ style=’color:#733b17; border: 1px #733b17 solid;’>War</th>
<th class=’sresh’ style=’color:#733b17; border: 1px #733b17 solid;’>Date Of Death</th>
<th class=’sresh’ style=’color:#733b17; border: 1px #733b17 solid;’>Date Of Birth</th>
<th class=’sresh’ style=’color:#733b17; border: 1px #733b17 solid;’></th>
</thead
“;
while($row = $result->fetch_assoc()){
$str = ‘More‘;
echo”
<tbody>
<tr class=’sres’>
<td class=’sres’ style=’color:#733b17; border: 1px #733b17 solid;’>” . $row[‘Surname’] . “</td>
<td class=’sres’ style=’color:#733b17; border: 1px #733b17 solid;’>” . $row[‘FirstName’] . “</td>
<td class=’sres’ style=’color:#733b17; border: 1px #733b17 solid;’>” . $row[‘Cemetery’] . “</td>
<td class=’sres’ style=’color:#733b17; border: 1px #733b17 solid;’>” . $row[‘War’] . “</td>
<td class=’sres’ style=’color:#733b17; border: 1px #733b17 solid;’>” . $row[‘Date_Of_Death’] . “</td>
<td class=’sres’ style=’color:#733b17; border: 1px #733b17 solid;’>” . $row[‘Date_Of_Birth’] . “</td>
<td class=’sres’ style=’color:#733b17; border: 1px #733b17 solid;’>” . $str . “</td>
</tbody>”;
}
}
$conn->close();
?>
Once edited and published if I visit the site while logged in the quick links in the admin bar drop down and out of the normal admin bar almost as if there is a break somewhere.
I am no expert when it comes to wordpress or php but before the last update everything was working fine under WP Exec PHP then it went to pot.
It’s a shortcode, so you cannot echo. Stuff everything into a string, then return that string at the end of your function.
Also, it’s good practice not to put the styles inline. Assign classes to your elements, then put the styles in your CSS file (or use the customizer’s “additonal css”.
Thanks Steve but it turns out to be me being thick and stupid and not closing the table in the right place. Couple of hours re reading my own code and “hey presto” page works.
Many thanks
Jeff.
