function created()
{
$site = new site();
$site->name = $_POST['name'];
$site->bonus_type = $_POST['bonus_type'];
$site->bonus_max = $_POST['bonus_max'];
$site->convert_rate = $_POST['convert_rate'];
$site->affiliate_url = "";
$site->url = "";
$site->comment = $_POST['comment'];
$site->create();
header("location: index.php");
}
$stmt->execute();
$row = $stmt->fetchall(PDO::FETCH_CLASS, 'site');
return $row;
} catch (PDOException $e) {
echo 'ERROR: ' . $e->getMessage();
}
}
function create()
{
try {
$conn = new PDO(PDOCONNECT, PDOUSERNAME, PDOPASSWORD, array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8'));
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$stmt = $conn->prepare('INSERT INTO sites SET name=:name,comment=:comment');
$stmt->execute(array("name" => $this->name, "comment" => $this->comment));
return $conn->lastInsertId();
} catch (PDOException $e) {
echo 'ERROR: ' . $e->getMessage();
}
}
}
if (isset($_GET['c']) && $_GET['c'] == "create") {
$site = new site();
$site->name = $_POST['name'];
$site->comment = $_POST['comment'];
$id = $site->create();
return $id;
} elseif (isset($_GET['c']) && $_GET['c'] == "all") {
$sites = site::all();
echo json_encode($sites);
exit;
}
