<?php
$username = "root";
$password = "";
$hostname = "localhost";

$user = $_GET['userid'];

//mb_internal_encoding("ISO-8859-1");
//$string = "0123456789";
//$mystring = mb_substr($string,0,mb_strlen($string));
//echo $mystring;

//connection to the database
$dbhandle = new PDO('mysql:host=localhost;dbname=book4book;', $username, $password,array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'utf8'"));

  $sql = $dbhandle->prepare("select * from bookstogive where book_user_id = $user");
		 //echo "\nPDO::errorInfo():\n";
		 //print_r($dbhandle->errorInfo());
  $sql->execute();
  $results= $sql->fetchAll(PDO::FETCH_ASSOC);
  $json=json_encode($results);

  //echo mb_substr($json,0,mb_strlen($json));;
  $iso88591_1 = utf8_decode($json);
$iso88591_2 = iconv('UTF-8', 'ISO-8859-1', $json);
$iso88591_2 = mb_convert_encoding($json, 'ISO-8859-1', 'UTF-8');
  echo $iso88591_2;

  $sql->closeCursor();
  $sql = null;
  //$result = mysql_query($sql) or trigger_error(mysql_error()." in ".$sql);

//asdasdasd
//close the connection
$dbh = null;
?>