• Products
  • Solutions
  • Made with Unity
  • Learning
  • Support & Services
  • Community
  • Asset Store
  • Get Unity

UNITY ACCOUNT

You need a Unity Account to shop in the Online and Asset Stores, participate in the Unity Community and manage your license portfolio. Login Create account
  • Blog
  • Forums
  • Answers
  • Evangelists
  • User Groups
  • Beta Program
  • Advisory Panel

Navigation

  • Home
  • Products
  • Solutions
  • Made with Unity
  • Learning
  • Support & Services
  • Community
    • Blog
    • Forums
    • Answers
    • Evangelists
    • User Groups
    • Beta Program
    • Advisory Panel

Unity account

You need a Unity Account to shop in the Online and Asset Stores, participate in the Unity Community and manage your license portfolio. Login Create account

Language

  • Chinese
  • Spanish
  • Japanese
  • Korean
  • Portuguese
  • Ask a question
  • Spaces
    • Default
    • Help Room
    • META
    • Moderators
    • Topics
    • Questions
    • Users
    • Badges
  • Home /
avatar image
0
Question by deanpackard · May 25, 2018 at 06:07 PM · phpsqldatabase

Posting to an sql database using Unity and PHP

Here is my c# code in unity

  public void addUser()
 {
     WWWForm form = new WWWForm();
     form.AddField("usernamePost", username.text);
     form.AddField("emailPost", email.text);
     form.AddField("passwordPost", password.text);

     using (UnityWebRequest www = UnityWebRequest.Post("localhost/assassin/insertUserData.php", form))
     {
         www.chunkedTransfer = false;
         test(www);
         if (www.isNetworkError || www.isHttpError)
         {
             Debug.Log(www.error);
         }
         else
         {
             Debug.Log("Form upload complete!");
         }
     }
 }
 IEnumerator test(UnityWebRequest www)
 {
     yield return www.SendWebRequest();
 }

Here is my PHP code

 <?php
 $servername = "localhost";
 $server_username = "root";
 $server_password = "root";
 $dbName = "test";
 
 $username = $_POST["usernamePost"];
 $email = $_POST["emailPost"];
 $password = $_POST["passwordPost"];
 
 //make a connection
 $connection = new mysqli($servername, $server_username, $server_password, $dbName);
 echo "hello world";
 //Check the connection
 if(!$connection)
 {
     die("Connection Failed".mysqli_connect_error());
     echo "DEAD";
 }
 
 $sql = "INSERT INTO users (username, email, age, level, lastgame, gameswon, kills, deaths, winnings, password)
 VALUES ('".$username."', '".$email."', '".$level."', '".$lastgame."', '".$gameswon."', '".$kills."', '".$deaths."', '".$winnings"', '".$password."')";
 $result = mysqli_query($connection, $sql);
 
 if(!result)
     echo "There was an error";
 else
     echo "Everything is ok";
 ?>

I get Form upload complete, but when I check my database, no new entry was added

Comment
Add comment · Show 1
10 |3000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image deanpackard · May 25, 2018 at 06:49 PM 0
Share

Bump for people to see

0 Replies

· Add your reply
  • Sort: 

Your answer

Hint: You can notify a user about this post by typing @username

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Welcome to Unity Answers

The best place to ask and answer questions about development with Unity.

To help users navigate the site we have posted a site navigation guide.

If you are a new user to Unity Answers, check out our FAQ for more information.

Make sure to check out our Knowledge Base for commonly asked Unity questions.

If you are a moderator, see our Moderator Guidelines page.

We are making improvements to UA, see the list of changes.



Follow this Question

Answers Answers and Comments

82 People are following this question.

avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image

Related Questions

Smart way of using servers and databases in unity 0 Answers

When built for web player, my php doesn't return the datatable. Works just fine in standalone build and while editing. 1 Answer

Sending values from Unity to PhP to SQL. 1 Answer

Unity5 check database connection c# 0 Answers

PHP is not able to input data from Unity to an empty SQL 0 Answers

  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Default
  • Help Room
  • META
  • Moderators
  • Explore
  • Topics
  • Questions
  • Users
  • Badges