<?php
$servername = "localhost";
$username = "root";
$password = "root123";
$dbname = "mygame";
// connect database
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
die("Connection failed");
}
// get POST data
$name = $_POST["name"];
$email = $_POST["email"];
$pass = $_POST["password"];
$age = $_POST["age"];
/* $name = "jjk";
$email = "jjk@gmail.com";
$pass = "1234";
$age = 14; */
// insert data
//INSERT INTO userprofile(userId, name, email, age, password, dateJoin) VALUES ('','hhh','hhh@gmail.com',12,'1234','2025-03-04');
//$sql = "INSERT INTO users (username, password) VALUES ('$user', '$pass')";
$sql = "INSERT INTO userprofile(userId, name, email, age, password, dateJoin) VALUES ('','$name','$email',$age,'$pass','2025-03-04')";
//echo $sql;
if ($conn->query($sql) === TRUE) {
echo "Register Success";
} else {
echo "Register Failed";
}
$conn->close();
?>
unity c sharp sample code
using System.Collections;
using UnityEngine;
using UnityEngine.Networking;
using TMPro;
public class Register : MonoBehaviour
{
public TMP_InputField[] registerIF;
string url = "http://localhost/register.php";
public void registerSubmit()
{
string name = registerIF[0].text;
string email = registerIF[1].text;
string pass = registerIF[2].text;
int age = int.Parse(registerIF[3].text);
SendData(name, email, pass, age);
}
public void SendData(string username, string email, string password, int age)
{
StartCoroutine(RegisterUser(username, email, password, age));
}
IEnumerator RegisterUser(string user, string email, string pass, int age)
{
WWWForm form = new WWWForm();
form.AddField("name", user);
form.AddField("email", email);
form.AddField("password", pass);
form.AddField("age", age);
UnityWebRequest www = UnityWebRequest.Post(url, form);
yield return www.SendWebRequest();
if (www.result != UnityWebRequest.Result.Success)
{
Debug.Log("Error: " + www.error);
}
else
{
Debug.Log("Server Response: " + www.downloadHandler.text);
}
}
}