Test my wordpress database connection with a simple mysql script06.04.16

<!DOCTYPE html>
<html lang="de-DE">
      <head>
      <meta charset="UTF-8">
      <meta name="viewport" content="width=device-width, initial-scale=1">
      <link rel="profile" href="http://gmpg.org/xfn/11">
      <link rel="pingback" href="http://scala2.dev/xmlrpc.php">
</head>
<body>
Json:
<?php
$test = array( 'bla' => 'äöü' );
$test['bla'] = htmlentities( $test['bla'] );

echo json_encode( $test );
?>

<br/>
<?php
$host = "localhost";
$user = "myusername";
$pass = "password";
$db = "mydbname";
// Create connection                                                                                                                                                                                                                          
$conn = mysqli_connect($host, $user, $pass,$db);

// Check connection                                                                                                                                                                                                                           
if (!$conn):
    die("Connection failed: " . mysqli_connect_error());
endif;

echo "Connected successfully<br/>";

$sql = "SELECT * FROM wp_posts";
$result = $conn->query($sql);

if ($result->num_rows > 0):
    while($row = $result->fetch_assoc()) {
        echo "ID: " . $row["ID"]. " - Post: " . $row["post_content"] . "<br>";
    }
else:
    echo "error";
endif;

</body>
</html>

http://www.w3schools.com/php/php_mysql_select.asp

Anonymous

Test my wordpress database connection with a simple mysql script06.04.16

Information Epoch 1714849779