第一部分-知識點(diǎn)

1.git命令

• 把主分支項(xiàng)目拉取下來
  git fetch
  git merge origin/master
  git diff //查看有沒有沖突
• 上傳分支
  cd 文件夾名稱
  git add .
  git commit -m 寫說明這是干嘛的
  git branch //這是創(chuàng)建分支
  git checkout //這是切換分支
  git push origin fengxiaobin:fengxiaobin 把分支推送到遠(yuǎn)程
  git status 查看狀態(tài)

2. 使用PDO連接數(shù)據(jù)庫實(shí)現(xiàn)增刪改查功能

• 連接到數(shù)據(jù)庫

function db(){
   try {
     $pdo = new PDO(mysql:host=" "; dbname=" ", username="root", passwd=" ");
     return $pdo;}catch ($e) {
     die("fail to connect mysql" .$e ->getMessage());
} 
}

• 增加

function add($data) {
  $pdo = db();
  $sql = "INSERT INTO photo (name,path) VALUES(?,?)";
  $std = $pdo -> prepare($sql);
  $res = $std -> execute($data);
  return $res;
}  

• 刪除

function delete($id) {
  $pdo = db();
  $sql = "DELETE from photo where id = ?";
  $std = $pdo -> prepare($sql);
  $res = $std -> execute([$id]);
  return $res;
}

• 修改

function update($data){
  $pdo = db();
  $sql = "UPDATE photo set name = ?,path = ? where id = ?";
  $std = $pdo -> prepare($sql);
  $res = $std ->execute($data);
  return $res;
}

• 查詢

function select() {
  $pdo = db();
  $sql = "select * from photo";
  $std = $pdo -> query($sql);
  $res = $std -> fetchALL();
  return $res;
}

• 查詢id

function selectOne($id) {
  $pdo = db();
  $sql = "select * from photo where id = $id";
  $std = $pdo -> query($sql);
  $res = $std -> fetch();
  return $res;
} 

• 全局配置

define('DB_ADDRESS','127.0.0.1');
define('DB_NAME','sys-photo');
define('DB_USER','root');
define('DB_PASS','123456');