Keuringsnummer naar AFS

[insert_php]
require_once(“_Regio_includes/config.php”);

// Create connection
$conn = new mysqli(DB_SERVER, DB_USER, DB_PASS, DB_NAME);
// Check connection
if ($conn->connect_error) {
die(“Connection failed: ” . $conn->connect_error);
}

$sql=”SELECT * FROM Tbl_Form_Keuringsnummer order by Volgnummer ASC”;

$result = $conn->query($sql);

echo ‘

‘;

if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {

echo ‘

‘;
}
} else {
echo “0 results”;
}
echo’

KeuringsnummerNaam aanmelderPostcodeAangemeldGewijzigd
‘;
echo $row[“Jaar”].$row[“Keuring”].$row[“Volgnummer”] ;
echo ‘		‘;
echo $row[“Naam”] ;
echo’		‘;
echo $row[“Postcode”] ;
echo’		‘;
echo $row[“Aangemeld”] ;
echo’		‘;
$dd = date(“d-m-Y”, strtotime($row[“reg_date”]));
echo $dd ;
echo’

‘;

[/insert_php]

 

Keuringsnummer :