File Contents: /home/planet5/public_html/tracking/tracking202/ajax/copy_of_ppc_accounts.php

<?php include_once(str_repeat("../", 2).'202-config/connect.php');

AUTH::require_user();

$mysql['ppc_network_id'] = $db->real_escape_string($_POST['ppc_network_id']);      
		$mysql['user_id'] = $db->real_escape_string($_SESSION['user_id']);
		$ppc_account_sql = "SELECT * FROM `202_ppc_accounts` WHERE `user_id`='".$mysql['user_id']."' AND `ppc_network_id`='".$mysql['ppc_network_id']."' AND `ppc_account_deleted`='0' ORDER BY `ppc_account_name` ASC";
		$ppc_account_result = $db->query($ppc_account_sql) or record_mysql_error($ppc_account_sql);

if ($ppc_account_result->num_rows == 0) {
		
			echo '<select class="form-control input-sm" id="ppc_account_id" disabled="">
			            <option>--</option>
			      </select>';
		
		} else { ?>
		
		<select class="form-control input-sm" name="ppc_account_id" id="ppc_account_id">			
			<option value=""> -- </option> <?php 		
			while ($ppc_account_row = $ppc_account_result->fetch_array(MYSQLI_ASSOC)) {
	
				$html['ppc_account_id'] = htmlentities($ppc_account_row['ppc_account_id'], ENT_QUOTES, 'UTF-8');
				$html['ppc_account_name'] = htmlentities($ppc_account_row['ppc_account_name'], ENT_QUOTES, 'UTF-8');
				
                if ($_POST['ppc_account_id'] == $ppc_account_row['ppc_account_id']) {
					$selected = 'selected=""';   
				} else {
					$selected = '';  
				}
                
				printf('<option %s value="%s">%s</option>', $selected, $html['ppc_account_id'], $html['ppc_account_name']);  
	
			} ?>
		</select>
	<?php }

⬅ Back to Directory