php - 如何管理团队更新 id，其他表上字段 id

问题描述

总结问题

使用 username = user 登录后，我想通过向数据发送 user id = id, username = update 来更新 tb_user 表中的 id_team 字段。

通过发送 id user = id, username = user。从团队管理页面。但团队管理来自 tb_team 表。tb_team 表没有数据，id user = id，username = user。用于更新

如何获取或保留会话 id user = id, username = user 以供在条件下使用，更新，我想要关于这个问题的建议。

提供背景，包括您已经尝试过的内容

var saveidUser: String?
saveidUser  = ????   <——  I do not know how to send the  id, username

显示一些代码 PHP 代码：

//Web Service
if (isset($_GET)) {
    if ($_GET['isAdd'] == 'true') {
        $idTeam = $_GET['idteam'];
        $idUser = $_GET['iduser']
        $User = $_GET['username'];

        UPDATE `tb_user` SET `id_team` = '$idTeam' WHERE `id` = '$iduser' and `username` = '$user'
        $result = mysqli_query($sql) or die mysql_error();
        if ($result) {
          echo $idTeam;
        } else {
          echo "False";
        }
    } 
    else echo "Welcome";
}

SWIFT代码：

//swift code constant
class Myconstant {
    func findURLSaveidTeam(idTeam: String, idUser: String) -> String {
        let urlGetidTeam = "http://www.test.com/myWebService/updateidTeam.php?isAdd=true&idteam=\(idTeam)&iduser=\(idUser)"
        return urlGetidTeam
    }
}//My Constant

//swift code view controller management team
class getAllTeamViewController: UIViewController {
    var selectValue: String?
    var saveidTeam: String?
    var saveidUser: String?  <— for id, username

    @IBOutlet weak var hiddenidTeamTextField: UITextField!
    @IBOutlet weak var showSelectValuePickerView: UITextField!

    func saveValue(idteam: String, iduser: String ) -> Void {
        let myconstant_idTeam = Myconstant()
        let urlSaveData: String = myconstant_idTeam.findURLSaveidTeam(idTeam: idteam, idUser: iduser)
        print("urlSaveData ==>\(urlSaveData)")
        //Save Value Process
        let url = URL(string: urlSaveData)!
        let request = NSMutableURLRequest(url: url) 
        let task = URLSession.shared.dataTask(with: request as URLRequest){ data,response, error in
            //Check nil value
            if error != nil {
                print("Error! Have nil value")
            }else{
                //Receive Value
                if let responseData = data {
                    let canReadData = NSString(data: responseData, encoding: String.Encoding.utf8.rawValue)
                    print("Can Read Data ==> \(String(describing: canReadData))")

                    //Show alert save success or failed upload to database on log panel
                    let myResponse = canReadData
                    if((myResponse) != nil){
                      print("Save Success")
                    }else{
                      print("Cannot Upload")
                    }//if
                }//if
            }//if
        }//End task
        task.resume()
    }//saveValue

    //Save Button
    @IBAction func SavevaluePicker(_ sender: UIButton) {
        selectValue = showSelectValuePickerView.text
        saveidTeam = hiddenidTeamTextField.text
        saveidUser  = ????   <——  I do not know how to send the  id,username

        //Call use function checkSpace
        if(checkSpace(picker: selectValue!)){
            print("Have Space")
        }else{
            print("No Space")
            //Call function Save data to database
            saveValue(idteam: saveidTeam!, iduser: saveidUser!)
        }//if
    }// SavevaluePicker
}//Main Class

描述预期和实际结果，包括显示日志面板中的任何错误消息值

     NameTeam database ==>2 - AvengersEndgame

图像团队管理页面

标签： phpswiftxcode10.2

php - 如何管理团队更新 id，其他表上字段 id_team 中的用户名

问题描述

解决方案

推荐阅读