(db연결) 레코드, 필드 개수 구하기

<?php

include ('./db_info.php');

$connect = mysqli_connect(DB_HOST,DB_USER,DB_PASSWORD);

$connect = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

if(!$connect){

echo "Error: Unable to connect to MySQL." . PHP_EOL;

echo "Debugging errno: " . mysqli_connect_errno() . PHP_EOL;

echo "Debugging error: " . mysqli_connect_error() . PHP_EOL;

exit();

}

if ($result = mysqli_query($connect,"SELECT * FROM TEST")){

$total_record = mysqli_num_rows($result); //레코드 개수

$total_fields = mysqli_num_fields($result); //필드 개수

}

?>