个回答

• 19951204

  2017-11-07 09:28:06

  index.php

  require __DIR__.'/lib/Article.php';
  

  $pdo=new PDO('mysql:host=localhost;dbname=res','root','root');
  $article = new article($pdo);
  var_dump($article->create('文章标题1','文章内容1',1))

  Article.php
  

  require_once __DIR__."/ErrorCode.php";
  class Article{

  private $_db;
  public function __construct($_db){
     $this->_db =  $_db;
  }

  public function create($title,$content,$userId){
     if(empty($title)){
         throw new Exception("文章标题不能为空", ErrorCode::ARTICLE_TITLE_CANNOT_EMPTY);
     }
     if(empty($content)){
         throw new Exception("文章内容不能为空", ErrorCode::ARTICLE_CONTENT_CANNOT_EMPTY);
     }
     $addtime = time();
     //数据写入
     $sql = 'INSERT INTO `article` (`title`,`content`,`addtime`,`user_id`) VALUES(:title,:content,:addtime,:user_id)';
     $stmt = $this->_db->prepare($sql);
     $stmt->bindParam(':title',$title);
     $stmt->bindparam(':content',$content);
     $stmt->bindparam(':addtime',$addtime);
     $stmt->bindparam(':user_id',$userId);
     if(!$stmt->execute()){
         throw new Exception("发布文章失败", ErrorCode::ARTICLE_CREATE_FAIL);
     }
     return [
         'articleId' => $this->_db->lastInsertId(),
         'title'    => $title,
         'content'  => $content,
         'addtime'  => $addtime,
         'userId'   => $userId
     ];
  }

  0

• YeapRoger

  2017-11-07 00:17:38

  贴代码朋友，不贴大家都只能猜，最好带上请求参数

  0