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; }