通过.NET连接到android studio中的SQL [英] Connectivity via .NET to SQL in android studio

查看:193
本文介绍了通过.NET连接到android studio中的SQL的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

如何在android studio的.NET帮助下将我的android项目与SQL服务器连接起来。

i需要一些帮助才能在.net到SQL服务器上建立连接API或Web服务。 />


我尝试过:



how i connect my android project with SQL server with the help of .NET in android studio.
i need some help in making of connectivity API or web services in .net to SQL server.

What I have tried:

$servername = "localhost";
$username = "root";
$password = "";
$dbname = "XYZ";

$user=$_REQUEST["username"];
$mobile=$_REQUEST["mobile"];
$email=$_REQUEST["email"];
$city=$_REQUEST["city"];
$gender=$_REQUEST["gender"];
 
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 

$sql = "INSERT INTO tablename (username, mobile,email,city,gender)VALUES ('$user', '$mobile', '$email', '$city', '$gender')";

if ($conn->query($sql) === TRUE) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();
?>

推荐答案

servername =localhost;
servername = "localhost";


username = root;
username = "root";


password =;
password = "";


这篇关于通过.NET连接到android studio中的SQL的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆