Advertisement
Guest User

Untitled

a guest
Dec 9th, 2019
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.58 KB | None | 0 0
  1. public function getUCsNumberByAreaId($id){
  2.         $db = new DB();
  3.         $db->dbConnect();
  4.         $ucs = array();
  5.         $i = 0;
  6.         $sql = "SELECT uc.nome FROM uc, area
  7.        WHERE uc.id_area = area.id
  8.        AND area.id = ".$id.";";
  9.         $result = mysqli_query($db->con, $sql);
  10.         $db->dbClose();
  11.         if ($result->num_rows > 0) {
  12.             while($row = mysqli_fetch_array($result)) {
  13.                 $ucs[$i]["nome"] = $row['nome'];
  14.                 $i++;
  15.             }
  16.             return $i;
  17.         } else {
  18.             return '0';
  19.         }
  20.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement