ios开发 访问mysql_iOS开发实战-时光记账Demo 网络版

写在前面

弄了下个人站...防止内容再次被锁定...所有东西都在这里面

welcome~

个人博客

之前写了一个本地数据库版本 戳这里

现在这个就是增加了后台 登录注册页面以及web的上传记录展示页面

含有少量php有兴趣可以看下

另外demo中包括数据库操作、json、网络请求等都没有用到第三方库，所以网络方面的逻辑可能有所欠缺，大神请轻拍。

效果

效果.gif

分析

很简单的分析把大致需要编写的模块列出

服务器交互.png

客户端部分

分析

与本地版的demo相比主要是多了服务器请求操作

新增数据库内容：

Users表

与Tally表关系：一对多

user表

相反Tally与Users的关系就是：一对多

tally表

flag字段 决定是否上传

需要发送请求的位置

登录

注册

登录成功后第一次加载

新增账单

修改账单

删除账单

代码

登录

登录时向服务器发送用户名和密码，当然只有两个结果：未注册 和 密码错误

#import "LoginViewController.h"

@interface LoginViewController ()

@property (weak, nonatomic) IBOutlet UITextField *userNameField;

@property (weak, nonatomic) IBOutlet UITextField *userPswField;

@end

@implementation LoginViewController

- (void)viewDidLoad {

[super viewDidLoad];

self.title = @"登录";

[[CoreDataOperations sharedInstance] loadTallyTypeToSqlite];

// Do any additional setup after loading the view.

}

- (void)viewWillAppear:(BOOL)animated{

self.userNameField.text = [[NSUserDefaults standardUserDefaults] objectForKey:@"userName"];

self.userPswField.text = nil;

}

- (void)didReceiveMemoryWarning {

[super didReceiveMemoryWarning];

// Dispose of any resources that can be recreated.

}

//去注册

- (IBAction)clickRegister:(id)sender {

[self.userPswField resignFirstResponder];

[self.userPswField resignFirstResponder];

}

//输入检查 6-20为正常字符

- (BOOL)inputCheck:(NSString*)passWord{

NSString *passWordRegex = @"^[a-zA-Z0-9]{6,20}+$";

NSPredicate *passWordPredicate = [NSPredicate predicateWithFormat:@"SELF MATCHES %@",passWordRegex];

return [passWordPredicate evaluateWithObject:passWord];

}

//去登录

- (IBAction)clickLogin:(id)sender {

//输入检查

BOOL userNameCheck = [self inputCheck:self.userNameField.text];

BOOL userPswCheck = [self inputCheck:self.userPswField.text];

if (!userNameCheck | !userPswCheck) {

[self showAlertInfoWithTag:999 andMessage:@"用户名或密码出错\n请输入6-20位合法字符"];

return;

}

//键盘收起

[self.userPswField resignFirstResponder];

[self.userNameField resignFirstResponder];

ServerOperations *op = [ServerOperations sharedInstance];

op.delegate = self;

[op loginWithUser:self.userNameField.text andPsw:self.userPswField.text];

}

//登录结果

- (void)didLoginBackWithTag:(int)tag{

[self loginAlertWithReslut:tag];

}

//验证登录

- (void)loginAlertWithReslut:(int)result{

switch (result) {

case 0:

//连接远程数据库失败

[self showAlertInfoWithTag:result andMessage:@"连接远程数据库失败"];

break;

case 1:

//验证成功

[self performSegueWithIdentifier:@"toHome" sender:nil];

break;

case 2:

//密码错误

[self showAlertInfoWithTag:result andMessage:@"密码错误"];

break;

case 3:

//用户不存在

[self showAlertInfoWithTag:result andMessage:@"用户名不存在\n请注册"];

break;

default:

break;

}

}

//弹出提示框

- (void)showAlertInfoWithTag:(int)tag andMessage:(NSString*)message {

UIAlertController *alertVC =[UIAlertController alertControllerWithTitle:@"提示" message:message preferredStyle:UIAlertControllerStyleAlert];

[alertVC addAction:[UIAlertAction actionWithTitle:@"确定" style:UIAlertActionStyleDefault handler:nil]];

if (tag == 3) {

[alertVC addAction:[UIAlertAction actionWithTitle:@"注册" style:UIAlertActionStyleDefault handler:^(UIAlertAction * _Nonnull action) {

[self performSegueWithIdentifier:@"toRegister" sender:nil];

}]];

}

[self presentViewController:alertVC animated:YES completion:nil];

}

-(void)prepareForSegue:(UIStoryboardSegue *)segue sender:(id)sender{

NSLog(@"准备push");

//本地保存用户名

[[NSUserDefaults standardUserDefaults] setBool:NO forKey:@"isLoaded"];

[[NSUserDefaults standardUserDefaults] setObject:self.userNameField.text forKey:@"userName"];

}

@end

注册

注册也很简单，发送注册信息给服务器，服务器判断下用户名是否存在就行。

#import "RegisterViewController.h"

@interface RegisterViewController ()

@property (weak, nonatomic) IBOutlet UITextField *userNameField;

@property (weak, nonatomic) IBOutlet UITextField *userPswField;

@end

@implementation RegisterViewController

- (void)viewDidLoad {

[super viewDidLoad];

self.title = @"注册";

}

- (void)didReceiveMemoryWarning {

[super didReceiveMemoryWarning];

// Dispose of any resources that can be recreated.

}

//输入检查 6-20为正常字符

- (BOOL)inputCheck:(NSString*)passWord{

NSString *passWordRegex = @"^[a-zA-Z0-9]{6,20}+$";

NSPredicate *passWordPredicate = [NSPredicate predicateWithFormat:@"SELF MATCHES %@",passWordRegex];

return [passWordPredicate evaluateWithObject:passWord];

}

- (void)didRegisterBackWithTag:(int)tag{

[self loginAlertWithReslut:tag];

}

//提交注册

- (IBAction)clickRegister:(id)sender {

//输入检查

BOOL userNameCheck = [self inputCheck:self.userNameField.text];

BOOL userPswCheck = [self inputCheck:self.userPswField.text];

if (!userNameCheck | !userPswCheck) {

[self showAlertInfoWithTag:0 andMessage:@"用户名或密码出错\n请输入6-20位合法字符"];

return;

}

//取消键盘响应

[self.userNameField resignFirstResponder];

[self.userPswField resignFirstResponder];

ServerOperations *ops = [ServerOperations sharedInstance];

ops.delegate = self;

[ops registerWithUser:self.userNameField.text andPsw:self.userPswField.text];

}

//登录提示

- (void)loginAlertWithReslut:(int)result{

switch (result) {

case 0:

//连接远程数据库失败

[self showAlertInfoWithTag:0 andMessage:@"连接远程数据库失败"];

break;

case 1:

//注册成功

[self showAlertInfoWithTag:1 andMessage:@"注册成功"];

break;

case 2:

//注册失败 用户已经存在

[self showAlertInfoWithTag:2 andMessage:@"注册失败\n用户已经存在"];

break;

default:

break;

}

}

//弹出提示框

- (void)showAlertInfoWithTag:(int)tag andMessage:(NSString*)message {

UIAlertController *alertVC =[UIAlertController alertControllerWithTitle:@"提示" message:message preferredStyle:UIAlertControllerStyleAlert];

if (tag == 1) {

[alertVC addAction:[UIAlertAction actionWithTitle:@"确定" style:UIAlertActionStyleDefault handler:^(UIAlertAction * _Nonnull action) {

[[NSUserDefaults standardUserDefaults] setObject:self.userNameField.text forKey:@"userName"];

[self.navigationController popViewControllerAnimated:YES];

}]];

}else{

[alertVC addAction:[UIAlertAction actionWithTitle:@"确定" style:UIAlertActionStyleDefault handler:nil]];

}

[self presentViewController:alertVC animated:YES completion:nil];

}

@end

向服务器发送的请求操作

整个操作写成一个单例

#import

#import "CoreDataOperations.h"

//服务器地址

//static NSString* const kServerUrl = @"http://localhost/timetally/";

static NSString* const kServerUrl = @"http://timetallydemo.duapp.com/";

@protocol ServerOperationsDelegate

@optional

//登录结果回调

- (void)didLoginBackWithTag:(int)tag;

//注册结果回调

- (void)didRegisterBackWithTag:(int)tag;

//成功上传

- (void)didUploadTallySuccessed;

//上传失败

- (void)didUploadTallyFaild;

@end

@interface ServerOperations : NSObject

@property(nonatomic,strong)id delegate;

+ (instancetype)sharedInstance;

//发送服务器请求加载数据

- (void)loadDataFormServer;

//上传账单至服务器

- (void)uploadTallyToServer;

//服务器删除指定账单

- (void)deleteTallyInServerWithIdentity:(NSString*)identity;

//登录到服务器

- (void)loginWithUser:(NSString*)username andPsw:(NSString*)psw;

//注册到服务器

- (void)registerWithUser:(NSString*)username andPsw:(NSString*)psw;

@end

#import "ServerOperations.h"

@implementation ServerOperations

static ServerOperations *instance = nil;

+ (instancetype)sharedInstance

{

return [[ServerOperations alloc] init];

}

+ (instancetype)allocWithZone:(struct _NSZone *)zone

{

static dispatch_once_t onceToken;

dispatch_once(&onceToken, ^{

instance = [super allocWithZone:zone];

});

return instance;

}

- (instancetype)init

{

static dispatch_once_t onceToken;

dispatch_once(&onceToken, ^{

instance = [super init];

});

return instance;

}

//发送服务器请求加载数据

- (void)loadDataFormServer{

NSMutableURLRequest *quest = [NSMutableURLRequest requestWithURL:[NSURL URLWithString:[kServerUrl stringByAppendingString:@"showusertally.php"]]];

[quest setHTTPMethod:@"POST"];

//POST 用户名

NSString *userName = [[NSUserDefaults standardUserDefaults] objectForKey:@"userName"];

NSDictionary *dict = [[NSDictionary alloc] initWithObjectsAndKeys:userName,@"username", nil];

NSData *postData = [NSJSONSerialization dataWithJSONObject:dict options:NSJSONWritingPrettyPrinted error:nil];

[quest setHTTPBody:postData];

NSURLSession *session = [NSURLSession sharedSession];

NSURLSessionTask *task = [session dataTaskWithRequest:quest completionHandler:^(NSData * _Nullable data, NSURLResponse * _Nullable response, NSError * _Nullable error) {

//json解码

NSString *dataStr = [[NSString alloc] initWithData:data encoding:NSUTF8StringEncoding];

NSLog(@"server下载结果-----%@",dataStr);

if ([dataStr isEqualToString:@"0"]) {

return ;

}

NSArray *jsonArray = [NSJSONSerialization JSONObjectWithData:data options:NSJSONReadingAllowFragments error:nil];

if (jsonArray.count != 0) {

[[CoreDataOperations sharedInstance] loadFromServerWithDataArray:jsonArray];

}

}];

[task resume];

}

//上传账单至服务器

- (void)uploadTallyToServer{

NSMutableURLRequest *quest = [NSMutableURLRequest requestWithURL:[NSURL URLWithString:[kServerUrl stringByAppendingString:@"uploadtally.php"]]];

[quest setHTTPMethod:@"POST"];

//POST 信息

NSArray *postArray = [[CoreDataOperations sharedInstance] getAllTallyWithArray];

NSData *postData = [NSJSONSerialization dataWithJSONObject:postArray options:NSJSONWritingPrettyPrinted error:nil];

[quest setHTTPBody:postData];

NSURLSession *session = [NSURLSession sharedSession];

NSURLSessionTask *task = [session dataTaskWithRequest:quest completionHandler:^(NSData * _Nullable data, NSURLResponse * _Nullable response, NSError * _Nullable error) {

int flag = [[[NSString alloc] initWithData:data encoding:NSUTF8StringEncoding] intValue];

NSLog(@"server上传结果 %d",flag);

if (flag==1 || flag == 9) {

//写入成功

for (NSDictionary *dict in postArray) {

[[CoreDataOperations sharedInstance] uploadServerSucceedWithIdentity:dict[@"identity"]];

}

dispatch_async(dispatch_get_main_queue(), ^{

if ([self.delegate respondsToSelector:@selector(didUploadTallySuccessed)]) {

[self.delegate didUploadTallySuccessed];

}

});

}else{

dispatch_async(dispatch_get_main_queue(), ^{

if ([self.delegate respondsToSelector:@selector(didUploadTallyFaild)]) {

[self.delegate didUploadTallyFaild];

}

});

}

}];

[task resume];

}

//登录到服务器

- (void)loginWithUser:(NSString*)username andPsw:(NSString*)psw {

//创建URL请求

NSMutableURLRequest *quest = [NSMutableURLRequest requestWithURL:[NSURL URLWithString:[kServerUrl stringByAppendingString:@"login.php"]]];

//post请求

[quest setHTTPMethod:@"POST"];

NSDictionary *dict = [[NSDictionary alloc] initWithObjectsAndKeys:username,@"username",psw,@"userpsw", nil];

//字典转json

NSData *postData = [NSJSONSerialization dataWithJSONObject:dict options:NSJSONWritingPrettyPrinted error:nil];

[quest setHTTPBody:postData];

//建立连接

NSURLSession *session = [NSURLSession sharedSession];

NSURLSessionTask *task = [session dataTaskWithRequest:quest completionHandler:^(NSData * _Nullable data, NSURLResponse * _Nullable response, NSError * _Nullable error) {

int result = [[[NSString alloc] initWithData:data encoding:NSUTF8StringEncoding] intValue];

NSLog(@"server登录结果 %d ",result);

dispatch_async(dispatch_get_main_queue(), ^{

if ([self.delegate respondsToSelector:@selector(didLoginBackWithTag:)]) {

[self.delegate didLoginBackWithTag:result];

}

});

}];

[task resume];

}

//注册到服务器

- (void)registerWithUser:(NSString*)username andPsw:(NSString*)psw{

//创建URL请求

NSMutableURLRequest *quest = [NSMutableURLRequest requestWithURL:[NSURL URLWithString:[kServerUrl stringByAppendingString:@"register.php"]]];

//post请求

[quest setHTTPMethod:@"POST"];

NSDictionary *dict = [[NSDictionary alloc] initWithObjectsAndKeys:username,@"username",psw,@"userpsw", nil];

//字典转json

NSData *postData = [NSJSONSerialization dataWithJSONObject:dict options:NSJSONWritingPrettyPrinted error:nil];

[quest setHTTPBody:postData];

//建立连接

NSURLSession *session = [NSURLSession sharedSession];

NSURLSessionTask *task = [session dataTaskWithRequest:quest completionHandler:^(NSData * _Nullable data, NSURLResponse * _Nullable response, NSError * _Nullable error) {

int result = [[[NSString alloc] initWithData:data encoding:NSUTF8StringEncoding] intValue];

NSLog(@"server注册结果 %d ",result);

//回到主线程

dispatch_async(dispatch_get_main_queue(), ^{

if ([self.delegate respondsToSelector:@selector(didRegisterBackWithTag:)]) {

[self.delegate didRegisterBackWithTag:result];

}

});

}];

[task resume];

}

//从服务器删除账单

- (void)deleteTallyInServerWithIdentity:(NSString*)identity{

//创建URL请求

NSMutableURLRequest *quest = [NSMutableURLRequest requestWithURL:[NSURL URLWithString:[kServerUrl stringByAppendingString:@"deletetally.php"]]];

//post请求

[quest setHTTPMethod:@"POST"];

NSDictionary *dict = [[NSDictionary alloc] initWithObjectsAndKeys:identity,@"identity", nil];

//字典转json

NSData *postData = [NSJSONSerialization dataWithJSONObject:dict options:NSJSONWritingPrettyPrinted error:nil];

[quest setHTTPBody:postData];

//建立连接

NSURLSession *session = [NSURLSession sharedSession];

NSURLSessionTask *task = [session dataTaskWithRequest:quest completionHandler:^(NSData * _Nullable data, NSURLResponse * _Nullable response, NSError * _Nullable error) {

int result = [[[NSString alloc] initWithData:data encoding:NSUTF8StringEncoding] intValue];

if (result == 0) {

NSLog(@"%d server链接数据库失败",result);

}else if (result == 1){

NSLog(@"%d server删除账单成功",result);

}else if (result == 2){

NSLog(@"%d server删除账单失败",result);

}

}];

[task resume];

}

@end

服务端部分

php新手 高手勿喷

文件结构

文件结构

其中index.php 和 useruploadrecords.php是web断的登录展示页面

数据库部分字段和表基本与客户端相同可以看CREATE的代码

代码

配置文件

define('MYSQL_HOST','localhost');

define('MYSQL_USER','root');

define('MYSQL_PSW','');

define('MYSQL_DBNAME','TimeTally');

所有数据库操作

require_once 'config.php';

/**链接并选择数据表

* @param $table 链接表

* @return mysqli 链接link

*/

function connectDBandSelectTable($table) {

$con = mysqli_connect(MYSQL_HOST,MYSQL_USER,MYSQL_PSW);

mysqli_set_charset($con,'utf8');

if ($con){

mysqli_select_db($con,MYSQL_DBNAME);

if(mysqli_num_rows(mysqli_query($con,"SHOW TABLES LIKE '".$table."'"))==0) {

if ($table == 'Tally'){

$sql = "CREATE TABLE $table

( id INT NOT NULL AUTO_INCREMENT ,

username VARCHAR(50) NOT NULL ,

date VARCHAR(50) NOT NULL ,

identity VARCHAR(1024) NOT NULL ,

typename VARCHAR(50) NOT NULL ,

income DOUBLE NOT NULL ,

expenses DOUBLE NOT NULL ,

timestamp DOUBLE NOT NULL ,

uploadtime TIMESTAMP NOT NULL,

PRIMARY KEY (id))";

mysqli_query($con,$sql);

}elseif ($table == 'Users'){

$sql = "CREATE TABLE $table

(id INT NOT NULL AUTO_INCREMENT,

username VARCHAR (100) NOT NULL ,

userpsw VARCHAR (100) NOT NULL ,

session INT NOT NULL DEFAULT 0,

PRIMARY KEY (id))";

mysqli_query($con,$sql);

}

}

}

return $con;

}

/**注册

* @param $table 表

* @param $username 用户名

* @param $userpsw 用户密码

* @return int 0:连接失败 1:注册成功 2:用户已存在

*/

function register($table,$username,$userpsw){

$con = connectDBandSelectTable($table);

if ($con){

$isExist = existQuery($table,"username",$username);

if ($isExist == 2){

$sql = "INSERT INTO $table (username, userpsw) VALUES ('$username',MD5('$userpsw'))";

$result = mysqli_query($con,$sql);

if ($result){

//成功

return 1;

}

}else if ($isExist == 1){

//已存在

return 2;

}

//关闭数据库

mysqli_close($con);

}

//连接数据库失败

return 0;

}

/**查询字段是否存在

* @param $table 表名

* @param $field 查询字段名

* @param $obj 查询对象

* @return 0:连接失败 1:存在 2:不存在

*/

function existQuery($table,$field,$obj){

$con = connectDBandSelectTable($table);

if ($con){

$sql = "SELECT * FROM $table WHERE $field = '$obj'";

$result = mysqli_query($con,$sql);

if (mysqli_num_rows($result) > 0){

return 1;

}else{

return 2;

}

}

return 0;

}

/**获取该用户下所有账单

* @param $table 表名

* @param $user 用户名

* @return int|string 0:连接失败或无法查询 string:json数组;

*/

function getUserTally($table,$user){

$con = connectDBandSelectTable($table);

if ($con){

$sql = "SELECT * FROM $table WHERE username = '$user'";

$arr = mysqli_query($con,$sql);

$num = mysqli_num_rows($arr);

if ($num > 0){

for ($i=0;$i

$results[] = mysqli_fetch_assoc($arr);

}

mysqli_close($con);

return json_encode($results);

}

}

//连接失败或无法查询

return 0;

}

/**登录验证

* @param $username 用户名

* @param $userpsw 用户密码

* @return int 0:连接失败 1:验证成功 2:密码错误 3:用户不存在

*/

function verifyLogin($username,$userpsw){

//查询用户名是否存在

$table = 'Users';

$con = connectDBandSelectTable($table);

if ($con){

$sql = "SELECT * FROM $table WHERE username = '$username'";

$isExist = mysqli_query($con,$sql);

if (mysqli_num_rows($isExist) > 0) {

//存在并继续验证 密码

$result = mysqli_fetch_array($isExist);

$psw = $result['userpsw'];

if (md5($userpsw) == $psw){

//密码正确

return 1;

}else {

//密码错误

return 2;

}

}else {

//用户不存在

return 3;

}

mysqli_close($con);

}

//数据库连接失败

return 0;

}

/**上传更新或新增账单数据

* @param $table 写入表名

* @param $tallyJson 传入解析后的json

* @return int -1:数据库连接失败 0:没有写入 1:写入成功 2:写入失败 9:更新数据

*/

function uploadTally($table,$tallyJson){

$con = connectDBandSelectTable($table);

$r = 0;

if ($con){

//根据json解析出来的数组的长度 更新对应identity数值

for ($i=0;$i

$identity = $tallyJson[$i]->identity;

$isExistSql = "SELECT * FROM $table WHERE identity LIKE '$identity'";

$isExisResult = mysqli_query($con,$isExistSql);

if (mysqli_num_rows($isExisResult) > 0){

$typename = $tallyJson[$i]->typename;

$income = $tallyJson[$i]->income;

$expenses = $tallyJson[$i]->expenses;

$timestamp = $tallyJson[$i]->timestamp;

$updateSql = "UPDATE $table

SET typename = '$typename',

income='$income' ,

expenses = '$expenses',

uploadtime = CURRENT_TIMESTAMP,

timestamp = '$timestamp'

WHERE identity = '$identity'";

mysqli_query($con,$updateSql);

$r = 9;

} else{

//没有查询到identity则进入新增

$typename = $tallyJson[$i]->typename;

$income = $tallyJson[$i]->income;

$expenses = $tallyJson[$i]->expenses;

$username = $tallyJson[$i]->username;

$date = $tallyJson[$i]->date;

$timestamp = $tallyJson[$i]->timestamp;

//mysql插入

$intoSql = "INSERT INTO $table

(id,username,date,identity,typename,income,expenses,timestamp,uploadtime)

VALUES (NULL, '$username', '$date','$identity','$typename','$income','$expenses','$timestamp',CURRENT_TIMESTAMP)";

$insertResult = mysqli_query($con,$intoSql);

if ($insertResult){

//新增成功

$r = 1;

}else{

//新增失败

$r = 2;

}

}

}

mysqli_close($con);

}else{

//连接失败

$r = -1;

}

return $r;

}

/**

* @param $table 表名

* @param $identity 需要删除的标识

* @return int 0:链接数据库失败 1:删除成功 2:删除失败

*/

function deleteTally($table,$identity){

$con = connectDBandSelectTable($table);

if ($con){

$sql = "DELETE FROM $table WHERE identity = '$identity'";

$result = mysqli_query($con,$sql);

if ($result){

return 1;

}else{

return 2;

}

}

mysqli_close($con);

return 0;

}

/**获取post的json数据 并连接数据库表

* @param $table 表名

* @return mixed json数据

*/

function getPostJsonValue($table){

//获取post数据

$postValue = file_get_contents("php://input");

//json解析

$postJson = json_decode($postValue);

$currentTable = $table;

//连接并选择数据库

connectDBandSelectTable($currentTable);

return $postJson;

}

各个调用页面

登录

require_once 'dboperations.php';

//获取post数据

$table = 'Users';

$postValue = getPostJsonValue($table);

//登录验证

$result = verifyLogin($postValue->username,$postValue->userpsw);

echo $result;

注册

require_once 'dboperations.php';

//获取post数据并连接数据库表

$currentTable = 'Users';

$postJson = getPostJsonValue($currentTable);

//注册

$result = register($currentTable,$postJson->username,$postJson->userpsw);

echo $result;

下载服务端数据

require_once 'dboperations.php';

$table = 'Tally';

$postValue = getPostJsonValue($table);

$reslut = getUserTally($table,$postValue->username);

echo $reslut;

上传

require_once 'dboperations.php';

$table = 'Tally';

$postJson = getPostJsonValue($table);

$result = uploadTally($table,$postJson);

echo $result;

删除

require_once 'dboperations.php';

$table = 'Tally';

$postValue = getPostJsonValue($table);

$reslut = deleteTally($table,$postValue->identity);

echo $reslut;

web端

首页登录

content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">

Document

内容页

content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">

Document

require_once 'dboperations.php';

if (isset($_GET["username"]) && isset($_GET["userpsw"])){

$username = $_GET["username"];

$userpsw = $_GET["userpsw"];

}

$verifty = verifyLogin($username,$userpsw);

if ($verifty == 1){

$table = 'Tally';

$con = connectDBandSelectTable($table);

$sql = "SELECT * FROM $table WHERE username = '$username' ORDER BY uploadtime DESC ";

$res = mysqli_query($con,$sql);

echo "

欢迎用户:$username
操作记录	上传时间	账单类型	支出	收入

for ($i=0;$i

$resarray = mysqli_fetch_assoc($res);

$uploadtime = $resarray["uploadtime"];

$typename = $resarray["typename"];

$income= $resarray["income"];

$expenses = $resarray["expenses"];

?>

}

echo "

";

}elseif ($verifty == 2){

echo "";

}elseif ($verifty == 3){

echo "";

}

?>

Demo地址

github

简书主页