前端之家

  1. 首页
  2. 问答

Mysqli到PHP到C＃

• 问答

所以我在c＃中有一个列表，该列表正在转换为字符串，然后在PHP中转换为二维数组，然后将其发送到MySQL数据库。现在，我要如何扭转这一状况，即可以从数据库下载到PHP，而不是c＃列表。

到目前为止，这是我要的内容，但是我不确定是否需要将数据下载回PHP中的数组，还是应该将其作为字符串下载并分解为c＃中的列表？ / p>

这是我的C＃代码： 

public List<Ship> shipList = new List<Ship>();
string shipListString = "";
WWWForm form = new WWWForm();
form.AddField("username",username);
form.AddField("shipcount",ShipInventory.Count);  
for (int i = 0; i < shipList.Count; i++)
{        
    shipListString = shipListString + " " + shipList[i].id + " '" + shipList[i].username + "' '" + shipList[i].name + "' " + shipList[i].power +
             "zzz";// + ShipInventory[i];            
}
form.AddField("shipinventory",shipListString);
WWW www = new WWW("x.x.x.x/savedata.php",form);
yield return www;

这是我的php： 

$shiparraytobesplit = $_POST["shipinventory"];
$ships =  explode("zzz",$shiparraytobesplit);
unset($ships[count($ships)-1]);

$shipinfo = array_map(function($ship) {
    $tempshipinfo = explode(" ",$ship);
    $ship_assoc = [
        "id" => $tempshipinfo[1],"name" => $tempshipinfo[2],"username" => $tempshipinfo[3],"hp" => $tempshipinfo[4]
    ];
    return $ship_assoc;
},$ships);

$sql = sprintf('INSERT INTO shipinventory (shipid,shipname,username,shippower) VALUES (%s)',implode(',',array_values($shipinfo[$i])));

if(!mysqli_query($con,$sql))
{
    echo("error description: " . mysqli_error($con));       
}

将我的c＃列表上传到数据库中的效果很好，但是我不确定从数据库中将其下载回c＃列表的最佳方法是什么。任何建议都很棒！谢谢

drtom 回答：Mysqli到PHP到C＃

好，所以我设法使其正常运行，但我想有更好的方法，请分享！谢谢：

C＃脚本：

WWW www = new WWW("x.x.x.x/loaddata.php");
        yield return www;
        stringFromPHP = www.text;

        char[] delimiterENTER = new char[] {'\n' };
        char[] delimiterSPACE = new char[] { ' ' };
        shipStringArray = stringFromPHP.Split(delimiterENTER,StringSplitOptions.RemoveEmptyEntries);        
        shipList.Clear();
        for (int i = 0; i < shipStringArray.Count(); i++)
        {
            string[] shipInfo = shipStringArray[i].Split(delimiterSPACE);                    
            shipList.Add(new Ship(Int32.Parse(shipInfo[0]),shipInfo[1],shipInfo[2],Int32.Parse(shipInfo[3]),shipStringArray[i]));            
        }

和php：

if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n",mysqli_connect_error());
    exit();
}

$query = "SELECT shipid,username,shipname,shippower FROM shipinventory";

if ($result = mysqli_query($con,$query)) {

    while ($row = mysqli_fetch_assoc($result)) {
      $stringtoexplodeincsharp  printf ("%s %s %s %s\n",(int) $row["shipid"],$row["username"],$row["shipname"],(int) $row["shippower"]);
    }

    mysqli_free_result($result);
}

mysqli_close($con);
c#multidimensional-arraymysqlphpunity3d
本文链接：https://www.f2er.com/3108579.html

大家都在问