public static function removeProduct($barcode, $expiration)
{
$mysql = new Mysql();
$update = $mysql->update("delete from product where barcode='{$barcode}' and expiration='{$expiration}'");
$mysql->closeConnection();
return $update;
}
public static function save(Music $music)
{
$data = ['id' => $music->id, 'band' => $music->band_name, 'album' => $music->album_name, 'year' => $music->year];
if ($data['id'] !== null) {
Mysql::update('UPDATE music SET band_name = ?, album_name = ?, year = ? WHERE id = ?', [$data['band'], $data['album'], $data['year'], $data['id']]);
} else {
Mysql::insert('INSERT INTO music (band_name, album_name, year) VALUES (?, ?, ?)', [$data['band'], $data['album'], $data['year']]);
}
}
function save()
{
$champsUpdate = array('nom' => $_REQUEST['nom'], 'adresse' => $_REQUEST['adresse'], 'cp' => $_REQUEST['cp'], 'ville' => $_REQUEST['ville'], 'telephone' => $_REQUEST['telephone'], 'email' => $_REQUEST['email'], 'site_web' => $_REQUEST['site_web'], 'nom_contact' => $_REQUEST['nom_contact'], 'prenom_contact' => $_REQUEST['prenom_contact'], 'tel_contact' => $_REQUEST['tel_contact'], 'portable_contact' => $_REQUEST['portable_contact'], 'email_contact' => $_REQUEST['email_contact'], 'temperature' => $_REQUEST['temperature'], 'dirigeant' => $_REQUEST['dirigeant'], 'naf' => $_REQUEST['naf'], 'autre' => $_REQUEST['autre']);
$champsInsert = $champsUpdate;
$id = $_REQUEST['id'];
if ($id) {
// Update
Mysql::update($this->table, $champsUpdate, "WHERE `id` = '%d'", $id);
} else {
// Insert
$id = Mysql::insert($this->table, $champsInsert);
}
$this->redirect($id);
// Rechargement de la page avec l'Bien courant
}
foreach ($KeyList as $k => $v) {
if (!isset($_GET[$v])) {
$res = ['ok' => 0, 'error' => "param invalid "];
echo json_encode($res);
return;
}
}
}
$mysql = new Mysql();
//连接数据库
$myMemcache = new MyMemcache();
if (isset($_GET['footId'])) {
$_GET['like'] = $myMemcache->get("like" . $_GET['footId']) ? $myMemcache->get("like" . $_GET['footId']) + 1 : 1;
$_GET['id'] = $_GET['footId'];
$FootList = array('id', 'like');
$mysql->update("foot", "like", "{$_GET['like']}", "id", "{$_GET['id']}");
} else {
$memValue = $myMemcache->get($_GET['url']);
if ($memValue) {
$_GET['id'] = $memValue;
$footprintId = $myMemcache->get($_GET['userId'] . "foot:" . $_GET['id']);
if ($footprintId) {
echo json_encode(['ok' => 1, 'data' => [id => $footprintId]]);
die;
}
$_GET['like'] = $myMemcache->get("like" . $_GET['id']) ? $myMemcache->get("like" . $_GET['id']) + 1 : 1;
$FootList = array('url', 'title', 'id', 'like');
} else {
$_GET['like'] = 1;
$FootList = array('url', 'title');
}
function ModifierLaRencontre($id_rencontre, $id_societe, $date_rencontre, $commentaire, $type_rencontre)
{
return Mysql::update('rencontre', array('id_societe' => $id_societe, 'date_rencontre' => $date_rencontre, 'commentaire' => $commentaire), "WHERE id = '%d' ", $id_rencontre);
}
$string .= $this->setQuoteStyle($key) . "='" . $this->safeFilter($val) . "'";
} else {
$string .= ',' . $this->setQuoteStyle($key) . "='" . $this->safeFilter($val) . "'";
}
}
$sql = 'UPDATE ' . $this->setQuoteStyle($table) . ' SET ' . $string . ($where === NULL ? $where : ' WHERE ' . $where);
echo $sql;
//mysql_query ( $sql, $this->_link );
}
function delete($table, $where = NULL)
{
$sql = 'DELETE FROM ' . $this->setQuoteStyle($table) . ($where == NULL ? $where : ' WHERE ' . $where);
echo $sql;
mysql_query($sql, $this->_link);
}
function setQuoteStyle($key)
{
return '`' . $key . '`';
}
function safeFilter($value)
{
return mysql_real_escape_string($value, $this->_link);
}
}
// 创建对象
$bind = array('username' => "1'1", 'password' => "2'1", 'age' => 112, 'sex' => 1);
$db = new Mysql();
$x = $db->connect('localhost', 'root', 'root', 'test');
//var_dump($x);
$db->update('users', $bind, 'id=1');