Author Topic: Connecting to MySQL. (Read 1214 times)

Pew446 · June 08, 2009, 01:54:36 AM

Hey, Sorry if this sounds (extremely) noobish, but (I've asked this before like 2 months ago) how do you connect to MySQL? Can Torque use PHP? Ty.

Ad Bot · Advertisement

Ephialtes · June 08, 2009, 02:20:02 AM

It has a TCPObject which can send HTTP GET/POST requests to webservers. Look at RTBH_Support.cs in RTB for examples of this.

Pew446 · June 08, 2009, 02:41:59 AM

Thanks, man. :)

Slicksilver555 · June 10, 2009, 12:00:30 AM

Ephi's tutorial was very... Lame. Plus, RTB is a hassel to sift through, and I've never found anything of use in there.

First, you need a server that is hosting a PHP script.

Say your PHP script calls for a name and it does something to it.

Code: [Select]

new HTTPObject(PHPtest);
function PHPtest::onLine(%this, %line)
{
//This is say a echo in PHP, anything you echo and any HTML code will come in through here, so you'll want to filter.
echo(%line); //Puts the returned line in console
}
HTTPObject.get("http://YourWebsite.com/PHPScript.php:80","name=hello");

That would connect to yourWebsite.com/PHPScript?name=hello
Then anything that would be in your browser is transferred to console.

Ephialtes · June 10, 2009, 02:27:00 AM

Quote from: Slicksilver555 on June 10, 2009, 12:00:30 AM

Ephi's tutorial was very... Lame. Plus, RTB is a hassel to sift through, and I've never found anything of use in there.

First, you need a server that is hosting a PHP script.

Say your PHP script calls for a name and it does something to it.

Code: [Select]
new HTTPObject(PHPtest); function PHPtest::onLine(%this, %line) { //This is say a echo in PHP, anything you echo and any HTML code will come in through here, so you'll want to filter. echo(%line); //Puts the returned line in console } HTTPObject.get("http://YourWebsite.com/PHPScript.php:80","name=hello");That would connect to yourWebsite.com/PHPScript?name=hello
Then anything that would be in your browser is transferred to console.

First off, I didn't write a tutorial. And secondly - atleast what I told him wasn't broken. I think the problem with you is that you're incompetent, RTB pretty nicely shows how to communicate with a webserver via PHP (and even retain sessions, or modify header data) so the fact that you can't find anything "useful" is purely a reflection of your own inability to understand.

HTTPObject.get() would just fail because there is nothing called HTTPObject. Try to pay attention when you're ~~misleading~~helping people trying to learn, ok?

Pew446 · June 10, 2009, 05:55:33 PM

So if I was trying to find how many coins some client had in my database, how would I go about doing that? Btw, can I have a PHP example too?

AGlass0fMilk · June 10, 2009, 09:41:57 PM

Well, now how would I set up a MySQL or PHP web page, I have no idea how to design web pages. I don't really need to know.

Pew446 · June 10, 2009, 09:59:10 PM

Web page design:

<html>
<head>
<title>Title goes here</title>
</head>
<body>
Content here
</body>
</html>

PHP design:

<?php
Code here
?>

Kalphiter · June 10, 2009, 10:02:51 PM

I don't know, might chip in an example.

Obviously I have it working perfectly :)

BobAndRob · June 10, 2009, 11:41:02 PM

This is on my to do list.

When I get something working, I may publish it.

Ephialtes · June 11, 2009, 02:22:13 AM

Quote from: AGlass0fMilk on June 10, 2009, 09:41:57 PM

Well, now how would I set up a MySQL or PHP web page, I have no idea how to design web pages. I don't really need to know.

Yeah, don't look up PHP/HTML/MySQL tutorials or anything. Ask on the Blockland forums.

Pew446 · June 11, 2009, 02:10:55 PM

Quote from: Ephialtes on June 11, 2009, 02:22:13 AM

Yeah, don't look up PHP/HTML/MySQL tutorials or anything. Ask on the Blockland forums.

Lol.

AGlass0fMilk · June 11, 2009, 04:09:42 PM

Quote from: AGlass0fMilk on June 10, 2009, 09:41:57 PM

Well, now how would I set up a MySQL or PHP web page, I have no idea how to design web pages. I don't really need to know.

Destiny/Zack0Wack0 · June 11, 2009, 07:12:59 PM

Quote from: AGlass0fMilk on June 11, 2009, 04:09:42 PM

Then why ask?

AGlass0fMilk · June 11, 2009, 07:13:44 PM

It would be nice to know, but I don't need to know it.