Help! What is wrong with this?

[chrisfennell]

what is wrong with this?

<?
//Start the session!
session_start();

//replace username and password with your mysql name and password
$conn = mysql_connect("localhost","pwnhost_resource","leo11ert55$");

//select the database
$db = mysql_select_db("pwnhost_resources");

//access key stuff
$result = MYSQL_QUERY("SELECT * from key WHERE accesskey='char($accesskey)'")
or die ("Incorrect AccessKey!");
$worked = mysql_fetch_array($result);
$accesskey = $worked[accesskey];

$username = $_POST["username"];
$password = md5($_POST["password"]);
$email = $_POST["email"];

//Store the session variables...
$_SESSION['username'] = $username;
$_SESSION['email'] = $email;

//insert the values
$result= MYSQL_QUERY("INSERT INTO users (id, username, password, email)".
"VALUES ('NULL', '$username', '$password', '$email')");

echo "Your name and password have been submitted into our database, and you are logged in!";
?> 

Please help me!

[chrisfennell]

I guess I should explain what im having troubles with.. I get "Invalid Accesskey!" as my error. It acts as if its not connecting to the database...

This is my database sql file:

--

-- Table structure for table key

CREATE TABLE key (
accesskey varchar(10) NOT NULL default '',
KEY accesskey (accesskey)
) TYPE=MyISAM COMMENT='the key to get in!';

--

-- Dumping data for table key

INSERT INTO key VALUES ('\0');
INSERT INTO key VALUES ('leo11');

---

--

-- Table structure for table users

CREATE TABLE users (
username varchar(10) binary NOT NULL default '',
password varchar(10) binary NOT NULL default '',
email varchar(25) binary NOT NULL default ''
) TYPE=MyISAM COMMENT='User stuff';

--

-- Dumping data for table users

[robert_w_ark]

/* WRONG */

//replace username and password with your mysql name and password
$conn = mysql_connect("localhost","pwnhost_resource","leo11ert55$");

//select the database
$db = mysql_select_db("pwnhost_resources"); 


/** RIGHT **/

$db = mysql_connect("localhost","pwnhost_resource","leo11ert55$");
mysql_select_db("pwnhost_resources", $db); 

maybe that works o,0

[chrisfennell]

No it still dont work. I dont know why either.

<?
//Start the session!
session_start();

$db = mysql_connect("localhost","pwnhost_resource","leo11ert55$");
mysql_select_db("pwnhost_resources", $db);

//access key stuff
$result = MYSQL_QUERY("SELECT * from key WHERE accesskey='char($accesskey)'")
or die ("Incorrect AccessKey!");
$worked = mysql_fetch_array($result);
$accesskey = $worked[accesskey];

$username = $_POST["username"];
$password = md5($_POST["password"]);
$email = $_POST["email"];

//Store the session variables...
$_SESSION['username'] = $username;
$_SESSION['email'] = $email;

//insert the values
$result= MYSQL_QUERY("INSERT INTO users (id, username, password, email)".
"VALUES ('NULL', '$username', '$password', '$email')");

echo "Your name and password have been submitted into our database, and you are logged in!";
?> 

I appreciate you helping though! Anyone else?

[bodzan]

Maybe the problem is in the line:

$result = MYSQL_QUERY("SELECT * from key WHERE accesskey='char($accesskey)'")
or die ("Incorrect AccessKey!");

In:

accesskey='char($accesskey)'

to be precise...

Maybe you should char the variable outside and then put it in query like:

$acc = char($accesskey);

and then put it in query like:

SELECT * from key WHERE accesskey='$acc'

[chrisfennell]

Fatal error: Call to undefined function: char() in /home/pwnhost/public_html/r/make.php on line 9

That is the error that I got...

Code:

<?
//Start the session!
session_start();

$db = mysql_connect("localhost","pwnhost_resource","leo11ert55$");
mysql_select_db("pwnhost_resources", $db);

//access key stuff
$acc = char($accesskey);
$result = MYSQL_QUERY("SELECT * from key WHERE accesskey='$acc'")
or die ("Incorrect AccessKey!");
$worked = mysql_fetch_array($result);


$username = $_POST["username"];
$password = md5($_POST["password"]);
$email = $_POST["email"];

//Store the session variables...
$_SESSION['username'] = $username;
$_SESSION['email'] = $email;

//insert the values
$result= MYSQL_QUERY("INSERT INTO users (id, username, password, email)".
"VALUES ('NULL', '$username', '$password', '$email')");

echo "Your name and password have been submitted into our database, and you are logged in!";
?> 

[bodzan]

...well I didn't realised that char function doesn't exist in PHP :bemused:

I was going to ask you what you were trying with that...

I'm some help...

[chrisfennell]

Hmm, I am lost. I just figured since its a char that id need that. Let me explain what I am doing. I am making a resources part of my site so that customers can login and use the stuff we have. Well we will have an accesskey that changes every week, so whoever signs up are already our members that have the accesskey. So its just a basic user registration and login with sessions script. Thanks for all the help!

[bodzan]

...and use the query and see what you get...

$result = MYSQL_QUERY("SELECT * from key WHERE accesskey='$accesskey'")

and this just might be it...

In my country we have a saying "Even a blind chicken finds the seed"... 😉