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; }