PHP - Echo'ing Sql Result Over Multiple Table Columns

<?php
$servername="127.0.0.1";
$username="root";
$password="";
$dbname="testdb";
$connection = new mysqli($servername,$username,$password,$dbname);
$sql = "SELECT Wages FROM w WHERE \"Country\"=\"".$_POST["blah"]."\"";
$r = $connection->query($sql);
$result = $r->fetch_all(MYSQLI_ASSOC);
echo $result;
?>

Hello all,

   I am trying to learn OOP in PHP so please forgive my ignorance. I seem to be having difficulty inserting data into my database from checkbox items. My database has a column for each each fruit. I would like for each column to be populated with either a one(1) for checked or a zero(0)  for not checked. Currently, my attempts have failed. I can either get all checkboxes to insert all zeros or I can get the first column to insert a one(1) while the others as zeros. Is there anybody here that can help me figure out what I am doing wrong and help me to re-work my code so I can get this to work? If anybody can help me using OOP methods that would be fantastic. Thank you all in advance.

$preffruit->create_preffruit(array(

  'fruit_apple' => escape(Input::get(['fruit_selection'][0]) ? 1 : 0),
  'fruit_orange' => escape(Input::get(['fruit_selection'][1]) ? 1 : 0),
  'fruit_banana' => escape(Input::get(['fruit_selection'][2]) ? 1 : 0),
  'fruit_pear' => escape(Input::get(['fruit_selection'][3]) ? 1 : 0),
  'fruit_kiwi' => escape(Input::get(['fruit_selection'][4]) ? 1 : 0)

  ));

<input type="checkbox" name="fruit_selection[]" value="fruit_apple">
<input type="checkbox" name="fruit_selection[]" value="fruit_orange">
<input type="checkbox" name="fruit_selection[]" value="fruit_banana">
<input type="checkbox" name="fruit_selection[]" value="fruit_pear">
<input type="checkbox" name="fruit_selection[]" value="fruit_kiwi">



public function insert_preffruit($table, $fields = array()) {
			
			$keys = array_keys($fields);
			$values = '';
			$x = 1;			
			
			foreach($fields as $field) {
				$values .= '?';
				if($x < count($fields)) {
					$values .= ', ';
				}
				$x++;
			}		
				
				$sql = "INSERT INTO preffruit (`user_id`, `" . implode('`, `', $keys) . "`) VALUES (LAST_INSERT_ID(), {$values})";		
			
			if(!$this->query($sql, $fields)->error()) {
				return true;
			}			
			
			return false;
		}

$query = "SELECT `profile_privacy`  FROM `users` WHERE `user_username` = '$username'";
$result = mysql_query($query) or die($query."<br/><br/>".mysql_error());
$profile_privacy = mysql_result($result, 0);

$query = "SELECT `profile_privacy`, `profile_pictures`  FROM `users` WHERE `user_username` = '$username'";
$result = mysql_query($query) or die($query."<br/><br/>".mysql_error());
$profile_privacy = mysql_result($result, 0);
$profile_pictures = mysql_result($result, 1);

I'm wanting to output data into two columns.  I've searched for this in a few places.  A vast majority of the search results deal with getting data from multiple columns, and the the ones that deal with what I'm looking for don't really have any solutions attached to them.

I'm not fully worried about the columns being equal length.  The data is broken up into a certain number of rows in a given year.  I have about 12 years, probably 6-8 rows per year.  I just don't know how to get it into different columns.  I don't care if it goes left to right then down or down then left to right.

If there has been a solution to that here already, feel free to point me in that direction.  Point me in any applicable direction, I'd fine with.  I just can't locate anywhere what trigger would cause that.