public static function add($param)
{
$pdo = new DBUtils();
$key_str = "";
$val_str = "";
$sql = "";
if (isset($param['type'])) {
$key_str .= "type,";
$val_str .= "'{$param['type']}',";
}
if (isset($param['studentName'])) {
$key_str .= "studentName,";
$val_str .= "'{$param['studentName']}',";
}
if (isset($param['num'])) {
$key_str .= "num" . ",";
$val_str .= "'{$param['num']}',";
}
$now = time();
$key_str .= "time" . ",";
$val_str .= "'{$now}',";
$key_str .= "course" . ",";
$val_str .= "'{$GLOBALS['STUDENT_COURSE_TYPE'][0]}',";
$key_str = substr($key_str, 0, strlen($key_str) - 1);
$val_str = substr($val_str, 0, strlen($val_str) - 1);
$sql = "insert into student_news (" . $key_str . ")";
$sql .= " VALUES (" . $val_str . ")";
$articleId = $pdo->insert($sql);
return $articleId;
}
public static function savePhoto($param)
{
$pdo = new DBUtils();
$create_time = time();
$sql = "insert into photo (photoName, photoUrl, create_time)";
$sql .= " VALUES ('{$param['photoName']}', '{$param['photoUrl']}', '{$create_time}')";
$rs = $pdo->insert($sql);
return $rs;
}
public static function add($param)
{
$pdo = new DBUtils();
$key_str = "";
$val_str = "";
$sql = "";
if (isset($param['content'])) {
$key_str .= "content,";
$val_str .= "'{$param['content']}',";
}
if (isset($param['title'])) {
$key_str .= "title,";
$val_str .= "'{$param['title']}',";
}
if (isset($param['snavId'])) {
$key_str .= "snavId" . ",";
$val_str .= "'{$param['snavId']}',";
}
if (isset($param['smallContent'])) {
$key_str .= "smallContent" . ",";
$val_str .= "'{$param['smallContent']}',";
}
if (isset($param['articleImg'])) {
$key_str .= "articleImg" . ",";
$val_str .= "'{$param['articleImg']}',";
}
$now = time();
$key_str .= "time" . ",";
$val_str .= "'{$now}',";
$key_str = substr($key_str, 0, strlen($key_str) - 1);
$val_str = substr($val_str, 0, strlen($val_str) - 1);
$sql = "insert into article (" . $key_str . ")";
$sql .= " VALUES (" . $val_str . ")";
$articleId = $pdo->insert($sql);
return $articleId;
}
public static function saveJoinus($param)
{
$pdo = new DBUtils();
$key_str = "";
$val_str = "";
$sql = "";
if (isset($param['bus_name'])) {
$key_str .= "bus_name,";
$val_str .= "'{$param['bus_name']}',";
}
if (isset($param['address'])) {
$key_str .= "address,";
$val_str .= "'{$param['address']}',";
}
if (isset($param['phone'])) {
$key_str .= "phone" . ",";
$val_str .= "'{$param['phone']}',";
}
if (isset($param['email'])) {
$key_str .= "email" . ",";
$val_str .= "'{$param['email']}',";
}
if (isset($param['others'])) {
$key_str .= "others" . ",";
$val_str .= "'{$param['others']}',";
}
$now = time();
$key_str .= "time" . ",";
$val_str .= "'{$now}',";
$key_str = substr($key_str, 0, strlen($key_str) - 1);
$val_str = substr($val_str, 0, strlen($val_str) - 1);
$sql = "insert into joinus (" . $key_str . ")";
$sql .= " VALUES (" . $val_str . ")";
$id = $pdo->insert($sql);
return $id;
}
public static function addCourse($param)
{
$pdo = new DBUtils();
$key_str = "";
$val_str = "";
$sql = "";
if (isset($param['courseId'])) {
$key_str .= "courseId,";
$val_str .= "'{$param['courseId']}',";
}
if (isset($param['courseName'])) {
$key_str .= "courseName,";
$val_str .= "'{$param['courseName']}',";
}
$key_str = substr($key_str, 0, strlen($key_str) - 1);
$val_str = substr($val_str, 0, strlen($val_str) - 1);
$sql = "insert into course (" . $key_str . ")";
$sql .= " VALUES (" . $val_str . ")";
$courseId = $pdo->insert($sql);
return $courseId;
}
