mysqli_query($connect, "UPDATE `news` SET `title` = '$_POST[n_title]', `short_content` = '$_POST[n_short_content]', `full_content` = '$_POST[n_content]' WHERE `id`='$_POST[n_id]' ");
UPDATE `blah` SET `isDeleted` = ?, `modify_date` = ? WHERE author_id = ?
-------------------------------------------------------
| id | is_deleted | modify_date | author_id |
-------------------------------------------------------
| 1 | f | 2017-01-02 | 1 |
-------------------------------------------------------
| 2 | f | 2017-01-02 | 1 |
-------------------------------------------------------
| 5 | f | 2017-01-02 | 3 |
-------------------------------------------------------
WHERE author_id = 1
, то UPDATE обновит несколько записей. security:
# ***
firewalls:
# ***
refresh:
pattern: ^/api/v1/token/refresh
stateless: true
anonymous: true
# ***
api:
pattern: ^/api
stateless: true
guard:
authenticators:
- lexik_jwt_authentication.jwt_token_authenticator
<?php
function connectDB() {
try {
$pdo = new PDO('mysql:host=localhost;dbname=#', 'root', '');
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
return $pdo;
} catch (PDOException $e) {
exit($e->getMessage());
}
}
function getA() {
$pdo = connectDB();
$select = $pdo->query("SELECT * FROM # ORDER BY id DESC", PDO::FETCH_ASSOC);
$result = $select->fetchAll();
var_dump($result);
}
getA();
?>