Advertisement
Guest User

Untitled

a guest
Mar 17th, 2019
160
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. <?php
  2. $servername = "localhost";
  3. $username = "root";
  4. $password = "";
  5. $dbname = "super";
  6.  
  7. $conn = mysqli_connect($servername, $username, $password, $dbname);
  8. if (!$conn) {
  9. die("Connection failed: " . mysqli_connect_error());
  10. }
  11.  
  12. $sql = "SELECT * FROM clientes";
  13. $result = mysqli_query($conn, $sql);
  14.  
  15. if (mysqli_num_rows($result) > 0) {
  16.  
  17. while($row = mysqli_fetch_assoc($result)) {
  18.  
  19. $VarTipo = $row["cli_tipo"];
  20. }
  21. } else {
  22. echo "0 results";
  23. }
  24.  
  25. $CliTipos = explode(",", $VarTipo);
  26.  
  27. foreach($CliTipos as $noString){
  28.  
  29. $query="SELECT * FROM tipo where id='$noString'";
  30.  
  31. $resultQuery = mysqli_query($conn, $query);
  32.  
  33. while($row = mysqli_fetch_assoc($resultQuery)) {
  34.  
  35. $VarDescClienteTipo = $row['desc'];
  36.  
  37.  
  38. echo "<br />".$VarDescClienteTipo;
  39. }
  40.  
  41. }
  42.  
  43. mysqli_close($conn);
  44. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement