public static function updatePhoto($param)
{
$pdo = new DBUtils();
$sql = "update homepage set photoUrl = '" . $param['photoUrl'] . "' where id = '{$param['id']}'";
$rs = $pdo->update($sql);
return $rs;
}
public static function edit_course_des($param)
{
$pdo = new DBUtils();
$sql = "update course set";
if (isset($param['courseDes'])) {
$sql .= " courseDes='{$param['courseDes']}',";
}
$sql = substr($sql, 0, strlen($sql) - 1);
$sql .= " where courseId = '{$param['courseId']}'";
return $pdo->update($sql);
}
public static function edit($param)
{
$pdo = new DBUtils();
$sql = "update article set";
if (isset($param['articleImg'])) {
$sql .= " articleImg='{$param['articleImg']}', ";
}
if (isset($param['content'])) {
$sql .= " content='{$param['content']}',";
}
if (isset($param['title'])) {
$sql .= " title='{$param['title']}',";
}
if (isset($param['smallContent'])) {
$sql .= " smallContent='{$param['smallContent']}',";
}
if (isset($param['articleImg'])) {
$sql .= " articleImg='{$param['articleImg']}',";
}
$sql = substr($sql, 0, strlen($sql) - 1);
$sql .= " where articleId = '{$param['articleId']}'";
return $pdo->update($sql);
}
public static function edit($aboutusId, $content)
{
$pdo = new DBUtils();
$sql = "update aboutus set content='{$content}' where aboutusId = '{$aboutusId}'";
$rs = $pdo->update($sql);
return $rs;
}
