CcSQL (API for MySQL)

CcSQL is an API you can use to connect to REAL MySQL databases.
You need this JSON API and my CcSQL.

usage

os.loadAPI("ccSQL")
local sql = ccSQL.createCcSQL("host", nil, "db", "user", "password") --nil is the port, for now it is not used in the API
sql:prepareStatement("SELECT * FROM table")
local response = sql:sendStatement()
--now, response contains a table with the content of the selection.

Bugs

• You can only use "localhost" as host for now, idk why other ones doesn't work D:

Can you release PHP source?

gknova61, on 03 April 2014 - 12:34 AM said:

Can you release PHP source?

Oh, yea… forgot that xD
The PHP script is as simple as this.

BTW,

Spoiler

If you want, you can use this data to connect to a ftp server with almost the newest script.
Name: ccsql
password: ccsql

not a huge fan, I like what you're trying to do, but you might want to work on security issues; I'd not overly trust the data I store in my databases to be 'safe' in this case.

theoriginalbit, on 03 April 2014 - 11:52 AM said:

not a huge fan, I like what you're trying to do, but you might want to work on security issues; I'd not overly trust the data I store in my databases to be 'safe' in this case.

Yea, that's true. But how should I improve the security? D:

first and foremost take a look into prepared statements for the PHP side of things.

I'm not exactly sure what the purpose of this is.
Are you trying to publish a program people can use to access a MySQL database on your server?
Or are you trying to provide people with a PHP script that they can put on their server so they can communicate with their database?

In either case, this implementation is very insecure.

Freack100, on 03 April 2014 - 12:21 PM said:

theoriginalbit, on 03 April 2014 - 11:52 AM said:

not a huge fan, I like what you're trying to do, but you might want to work on security issues; I'd not overly trust the data I store in my databases to be 'safe' in this case.

Yea, that's true. But how should I improve the security? D:

Write an encryption library!

Shazz, on 07 April 2014 - 10:07 PM said:

I'm not exactly sure what the purpose of this is.
Are you trying to publish a program people can use to access a MySQL database on your server?
Or are you trying to provide people with a PHP script that they can put on their server so they can communicate with their database?

In either case, this implementation is very insecure.

If people setup their MySQL server right, you can access it from my script. But I made this as a connection between computercraft and a MySQL server (not exactly mine).

Parzivail, on 08 April 2014 - 12:44 PM said:

Freack100, on 03 April 2014 - 12:21 PM said:

theoriginalbit, on 03 April 2014 - 11:52 AM said:

not a huge fan, I like what you're trying to do, but you might want to work on security issues; I'd not overly trust the data I store in my databases to be 'safe' in this case.

Yea, that's true. But how should I improve the security? D:

Write an encryption library!

How would it improve the security?

Parzivail, on 08 April 2014 - 12:44 PM said:

Write an encryption library!

It's a horrible idea to write your own encryption algorithm. I can understand it if you are writing one just for experimenting but homebrew encryption algorithms for use in a production environment is a bad idea.