模板和class操作SQL语句方法

模板

$user_rs=DB::get_one("SELECT id,username FROM ".$_M['table']['user']." where id='$uid'");//读取一条$user_rs=DB::get_all("SELECT id,username FROM ".$_M['table']['user']." where id='$uid'");//读取所有

数据库名称引用方法：

FROM $met_my_application_subject

class类操作

$teachers_rows = DB::get_one("SELECT id FROM {$_M['table']['my_class_course']} WHERE teachers_id = '$tid' $so_time");//一条$teachers_rows = DB::get_all("SELECT id FROM {$_M['table']['my_class_course']} WHERE teachers_id = '$tid' $so_time");//所有

数据库名称引用方法：

FROM ".$_M['table']['my_application_subject']." WHERE  不用能 FROM $met_my_application_subject

统计记录集，统计有多少条数据

teachers_num2=count($teachers_rows2);