charlootus Posted October 11, 2019 Posted October 11, 2019 Hello!I have seen this done by other people but I just can't seem to figure it out!So I am currently trying to connect the database of the users on my Forum with a c# and c++ application.I know you can do this with things like phpMyAdmin and using their databaseSo I was wondering if you have any available tutorials or source codes that I could look at that would help me connect my forum member database to my C# and C++ Application, C++ Preferred.Thank you!And hopefully I can do this as it would be so great!
bfarber Posted October 11, 2019 Posted October 11, 2019 If you're just trying to connect to a database, use the appropriate PHP database connection functions. If it's a MySQL database, then you can even use our built in \IPS\Db driver (just pass different connection details to it to create a new instance). If using something like MSSQL you'll have to use the lower level mssql PHP functions.
Aiwa Posted October 12, 2019 Posted October 12, 2019 Why are you worried about IPS to begin with? C# / C++(eww) has build in SQL tools. Just connect to the DB directly.
charlootus Posted October 12, 2019 Author Posted October 12, 2019 yah see! I didn't know that (i bet u use python) eww
Aiwa Posted October 13, 2019 Posted October 13, 2019 7 hours ago, charlootus said: yah see! I didn't know that (i bet u use python) eww Yup, and C#, PowerShell, PHP, Angular, React, various machine learning tool, and the list goes on. Stackoverflow would have more information for you on how to connect to a SQL database from C++.
charlootus Posted October 13, 2019 Author Posted October 13, 2019 16 hours ago, Aiwa said: Yup, and C#, PowerShell, PHP, Angular, React, various machine learning tool, and the list goes on. Stackoverflow would have more information for you on how to connect to a SQL database from C++. Yes I know how to connect to a DB but I don't know where to find my DB Info! I'm so lost I've never used IPS before. Could you maybe provide a link of where I can get the info to connect to my DB?
Joel R Posted October 13, 2019 Posted October 13, 2019 1 hour ago, charlootus said: Yes I know how to connect to a DB but I don't know where to find my DB Info! I'm so lost I've never used IPS before. Could you maybe provide a link of where I can get the info to connect to my DB? In case you didn't save your DB credentials yourself, you can always refer to your config file.
charlootus Posted October 13, 2019 Author Posted October 13, 2019 5 minutes ago, Joel R said: In case you didn't save your DB credentials yourself, you can always refer to your config file. Maybe it's because I don't selfhost? Is that why I can't find this info? Where would I find the config file?
Joel R Posted October 13, 2019 Posted October 13, 2019 26 minutes ago, charlootus said: Maybe it's because I don't selfhost? Is that why I can't find this info? Where would I find the config file? You should see a 'conf_global.php' in the root of your IPS installation on your server.
charlootus Posted October 13, 2019 Author Posted October 13, 2019 1 minute ago, Joel R said: You should see a 'conf_global.php' in the root of your IPS installation on your server. Where do I find this! I used IPS webhosting I dont have any FTP info and I have no idea where to find any of this information
Joel R Posted October 13, 2019 Posted October 13, 2019 You're cloud hosted? Submit a ticket in the Client Area.
charlootus Posted October 13, 2019 Author Posted October 13, 2019 Just now, Joel R said: You're cloud hosted? Submit a ticket in the Client Area. Already did! They said they couldn't help me, I'll try again
bfarber Posted October 14, 2019 Posted October 14, 2019 We don't allow external MySQL connections for security purposes last I checked, so that's not going to be an option in your case.
Ryan Ashbrook Posted October 14, 2019 Posted October 14, 2019 Correct - you cannot connect directly to the database on Community in the Cloud. Generally speaking, however, you should never interface with the database directly. In your case the REST API would probably be a better alternative.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.