gpt4 book ai didi

ios - 我想将我的 mySQL 数据库连接到我的 xcode 项目

转载 作者:太空宇宙 更新时间:2023-11-03 11:39:06 25 4
gpt4 key购买 nike

<分区>

我正在尝试将我的 mysql 数据库连接到我的 xcode 项目,以获得一个简单的登录 View ,用户可以在其中输入他们的用户名和密码。我已经设置了数据库,但我需要使用 JSON 还是?

 <?php

// Create connection
$con=mysqli_connect("localhost","username","password","dbname");



// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

// This SQL statement selects ALL from the table 'Locations'
$sql = "SELECT * FROM Locations";

// Check if there are results
if ($result = mysqli_query($con, $sql))
{
// If so, then create a results array and a temporary one
// to hold the data
$resultArray = array();
$tempArray = array();

// Loop through each row in the result set
while($row = $result->fetch_object())
{
// Add each row into our results array
$tempArray = $row;
array_push($resultArray, $tempArray);
}

// Finally, encode the array to JSON and output the results
echo json_encode($resultArray);
}

// Close connections
mysqli_close($con);
?>

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com