PHP - Database Or No Database? If No, How To Paginate?

<?PHP
require_once("./include/membersite_config.php");

if(!$fgmembersite->CheckLogin())
{
    $fgmembersite->RedirectToURL("login.php");
    exit;
}

?>
<form action="editform.php?id_user=<?= $fgmembersite->UserId() ?>" method="POST">
<input type="hidden" name="id_user" value="<?= $fgmembersite->UserId() ?>"><br>
Name:<br> <input type="text" name="name" size="40" value="<?= $fgmembersite->UserFullName() ?>"><br><br>
Email:<br> <input type="text" name="email" size="40" value="<?= $fgmembersite->UserEmail() ?>  "><br><br>
Address:<br> <input type="text" name="address" size="40" value="<?= $fgmembersite->UserAddress() ?>  "><br><br>

<button>Submit</button>

<?php

$con = mysqli_connect("localhost","root","user","pass");

if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

mysqli_query($con,"UPDATE fgusers3 SET name = '".$_POST['name']."', email= '".$_POST['email']."', address= '".$_POST['address']."' WHERE id_user='".$_POST['id_user']."'");



header("Location: test.php");

?>

the second database found on the cloud

i try to get JSON data but how to insert and update  them to another online database with the same table

my php script to return json data 

<?php        

 include_once('db.php');

        $users = array();

        $users_data = $db -> prepare('SELECT id, username FROM  users');

        $users_data -> execute();

        while($fetched = $users_data->fetch()) {

            $users[$fetchedt['id']] = array (

                'id' => $fetched['id'],

                'username' => $fetched['name']

            );

        }

        echo json_encode($leaders);

i get

{"1":{"id":1,"username":"jeremia"},"2":{"id":2,"username":"Ernest"}}

DATE(date_add)
2014-01-07
2014-01-07
2014-01-07
2014-01-07
2014-01-08
2014-01-15
2014-01-20
2014-01-20
2014-01-20
2014-01-26
2014-01-28
2014-02-16
2014-02-16
2014-02-16
2014-02-16
2014-02-16
2014-02-16
2014-02-16
2014-02-18
2014-02-18
2014-03-08
2014-03-08

 $tableName="records";        

    $targetpage = "sales.php";     

    $limit = 1000;

    $cur_month = date("Y-m");


         $query = "SELECT COUNT(*) as num FROM $tableName  WHERE Customer_Status = 'Sale' AND DATE_FORMAT(Date, '%Y-%m') = '$cur_month' ORDER BY id DESC";

    $total_pages = mysql_fetch_array(mysql_query($query));

    $total_pages = $total_pages[num];

    

    $stages = 1;

    $page = mysql_escape_string($_GET['page']);

    if($page){

        $start = ($page - 1) * $limit;

    }else{

        $start = 0;    

        }    

    

    // Get page data

    $query1 = "SELECT id, Date, User, Team, Transfer_Number, Agent_Name, Cell_Phone, Customer_Name, Customer_Status FROM $tableName WHERE Customer_Status = 'Sale' AND DATE_FORMAT(Date, '%Y-%m') = '$cur_month' ORDER BY id DESC LIMIT $start, $limit";

    $result = mysql_query($query1);

    

    // Initial page num setup

    if ($page == 0){$page = 1;}

    $prev = $page - 1;    

    $next = $page + 1;                            

    $lastpage = ceil($total_pages/$limit);        

    $LastPagem1 = $lastpage - 1;    

    

    $paginate = '';

    if($lastpage > 1)

    {    

    $paginate .= "<div class='paginate'>";

        // Previous

        if ($page > 1){

            $paginate.= "<a href='$targetpage?page=$prev'>previous</a>";

        }else{

            $paginate.= "<span class='disabled'>previous</span>";    }

                

        // Pages    

        if ($lastpage < 7 + ($stages * 2))    // Not enough pages to breaking it up

        {    

            for ($counter = 1; $counter <= $lastpage; $counter++)

            {

                if ($counter == $page){

                    $paginate.= "<span class='current'>$counter</span>";

                }else{

                    $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}                    

            }

        }

        elseif($lastpage > 5 + ($stages * 2))    // Enough pages to hide a few?

        {

            // Beginning only hide later pages

            if($page < 1 + ($stages * 2))        

            {

                for ($counter = 1; $counter < 4 + ($stages * 2); $counter++)

                {

                    if ($counter == $page){

                        $paginate.= "<span class='current'>$counter</span>";

                    }else{

                        $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}                    

                }

                $paginate.= "...";

                $paginate.= "<a href='$targetpage?page=$LastPagem1'>$LastPagem1</a>";

                $paginate.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>";        

            }

            // Middle hide some front and some back

            elseif($lastpage - ($stages * 2) > $page && $page > ($stages * 2))

            {

                $paginate.= "<a href='$targetpage?page=1'>1</a>";

                $paginate.= "<a href='$targetpage?page=2'>2</a>";

                $paginate.= "...";

                for ($counter = $page - $stages; $counter <= $page + $stages; $counter++)

                {

                    if ($counter == $page){

                        $paginate.= "<span class='current'>$counter</span>";

                    }else{

                        $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}                    

                }

                $paginate.= "...";

                $paginate.= "<a href='$targetpage?page=$LastPagem1'>$LastPagem1</a>";

                $paginate.= "<a href='$targetpage?page=$lastpage'>$lastpage</a>";        

            }

            // End only hide early pages

            else

            {

                $paginate.= "<a href='$targetpage?page=1'>1</a>";

                $paginate.= "<a href='$targetpage?page=2'>2</a>";

                $paginate.= "...";

                for ($counter = $lastpage - (2 + ($stages * 2)); $counter <= $lastpage; $counter++)

                {

                    if ($counter == $page){

                        $paginate.= "<span class='current'>$counter</span>";

                    }else{

                        $paginate.= "<a href='$targetpage?page=$counter'>$counter</a>";}                    

                }

            }

        }

                    

                // Next

        if ($page < $counter - 1){

            $paginate.= "<a href='$targetpage?page=$next'>next</a>";

        }else{

            $paginate.= "<span class='disabled'>next</span>";

            }

            

        $paginate.= "</div>";        

        

}



echo "Total Records:".$total_pages;

echo '<br/><br/>';

 // pagination

 echo $paginate;


 }

</div><!-- AJAX return container-->

    	<nav class="pagenav">
			<ul id="pag-link">
				<li class="old"><?php next_posts_link('&laquo; Older Sermons', $sermons_query->max_num_pages) ?></li>
				<li class="new"><?php previous_posts_link('Newer Sermons &raquo;', $sermons_query->max_num_pages) ?></li>
			</ul>
		</nav>	

	//Listen for the menu's to change except the main filter_by dropdown
	var ids = ['filter_preacher_dropdown', 'filter_sort_by_dropdown', 'filter_per_page_dropdown', 
	'filter_series_dropdown', 'filter_service_dropdown', 'filter_tag_dropdown', 'filter_book_dropdown', 'filter_year_dropdown'];
	$('#' + ids.join(',#')).change(function(e) {
		var pt = [ "preacher","series","service" ];
		if($.inArray(this.name, pt)!==-1){
		var mk 	= this.name;
		var mv 	= $(this).val();
		var ppp = $("#filter_per_page_dropdown").val();
		var ob 	= $("#filter_sort_by_dropdown").val();
		var data = {
			action: 'filter_sermons', 
			meta_key: mk, 
			meta_value: mv, 
			posts_per_page: ppp
			};
			$.post(mbsb_ajaxurl, data, function(response) {
				$('#sermonlists').fadeOut('slow', function() {
					$(this).html(response)
				}).fadeIn('slow');
			});
		}

//ajax for sermons filter
add_action('wp_ajax_filter_sermons', 'check_ajax'); 
add_action('wp_ajax_nopriv_filter_sermons', 'check_ajax');


function check_ajax() {
	global $wpdb, $paged, $max_num_pages;
//check if filter is on post_type
if($_POST['meta_key']){
	$paged = (get_query_var('paged')) ? get_query_var('paged') : 1;
	$mk = '"'.$_POST['meta_key'].'"';
	$mv = intval($_POST['meta_value']);
	$ppp = intval($_POST['posts_per_page']);
	$offset = ($paged - 1) * $ppp;
	$sermons = $wpdb->get_results("SELECT SQL_CALC_FOUND_ROWS sermons.* FROM {$wpdb->prefix}posts AS sermons, {$wpdb->prefix}postmeta WHERE meta_key = {$mk} AND meta_value = {$mv} AND sermons.ID = {$wpdb->prefix}postmeta.post_id LIMIT {$offset}, {$ppp}", OBJECT);
	$sql_posts_total = $wpdb->get_var( "SELECT FOUND_ROWS();" );
    $max_num_pages = ceil($sql_posts_total / $ppp);	
}elseif($_POST['name']){	
	//another custom query
}elseif ($_POST['book_number']){
	//another custom query

}
    $posts = get_posts();                		// returns posts in an array

	if($sermons) {
		global $post; 
		foreach ($sermons as $post){
		setup_postdata($post); 
		
			//custom query info returned here
		}

          //Would the Pagination for the AJAXED content go here?

	}else{ ?>
    <h2 class="center">Not Found</h2>
    <p class="center">Sorry, but you are looking for something that isn't here.</p>
 <?php 
 } 

	die();
}