<?php

header('Content-Type: application/json; charset=utf-8');

$conn = mysqli_connect("localhost", "venmobdc_venmobduser","QU~v8pVdZdSS", "venmobdc_accountholder" );

mysqli_set_charset($conn, "utf8");

$sql= "SELECT * FROM holderDetails ";


$result= mysqli_query($conn,$sql);

$rowcount= mysqli_num_rows($result);


$data= array();
foreach($result as $item){
    $id=$item['id'];

    $firstname=$item['firstname'];
    $lastname=$item['lastname'];
    $gmail=$item['gmail'];
    
    
	$user_name=$item['user_name'];
	$short_name=$item['short_name'];
	$arrowSideOfname=$item['arrowSideOfname'];
	$qrcodeImage=$item['qrcodeImage'];
	
	
	
	

	$image=$item['image'];
	$Totaldollar=$item['Totaldollar'];
	$blanceBig=$item['blanceBig'];
	$blanceSmall=$item['blanceSmall'];
	$worning=$item['worning'];
	
	
	$howmuchnotification=$item['howmuchnotification'];
	$notificationOnOff=$item['notificationOnOff'];
	



	$userinfo['id']=$id;
    $userinfo['firstname']=$firstname;
    $userinfo['lastname']=$lastname;
    $userinfo['gmail']=$gmail;
	$userinfo['user_name']=$user_name;
	$userinfo['short_name']=$short_name;

	$userinfo['image']=$image;
	$userinfo['Totaldollar']=$Totaldollar;
	$userinfo['blanceBig']=$blanceBig;
	$userinfo['blanceSmall']=$blanceSmall;
	$userinfo['worning']=$worning;
	$userinfo['howmuchnotification']=$howmuchnotification;
	$userinfo['notificationOnOff']=$notificationOnOff;
	$userinfo['arrowSideOfname']=$arrowSideOfname;
	$userinfo['qrcodeImage']=$qrcodeImage;
					

	array_push($data,$userinfo);


}
echo json_encode($data);



?>