I have pretty much no experience with php, but is there a way to connect to a database in MMF to login to a game? Could someone direct me to a help file or tutorail? Also, is there a way to create directories on my site in MMF using vitalized extensions? (www.mysite.com/newdirectory)
If you can answer either of these questions, that would be very helpful.
Here's a tutorial:
http://www.clickteam.com/eng/resources/online_score/dxn-scoreboards.zip
(Though I recommend you use Live Receiver instead of Moosock, the theory is much the same - I promise I will update it to Live Receiver some day even though I've been saying that for the last year.)
Like I said, I do not know much php. So if you could explain how to code this, that would be much appreciated.
Even for people who have no PHP coding knowledge, the tutorial explains most of the PHP code and you really hardly need to understand very little of it, copy and paste will suffice.
How did I know you'd be posting a reply, Brandon? Are you following me around?I bet you've caught on to my evil scheme already.
EDIT: I didn't even notice the files that came with the MMF file. I guess it may be smart to look at them.
I'm having trouble checking a user's name with its password for logging in. I know it's simple php, but I'm not sure how to do it. I created a new php file and called it "user_check.php" and I set it to get the username from the url, but how do I compare it to the password on the database?
OK. This is what I have in my php file that checks if the user's name and password match:
If the name and password match, there should be a "1" on the screen, but when I try it, the page is blank. What did I do wrong?Code:<html> <head> <title>User Check</title> </head> <? $name = $_GET['name']; $userpassword = $_GET['userpassword']; $service = "localhost"; $username = "pauliuko"; $password = "sdfsfsf"; $database = "pauliuko_games"; mysql_connect($service, $username, $password); @mysql_select_db($database) or die( "Unable to select database"); $get=mysql_query("SELECT (id) FROM users WHERE name=$user and password=$pass"); $result=mysql_query($query); echo"$result" ?> </body> </html>
EDIT: My MySQL table has 4 columns: id, name, password, and datejoined.
your result line is wrong, you're asking another query here :
$result=mysql_query($query);
I don't remember very well but isn't it something like mysql_fetcharray ? or something like that ?
EDIT : found this :
$result = mysql_query("SELECT id, name FROM mytable");
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
printf("ID: %s Name: %s", $row[0], $row[1]);
}
I have no idea. This is my first time ever actually using php and MySQL.
What you found just returns the entire table. What I want is to check if 2 values are the same.Originally Posted by Corentin
Posting Permissions
Reply With Quote