Sejauh ini Anda telah mempelajari cara membuat database dan tabel serta memasukkan data. Sekarang saatnya mengambil data yang telah disisipkan pada tutorial sebelumnya. Pernyataan SQL SELECT_ digunakan untuk memilih record dari tabel database. Sintaks dasarnya adalah sebagai berikut
PILIH nama_kolom1, nama_kolom2, nama_kolom DARI nama_tabel;
Mari kita membuat kueri SQL menggunakan pernyataan SELECT, setelah itu kita akan mengeksekusi kueri SQL ini dengan meneruskannya ke fungsi PHP mysqli_query() untuk mengambil data tabel
Pertimbangkan tabel database orang kami memiliki catatan berikut
+----+------------+-----------+----------------------+ | id | first_name | last_name | email | +----+------------+-----------+----------------------+ | 1 | Peter | Parker | peterparker@mail.com | | 2 | John | Rambo | johnrambo@mail.com | | 3 | Clark | Kent | clarkkent@mail.com | | 4 | John | Carter | johncarter@mail.com | | 5 | Harry | Potter | harrypotter@mail.com | +----+------------+-----------+----------------------+Kode PHP dalam contoh berikut memilih semua data yang disimpan dalam tabel orang (menggunakan karakter asterisk (*) di tempat nama kolom memilih semua data dalam tabel)
Contoh
PDO Berorientasi Objek Prosedural
Unduh 0){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; while($row = mysqli_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "idfirst_namelast_nameemail" . $row['id'] . "" . $row['first_name'] . "" . $row['last_name'] . "" . $row['email'] . ""; // Free result set mysqli_free_result($result); } else{ echo "No records matching your query were found."; } } else{ echo "ERROR: Could not able to execute $sql. " . mysqli_error($link); } // Close connection mysqli_close($link); ?>connect_error); } // Attempt select query execution $sql = "SELECT * FROM persons"; if($result = $mysqli->query($sql)){ if($result->num_rows > 0){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; while($row = $result->fetch_array()){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "idfirst_namelast_nameemail" . $row['id'] . "" . $row['first_name'] . "" . $row['last_name'] . "" . $row['email'] . ""; // Free result set $result->free(); } else{ echo "No records matching your query were found."; } } else{ echo "ERROR: Could not able to execute $sql. " . $mysqli->error; } // Close connection $mysqli->close(); ?>setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch(PDOException $e){ die("ERROR: Could not connect. " . $e->getMessage()); } // Attempt select query execution try{ $sql = "SELECT * FROM persons"; $result = $pdo->query($sql); if($result->rowCount() > 0){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; while($row = $result->fetch()){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "idfirst_namelast_nameemail" . $row['id'] . "" . $row['first_name'] . "" . $row['last_name'] . "" . $row['email'] . ""; // Free result set unset($result); } else{ echo "No records matching your query were found."; } } catch(PDOException $e){ die("ERROR: Could not able to execute $sql. " . $e->getMessage()); } // Close connection unset($pdo); ?>Penjelasan Kode (Procedural style)
Pada contoh di atas, data yang dikembalikan oleh fungsi mysqli_query() disimpan dalam variabel $result. Setiap kali 0){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; while($row = mysqli_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "idfirst_namelast_nameemail" . $row['id'] . "" . $row['first_name'] . "" . $row['last_name'] . "" . $row['email'] . ""; // Free result set mysqli_free_result($result); } else{ echo "No records matching your query were found."; } } else{ echo "ERROR: Could not able to execute $sql. " . mysqli_error($link); } // Close connection mysqli_close($link); ?>_0 dipanggil, ia mengembalikan baris berikutnya dari hasil yang ditetapkan sebagai larik. While loop digunakan untuk mengulang semua baris di set hasil. Terakhir, nilai bidang individual dapat diakses dari baris baik dengan meneruskan indeks bidang atau nama bidang ke variabel 0){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; while($row = mysqli_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "idfirst_namelast_nameemail" . $row['id'] . "" . $row['first_name'] . "" . $row['last_name'] . "" . $row['email'] . ""; // Free result set mysqli_free_result($result); } else{ echo "No records matching your query were found."; } } else{ echo "ERROR: Could not able to execute $sql. " . mysqli_error($link); } // Close connection mysqli_close($link); ?>1 seperti 0){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; while($row = mysqli_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "idfirst_namelast_nameemail" . $row['id'] . "" . $row['first_name'] . "" . $row['last_name'] . "" . $row['email'] . ""; // Free result set mysqli_free_result($result); } else{ echo "No records matching your query were found."; } } else{ echo "ERROR: Could not able to execute $sql. " . mysqli_error($link); } // Close connection mysqli_close($link); ?>2 atau 0){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; while($row = mysqli_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "idfirst_namelast_nameemail" . $row['id'] . "" . $row['first_name'] . "" . $row['last_name'] . "" . $row['email'] . ""; // Free result set mysqli_free_result($result); } else{ echo "No records matching your query were found."; } } else{ echo "ERROR: Could not able to execute $sql. " . mysqli_error($link); } // Close connection mysqli_close($link); ?>3, 0){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; while($row = mysqli_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "idfirst_namelast_nameemail" . $row['id'] . "" . $row['first_name'] . "" . $row['last_name'] . "" . $row['email'] . ""; // Free result set mysqli_free_result($result); } else{ echo "No records matching your query were found."; } } else{ echo "ERROR: Could not able to execute $sql. " . mysqli_error($link); } // Close connection mysqli_close($link); ?>4 atau 0){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; while($row = mysqli_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "idfirst_namelast_nameemail" . $row['id'] . "" . $row['first_name'] . "" . $row['last_name'] . "" . $row['email'] . ""; // Free result set mysqli_free_result($result); } else{ echo "No records matching your query were found."; } } else{ echo "ERROR: Could not able to execute $sql. " . mysqli_error($link); } // Close connection mysqli_close($link); ?>5, 0){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; while($row = mysqli_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "idfirst_namelast_nameemail" . $row['id'] . "" . $row['first_name'] . "" . $row['last_name'] . "" . $row['email'] . ""; // Free result set mysqli_free_result($result); } else{ echo "No records matching your query were found."; } } else{ echo "ERROR: Could not able to execute $sql. " . mysqli_error($link); } // Close connection mysqli_close($link); ?>6 atau 0){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; while($row = mysqli_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "idfirst_namelast_nameemail" . $row['id'] . "" . $row['first_name'] . "" . $row['last_name'] . "" . $row['email'] . ""; // Free result set mysqli_free_result($result); } else{ echo "No records matching your query were found."; } } else{ echo "ERROR: Could not able to execute $sql. " . mysqli_error($link); } // Close connection mysqli_close($link); ?>7, dan 0){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; while($row = mysqli_fetch_array($result)){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "idfirst_namelast_nameemail" . $row['id'] . "" . $row['first_name'] . "" . $row['last_name'] . "" . $row['email'] . ""; // Free result set mysqli_free_result($result); } else{ echo "No records matching your query were found."; } } else{ echo "ERROR: Could not able to execute $sql. " . mysqli_error($link); } // Close connection mysqli_close($link); ?>8 atau ________1
Jika Anda ingin menggunakan loop connect_error); } // Attempt select query execution $sql = "SELECT * FROM persons"; if($result = $mysqli->query($sql)){ if($result->num_rows > 0){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; while($row = $result->fetch_array()){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "idfirst_namelast_nameemail" . $row['id'] . "" . $row['first_name'] . "" . $row['last_name'] . "" . $row['email'] . ""; // Free result set $result->free(); } else{ echo "No records matching your query were found."; } } else{ echo "ERROR: Could not able to execute $sql. " . $mysqli->error; } // Close connection $mysqli->close(); ?>_0 Anda bisa mendapatkan nilai penghitung loop atau jumlah baris yang dikembalikan oleh kueri dengan meneruskan variabel $result ke fungsi connect_error); } // Attempt select query execution $sql = "SELECT * FROM persons"; if($result = $mysqli->query($sql)){ if($result->num_rows > 0){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; while($row = $result->fetch_array()){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "idfirst_namelast_nameemail" . $row['id'] . "" . $row['first_name'] . "" . $row['last_name'] . "" . $row['email'] . ""; // Free result set $result->free(); } else{ echo "No records matching your query were found."; } } else{ echo "ERROR: Could not able to execute $sql. " . $mysqli->error; } // Close connection $mysqli->close(); ?>2. Nilai penghitung loop ini menentukan berapa kali loop harus dijalankan