Simple and Small Project in Php

Hello i have a code which is written in mysqli function in PHP but i want to change in param and bind and execute in php look like $number_filter_row = mysqli_num_rows(mysqli_query($connect, $query)); But i want to change it on $cpc3 = NULL; $cpc3 = $_POST["search"]["value"]; $cpc3 = "%$cpc3%"; $cpc3 = "'". $cpc3. "'"; $nrs=$cn->prepare($query); $nrs->bind_param("sssss",$cpc3,$cpc3,$cpc3,$cpc3,$cpc3); $nrs->execute(); $nrt = $nrs->get_result(); while($row = $nrt->fetch_assoc()) { $number_filter_row = $row['row']; } ANd all code is here:- <?php //[login to view URL] $connect = mysqli_connect("localhost", "root", "", "test"); $columns = array('meg', 'cpc' ,'os' , 'qa' , 'finance'); $query = "SELECT * FROM user "; if(isset($_POST["search"]["value"])) { $query .= ' WHERE meg LIKE "%'.$_POST["search"]["value"].'%" OR cpc LIKE "%'.$_POST["search"]["value"].'%" OR os LIKE "%'.$_POST["search"]["value"].'%" OR qa LIKE "%'.$_POST["search"]["value"].'%" OR finance LIKE "%'.$_POST["search"]["value"].'%" '; } if(isset($_POST["order"])) { $query .= 'ORDER BY '.$columns[$_POST['order']['0']['column']].' '.$_POST['order']['0']['dir'].' '; } else { $query .= 'ORDER BY id DESC '; } $query1 = ''; if($_POST["length"] != -1) { $query1 = 'LIMIT ' . $_POST['start'] . ', ' . $_POST['length']; } $number_filter_row = mysqli_num_rows(mysqli_query($connect, $query)); print $query $result = mysqli_query($connect, $query . $query1); $data = array(); while($row = mysqli_fetch_array($result)) { $sub_array = array(); $sub_array[] = '<div contenteditable class="update" data-id="'.$row["id"].'" data-column="meg">' . $row["meg"] . '</div>'; $sub_array[] = '<div contenteditable class="update" data-id="'.$row["id"].'" data-column="cpc">' . $row["cpc"] . '</div>'; $sub_array[] = '<div contenteditable class="update" data-id="'.$row["id"].'" data-column="os">' . $row["os"] . '</div>'; $sub_array[] = '<div contenteditable class="update" data-id="'.$row["id"].'" data-column="qa">' . $row["qa"] . '</div>'; $sub_array[] = '<div contenteditable class="update" data-id="'.$row["id"].'" data-column="finance">' . $row["finance"] . '</div>'; $sub_array[] = '<img src="[login to view URL]" id="'.$row["id"].'" class="delete" style="text-align:center">'.'<img src="[login to view URL]" id="'.$row["id"].'" class="edit" style="padding-left:10px;">'; $data[] = $sub_array; } function get_all_data($connect) { $query = "SELECT * FROM user"; $result = mysqli_query($connect, $query); return mysqli_num_rows($result); } $output = array( "draw" => intval($_POST["draw"]), "recordsTotal" => get_all_data($connect), "recordsFiltered" => $number_filter_row, "data" => $data ); echo json_encode($output); ?> So if anyone can do it then please let lme know Thanks