This is a read-only archive of the old Scratch 1.x Forums.
Try searching the current Scratch discussion forums.

#1 2011-09-07 11:17:38

WindowsExplorer
Scratcher
Registered: 2011-02-25
Posts: 1000+

MySQL

I have a login thing on my website, but how do I make it so that it says the username on the success page when logged in?


http://i.imgur.com/H6LLdnK.pnghttp://i.imgur.com/VYuD7BY.png

Offline

 

#2 2011-09-07 11:25:47

Baderous
New Scratcher
Registered: 2011-04-14
Posts: 100+

Re: MySQL

It depends on the language you are using to develop the website. It has little to do with the DBMS.

Offline

 

#3 2011-09-07 11:31:33

roijac
Scratcher
Registered: 2010-01-19
Posts: 1000+

Re: MySQL

he uses php

Offline

 

#4 2011-09-07 13:08:48

ProgrammingFreak
Scratcher
Registered: 2010-09-04
Posts: 1000+

Re: MySQL

Here's the code

Code:

$sql = "SELECT * FROM Person";
mysql_query($sql,$con);

$con is the connection details.  wink

Offline

 

#5 2011-09-07 14:45:01

WindowsExplorer
Scratcher
Registered: 2011-02-25
Posts: 1000+

Re: MySQL

ProgrammingFreak wrote:

Here's the code

Code:

$sql = "SELECT * FROM Person";
mysql_query($sql,$con);

$con is the connection details.  wink

What does the "SELECT * FROM person" do?


http://i.imgur.com/H6LLdnK.pnghttp://i.imgur.com/VYuD7BY.png

Offline

 

#6 2011-09-07 15:27:52

ProgrammingFreak
Scratcher
Registered: 2010-09-04
Posts: 1000+

Re: MySQL

WindowsExplorer wrote:

ProgrammingFreak wrote:

Here's the code

Code:

$sql = "SELECT * FROM Person";
mysql_query($sql,$con);

$con is the connection details.  wink

What does the "SELECT * FROM person" do?

The SELECT statement is used to select data from a database.
FROM tells what the command is selecting from. In the example, its selecting from the 'person' table.

Offline

 

#7 2011-09-08 14:25:09

Magnie
Scratcher
Registered: 2007-12-12
Posts: 1000+

Re: MySQL

WindowsExplorer I suggest learning how to program in MySQL before actually doing it and asking help every time you need something. How about making one thread "My Site Development Thread" and ask all your questions there.

I learned by downloading an Adoptables script ( PHP and MySQL ) and then looked through the code and modded it for more stuff, like money, shops, etc.

Though the script I learned from is gone, but, http://http://www.mysidiaadoptables.com/ looks like an interesting adoptables script ( in fact, I might try it out ) that you could try modding and there is a community there that could help you mod it as well.

So learn the basics of PHP and MySQL and then start creating things from blank pages.  smile

Last edited by Magnie (2011-09-09 09:21:12)

Offline

 

#8 2011-09-08 14:27:41

WindowsExplorer
Scratcher
Registered: 2011-02-25
Posts: 1000+

Re: MySQL

Great! I will create that thread now! (Gopher Website Development Thread)


http://i.imgur.com/H6LLdnK.pnghttp://i.imgur.com/VYuD7BY.png

Offline

 

#9 2011-09-08 23:13:17

GP1
Scratcher
Registered: 2009-07-06
Posts: 1000+

Re: MySQL

Magnie wrote:

GP1 I suggest learning how to program in MySQL before actually doing it and asking help every time you need something. How about making one thread "My Site Development Thread" and ask all your questions there.

I learned by downloading an Adoptables script ( PHP and MySQL ) and then looked through the code and modded it for more stuff, like money, shops, etc.

Though the script I learned from is gone, but, http://http://www.mysidiaadoptables.com/ looks like an interesting adoptables script ( in fact, I might try it out ) that you could try modding and there is a community there that could help you mod it as well.

So learn the basics of PHP and MySQL and then start creating things from blank pages.  smile

uuuuuhhhhhhhhhh, I ALREADY know MySql, and php. I don't know WHO your talking to, but its not me.


I am currently http://blocks.scratchr.org/API.php?user=GP1&action=onlineStatus&type=imagehttp://blocks.scratchr.org/API.php?user=GP1&action=onlineStatus&type=text and I finally got over 1000 posts.

Offline

 

#10 2011-09-08 23:28:59

kayybee
Scratcher
Registered: 2009-12-07
Posts: 1000+

Re: MySQL

Magnie wrote:

GP1 I suggest learning how to program in MySQL before actually doing it and asking help every time you need something. How about making one thread "My Site Development Thread" and ask all your questions there.

I learned by downloading an Adoptables script ( PHP and MySQL ) and then looked through the code and modded it for more stuff, like money, shops, etc.

Though the script I learned from is gone, but, http://http://www.mysidiaadoptables.com/ looks like an interesting adoptables script ( in fact, I might try it out ) that you could try modding and there is a community there that could help you mod it as well.

So learn the basics of PHP and MySQL and then start creating things from blank pages.  smile

I think you're talking about WindowsExplorer.  tongue

Offline

 

#11 2011-09-09 09:22:37

Magnie
Scratcher
Registered: 2007-12-12
Posts: 1000+

Re: MySQL

GP1 wrote:

Magnie wrote:

GP1 I suggest learning how to program in MySQL before actually doing it and asking help every time you need something. How about making one thread "My Site Development Thread" and ask all your questions there.

I learned by downloading an Adoptables script ( PHP and MySQL ) and then looked through the code and modded it for more stuff, like money, shops, etc.

Though the script I learned from is gone, but, http://http://www.mysidiaadoptables.com/ looks like an interesting adoptables script ( in fact, I might try it out ) that you could try modding and there is a community there that could help you mod it as well.

So learn the basics of PHP and MySQL and then start creating things from blank pages.  smile

uuuuuhhhhhhhhhh, I ALREADY know MySql, and php. I don't know WHO your talking to, but its not me.

*head desk* Sorry GP1, I must have some unconscious grudge or something. I fixed who it was pointed towards.  smile

Offline

 

#12 2011-09-09 17:46:44

ProgrammingFreak
Scratcher
Registered: 2010-09-04
Posts: 1000+

Re: MySQL

You could always visit w3schoolswink

Offline

 

Board footer