PHPda ma'lumotlar bazasiga yangi yozuv qo'shish

Keling endi new.php sahifasini yarataylik yangi foydalanuvchini ma'lumotlar bazamizga qo'shish uchun. Buning uchun mos formani yasaymiz:

new.php<form action="" method="POST">
  <input name="name">
  <input name="age">
  <input name="salary">
  <input type="submit">
</form>

Forma yuborilgandan so'ng uning ma'lumotlarini bazaga saqlaymiz. Boshlanish uchun formaning yuborilish paytini ushlaymiz:

new.php<?php
  if (!empty($_POST)) {
    // shu yerda formani qayta ishlash kodi bo'ladi
  }
?>

Shart ichida bizning ma'lumotlarimizni o'zgaruvchilarga olamiz:

new.php<?php
  $name = $_POST['name'];
  $age = $_POST['age'];
  $salary = $_POST['salary'];
?>

Ma'lumotlarni kiritish uchun so'rov tuzamiz:

new.php<?php
  $query = "INSERT INTO users SET name='$name', age='$age', salary='$salary'";
?>

Ushbu so'rovni bajaramiz:

new.php<?php
  mysqli_query($link, $query) or die(mysqli_error($link));
?>