'; //Standard 5-6 $information .= "\n"; //num_student $host="localhost"; $username="root"; $pass_word="forever"; $db="reg"; //mysql_query("SET NAMES TIS620"); mysql_connect( $host,$username,$pass_word) or die ("ติดต่อกับฐานข้อมูล Mysql ไม่ได้ "); mysql_select_db($db) or die("เลือกฐานข้อมูลไม่ได้"); $sql = "SELECT * FROM studentmaster "; $dbquery = mysql_query($sql); $num_student_all =mysql_num_rows($dbquery) ; //echo "นักศึกษาทั้งหมด $num_student_all
"; $sql2 = "SELECT * FROM studentmaster WHERE studentStatus = '1'"; $dbquery2 = mysql_query($sql2); $num_student_now =mysql_num_rows($dbquery2) ; //echo "นักศึกษาที่กำลังศึกษาอยู่ $num_student
"; $sql2 = "SELECT * FROM studentmaster WHERE studentStatus = '5'"; $dbquery2 = mysql_query($sql2); $num_student_out =mysql_num_rows($dbquery2) ; //echo "นักศึกษาที่่ลาออก $num_student_out
"; $information .= "\n"; $information .= "$num_student_all"; $information .= "\n"; $information .= "\n"; $information .= "$num_student_now"; $information .= "\n"; $information .= "\n"; $information .= "$num_student_out"; $information .= "\n"; $information .= "\n"; echo "$information"; ?>