目录
1、配置文件 config.php
class Config
{
public static $db_name = '数据库名称';
public static $db_user = '用户名';
public static $db_pwd = '******';
public static $db_host = '主机IP地址';
public static $dsn = 'mysql:dbname=数据库名称;host=主机IP地址';
}
2、连接数据库文件 conn.php
include 'config.php';
class connDatabase
{
public function connectOperator()
{
$dsn = Config::$dsn;
$db_user = Config::$db_user;
$db_pass = Config::$db_pwd;
try {
$pdo = new PDO($dsn, $db_user, $db_pass);
} catch (PDOException $e) {
echo "数据库连接失败" . $e->getMessage();
}
return $pdo;
}
}
3、连接使用
<?php
/**
* Created by PhpStorm.
* User: bianenhui
* Date: 2019-06-01
* Time: 20:46
*/
include("conn.php");
class joinTarget{
public function joinTargetOperator(){
$pdoObj = new connDatabase();
$pdo = $pdoObj->connectOperator();
$pdo->exec("set names utf8");
$nowTime = date("Y-m-d 00:00:00");
$sql_account_log = "SELECT * FROM gs_account_log WHERE check_status = 2 AND create_time ='".$nowTime."'";
$result_account_log = $pdo->query($sql_account_log);
$result_account_log_list = $result_account_log->fetchAll();
foreach ($result_account_log_list as $k=>$v){
$task_id = $v['task_id'];
$aid = $v['aid'];
$sql_account = "SELECT * FROM gs_account WHERE id =".$aid;
$result = $pdo->query($sql_account);
$account_list = $result->fetch();
$uid = $account_list['store_target_uid'];
$sql_account_update = "UPDATE gs_account SET uid = ".$uid." WHERE id = ".$aid ;
$pdo->exec($sql_account_update);
$sql_task_update = "UPDATE gs_task SET join_status = 0 WHERE id = ".$task_id ;
$pdo->exec($sql_task_update);
}
}
}
$joinTargetObj = new joinTarget();
$joinTargetObj->joinTargetOperator();