Sorry your browser is not supported!

You are using an outdated browser that does not support modern web technologies, in order to use this site please update to a new browser.

Browsers supported include Chrome, FireFox, Safari, Opera, Internet Explorer 10+ or Microsoft Edge.

Geek Culture / What is Mysql

Author
Message
Oneka
20
Years of Service
User Offline
Joined: 24th Apr 2004
Location: Hampton,VA
Posted: 28th Jul 2004 09:29
Link
What is Mysql? is it a forum thingy iam so dumb


Making better games everday!
Oh yeah and just so you know its Oh-nek-a not One-ka!
Back to top
Profile PM Email Website
TKF15H
21
Years of Service
User Offline
Joined: 20th Jul 2003
Location: Rio de Janeiro
Posted: 28th Jul 2004 09:39
Link
MySQL is a database thingy. Forums use it to store information about each user and other things. If you want something for games, you could try LSD (Library for Simple Databases).

Back to top
Profile PM Email Website
Oneka
20
Years of Service
User Offline
Joined: 24th Apr 2004
Location: Hampton,VA
Posted: 28th Jul 2004 09:42
Link
o well ya see on DBspot i was gonna get a mysql but I didnt know what it was so how can I use it for a forum?


Making better games everday!
Oh yeah and just so you know its Oh-nek-a not One-ka!
Back to top
Profile PM Email Website
TKF15H
21
Years of Service
User Offline
Joined: 20th Jul 2003
Location: Rio de Janeiro
Posted: 28th Jul 2004 09:51
Link
Do you want to write your own forum, or do you want to install a pre-made forum like phpBB? If you're using phpBB, there are instructions with the download.

Back to top
Profile PM Email Website
Ilya
21
Years of Service
User Offline
Joined: 10th Aug 2003
Location:
Posted: 28th Jul 2004 10:32 Edited at: 28th Jul 2004 10:33
Link
Go to phpbbhacks.com and get a premade phpbb(it's cooler).

Sample:

Go to my website and click on "Fourms" or "PhpBB"

-Ilya
Back to top
Profile PM Email Website
David T
Retired Moderator
22
Years of Service
User Offline
Joined: 27th Aug 2002
Location: England
Posted: 28th Jul 2004 18:23 Edited at: 28th Jul 2004 18:23
Link
Or even just phpbb.com Try invision also, that's a pretty cool forum.

Get 15 new commands, all the date / time commands left out of DBPro for free!
DOWNLOAD PLUGINS HERE: http://www.davidtattersall.me.uk/ and select "DarkBasic"
Back to top
Profile PM Email Website
OSX Using Happy Dude
21
Years of Service
User Offline
Joined: 21st Aug 2003
Location: At home
Posted: 28th Jul 2004 18:30
Link
And if you want to access mySQL databases (presumably those used by websites & those created using the API are the same format etc) from either a computer, web site or the internet, I have just the plug-in.


I came, I saw and I forgot all about it... or something...
Back to top
Profile PM Email Website
David T
Retired Moderator
22
Years of Service
User Offline
Joined: 27th Aug 2002
Location: England
Posted: 28th Jul 2004 18:33
Link
@TCA: How do you connect to a database held on a web site? What do you put in the host space? "domain.com"?

Get 15 new commands, all the date / time commands left out of DBPro for free!
DOWNLOAD PLUGINS HERE: http://www.davidtattersall.me.uk/ and select "DarkBasic"
Back to top
Profile PM Email Website
OSX Using Happy Dude
21
Years of Service
User Offline
Joined: 21st Aug 2003
Location: At home
Posted: 28th Jul 2004 19:03 Edited at: 28th Jul 2004 19:05
Link
I've never tried it (just computer to computer over the internet), so I dont exactly know... I'm just assuming its possible - however, it does look as though its not possible...


I came, I saw and I forgot all about it... or something...
Back to top
Profile PM Email Website
David T
Retired Moderator
22
Years of Service
User Offline
Joined: 27th Aug 2002
Location: England
Posted: 28th Jul 2004 19:50
Link
Well, the host parameter has to be there for a reason If it was always localhost then it'd be a bit pointless I'll have a look on google.

Get 15 new commands, all the date / time commands left out of DBPro for free!
DOWNLOAD PLUGINS HERE: http://www.davidtattersall.me.uk/ and select "DarkBasic"
Back to top
Profile PM Email Website
OSX Using Happy Dude
21
Years of Service
User Offline
Joined: 21st Aug 2003
Location: At home
Posted: 28th Jul 2004 20:00
Link
It can also be an IP address of course...


I came, I saw and I forgot all about it... or something...
Back to top
Profile PM Email Website
David T
Retired Moderator
22
Years of Service
User Offline
Joined: 27th Aug 2002
Location: England
Posted: 28th Jul 2004 20:05
Link
Hmm. That may be it.

Get 15 new commands, all the date / time commands left out of DBPro for free!
DOWNLOAD PLUGINS HERE: http://www.davidtattersall.me.uk/ and select "DarkBasic"
Back to top
Profile PM Email Website
OSX Using Happy Dude
21
Years of Service
User Offline
Joined: 21st Aug 2003
Location: At home
Posted: 28th Jul 2004 20:15
Link
Its possible that somehow directly connecting to a website allows access to the database...


I came, I saw and I forgot all about it... or something...
Back to top
Profile PM Email Website
adr
21
Years of Service
User Offline
Joined: 21st May 2003
Location: Job Centre
Posted: 28th Jul 2004 20:37
Link
you can connect to a database that is held remotely the same way you connect to a local one. Instead of the host being "localhost" it's subdomain.yourdbhost.com ... usually on port 3306. If you actually want to connect using a web browser, then you could benefit from using phpMyAdmin. That presents a nice fluffy web interface for your MySQL DB.

Oh and MySQL isn't limited to running a forum/website. Our multi-million pound business operates entirely on a MySQL DB

Back to top
Profile PM Website
OSX Using Happy Dude
21
Years of Service
User Offline
Joined: 21st Aug 2003
Location: At home
Posted: 28th Jul 2004 20:53
Link
When connecting to a website then, does the local mySQL deal with all requests etc or is there a system on the site that processes everything and then sends the result back ?


I came, I saw and I forgot all about it... or something...
Back to top
Profile PM Email Website
adr
21
Years of Service
User Offline
Joined: 21st May 2003
Location: Job Centre
Posted: 28th Jul 2004 21:16
Link
Quote: "When connecting to a website"

Assuming you mean "interact with the DB through a web layer" then what happens is there are a series of PHP Pages which interact with MySQL for you. Put another way, MySQL does not have a native "web interface".

Back to top
Profile PM Website
OSX Using Happy Dude
21
Years of Service
User Offline
Joined: 21st Aug 2003
Location: At home
Posted: 28th Jul 2004 21:51
Link
I presume these pages would then send the result back in a format uses by the C API system...


I came, I saw and I forgot all about it... or something...
Back to top
Profile PM Email Website
adr
21
Years of Service
User Offline
Joined: 21st May 2003
Location: Job Centre
Posted: 29th Jul 2004 02:32 Edited at: 29th Jul 2004 02:33
Link
Quote: "I presume these pages would then send the result back in a format uses by the C API system..."

I don't understand exactly where, but you seem to be misunderstanding the way it all layers together. Either that or I'm misunderstanding your terminology. ASCII art saves the day...



PHP, like a couple of other languages, sports an set of native interface functions for the MySQL DB. phpMyAdmin is basically a set of generic PHP pages which let you view/play with MySQL. The end result is a web interface to a MySQL server. There's nothing terribly magical about it, it's all just the glory that is webdev.

Back to top
Profile PM Website
OSX Using Happy Dude
21
Years of Service
User Offline
Joined: 21st Aug 2003
Location: At home
Posted: 29th Jul 2004 02:50
Link
Yes - there does seem to be a slightly mis-understanding: The query is in relation to using the mySQL C API system and whether its possible to use web-based databases to access results. Using the C API, it goes something like :

Caller -> Send to server a query/command
Server -> Process results and sends back to caller
Caller -> Process results


I came, I saw and I forgot all about it... or something...
Back to top
Profile PM Email Website
Newbie Brogo
21
Years of Service
User Offline
Joined: 10th Jul 2003
Location: In a Pool of Cats
Posted: 29th Jul 2004 03:02
Link
Hi people, since this is a MySQL thread, I'll steal it for a sec.
I've made a very basic user registration thingy in php.
Does anyone know a code that checks the MySQL database to see if $username already exists in it?
I'm not very advanced in PHP, or MySQL.... But I'm sorta learning.

Back to top
Profile PM Email Website
David T
Retired Moderator
22
Years of Service
User Offline
Joined: 27th Aug 2002
Location: England
Posted: 29th Jul 2004 05:39 Edited at: 29th Jul 2004 17:55
Link


I think that'll work.

Get 15 new commands, all the date / time commands left out of DBPro for free!
DOWNLOAD PLUGINS HERE: http://www.davidtattersall.me.uk/ and select "DarkBasic"
Back to top
Profile PM Email Website
Newbie Brogo
21
Years of Service
User Offline
Joined: 10th Jul 2003
Location: In a Pool of Cats
Posted: 29th Jul 2004 07:57 Edited at: 29th Jul 2004 08:11
Link
Thanks david, that worked perfectly.
I did have a code before that didnt work, and it was a bit messy and I learned I just forgot some very simple things like a '. But your code is a lot cleaner and easier to understand.
Messy... or Clean.....
I'll take clean.

Thanks again David.

Back to top
Profile PM Email Website
David T
Retired Moderator
22
Years of Service
User Offline
Joined: 27th Aug 2002
Location: England
Posted: 29th Jul 2004 17:55
Link
No problem

I hope the code didn't work perfectly, I accidentally left out a = before mysql_num_rows

Get 15 new commands, all the date / time commands left out of DBPro for free!
DOWNLOAD PLUGINS HERE: http://www.davidtattersall.me.uk/ and select "DarkBasic"
Back to top
Profile PM Email Website
Back to top

Login to post a reply

Server time is: 2024-09-22 08:44:02
Your offset time is: 2024-09-22 08:44:02