[FX.php List] RE: Do an "if" on found set ...

[VanBuskirk, Patricia]

Thanks Andrew!  I will play around with your ideas ... great info!

~ Trish


-----Original Message-----
From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Andrew Denman
Sent: Wednesday, September 08, 2010 3:42 PM
To: FX.php Discussion List
Subject: [FX.php List] RE: Do an "if" on found set ...

Patricia,

1. Is there a [0] missing from this bit of code that you say doesn't
work? I could not tell where in the page this code would go.
	if ($userData['ITEMNO']=='HGCATVHBO') {

2. It appears you are only pulling the current services for a user here.
To provide an add/remove option you need a list of all available
services and then compare the user's current services with the full
list. You'll have to play with the user data to get it in a usable
format to do the compare. I would put all of the user services into an
array and then use in_array().

// Get list of all services
// Get list of user services
// foreach user service IDs into an array
// foreach echo list of all services
	// echo service info
	// if( in_array(current_service_ID, user_service_IDs_array) )
		// provide remove button
	// else
		// provide add button

3. An aside: I believe you need to add [] to your checkbox names so you
get all of the values returned on the next page, otherwise PHP just uses
the value of the last selected box on the page.
	echo "Remove&nbsp;<input name='D_CableService[]' type='radio'
value='HGCATVHBO'>";
	echo "Add&nbsp;<input name='A_CableService[]' type='radio'
value='HGCATVHBO'>";

Andrew Denman


-----Original Message-----
From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of VanBuskirk,
Patricia
Sent: Wednesday, September 08, 2010 11:30 AM
To: FX.php Discussion List
Subject: [FX.php List] Do an "if" on found set ...

I have a FMFind as follows (on a user ID, it pulls back lines of items
for that user)

	$userQuery = new FX(FM_IP, FM_PORT, FM_VERSION);
	$userQuery->SetDBData('Webtest_Forms.fp7', 'MS_HG_SERVICES');
	$userQuery->SetDBUserPass(FM_USERNAME, FM_PASSWORD);
	$userQuery->AddDBParam ('USERID', $_SESSION['fsusn'], 'eq');
	$userResult=$userQuery->FMFind();

	foreach($userResult['data'] as $key=>$userData){
	$userDetails=explode('.',$key);
	$userRecord=$userDetails[0];
	}

Then I have each line show in a table as follows, which works great:

	<?php
	if ($_SESSION['found']>0) {     // If user exists

	echo "<table align='center' cellpadding='3' class='bordertable'>
                <tr><td align='center' colspan='4'
class='tableborderheading'>You presently have ".$_SESSION['found']."
service(s):</td></tr>
				<tr valign='bottom'>
					  <td align='left'
class='ColumnHeader'><b>Description</b></td>
					  <td align='center'
class='ColumnHeader'><b>Start Date</b></td>
					  <td align='right'
class='ColumnHeader'><b>Rate</b></td>
				</tr>";

	foreach($userResult['data'] as $key=>$userData){
	$userDetails=explode('.',$key);
	$userRecord=$userDetails[0];

	echo "<tr align='center'>
                  <td align='left'
nowrap>".strtoupper($userData['DESCRIPTION'] [0])."</td>
                  <td align='center'>".$userData['STARTDATE'] [0]."</td>
                  <td align='right'>".$userData['AMOUNT'] [0]."</td>
           </tr>";
	  }
	echo "</table><br>";
	}
	?>

Now what I'd like to do is ... if an item exists, then have the checkbox
be to Remove the item ... if not, it would be to add the item.  What
would the syntax be for something like that?  Do I have to do a find for
each item first?  

I tried the following, but it did not work:

	<?php

		if ($userData['ITEMNO']=='HGCATVHBO') {
			echo "Remove&nbsp;<input name='D_CableService'
type='radio' value='HGCATVHBO'>";
			} else {
			echo "Add&nbsp;<input name='A_CableService'
type='radio' value='HGCATVHBO'>";
			}

	?>
_______________________________________________
FX.php_List mailing list
FX.php_List at mail.iviking.org
http://www.iviking.org/mailman/listinfo/fx.php_list
_______________________________________________
FX.php_List mailing list
FX.php_List at mail.iviking.org
http://www.iviking.org/mailman/listinfo/fx.php_list