> For the complete documentation index, see [llms.txt](https://overfinch.gitbook.io/cheatsheet/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://overfinch.gitbook.io/cheatsheet/pdo/insert.md).

# INSERT

вставка в БД

```php
$db = new PDO("mysql:host=localhost;dbname=pdo;charset=utf8","root","");

$sql = "INSERT INTO users (username, password) VALUES (:username, :password)";
$stmp = $db->prepare($sql);

$username = "Azov";
$password = "11111111";

$stmp->bindValue("username",$username);
$stmp->bindValue("password",$password);
$stmp->execute();

echo "было затронуто строк: ". $stmp->rowCount()."<br>";
echo "ID вставленной записи: ".$db->lastInsertId();
```