Jump to content
The Uniform Server Community
Sign in to follow this  
oconkero

SOS Databases and mySQL HELP PLZ

Recommended Posts

First of all i have taken a look at the phpmyadmin and my sql ive tried piecing it all together but im still unable to understand it all. What im trying to accomlish is that i have my website running with Uniform server and i have access to the APANEL so i can then start the sql, i have changed the script so i can start it from anywhere. but the real problem lies where i need a register and login for my site, and i need it to be a database login, not .htaccess. I think this is kinda like what olajideolaolorun has on his forums here like the login and register, maybe, i dk. THANK YOU in advance. :(

 

If you need more info to try and help me just ask, thx.

Share this post


Link to post
Share on other sites

OK - in order to do what you want you will need to store usernames and passwords in the database and then you will need to use a scripting language such as PHP (already part of the uniform server setup) to interact with the database

 

So you will have to learn about MySQL and about PHP

 

You can learn about MySQL by going to http://www.tqnyc.org/tutorial/mysql/index.php

 

You can get started learning PHP by going here http://www.tizag.com/phpT/

 

there are lots of other places that offer tutorials on mysql and php - you can use google to find them Like This

 

This One also looks good

 

hope that helps, megan

Share this post


Link to post
Share on other sites

ok ok THANK YOU very much for your VERY VERY fast reply which took a time of like 2 minutes, lol , i will read up on those links Thanks again :(

Share this post


Link to post
Share on other sites

Well im still kindof confused with this all after reading thru the websites u gave me for refrences. so i was wondering if anyone can help me with the script and script installation. THX

Share this post


Link to post
Share on other sites

Ok um... the thing is... where in the world... or the confusing phpmyadmin do i put this code?? i know hot to make a database and how to make tables in those databases but i get confused at the whole coding part as far as i see phpmyadmin is all visual. not code. this is the only part im stuck at im sure all the php coding for forms is simple, almost copy and paste.

 

and one more thing whats this include "db.php" the where or how can i make or get it?

Share this post


Link to post
Share on other sites

im sorry this is taking longer than expected but heres my problem now i have the code the one from that website you refrenced earlier but everytime is use any code it gives me an error, about some db.php on some line or rather i think i might have found what everyone is talking about. I jist need help with the username and pass. i think i got the rest.

 

"This is the db.php?"

 

$host = 'localhost';

$username = 'your_username';

$password = 'your_password';

$database = 'your_database';

 

$connection = mysql_pconnect($host, $username, $password);

 

$mysql_select_db($database, $connection);

 

Perform your mysql_query(); here.

Share this post


Link to post
Share on other sites

ok thx ill edit it when im home im kinda at school :) but itas over in 4 days just ned to write finals then ill fool around with sql ect full time :)

Share this post


Link to post
Share on other sites

yeah i dont know if im close but still no cigar um ill get back to you on the error msg status. i think its still the old one

Share this post


Link to post
Share on other sites

Uhhh, Yeah this should be similair to the finished product i just need to know what the username and password is, is it the admin pass ar just and www pass or is there a diferent one for mysql becuz it doesnt ask me anything to get in there but i didnt change nething so it should be the defualt username and pass.and the database i want the users to be stored in is "users". ah and do i just leave the host as localhost or my remote or local ip?

 

"db.php"

 

$host = 'localhost';

$username = 'your_username';

$password = 'your_password';

$database = 'users';

 

$connection = mysql_connect($host, $username, $password);

 

$mysql_select_db($database, $connection);

 

Thanks For the Help.

Share this post


Link to post
Share on other sites

Just leave the host as localhost :(

 

Uniform Server mySQL Defaults: Username = root ; Password = root

 

Instructions on how to change the password can be found here.

Share this post


Link to post
Share on other sites

ohhh thanks i might be able to start figuring this out i also found a script that tells u if the sql if working or not woth the username and pass u use... thanks im gonna try this cool script out and thanks for the defaults

 

Update:

 

yep i used this php script and i can connect so ima use the same user and pass for now and see if i can get some sort of user registration and login goin, heres what helped me

 

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>

<title>MySQL Test</title>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

</head>

 

<body>

<p>MySQL test</p>

 

<?php

mysql_connect("localhost", "root", "root");

if (mysql_select_db("phpmyadmin")){

echo "CAN connect to database";

}

else{

echo "CAN NOT connect to database";

}

 

?>

 

</body>

</html>

Share this post


Link to post
Share on other sites

right i got it working and ive studied sql and php together with databases so i do have a php few scripts that ban users ect but i need one that bans users with admin ect and protects certain pages most scripts i com across dont protect pages at all thet just kinda like a gate with no walls u can just walk around the gate like on these scripts u can just type the html address of that page and ban ur there.... i cant have unregistered or banned users finding this out and well its crap. unbeliveable, unacheivable crap, i cant have it. so if anyone know any scripts better"" it would be great... oh an i cant seam to load phpfreaks... ive tried for 3 weeks i only get a white page. can anyone else load it?

 

Thanks to everyone for the great help on teaching a begginer :D

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...