Database MySql - for Game Maker Studio 2+
A downloadable asset pack
A simple and easy-to-use PHP interface allows Game Maker to communicate with a MySQL database, also simple to edit & add more functions.
--> Quick setup guide provide <--
Operations supported:
- CREATE DATABASE
- CONNECT TO DATABASE
- CHECK CONNECTED DATABASE NAME
- CREATE TABLE table (columns)
- -----> RAW MYSQL CODE <-----
Scripts for quick operations:
- INSERT: INSERT INTO table (columns) VALUES (values)
- SELECT: SELECT columns FROM table
- WHERE: SELECT columns FROM table WHERE values
- SELECT ORDER BY: SELECT columns FROM table ORDER BY order_by
- WHERE ORDER BY: SELECT columns FROM table WHERE values
- LIMIT: SELECT columns FROM table LIMIT limit
- WHERE LIMIT: SELECT columns FROM table WHERE values LIMIT limit
- ORDER BY LIMIT: SELECT columns FROM table ORDER BY order_by LIMIT limit
- WHERE ORDER BY LIMIT: SELECT columns FROM table WHERE values ORDER BY order_by LIMIT limit
- DELETE: DELETE FROM table WHERE values
- UPDATE: UPDATE table SET scope WHERE values
Other functions could be added in the future.
Purchase
In order to download this asset pack you must purchase it at or above the minimum price of $19.99 USD. You will get access to the following files:
Download demo
Development log
- Now MySQL Database work on Game Maker Studio 2!Feb 06, 2021
- Now MySQL Database work on Game Maker Studio 2!Feb 05, 2021
- New functions + scripts + raw query addedJan 15, 2021
- Database MySql for GMS2Jan 15, 2021
Comments
Log in with itch.io to leave a comment.
Hello! Do I need to know PHP programming to include this in my GameMaker projects? Another question: For the game to run by accessing the database, will it be necessary to leave a program running simultaneously with the game so that it can access the database?
Hi, i added you on Discord (Bocary)
I'm considering to buy but i need to ask a few questions about connecting to an online database :)
Currently, would it work for Android?
Hi, might be an obvious question (database noob here) but the quickstartguide pdf only shows you connecting to a local server, is it possible to connect to a web based server? And would that be the same setup? I need an online database where I can upload and retrieve user submitted levels from inside gamemaker. Thanks in advance
Hi, yeah it’s the same setup, but if you’re developing an HTML5 game you’ll probably have to allow CORS (cross-origin requests), if you need some help text me on Discord ^^
Hello, I'm having some troubles getting this to work. What is the best way to contact you for help?
The issue I'm having is when I run install.php, I get the following error:
PHP Notice: Undefined variable: conn in /opt/bitnami/apache/htdocs/utility/dbgenerator.php on line 6
PHP Fatal error: Uncaught Error: Call to a member function query() on null in /opt/bitnami/apache/htdocs/utility/dbgenera tor.php:6
I am trying to run this on a LAMP server using AWS, to use for an online leaderboard system.
Is it working in Game Maker Studio 1.4?
I haven’t tested it on v1.4, probably yes, because it uses functions also available on older versions, I’ll try it tomorrow and let you know :)
Hello, your interface works on GM:S 2.3.3?
Yes, I developed it with GMS 2.3 and the GML implementation is very basic, lots of work is done by PHP
Currently, would it work for Desktop version (.exe)?
I tried it just with the Windows version, so yes