<?php /* */ require_once "../config/vars.php"; $db = new mymysqli("presstracker"); if (empty($_POST['site'])) { exit(0); } $site = json_decode($_POST['site']); $name = $db->str($site->name); $url = $db->str($site->url); $twitter = $db->str($site->twitter); $facebook = $db->str($site->facebook); $google = $db->str($site->google); $email = $db->str($site->email); $id = 0; if (!empty($name)) { $rs = $db->query("INSERT INTO sites(name,url,twitter,facebook,google,email) VALUES('" . $name . "','" . $url . "','" . $twitter . "','" . $facebook . "','" . $google . "','" . $email . "')"); $id = $db->lastID(); } echo $id;
<?php /* */ require_once "../config/vars.php"; $db = new mymysqli("presstracker"); if (empty($_POST['person'])) { exit(0); } $person = json_decode($_POST['person']); $name = $db->str($person->name); $email = $db->str($person->email); $twitter = $db->str($person->twitter); $facebook = $db->str($person->facebook); $google = $db->str($person->google); $id = 0; if (!empty($name)) { $rs = $db->query("INSERT INTO people(name,email,twitter,facebook,google) VALUES('" . $name . "','" . $email . "','" . $twitter . "','" . $facebook . "','" . $google . "')"); $id = $db->lastID(); } echo $id;
<?php /* */ require_once "../config/vars.php"; $db = new mymysqli("presstracker"); $rs = $db->query("SELECT * FROM belongs"); $rows = array(); while ($row = $db->getNext($rs, 1)) { $rows[] = $row; } echo json_encode($rows);
<?php /* */ require_once "../config/vars.php"; $db = new mymysqli("presstracker"); $rs = $db->query("SELECT * FROM sites"); $sites = array(); while ($row = $db->getNext($rs, 1)) { $sites[] = $row; } echo json_encode($sites);
<?php /* */ require_once "../config/vars.php"; $db = new mymysqli("presstracker"); if (empty($_POST['mention'])) { exit(0); } $mention = json_decode($_POST['mention']); $url = $db->str($person->url); $id = 0; if (!empty($url)) { $rs = $db->query("INSERT INTO mentions(url) VALUES('" . $url . "')"); $id = $db->lastID(); } echo $id;
<?php /* */ require_once "../config/vars.php"; $db = new mymysqli("presstracker"); $rs = $db->query("SELECT * FROM people"); $sites = array(); while ($row = $db->getNext($rs, 1)) { $sites[] = $row; } echo json_encode($sites);
<?php /* */ require_once "../config/vars.php"; $db = new mymysqli("presstracker"); $rs = $db->query("SELECT * FROM mentions"); $sites = array(); while ($row = $db->getNext($rs, 1)) { $sites[] = $row; } echo json_encode($sites);
<?php /* */ require_once "../config/vars.php"; $db = new mymysqli("presstracker"); if (empty($_POST['site'])) { exit(0); } $site = intval($_POST['site']); $belongs = json_decode($_POST['belongs']); if (!empty($site)) { $db->query("DELETE from belongs WHERE site=" . $site); foreach ($belongs as $v) { if ($v) { $db->query("INSERT INTO belongs(site,person) VALUES(" . $site . "," . intval($v->id) . ")"); } } echo 1; } else { echo 0; }
<?php /* */ require_once "../config/vars.php"; $db = new mymysqli("presstracker"); if (empty($_POST['site'])) { exit(0); } $site = json_decode($_POST['site']); $id = intval($site->id); $name = $db->str($site->name); $url = $db->str($site->url); $twitter = $db->str($site->twitter); $facebook = $db->str($site->facebook); $google = $db->str($site->google); $email = $db->str($site->email); if (!empty($id)) { $rs = $db->query("UPDATE sites set name='" . $name . "', url='" . $url . "', twitter='" . $twitter . "', facebook='" . $facebook . "', google='" . $google . "', email='" . $email . "' WHERE id=" . $id); echo 1; } else { echo 0; }
<?php /* */ require_once "../config/vars.php"; $db = new mymysqli("presstracker"); if (empty($_POST['mention'])) { exit(0); } $mention = json_decode($_POST['mention']); $id = intval($mention->id); $url = $db->str($mention->url); if (!empty($id)) { $rs = $db->query("UPDATE mentions set url='" . $url . "' WHERE id=" . $id); echo 1; } else { echo 0; }