Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php include_once 'blocks/bd.php'; ?>
- //bd.php
- <?php
- $dbServerName = "localhost";
- $dbUserName = "root";
- $dbPassword = "";
- $dbName = "testing";
- $conn = mysqli_connect($dbServerName, $dbUserName, $dbPassword, $dbName);
- if (!$conn) {
- echo "Ошибка: Невозможно установить соединение с MySQL." . PHP_EOL;
- echo "Код ошибки errno: " . mysqli_connect_errno() . PHP_EOL;
- echo "Текст ошибки error: " . mysqli_connect_error() . PHP_EOL;
- exit;
- }
- echo "Соединение с MySQL установлено!" . PHP_EOL;
- ?>
- //index.php gettin rows from db
- <?php
- $sql = "SELECT * FROM users;";
- $result = mysqli_query($conn, $sql);
- $resultCheck = mysqli_num_rows($result);
- if ($resultCheck>0) {
- while ($row = mysqli_fetch_assoc($result)) {
- echo $row['name'];
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement