Phpfile

From rbachwiki
Revision as of 00:37, 13 February 2019 by Bacchas (talk | contribs) (Created page with "<pre> <?php $dbhost = 'localhost:3306'; $dbuser = 'root'; $dbpass = 'out'; $conn = mysqli_connect($dbhost, $dbuser, $dbpass); if(! $conn){ die('could not connect '. mysql...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
<?php
$dbhost = 'localhost:3306';
$dbuser = 'root';
$dbpass = 'out';
$conn = mysqli_connect($dbhost, $dbuser, $dbpass);

if(! $conn){
    die('could not connect '. mysqli_error());
}
echo 'Connected Successfully';
mysqli_select_db($conn, 'test');
$query = 'SELECT * FROM posts';
$result = mysqli_query($conn, $query);

mysqli_close($conn);

?>


<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <title>Document</title>
</head>
<body>
    <?php
    if(mysqli_num_rows($result)> 0):?>
    <ul>
        <?php while($row = mysqli_fetch_object($result)): ?>
        <li><?php echo $row->Name ?></li>
<?php endwhile; ?>
    </ul>
<?php else: ?>
<p>No post</p>
<?php endif; ?>

    <?php phpinfo(); ?>
</body>
</html>