trying to do an if statement

[Hoangsta]

I am trying to direct users to their appropriate direction. if a user has already registered their business, they don't need to see the registeration form again, but to just send them to the main page.

...if ur still confused, once a user logs in, user will be directed to either they have already registered their business or not. if they did, send them to "A" if not then "B" B is the registration form. once they logout, and login again, they will just be directed to "A" and not "B" because they are already registered.

...HOw I did this was to put a "1" into my database when they registered. I put "1" in a field name "bus_registered". When a user logs in, the code will detect if the "1" exits, if so, direct them to "A" if not, then "B" B again, is the registration form.

I did the best with my code below for the login.php

if ($_POST['submit'] == 'Login') {
  if (strlen($_POST['user_name']) <= 25 && strlen($_POST['password']) <=25) {
    $feedback = user_login();
  } else {
    $feedback = 'ERROR - Username and password are too long';
  }

$query = "SELECT bus_confirmed
		  FROM BusinessName
		  WHERE bus_confirmed = 1"; 
$result = mysql_query($query); 


  if ($feedback == 1) && ($result && mysql_num_rows($result) > 1) {	
// Register the input with the value
$_SESSION['user_name'] = $_POST['user_name'];
session_register("authr_user_name");
$authr_user_name = $_POST['user_name'];
    // On successful login, redirect to homepage
	header("Location: A ");

  } else {
  	header("Location: B");

  } else {
    $feedback_str = "<P class=\"errormess\">$feedback</P>";
  }
} else {
  $feedback_str = '';
}

any help would be greatly appreciated!!!!!

MY error for the moment is

Parse error: parse error in /virtual/buzzabiz.com/home/web/public_html/login.php on line 40

line 40 =

if ($feedback == 1) && ($result && mysql_num_rows($result) > 1) 

($feedback == 1) is called from another form to check if they have their username and userid confirmed.

[Arc]

Looks like you need another set of brackets

if (($feedback == 1) && ($result && mysql_num_rows($result) > 1))

But I think you are going about it all wrong. Try this

$Sql = "SELECT bus_confirmed 
              FROM BusinessName 
              WHERE TheFieldThatHasTheBusinessName = 'This Business's Name'";  

    $Result = mysql_query($Sql); 
$ResultArray = mysql_fetch_array($Result);   


  if (($feedback == 1) AND ($ResultArray[bus_confirmed] == 1)){  

[Hoangsta]

it doesn't work, but thanks for replying to my email

[drawmack]

if ($_POST['submit'] == 'Login') {
//you really should make sure they entered something 
//into the fields as well. Also rewritting the if like this is 
//less clicks
    if (strlen($_POST['user_name']) > 25 && strlen($_POST['password']) > 25) {
        $feedback = user_login();
    } else {
        $feedback = 'ERROR - Username and/or password are too long';
    } //end if

//this select statment has no where clause if you have
//any registered businesses in your database this will
//return rows. You need a where clause that returns
//this user's bus_confirmed id (0,1) if you post the
//structure of your table I'll help with that.
$query  = "SELECT bus_confirmed\n";
$query .= " FROM BusinessName\n";
$query .= " WHERE bus_confirmed = 1"; 
$result = mysql_query($query); 

if (($feedback == 1) && (mysql_num_rows($result) > 1)) {	
    // Register the input with the value
    $_SESSION['user_name'] = $_POST['user_name'];
    session_register("authr_user_name");
    $authr_user_name = $_POST['user_name'];
    // On successful login, redirect to homepage
    header("Location: A ");
} else {
    header("Location: B");	
} else {
    $feedback_str = "<P class=\"errormess\">$feedback</P>";
} //end if
} else {
    $feedback_str = '';
} //end if

please read my comments and implement my fix of your line 40

[Hoangsta]

I don't know how to bring up the sql for my table via php myadmin...

business_id int(11) No auto_increment

customer_id int(11) No 0

business_type tinytext Yes NULL

business_name tinytext Yes NULL

business_address tinytext Yes NULL

bus_city tinytext Yes NULL

businessacct_state_country tinytext Yes NULL

bus_zip tinytext Yes NULL

business_phone tinytext Yes NULL

business_fax tinytext Yes NULL

webpagelink tinytext Yes NULL

bus_confirmed int(4) Yes 0

date_created date Yes NULL

[Hoangsta]

somehow your code doesn't like

line 56: which is the first } else {

 } else { 
        $feedback_str = "<P class=\"errormess\">$feedback</P>"; 
    } //end if 
} else { 
    $feedback_str = ''; 
} //end if

[drawmack]

you should be using customer_id field in your where clause. You'll probably want to write the person's customer_id to a session variable for easy retrieval.

[Hoangsta]

all i wanted to do was to direct a user two have one of two directions:

if a new user logs in, that user needs to fill out a business registration form (o) in order to go to the homepage

else

continue to show the business registration form (o)

if that user has already registered a business (1),

then skip that business registration form and go directly to the homepage.

why should I use customer_id as a where clause with the given information above? All that I need to check for is bus_registered == 1? yeah? I don't know...i thought that my { else } would work, I have to debug now...ehahehehaeh. thanks for helping. appreciate it

[drawmack]

you need to know if this customer registered a business so you ask the database that by saying

SELECT bus_registered WERHE customer_id = <this customer's id>

you would need to < ... > with a php variable that holds this value.

[AshtrayWaterloo]

I think there's a big problem with the if statements here.

I count 3 if's and 4 else's.

This should work a little better:

if ($POST['submit'] == 'Login') {
//you really should make sure they entered something
//into the fields as well. Also rewritting the if like this is
//less clicks
if (strlen($POST['user_name']) > 25 && strlen($_POST['password']) > 25) {
$feedback = user_login();
} else {
$feedback = 'ERROR - Username and/or password are too long';
} //end if

//this select statment has no where clause if you have 
//any registered businesses in your database this will 
//return rows. You need a where clause that returns 
//this user's bus_confirmed id (0,1) if you post the 
//structure of your table I'll help with that. 
$query  = "SELECT bus_confirmed\n"; 
$query .= " FROM BusinessName\n"; 
$query .= " WHERE bus_confirmed = 1";  
$result = mysql_query($query);  

if (($feedback == 1) && (mysql_num_rows($result) > 1)) {     
    // Register the input with the value 
    $_SESSION['user_name'] = $_POST['user_name']; 
    session_register("authr_user_name"); 
    $authr_user_name = $_POST['user_name']; 
    // On successful login, redirect to homepage 
    header("Location: A "); 
} else { 
    header("Location: B");     
} 

} else {
$feedback_str = '';
} //end if

I've left this part out because it doesn't belong:
else {
$feedback_str = "<P class=\"errormess\">$feedback</P>";
} //end if

Hope this helps!

Ash

[Hoangsta]

hi ASh, actually, i left out some code on top of the form

if ($LOGGED_IN = user_isloggedin()) {
  user_logout();
  $_COOKIE['user_name'] = '';
  unset($LOGGED_IN);
}

that is why i have to add tis end

    } else { 
        $feedback_str = "<P class=\"errormess\">$feedback</P>"; 
    } //end if 
} else { 
    $feedback_str = ''; 
} //end if

also, i had to fix the code so that...

if (strlen($_POST['user_name']) <= 25 && strlen($_POST['password']) <=25) { 

would work or else anything less than 25 character will show an error message.

I also had to set

 if (($feedback == 1) && (mysql_num_rows($result) == 1)) {

I try to set it to

 if (($feedback == 1) && (mysql_num_rows($result) > 1)) {

it won't work, whenever i log in, it would just give me a 1 on the login page, won't go to my index.php

anything u can help me with????

[Hoangsta]

to be honest with you guys, i don't think the code works at all, i try to debug everything, changing the code to everything i can think of, i changed it to Ash's way then to drawmack
's...

if you guys have any example that I can work with, I would like to take that route and study the codes. i read my php books on if, elseif statement...i don't think that my code works for various reason...if the query statment is all wrong.

drawmack, I did check if a business already exists. i had one customer for many business relationship. sooo frustrated on my coding... 🙁