Update guests examples (PDO)

0 records UPDATED successfully

Here is the code for deleting the database record.

<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDBPDO";

try {
  $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
  // set the PDO error mode to exception
  $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

  // Update the selected record with a new last name
  $sql = "UPDATE MyGuests SET lastname='' WHERE id=7";

  // Prepare statement
  $stmt = $conn->prepare($sql);

  // execute the query
  $stmt->execute();

  // echo a message to say the UPDATE succeeded
  echo "".$stmt->rowCount() . " records UPDATED successfully";
} catch(PDOException $e) {
  echo "".$sql . "<br>" . $e->getMessage()."";
}

$conn = null;
?>

This is what the database table looks like after the record is deleted.

IdFirstnameLastnameEmailRegistration Date
1JohnDoejohn@example.com2024-11-28 13:31:22
2JohnDeerejohn@deere.net2024-11-28 13:38:46
4DaisyDuckdaisyduck@example.com2024-11-28 13:46:18
5Plutopluto@example.com2024-11-28 13:46:18
6DonaldDuckdduck@example.com2024-12-05 06:47:46
7Daisydaisyduck@example.com2024-12-05 06:48:54
8Plutopluto@example.com2024-12-05 06:47:46
9JohnDeerejohn@deere.net2024-12-05 06:54:14
10JohnDoejohn@example.com2024-12-05 06:54:18
11DonaldDuckdduck@example.com2024-12-07 02:11:50
12DaisyDuckdaisyduck@example.com2024-12-07 02:11:50
13Plutopluto@example.com2024-12-07 02:11:50
14JohnDeerejohn@deere.net2024-12-07 02:13:49
15JohnDoejohn@example.com2024-12-08 00:09:04
16JohnDeerejohn@deere.net2024-12-08 03:13:10
17DonaldDuckdduck@example.com2024-12-08 03:39:28
18DaisyDuckdaisyduck@example.com2024-12-08 03:39:28
19Plutopluto@example.com2024-12-08 03:39:28
20DonaldDuckdduck@example.com2024-12-13 22:35:38
21DaisyDuckdaisyduck@example.com2024-12-13 22:35:38
22Plutopluto@example.com2024-12-13 22:35:38
23JohnDoejohn@example.com2024-12-13 22:37:14
24JohnDeerejohn@deere.net2024-12-13 22:42:26
25JohnDeerejohn@deere.net2024-12-20 01:25:39
26JohnDeerejohn@deere.net2024-12-22 19:07:39
27JohnDoejohn@example.com2024-12-22 19:08:16
28DonaldDuckdduck@example.com2024-12-22 19:21:13
29DaisyDuckdaisyduck@example.com2024-12-22 19:21:13
30Plutopluto@example.com2024-12-22 19:21:13
31JohnDeerejohn@deere.net2024-12-28 09:01:18
32JohnDoejohn@example.com2024-12-30 17:05:24
33DonaldDuckdduck@example.com2024-12-30 17:07:26
34DaisyDuckdaisyduck@example.com2024-12-30 17:07:26
35Plutopluto@example.com2024-12-30 17:07:26
36JohnDeerejohn@deere.net2025-01-03 21:34:45
37JohnDoejohn@example.com2025-01-03 21:41:36
38DonaldDuckdduck@example.com2025-01-03 21:53:00
39DaisyDuckdaisyduck@example.com2025-01-03 21:53:00
40Plutopluto@example.com2025-01-03 21:53:00
41JohnDoejohn@example.com2025-01-03 23:02:47
42DonaldDuckdduck@example.com2025-01-03 23:08:58
43DaisyDuckdaisyduck@example.com2025-01-03 23:08:58
44Plutopluto@example.com2025-01-03 23:08:58
45DonaldDuckdduck@example.com2025-01-04 15:05:58
46DaisyDuckdaisyduck@example.com2025-01-04 15:05:58
47Plutopluto@example.com2025-01-04 15:05:58
48JohnDeerejohn@deere.net2025-01-04 15:12:26
49JohnDoejohn@example.com2025-01-04 15:12:30
50JohnDoejohn@example.com2025-01-04 23:46:11
51DonaldDuckdduck@example.com2025-01-07 14:30:59
52DaisyDuckdaisyduck@example.com2025-01-07 14:30:59
53Plutopluto@example.com2025-01-07 14:30:59
54JohnDoejohn@example.com2025-01-07 14:50:22
55JohnDeerejohn@deere.net2025-01-07 18:49:25
56DonaldDuckdduck@example.com2025-01-10 07:32:28
57DaisyDuckdaisyduck@example.com2025-01-10 07:32:28
58Plutopluto@example.com2025-01-10 07:32:28
59JohnDoejohn@example.com2025-01-10 08:29:05
60JohnDeerejohn@deere.net2025-01-11 09:59:18
61DonaldDuckdduck@example.com2025-01-12 11:28:23
62DaisyDuckdaisyduck@example.com2025-01-12 11:28:23
63Plutopluto@example.com2025-01-12 11:28:23
64JohnDoejohn@example.com2025-01-12 14:18:21
65JohnDeerejohn@deere.net2025-01-14 05:19:18
66DonaldDuckdduck@example.com2025-01-15 13:03:58
67DaisyDuckdaisyduck@example.com2025-01-15 13:03:58
68Plutopluto@example.com2025-01-15 13:03:58
69JohnDeerejohn@deere.net2025-01-18 05:12:59
70JohnDoejohn@example.com2025-01-18 05:15:35
71DonaldDuckdduck@example.com2025-01-18 05:16:49
72DaisyDuckdaisyduck@example.com2025-01-18 05:16:49
73Plutopluto@example.com2025-01-18 05:16:49
74DonaldDuckdduck@example.com2025-01-21 14:48:48
75DaisyDuckdaisyduck@example.com2025-01-21 14:48:48
76Plutopluto@example.com2025-01-21 14:48:48
77JohnDoejohn@example.com2025-01-21 14:54:58
78JohnDeerejohn@deere.net2025-01-21 15:34:18
79JohnDeerejohn@deere.net2025-01-25 18:40:04
80DonaldDuckdduck@example.com2025-01-25 18:40:07
81DaisyDuckdaisyduck@example.com2025-01-25 18:40:07
82Plutopluto@example.com2025-01-25 18:40:07
83DonaldDuckdduck@example.com2025-01-29 15:00:25
84DaisyDuckdaisyduck@example.com2025-01-29 15:00:25
85Plutopluto@example.com2025-01-29 15:00:25
86JohnDoejohn@example.com2025-01-29 15:01:13
87JohnDeerejohn@deere.net2025-02-02 00:40:07
88JohnDoejohn@example.com2025-02-02 00:54:03
89DonaldDuckdduck@example.com2025-02-02 02:05:36
90DaisyDuckdaisyduck@example.com2025-02-02 02:05:36
91Plutopluto@example.com2025-02-02 02:05:36
92DonaldDuckdduck@example.com2025-02-03 16:49:11
93DaisyDuckdaisyduck@example.com2025-02-03 16:49:11
94Plutopluto@example.com2025-02-03 16:49:11
95JohnDeerejohn@deere.net2025-02-03 16:56:12
96JohnDoejohn@example.com2025-02-03 16:56:16
97JohnDoejohn@example.com2025-02-05 21:31:33
98JohnDeerejohn@deere.net2025-02-07 13:13:13
99JohnDoejohn@example.com2025-02-07 13:14:21
100DonaldDuckdduck@example.com2025-02-07 13:15:55
101DaisyDuckdaisyduck@example.com2025-02-07 13:15:55
102Plutopluto@example.com2025-02-07 13:15:55
103JohnDeerejohn@deere.net2025-02-12 06:33:17
104JohnDoejohn@example.com2025-02-12 06:34:12
105DonaldDuckdduck@example.com2025-02-12 06:35:54
106DaisyDuckdaisyduck@example.com2025-02-12 06:35:54
107Plutopluto@example.com2025-02-12 06:35:54
108JohnDeerejohn@deere.net2025-02-21 13:02:39
109DonaldDuckdduck@example.com2025-02-21 13:12:36
110DaisyDuckdaisyduck@example.com2025-02-21 13:12:36
111Plutopluto@example.com2025-02-21 13:12:36
112JohnDoejohn@example.com2025-02-21 13:26:03
113JohnDeerejohn@deere.net2025-02-23 01:44:24
114DonaldDuckdduck@example.com2025-02-23 02:09:24
115DaisyDuckdaisyduck@example.com2025-02-23 02:09:24
116Plutopluto@example.com2025-02-23 02:09:24
117JohnDoejohn@example.com2025-02-23 02:14:24
118JohnDeerejohn@deere.net2025-02-23 04:59:24
119JohnDeerejohn@deere.net2025-02-24 11:11:25
120JohnDoejohn@example.com2025-02-24 11:24:18
121DonaldDuckdduck@example.com2025-02-24 11:39:01
122DaisyDuckdaisyduck@example.com2025-02-24 11:39:01
123Plutopluto@example.com2025-02-24 11:39:01
124JohnDeerejohn@deere.net2025-02-26 22:11:22
125DonaldDuckdduck@example.com2025-02-26 22:58:33
126DaisyDuckdaisyduck@example.com2025-02-26 22:58:33
127Plutopluto@example.com2025-02-26 22:58:33
128JohnDoejohn@example.com2025-03-06 01:19:41
129DonaldDuckdduck@example.com2025-03-08 14:04:03
130DaisyDuckdaisyduck@example.com2025-03-08 14:04:03
131Plutopluto@example.com2025-03-08 14:04:03
132JohnDeerejohn@deere.net2025-03-08 14:08:49
133JohnDoejohn@example.com2025-03-08 14:08:53
134JohnDeerejohn@deere.net2025-03-11 15:32:13
135DonaldDuckdduck@example.com2025-03-16 11:34:08
136DaisyDuckdaisyduck@example.com2025-03-16 11:34:08
137Plutopluto@example.com2025-03-16 11:34:08
138JohnDoejohn@example.com2025-03-18 00:19:51
139DonaldDuckdduck@example.com2025-03-18 00:21:36
140DaisyDuckdaisyduck@example.com2025-03-18 00:21:36
141Plutopluto@example.com2025-03-18 00:21:36
142DonaldDuckdduck@example.com2025-03-20 01:47:24
143DaisyDuckdaisyduck@example.com2025-03-20 01:47:24
144Plutopluto@example.com2025-03-20 01:47:24
145JohnDeerejohn@deere.net2025-03-20 01:47:25
146JohnDoejohn@example.com2025-03-20 01:47:25
147DonaldDuckdduck@example.com2025-03-22 11:26:09
148DaisyDuckdaisyduck@example.com2025-03-22 11:26:09
149Plutopluto@example.com2025-03-22 11:26:09
150JohnDoejohn@example.com2025-03-24 22:18:12
151JohnDoejohn@example.com2025-03-28 09:06:47
152JohnDeerejohn@deere.net2025-03-31 09:05:19
153JohnDeerejohn@deere.net2025-04-02 21:44:03
154JohnDoejohn@example.com2025-04-02 21:51:52
155DonaldDuckdduck@example.com2025-04-02 23:01:36
156DaisyDuckdaisyduck@example.com2025-04-02 23:01:36
157Plutopluto@example.com2025-04-02 23:01:36
158JohnDoejohn@example.com2025-04-03 03:42:03
159DonaldDuckdduck@example.com2025-04-03 03:59:29
160DaisyDuckdaisyduck@example.com2025-04-03 03:59:29
161Plutopluto@example.com2025-04-03 03:59:29
162JohnDeerejohn@deere.net2025-04-03 17:26:59
163JohnDeerejohn@deere.net2025-04-07 04:25:23
164JohnDoejohn@example.com2025-04-07 04:26:28
165DonaldDuckdduck@example.com2025-04-07 04:27:48
166DaisyDuckdaisyduck@example.com2025-04-07 04:27:48
167Plutopluto@example.com2025-04-07 04:27:48
168JohnDeerejohn@deere.net2025-04-12 12:03:09
169DonaldDuckdduck@example.com2025-04-12 13:25:13
170DaisyDuckdaisyduck@example.com2025-04-12 13:25:13
171Plutopluto@example.com2025-04-12 13:25:13
172JohnDoejohn@example.com2025-04-12 16:26:41
173JohnDeerejohn@deere.net2025-04-17 05:06:13
174JohnDoejohn@example.com2025-04-17 05:06:34
175DonaldDuckdduck@example.com2025-04-17 05:14:26
176DaisyDuckdaisyduck@example.com2025-04-17 05:14:26
177Plutopluto@example.com2025-04-17 05:14:26
178JohnDeerejohn@deere.net2025-04-19 12:49:44
179JohnDoejohn@example.com2025-04-19 13:20:29
180DonaldDuckdduck@example.com2025-04-19 14:07:40
181DaisyDuckdaisyduck@example.com2025-04-19 14:07:40
182Plutopluto@example.com2025-04-19 14:07:40
183JohnDeerejohn@deere.net2025-04-23 19:15:18
184JohnDoejohn@example.com2025-04-23 21:08:57
185DonaldDuckdduck@example.com2025-04-23 21:10:37
186DaisyDuckdaisyduck@example.com2025-04-23 21:10:37
187Plutopluto@example.com2025-04-23 21:10:37
188JohnDeerejohn@deere.net2025-04-26 00:35:18
189DonaldDuckdduck@example.com2025-04-26 21:36:14
190DaisyDuckdaisyduck@example.com2025-04-26 21:36:14
191Plutopluto@example.com2025-04-26 21:36:14
192JohnDoejohn@example.com2025-04-26 21:41:47
193JohnDeerejohn@deere.net2025-04-26 22:07:05
194JohnDeerejohn@deere.net2025-05-06 00:38:35
195DonaldDuckdduck@example.com2025-05-11 06:30:14
196DaisyDuckdaisyduck@example.com2025-05-11 06:30:14
197Plutopluto@example.com2025-05-11 06:30:14
198JohnDeerejohn@deere.net2025-05-16 12:21:07
199DonaldDuckdduck@example.com2025-05-16 13:23:07
200DaisyDuckdaisyduck@example.com2025-05-16 13:23:07
201Plutopluto@example.com2025-05-16 13:23:07
202JohnDoejohn@example.com2025-05-16 17:23:11
203JohnDeerejohn@deere.net2025-05-18 02:26:34
204DonaldDuckdduck@example.com2025-05-18 02:55:38
205DaisyDuckdaisyduck@example.com2025-05-18 02:55:38
206Plutopluto@example.com2025-05-18 02:55:38
207JohnDoejohn@example.com2025-05-18 05:08:17
208DonaldDuckdduck@example.com2025-05-22 05:47:06
209DaisyDuckdaisyduck@example.com2025-05-22 05:47:06
210Plutopluto@example.com2025-05-22 05:47:06
211JohnDoejohn@example.com2025-05-22 05:47:53
212JohnDoejohn@example.com2025-05-23 08:38:28
213DonaldDuckdduck@example.com2025-05-28 19:24:11
214DaisyDuckdaisyduck@example.com2025-05-28 19:24:11
215Plutopluto@example.com2025-05-28 19:24:11
216JohnDeerejohn@deere.net2025-05-29 03:25:46
217JohnDeerejohn@deere.net2025-05-29 03:25:47
218JohnDeerejohn@deere.net2025-05-29 03:25:48
219JohnDeerejohn@deere.net2025-05-29 04:52:15
220JohnDoejohn@example.com2025-05-29 10:08:12
221JohnDoejohn@example.com2025-05-30 08:37:20
222DonaldDuckdduck@example.com2025-06-05 00:31:28
223DaisyDuckdaisyduck@example.com2025-06-05 00:31:28
224Plutopluto@example.com2025-06-05 00:31:28
225JohnDoejohn@example.com2025-06-05 00:31:40
226JohnDeerejohn@deere.net2025-06-05 00:31:43
227JohnDoejohn@example.com2025-06-06 08:43:46
228DonaldDuckdduck@example.com2025-06-15 13:19:47
229DaisyDuckdaisyduck@example.com2025-06-15 13:19:47
230Plutopluto@example.com2025-06-15 13:19:47
231JohnDoejohn@example.com2025-06-15 13:29:38
232JohnDoejohn@example.com2025-06-19 09:22:03
233JohnDoejohn@example.com2025-06-20 10:42:29
234JohnDeerejohn@deere.net2025-06-20 17:20:51
235DonaldDuckdduck@example.com2025-06-20 19:04:19
236DaisyDuckdaisyduck@example.com2025-06-20 19:04:19
237Plutopluto@example.com2025-06-20 19:04:19
238JohnDeerejohn@deere.net2025-06-21 12:35:43
239DonaldDuckdduck@example.com2025-06-22 13:29:17
240DaisyDuckdaisyduck@example.com2025-06-22 13:29:17
241Plutopluto@example.com2025-06-22 13:29:17
242JohnDoejohn@example.com2025-06-22 13:30:00
243JohnDoejohn@example.com2025-06-28 14:58:22
244JohnDoejohn@example.com2025-07-02 23:19:16
245JohnDeerejohn@deere.net2025-07-02 23:56:37
246DonaldDuckdduck@example.com2025-07-03 02:06:12
247DaisyDuckdaisyduck@example.com2025-07-03 02:06:12
248Plutopluto@example.com2025-07-03 02:06:12
249JohnDeerejohn@deere.net2025-07-04 11:49:39
250JohnDoejohn@example.com2025-07-05 08:51:11

Here is the code for accessing the database and display the information.

<?php
echo "<table style='border: solid 1px black;'>";
echo "<tr><th>Id</th><th>Firstname</th><th>Lastname</th><th>Email</th><th>Registration Date</th></tr>";

class TableRows extends RecursiveIteratorIterator {
  function __construct($it) {
    parent::__construct($it, self::LEAVES_ONLY);
  }

  function current() {
    return "<td style='width:150px;border:1px solid black;'>" . parent::current(). "</td>";
  }

  function beginChildren() {
    echo "<tr style='width:150px;border:1px solid black;background-color:yellow;'>";
  }

  function endChildren() {
    echo "</tr>" . "\n";
  }
}

$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDBPDO";

try {
  $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
  $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// Define and execute prepared statement
  $stmt = $conn->prepare("SELECT id, firstname, lastname, email, reg_date FROM MyGuests");
  $stmt->execute();

  // set the resulting array to associative
  $result = $stmt->setFetchMode(PDO::FETCH_ASSOC);
  foreach(new TableRows(new RecursiveArrayIterator($stmt->fetchAll())) as $k=>$v) {
    echo $v;
  }
} catch(PDOException $e) {
  echo "Error: " . $e->getMessage();
}
$conn = null;
echo "</table>";
?>