<?php
class Conect {
    public static function con() {
        try {
            $pdo = new PDO("mysql:dbname=user;host=localhost", "root[![introducir la descripción de la imagen aquí][1]][1]", "******");
            $pdo->query("SET NAMES 'utf8'");
            return $pdo;
        } catch (PDOException $e) {
            echo $e->getMessage();
            exit;
        }
    }
}

function get_noticias(){

    $con = Conect::con();

    $sql = "SELECT * FROM personas;";
    $datos = $con->prepare($sql);
    $datos->execute();
    header("Content-Type: application/json; charset=UTF-8");
    return json_encode($datos->fetchAll(PDO::FETCH_ASSOC));
}

function insertPersona(){

    $boton = $_REQUEST['boton'];

    if ($boton == "btnEnviar"){
        $con = Conect::con();
        $nombre = $_REQUEST['Nombre'];
        $edad = $_REQUEST['Edad'];
        $ciudad = $_REQUEST['Ciudad'];

        $sql = "INSERT INTO personas (Nombre, Edad, Ciudad) VALUES (?, ?, ?);";
        $datos = $con->prepare($sql);
        $datos->bindParam(1, $nombre, PDO::PARAM_STR);
        $datos->bindParam(2, $edad, PDO::PARAM_STR);
        $datos->bindParam(3, $ciudad, PDO::PARAM_STR);
        $datos->execute();
    }
}

function misProductos(){
    $boton = $_REQUEST['boton'];

    if ($boton == "btnMisProductos"){

        $con = Conect::con();
        $user_id = $_REQUEST['user_id'];

        $sql = "SELECT titulo, descripcion, precio, stock from avisos WHERE user_id = ?";
        $datos = $con->prepare($sql);
        $datos->bindParam(1, $user_id, PDO::PARAM_INT);
        $datos->execute();
        header("Content-Type: application/json; charset=UTF-8");
        return json_encode($datos->fetchAll(PDO::FETCH_ASSOC));
    }
}

function login(){
    $boton = $_REQUEST['boton'];
    if ($boton == "btn_entrar"){
        $con = Conect::con();
        $email = $_REQUEST['email'];
        $password = $_REQUEST['password'];

        $sql = "SELECT * FROM users WHERE email = ? and password = ?;";
        $datos = $con->prepare($sql);
        $datos->bindParam(1, $email, PDO::PARAM_STR);
        $datos->bindParam(2, $password, PDO::PARAM_STR);
        $datos->execute();

        if ($datos->rowCount() > 0 ) {
            echo "login ok";
        } else{
            echo "login error";
        }
    }
}



function all_tiendas(){
    $boton = $_REQUEST['boton'];
    if ($boton == "btnAllTiendas"){
        $con = Conect::con();


        $sql = "SELECT * FROM tienda;";
        $datos = $con->prepare($sql);
        $datos->execute();

        header("Content-Type: application/json; charset=UTF-8");
        return json_encode($datos->fetchAll(PDO::FETCH_ASSOC));
    }
}

function mis_tiendas(){
    $boton = $_REQUEST['boton'];
    if ($boton == "btnMisTiendas"){
        $con = Conect::con();
        $user_id = $_REQUEST['user_id'];

        $sql = "SELECT * FROM tienda WHERE user_id = ?;";
        $datos = $con->prepare($sql);
        $datos->bindParam(1, $user_id, PDO::PARAM_INT);
        $datos->execute();
        header("Content-Type: application/json; charset=UTF-8");
        return json_encode($datos->fetchAll(PDO::FETCH_ASSOC));
    }
}

function basica(){
    $boton = $_REQUEST['boton'];
    if ($boton == ""){
        $con = Conect::con();
        $a = $_REQUEST[''];


        $sql = "";
        $datos = $con->prepare($sql);
        $datos->execute();
    }
}

echo login();
echo insertPersona();
echo misProductos();
echo all_tiendas();
echo mis_tiendas();