MySQL - i dont understand - PHPBuilder Forums

MySQL - i dont understand

pablodelapena

Ok, here is my script. First it checks to see if the username is already taken. If that happens it says USername taken etc.

ELSE it redirects to another webpage (i plan to amke this the code where it INSERTS INTO the databse the typed fields.)

But it doesnt. If i type a username which is already taken it tells em so. But if i type a new one it just stays blank!!!

code:
________________________--

<?php

$database = "auth";
$dbhost = "localhost";
$dbuser = "root";
$dbpass = "";

//QUERIES

$query_checkifexist = "SELECT * FROM authentication WHERE username = '$username'";
$query_final = "INSERT INTO authentication (username, password, realname, age) VALUES ('$username', '$password', '$realname',

'$age')";

mysql_connect($dbhost, $dbuser, $dbpass);
$db = mysql_select_db($database);
if (!$db)
die("Failed to open database");

$checkifexist = mysql_query($query_checkifexist);

if ($row = mysql_fetch_array($checkifexist)) {
do {
if ($username === $row[username]){
echo ("Username taken! Please choose another.");

} else {
$final = mysql_query($query_final);
header ("location: [url]http://www.mountaincanon.com[/url]");
}

} while($row = mysql_fetch_array($checkifexist));
}

_________________________________--

Im quite confused as to what is going wrong! I kow it is probably something really simple, but id be grateful for any advice!!

Pablo de la Pena

Blob

It'd help if you used the php tags. 😛

You have to have something at the very first line of your page to use the header thing... I don't know what, I never use it - I use another way...

My way is just using html meta tags to redirect. 🙂
Do where you did the header, do:

<html>
<head>
<meta http-equiv="refresh" content="5;url=http://www.site.co.uk">
</head>
<body>
Username created!. Taking you to the next step...
</body>
</html>

I prefer putting everything in one whole php script though. 😛

pablodelapena

thanks, but what i dont get is, the first time i use the header tag it works (i think i used an echo tag in this demonstration). but int he 2nd part after the ELSE statement.......nothing. blank screen!

aviendha

I can't answer your direct question as I haven't used headers, but I can offer a possible work-around (uses the meta).

This may not be the best way to do things, but it worked for me.

I posted this form to php_self, if that makes a difference.


//statements to check for duplicate username...
//if there is a duplicate
$nameError = "true";

//after any other necessary code:
if(!isset($idError))  //if no errors & processing finished redirect user back to index
  {
     $complete = "<HTML><HEAD><META HTTP-EQUIV=\"REFRESH\"CONTENT=\"10; URL=../admin/\"><TITLE>New Member</TITLE></HEAD>
     <BODY><font  face=\"Comic Sans MS\">Processing has completed successfully.  

     If after 10 seconds you are not in the main menu <A HREF='../admin/'>Click Here</A> to go back.</font>
     </BODY></HTML>";
     echo $complete;
  }