ho usato count .. ma non so come mai , non ricevo nessun errore ma non funziona e non mi stampa la frase "404".
Codice: Seleziona tutto
<?php
include($_SERVER["DOCUMENT_ROOT"] . "/inc.php");
session_start();
use Medoo\Medoo;
// Initialize
$database = new Medoo([
'database_type' => 'mysql',
'database_name' => 'test',
'server' => 'localhost',
'username' => 'root',
'password' => 'root'
]);
if(isset($_POST["login"]))
{
if(empty($_POST["email"]))
{
echo '404 email';
}else if(empty($_POST["password"]))
{
echo '404 password';
}else {
$data = $database->select('users', [
'forename',
'surname',
'email',
'password'
], [
'email' => ''.$_POST["email"].'',
'password' => ''.$_POST["password"].''
]);
$count = $database->count("users");
if($count>0)
{
foreach ($data as $user) {
$_SESSION["login"] = true;
$_SESSION["user_email"] = $user["email"];
$_SESSION["user_forename"] = $user["forename"];
$_SESSION["user_surname"] = $user["surname"];
}
}else {
echo '404';
}
}
}
?>
<form action="medoo.php" method="post">
<input type="text" name="email">
<input type="text" name="password">
<input type="submit" name="login" value="Accedi">
</form>
il db è questo:
Codice: Seleziona tutto
CREATE TABLE users ( id INT UNSIGNED NOT NULL AUTO_INCREMENT ,
forename VARCHAR(50) NOT NULL ,
surname VARCHAR(50) NOT NULL ,
email VARCHAR(50) NOT NULL ,
password VARCHAR(50) NOT NULL ,
created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
updated_at TIMESTAMP NULL DEFAULT NULL ,
PRIMARY KEY (id), UNIQUE (email)) ENGINE = InnoDB;
INSERT INTO users (id,
forename,
surname,
email,
password,
created_at,
updated_at) VALUES (
NULL,
'John',
'Doe',
'john@doe.com',
'qwertz',
CURRENT_TIMESTAMP, NULL);
Vi ringrazio molto aspetto risposta e buona serata.