PHP mymysqli::str 예제들

예제 #1

파일: site_add.php 프로젝트: offsky/angular2_learn

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

예제 #2

파일: mention_add.php 프로젝트: offsky/angular2_learn

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

예제 #3

파일: person_add.php 프로젝트: offsky/angular2_learn

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

예제 #4

파일: mention_edit.php 프로젝트: offsky/angular2_learn

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