Guest User

Untitled

a guest
Apr 9th, 2018
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.71 KB | None | 0 0
  1. <?php
  2. // host (localhost)
  3. $db_host = "localhost";
  4. // database name
  5. $db_name = "yourdatabasename";
  6. // login
  7. $db_user = "youruser";
  8. // password
  9. $db_pass = "yourpass";
  10.  
  11. $db = mysqli_connect ($db_host, $db_user, $db_pass, $db_name) or die ("Невозможно подключиться к БД");
  12.  
  13. $sql="SELECT id, group_concat(name) as name FROM data group by id";
  14.  
  15. $result=mysqli_query($db,$sql);
  16.  
  17.  
  18.  
  19. while($row=mysqli_fetch_array($result)){
  20.  
  21.  
  22. echo "[&nbsp". $row['id'] ."] &nbsp<br>";
  23. echo "[&nbsp<a href='#link'>". $row['name'] ."</a>] &nbsp<br><br>";
  24.  
  25.  
  26. }
  27.  
  28. CREATE TABLE `data` (
  29. `id` int(11) NOT NULL,
  30. `name` varchar(50) NOT NULL
  31. ) ENGINE=InnoDB DEFAULT CHARSET=latin1
  32.  
  33. [ 1]
  34. [ kamran,emin]
  35.  
  36. [ 2]
  37. [ ramin,kam,john]
Add Comment
Please, Sign In to add comment