c# - Making a Game in Unity for android with an offline mySQL database -


im making trivia , @ end has 5 inputfields user data such name, last name, phone, document number , email. , did database mysql , phpmyadmin store data. when build windows works fine have build android tablet, cant manage data base working, glad if can me!

this c# unity script database management:

using system.collections; using unityengine.ui; using unityengine;  public class gestorbd : monobehaviour {  public inputfield txtnombre; public inputfield txtapellido; public inputfield txtci; public inputfield txttel; public inputfield txtmail;  public string nombrenombre; public string apellidoapellido; public int cici; public int tel; public string mail;  public bool sesioniniciada = false;  /// respuestas web ///  /// 200 = datos encontrados  /// 201 = usuario registrado ///  /// 400 = no pudo establecer coneccion /// 401 = no enconto datos /// 402 = el usuario ya existe    public void iniciarsesion() {     startcoroutine(login());     startcoroutine(datos()); } public void registrarnombre() {     startcoroutine(registrar()); }  ienumerator login() {     www coneccion = new www("http://127.0.0.1/trivia/login.php?nom=" +  txtnombre.text + "&ape=" + txtapellido.text + "&ci=" + txtci.text + "&tel="  + txttel.text + "&mai=" + txtmail);     yield return (coneccion);     if (coneccion.text == "200")     {         print("el usuario si existe");     }     else if (coneccion.text == "401")     {         print("usuario o contrasena incorrectos");     }     else     {         print("error en la coneccion con la base de datos");     } }  ienumerator datos() {     www coneccion = new www("http://127.0.0.1/trivia/datos.php?nom=" +  txtnombre.text + "&ape=" + txtapellido.text + "&ci=" + txtci.text + "&tel="  + txttel.text + "&mai=" + txtmail);     yield return (coneccion);     if (coneccion.text == "401")     {         print("usuario o contrasena incorrectos");     }     else     {         string[] ndatos = coneccion.text.split('^');         if (ndatos.length != 2)         {             print("error en la coneccion");         }         else         {             nombrenombre = ndatos[0];             apellidoapellido = ndatos[1];             cici = int.parse(ndatos[2]);             tel = int.parse(ndatos[3]);             mail = ndatos[4];             sesioniniciada = true;         }     } }  ienumerator registrar() {     www coneccion = new www("http://127.0.0.1/trivia/registro.php?nom=" +  txtnombre.text + "&ape=" + txtapellido.text + "&ci=" + txtci.text + "&tel="  + txttel.text + "&mai=" + txtmail.text);     yield return (coneccion);     if (coneccion.text == "402")         debug.logerror("usuario ya existe!");      else if (coneccion.text == "201")     {         nombrenombre = txtnombre.text;         apellidoapellido = txtapellido.text;         sesioniniciada = true;      }     else     {         debug.logerror("error en la coneccion con la base de datos");     }    }   }

and php file login:

<?php  $servidor  = 'localhost'; $user      = 'root'; $password  = ''; $basedatos = 'trivia';  $conexion = new mysqli($servidor, $user, $password, $basedatos);  $nom      = $_get['nom']; $ape      = $_get['ape']; $ci       = $_get['ci']; $tel      = $_get['tel']; $mai     = $_get['mai'];  if (!$conexion) {      echo "error"; } else {     $sql  = "select * usuarios nombre '$nom' , apellido      '$ape' , ci '$ci' , tel '$tel' , mail '$mai'";     $resultado = mysqli_query($conexion, $sql);     if (mysqli_num_rows($resultado)>0)     {       echo "bien";     }     else     {        echo "mal";     }   }  ?>

my php file data:

<?php  $servidor  = 'localhost'; $user      = 'root'; $password  = ''; $basedatos = 'trivia';  $conexion = new mysqli($servidor, $user, $password, $basedatos);  $nom      = $_get['nom'];  if (!$conexion) {     echo "400"; } else {      $sql  = "select * usuarios nombre '$nom'";      $resultado = mysqli_query($conexion, $sql);      if (mysqli_num_rows($resultado)>0)      {       while ($row = mysqli_fetch_assoc($resultado)){         echo    $row['nombre']."^".$row['apellido']."^".$row['ci']."^".$row['tel']  ."^".$row['mail'];       }     }     else     {        echo "401";     }   }  ?>

and php file register:

<?php  $servidor  = 'localhost'; $user      = 'root'; $password  = ''; $basedatos = 'trivia';  $conexion = new mysqli($servidor, $user, $password, $basedatos);  $nom      = $_get['nom']; $ape      = $_get['ape']; $ci       = $_get['ci']; $tel      = $_get['tel']; $mai      = $_get['mai'];  if (!$conexion) {      echo "400"; } else {      $sql  = "select * usuarios ci '$ci'";       $resultado = mysqli_query($conexion, $sql);      if (mysqli_num_rows($resultado)>0)      {        echo "402";      }      else      {        $sql  = "insert usuarios (id, nombre, apellido, ci, tel, mail)  values (null, '$nom', '$ape', '$ci', '$tel', '$mai')";        $resultado = mysqli_query($conexion, $sql);        echo "201";      }    }  ?>

thanks!

localhost not work in android there's no local server set in pc. if want store in local database, you'll need use sqlite(https://www.sqlite.org). there's free asset in assetstore sqlite: https://www.assetstore.unity3d.com/en/#!/content/20660

for remote server, using actual server credentials make work.


Comments

Post a Comment

Popular posts from this blog

What is happening when Matlab is starting a "parallel pool"? -

running parallel cpu processes in matlab starts command parpool() according documentation , function: [creates] special job on pool of workers, , [connects] matlab client parallel pool. this function takes bit of time execute, on order of 30 seconds. in other multi-cpu paradigms openmp, parallel execution seems totally transparent -- i've never noticed behavior analogous matlab (granted i'm not experienced parallel programming). so, happening between time parpool() called , when finishes executing? takes long? parallel computing toolbox enables run matlab code in parallel using several different paradigms (e.g. jobs , tasks, parfor , spmd , parfeval , batch processing), , run either locally (parallelised across cores in local machine) or remotely (parallelised across machines in cluster - either 1 own, or 1 in cloud). in of these cases, code run on matlab workers , copies of matlab without interactive desktop. if you're intending run on remo...
Read more

angular - DownloadURL return null in below code -

when change file updated in firebase storage when try downloadurl show null. filechange(event: any) { const imagefolder: string = this.employee.id; const filelist: filelist = event.target.files; const file: file = filelist[0]; const storageref = firebase.storage().ref().child(`${imagefolder}/profile.jpg`).put(file); console.log(storageref.snapshot.downloadurl); } the put() asynchronous. if want url after file uploaded have this: firebase.storage().ref().child(`${imagefolder}/profile.jpg`).put(file).then((snapshot) => { storageref = snapshot.downloadurl: console.log(snapshot.downloadurl); });
Read more

php - Cannot override Laravel Spark authentication with own implementation -

during login process of laravel spark need request token of remote api. api stores exact same users , passwords laravel spark application. therefore need username , non hashed password of user during authentication process. i thought overriding authenticated method solution problem. in routes/web.php override post /login endpoint , pointing endpoint own logincontroller: <?php namespace app\http\controllers\auth; use illuminate\support\facades\log; use illuminate\http\request; use laravel\spark\http\controllers\auth\logincontroller sparklogincontroller; class logincontroller extends sparklogincontroller { /** * create new login controller instance. * * @return void */ public function __construct() { parent::__construct(); } /** * handle successful authentication attempt. * * @param request $request * @param \illuminate\contracts\auth\authenticatable $user * @return response */ public fu...
Read more