PHP operation mysql example memo_PHP tutorial

1. General insert

$query = "INSERT INTO Profile (userName) VALUES ('{$userName}')";

$this->db->query($query);

$userId = sprintf("%d", $this->db->insert_id);

$this->db->commit();

2. If there is one in the database, update it, if not, insert it

$query = "INSERT INTO BookRead (userId, bookId, count) VALUES ($_userId, $_bookId, 1) ON DUPLICATE KEY UPDATE count = count + 1";

$this->db->query($query);

$this->db->commit();

3. Update

$query = "UPDATE Profile Set deviceToken='{$_token}' WHERE userId=$_userId";

$this->db->query($query);

$this->db->commit();

4. Query 1, fields that need to be operated

$stmt = $this->db->prepare('SELECT userId, passWord FROM Profile WHERE userName=?');

$stmt->bind_param("s", $_userName);

$rs = $stmt->execute();

$stmt->bind_result($_userId, $_passWord);

while ($stmt->fetch()) {

break;

}

$stmt->close();

Query 2, return query result array

$query = "SELECT name, points FROM Profile WHERE 1 ORDER BY points DESC LIMIT $_from, $_to";

                                                                     

if ($result = $this->db->query($query)) {

while ($row = $result->fetch_row()) {

                                                         

$ret = array (

"name" => $row[0],

"points" => $row[1],

);

}

$result->close();

}

http://www.bkjia.com/PHPjc/477688.html

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/477688.htmlTechArticle1. General insert $query = INSERT INTO Profile (userName) VALUES ({$userName}); $this -db-query($query); $userId = sprintf(%d, $this-db-insert_id); $this-db-commit(); 2. In the database, such as...