Advertisement
Nehorowo

PHP datebase

Nov 25th, 2018
165
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.92 KB | None | 0 0
  1. <?php include_once 'blocks/bd.php'; ?>
  2.  
  3. //bd.php
  4. <?php
  5.  
  6.     $dbServerName = "localhost";
  7.     $dbUserName = "root";
  8.     $dbPassword = "";
  9.     $dbName = "testing";
  10.  
  11.     $conn = mysqli_connect($dbServerName, $dbUserName, $dbPassword, $dbName);
  12.  
  13. if (!$conn) {
  14.     echo "Ошибка: Невозможно установить соединение с MySQL." . PHP_EOL;
  15.     echo "Код ошибки errno: " . mysqli_connect_errno() . PHP_EOL;
  16.     echo "Текст ошибки error: " . mysqli_connect_error() . PHP_EOL;
  17.     exit;
  18.     }
  19.  
  20. echo "Соединение с MySQL установлено!" . PHP_EOL;
  21.  
  22. ?>
  23.  
  24. //index.php gettin rows from db
  25. <?php  
  26.     $sql = "SELECT * FROM users;";
  27.     $result = mysqli_query($conn, $sql);
  28.     $resultCheck = mysqli_num_rows($result);
  29.     if ($resultCheck>0) {
  30.         while ($row = mysqli_fetch_assoc($result)) {
  31.         echo $row['name'];
  32.         }
  33.     }
  34.                                        
  35. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement