User Registration

lyme3m

Hello, I'm new here and new to PHP programming. This may be a simple question, but I need a variable that simply checks if a table is filled out for a logged in user. If the table is not filled out then it directs them to a page to fill it out. It will need to do this for three tables. If all tables are filled then it takes them to the user home. Any help is greatly appreciated!!

Thanks!!

Charlie

sheephat

if()

lyme3m

...it can't be that simple?? :/

sheephat

no, but the if function is what you would need.

If(field = filled in){then do nothing}

else{field is empty text}

This is what i would do as im only up to if/else in expierence.

If you are brand new to php then i advise you take alook at php.net and the documentation, there are a few good tutorials to get you started.

lyme3m

I'm back. I had to take a break from this project for a couple days...

I need an if statement. The if statement would look for the current users 'client_id' in the table 'client_billing_party'. If one matches then it would go onto the next variable. If not then it would redirect to a page to fill out the table 'client_billing_party'.

Does that make sense?? I feel like such a n00b...

Any help is appreciated!!

Charlie

schwim

Hi there,

This might be a good start for you:

$query = "SELECT * FROM client_billing_party WHERE client_id=$client_id";
$result_rows = mysql_num_rows($result);

/*Determine whether you have a record to work with*/

if($result_rows==0){

  /*Letting them know that no record was found and they need to fill out some schtuff*/
  echo("You need to <a href='here.html'>go here</a>.");

}else{

  /*Starting next check, since they passed the previous one*/
  Next check goes here.

}

I think that will work. I'm not the snazziest on the forum, but I am replying and that's got to count for something 😉

thanks,
json

sys4dm1n

lyme3m wrote:
I'm back. I had to take a break from this project for a couple days...

I need an if statement. The if statement would look for the current users 'client_id' in the table 'client_billing_party'. If one matches then it would go onto the next variable. If not then it would redirect to a page to fill out the table 'client_billing_party'.

Does that make sense?? I feel like such a n00b...

Any help is appreciated!!

Charlie

What type of interface is this for? It seems like it could be for a gateway of some type?

lyme3m

I guess you could call it a gateway...

The code supplied by schwim worked. Here is how it ended up because I added a header line to automatically load the next page to fill in.

<?php 
$query = "SELECT * FROM client_billing_party WHERE client_id=$client_id";
$result_rows = mysql_num_rows;

/*Determine whether you have a record to work with*/

if($result_rows==0){

header("location: client_billing_partyadd.php");

 /*Letting them know that no record was found and they need to fill out some stuff*/
 echo("You need to <a href='client_billing_partyadd.php'>go here</a>.");

}else{

}
?>

I've done this for two different tables.

Thanks!

Charlie

lyme3m

Actually now I'm having trouble doing a verification.

After one step in the registration I need to check a row 'is_an_agency_payee' in table 'client_billing_party' for a 0 or 1. If the row is 0 then I will direct to the clients home page, if the row is a 1 then I will direct the client to define the agency.

Thanks again Schwim!!

Charlie

schwim

<?php 
$query = "SELECT * FROM client_billing_party WHERE client_id=$client_id";
$result = mysql_query ($query) or die('MySQL error: ' . mysql_error() . '<hr/>' . $query);
$result_rows = mysql_num_rows($result);

/*Determine whether you have a record to work with*/

if($result_rows==0){

  header("location: client_billing_partyadd.php");

   /*Letting them know that no record was found and they need to fill out some stuff*/
   echo("You need to <a href='client_billing_partyadd.php'>go here</a>.");

}else{

  if($row['is_an_agency_payee']=='0'){
     echo('You must define an agency');
  }else{
     echo('You are being directed to the home page.');
  }
}
?>

That should do it, I think. I modified the mysql query at the top to actually get the data. Also, I would suggest that you define the actual tables to grab in that query, as '' is wasteful. I didn't, because I'm not sure if you need any more tables pulled. From the example above, you could turn into 'is_an_agency_payee' and be A-OK.

Hope this works for you,
json

lyme3m

I'm getting an error now....

Here is the code:

<?php
$query = "SELECT is_an_agency_payee FROM client_billing_party WHERE client_id=$client_id";
$result = mysql_query ($query) or die('MySQL error: ' . mysql_error() . '<hr/>' . $query);
$result_rows = mysql_num_rows($result);

/*Determine whether you have a record to work with*/

if($result_rows==0){

  header("location: client_agency_billing_linkadd.php");

   /*Letting them know that no record was found and they need to fill out some stuff*/
   echo("You need to <a href='client_agency_billing_linkadd.php'>go here</a>.");

}else{

  if($row['is_an_agency_payee']=='0'){
     echo('You must define an agency');
  }else{
     echo('You are being directed to the home page.');
  }
}
?>

Here is the error:

MySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1SELECT is_an_agency_payee FROM client_billing_party WHERE client_id=

Charlie

schwim

Hi there,

If you look at your error, it seems that your problem is that the client_id isn't getting passed to the query. Try manually entering a legitimate client_id there, and if your code works, then you know that the problem is with how you're retrieving your client_id.

thanks,
json

lyme3m

You're right, I entered in a valid client_id and it didn't error out. What would be another way to grab the right client_id? It is a foreign key in the table 'client_billing_party'.

Charlie

schwim

Hi there Charlie,

You stated that you're grabbing the data relating to a client ID, so you can't get the client_id from MySQL, because you're telling it what client_ID to grab 😃

If it's a log in system you're using, you can get it from the cookie and if they're submitting a form with their name, or some other identifier, then you can alter the WHERE clause in the mysql query to use that identifier instead.

Does that make sense?

thanks,
json

lyme3m

Well, I need it to look in the table client_billing_party for the foreign key client_id that matches the current logged in users client_id. Then look to see if a field in that same table, 'is_agency_payee' is a 0 or 1. The to proceed from there as we have discussed... Does that make sense?

Charlie

schwim

Hi there Charlie,

It does make sense, but you need to grab the id from the cookie, and not MySQL.

Someone is going to have to post how to do it correctly if I'm wrong about this, as I can no longer rembmer, but I wrote a script that used something like:

$client_id = $_COOKIE['client_id'];

I think that was how I did it. Just make sure the cookie actually has the client_id and not the client_name 🙂 If your cookie holds the client name, then you'll need to alter your WHERE clause in the mysql query to the name field, then add the client_id to the list of values it grabs.

thanks,
json

schwim

I should have mentioned:

An easy way to tell if it would work is to attempt to echo the values:

echo("Client ID is: ".$_COOKIE['client_id']);
echo("Client Name is: ".$_COOKIE['your_client_name_field']);

To find out what the cookie is holding.

thanks,
json

lyme3m

Hmmmm, this is the response

Client ID is: Client Name is:

schwim

Hi there Charlie,

That means that either those values aren't on the cookie OR you're using a log in system that this query isn't compatible with, which is a very good possibility because I often am wrong 😃

We need to find out what type of login system you're using(maybe sessions) and then figure out how to get the id you need.

I'm very weak with authentication scripts, so maybe someone can steer you better than I, but until someone speaks up, I would suggest that we find out how your users are logging in. What's the script look like where it places the cookie?

thanks,
json

lyme3m

I'm able to get the logged in user id this way

<?php echo $my->agency_id; ?>