Kusasisha Rekodi Kupitia SQL Query katika PHP

Hebu sasa tujifunze kubadilisha rekodi. Hii inafanywa kwa kutumia amri UPDATE. Ina syntax ifuatayo:

php<?php
  $query = "UPDATE table SET field = value WHERE condition";
?>

Mfano

Hebu tubadilishe umri na mshahara wa user:

php<?php
  $query = "UPDATE users SET age=20, salary=800 WHERE id=1";
?>

Mfano

Weka mshahara 400 na umri 24 kwa users wote wenye umri 23:

php<?php
  $query = "UPDATE users SET age=24, salary=300 WHERE age=23";
?>

Mfano

Bila amri WHERE updates zitaathiri meza nzima. Kwa mfano, tuweke users wote mshahara 400 na umri 24:

php<?php
  $query = "UPDATE users SET age=24, salary=300";
?>