• 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 misticone00 · Aug 11, 2014 at 10:17 PM · mysqland

Android and Mysql

Hi, I wrote this code that pulls information from my mysql database and it works perfectly but when i run it on a android phone it does nothing...

This is a bit of my code in C#:

 MySqlConnection conn;
 MySqlCommand command;
 MySqlDataReader reader;
 MySqlDataAdapter adapter;
 public string checker ;
 public string nameX ;
 public int UsernameInUse = 0;



         conn = new MySqlConnection("server=db4free.net;Port=3306; user id=misticone; password=MyPass; database=MyDatabase");
         adapter = new MySqlDataAdapter();
         command = new MySqlCommand();
     

         conn.Open ();


         command.CommandText = "SELECT * FROM Player WHERE Username='" + nameX + "';";
         command.Connection = conn;
         adapter.SelectCommand = command;
         reader = command.ExecuteReader();


         while (reader.Read ()){
             if(reader.HasRows){
                 UsernameInUse=1;
                 checker = (string)reader["Password"];



             }
             else{

                 UsernameInUse = 0;
                 reader.Close();
             }

         }

         reader.Close ();
         conn.Close ();


Why Does this code work on the computer but when i run it on my android phone it doesn't?

Thanks in advance,

,MistY,

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 jaaya · Sep 15, 2017 at 01:17 PM 0
Share

Hi, Have you find a solution ? I have the same problem on my app

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

If you’re new to Unity Answers, please check our User Guide to help you navigate through our website and refer to our FAQ for more information.

Before posting, make sure to check out our Knowledge Base for commonly asked Unity questions.

Check our Moderator Guidelines if you’re a new moderator and want to work together in an effort to improve Unity Answers and support our users.

Follow this Question

Answers Answers and Comments

3 People are following this question.

avatar image avatar image avatar image

Related Questions

if get key and float bigger as 1 Answer

C# and Mysql problem in Windows standalone 0 Answers

Unity 3D + mySQL no working (taken from the example page) 1 Answer

Unity C# MySQL Issues 1 Answer

error getting data from mySQL database 0 Answers


Enterprise
Social Q&A

Social
Subscribe on YouTube social-youtube Follow on LinkedIn social-linkedin Follow on Twitter social-twitter Follow on Facebook social-facebook Follow on Instagram social-instagram

Footer

  • Purchase
    • Products
    • Subscription
    • Asset Store
    • Unity Gear
    • Resellers
  • Education
    • Students
    • Educators
    • Certification
    • Learn
    • Center of Excellence
  • Download
    • Unity
    • Beta Program
  • Unity Labs
    • Labs
    • Publications
  • Resources
    • Learn platform
    • Community
    • Documentation
    • Unity QA
    • FAQ
    • Services Status
    • Connect
  • About Unity
    • About Us
    • Blog
    • Events
    • Careers
    • Contact
    • Press
    • Partners
    • Affiliates
    • Security
Copyright © 2020 Unity Technologies
  • Legal
  • Privacy Policy
  • Cookies
  • Do Not Sell My Personal Information
  • Cookies Settings
"Unity", Unity logos, and other Unity trademarks are trademarks or registered trademarks of Unity Technologies or its affiliates in the U.S. and elsewhere (more info here). Other names or brands are trademarks of their respective owners.
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Default
  • Help Room
  • META
  • Moderators
  • Explore
  • Topics
  • Questions
  • Users
  • Badges