My connection file is like this:
conect.php
<?php
// Connect PHP PDO
$connect = 'mysql:host=localhost;dbname=comidas';
try {
$db = new PDO($connect,'root','');
$db->setattribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e)
{
echo $e->getMessage();
}
?>
my query file is this way, separate rations in a faculty.
income.php
<?php
include ('conect.php');
if (isset($_GET['login']) AND isset($_GET['login'])) {
$login = $_GET['login'];
$password = $_GET['password'];
}else{
$login="";
$password="";
}
$queryselectusuario = 'SELECT * FROM cuentas WHERE cuenta = :cuenta AND contraseña = :contraseña';
$queryusuario = $db-> prepare($queryselectusuario);
$queryusuario -> bindValue(':cuenta', $login , PDO::PARAM_STR);
$queryusuario -> bindValue(':contraseña', $password , PDO::PARAM_STR);
$queryusuario -> execute();
$i=0;
while ($resusuario = $queryusuario -> fetch (PDO::FETCH_OBJ)) {
$i++;
$Usuarios[] = array ('id'=>$resusuario-> id,'faculdad'=>$resusuario-> apodo, 'correo'=> $resusuario->correo, 'respuesta'=>$resusuario->comida);
}
if($i==0){
$Usuarios[] = array ('id'=>'','facultad'=>'','correo'=> '', 'comida'=>'');
}
$json_string = json_encode($Usuarios);
$json_string = '{"length":'.$i.',"result":'.$json_string.'}';
echo $json_string;
?>
I was looking for some reference but I would not know how to use it I leave it to you
#Charset
$SQL ="
SET character_set_results = 'utf8',
character_set_client = 'utf8',
character_set_connection = 'utf8',
character_set_database = 'utf8',
character_set_server = 'utf8'
";
$db->execute($SQL);
$db->setCharset('utf8');
$db->setFetchMode(ADODB_FETCH_ASSOC);