Drupal: PHP field for allowed values

Question

I'm working in Drupal 6 with CCK. Under each text field there is a PHP section where you can run some PHP code to get allowed values. I'm running into trouble using an "if" statement to change the allowed values based on user type

So to start, I do a query to determine current users user type. -1 is default user, which is employees and user type id "1", is for site users. What I want is to restrict the site user to only the allowed values they need to see, while allowing employees to edit that value when on the node edit screen with all choices.

The first part of the if statement works. However, the "else" part doesn't work. Is this field set up to deal with control structures?

global $user;
$sql1 = "SELECT user_type_id FROM user_types_user WHERE uid = ".$user->uid." ";
$res1 = db_query($sql1);
if($res1 == '1'){
$sql = "SELECT account FROM users WHERE uid = ".$user->uid." ";
$res = db_query($sql);
while($row = db_fetch_array($res)){
$rows[] = $row['account'];
}
$rows = drupal_map_assoc($rows);
return $rows;
}
else {
$sql2 = "SELECT title FROM node WHERE type = 'accounts' ";
$res2 = db_query($sql2);
while($row2 = db_fetch_array($res2)){
$rows2[] = $row2['title'];
}
$rows2 = drupal_map_assoc($rows2);
return $rows2;
}

The choices are type=accounts in nodes, however, when a user is created one of the choices is selected and stored in the user table, under a column I created named "account"

Simon · Accepted Answer · 2009-12-21 23:41:03Z

1

If by 'the "else part does not work' you mean that it is never executed, even if user_type_id does not equal 1, it might be the missing db_fetch_array() on $res1. You're comparing your result object directly to the string '1', not the field value.

answered Dec 21, 2009 at 23:41

Simon

12.5k4 gold badges37 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

tpow Over a year ago

You are the man! Just so I'm straight, the problem was that the result of my array was an integer, but I was trying to compare it to a string? So, even thought they were the same, they weren't equal?

Simon Over a year ago

I'm not exactly sure what happens, but PHP hat some weird rules for comparison when types don't match (see the docs at php.net/manual/en/language.operators.comparison.php). Drupal's db_query seems to return a resource, which is converted to a number (probably 1). If adding db_fetch_array helps, great :-) I tripped over comparison problems more than once...

tpow · Accepted Answer · 2009-12-22 00:03:12Z

0

Here is the working code for this. There may have been a quicker/shorter way to do this.

global $user;
$sql1 = "SELECT user_type_id FROM user_types_user WHERE uid = ".$user->uid." ";
$res1 = db_query($sql1);
while($type = db_fetch_array($res1)){
$types[] = $type['user_type_id'];
}
$resType = $types[0];
if($resType == "1"){
$sql = "SELECT account FROM users WHERE uid = ".$user->uid." ";
$res = db_query($sql);
while($row = db_fetch_array($res)){
$rows[] = $row['account'];
}
$rows = drupal_map_assoc($rows);
return $rows;
}
else {
$sql2 = "SELECT title FROM node WHERE type = 'accounts' ";
$res = db_query($sql2);
while($row2 = db_fetch_array($res)){
$rows2[] = $row2['title'];
}
return $rows2;
}

answered Dec 22, 2009 at 0:03

tpow

7,92411 gold badges62 silver badges86 bronze badges

Collectives™ on Stack Overflow

Drupal: PHP field for allowed values

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related