Jump to content

Returning HTML in a php function


thomasw_lrd

Recommended Posts


//policies subreport
function opportunity_sub_report($business_contact_id){
global $edit, $styles;
$sql="Select * from opportunities WHERE op_business_contact_id='$business_contact_id'";
$rs=myload($sql);

echo '<table>';
if (count($rs)>0){
	// print a header row
	echo '<tr>
					<td>Opportunity ID</td>
					<td>Category</td>
					<td>Agent</td>
					<td>Opportunity Name</td>
					<td>Priority</td>
					<td>Assigned To</td>
					<td>Opportunity Type</td>
					<td>Opporunity Status</td>
					<td>Opportunity Submission</td>
					<td>Due Date</td>
					<td>Contracting Recieved(Y or N)?</td>
					<td>New Business</td>
					<td>Notes</td>
					<td>Business Contact ID</td>
				</tr>';

	// print all data rows
	foreach ($rs as $r){
	echo '<tr>
					<td>'.display_field('', $p,$r['op_id']).'</td>
					<td>'.display_field('',$p,$r['op_category']).'</td>
					<td>'.display_field('', $p,$r['op_agent_id']).'</td>
					<td>'.display_field('', $p, $r['op_opportunity_name']).'</td>
					<td>'.display_field('', $p, $r['op_priority']).'</td>
					<td>'.display_field('', $p, $r['op_assigned_to']).'</td>
					<td>'.display_field('', $p, $r['op_opportunity_type']).'</td>
					<td>'.display_field('', $p, $r['op_status']).'</td>
					<td>'.display_field('', $p, $r['op_submission_date']).'</td>
					<td>'.display_field('', $p, $r['op_due_date']).'</td>
					<td>'.display_field('', $p, $r['op_contracting_received_y_or_n']).'</td>
					<td>'.display_field('', $p, $r['op_new_business_app_received_y_or_n']).'</td>
					<td>'.display_field('', $p, $r['op_wholesaler_notes']).'</td>
					<td>'.display_field('', $p, $r['op_business_contact_id']).'</td>
				</tr>';
	}

}
echo '</table>';


}

 

I'm having some trouble with some code I'm tasked with maintaining.  This code works, but it doesn't return the information in a tab.  I'm using tabber.js 

It's being called here

 

echo '
	<tr>
		<td class="timegrid" colspan=5>
			<div class="tabber">
				<div class="tabbertab" title="Contracting"></div>
				<div class="tabbertab" title="Licensing"></div>
				<div class="tabbertab" title="Cases"></div>
				<div class="tabbertab" title="Commissions"></div>
				<div class="tabbertab" title="Opportunities">'.opportunity_sub_report($rs[0][bc_business_contact_id]).'</div>
				<div class="tabbertab" title="Tasks"></div>
				<div class="tabbertab" title="Calendar"></div>
				<div class="tabbertab" title="Attachments">'.agent_detail_attachments($rec_id).'</div>
			</div>
		</td>
		</tr>';

echo '</table>';

I've tried changing it from echo to return, but I'm not sure how to keep the foreach loop intact in such a way.  I'm trying to create subreports in a web app, that would act like access.  Any help would be much appreciated.

 

 

Link to comment
https://forums.phpfreaks.com/topic/247204-returning-html-in-a-php-function/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.