Nilai pengembalian. Untuk SELECT, SHOW, DESCRIBE, atau EXPLAIN mengembalikan objek mysqli_result. Untuk kueri sukses lainnya, ini mengembalikan nilai true. Kalau tidak, itu mengembalikan false pada kegagalan
Mari kita pahami bagaimana kita bisa mengeksekusi kueri SQL
Menjalankan kueri SQL. Kami akan memahami bagaimana kami dapat menjalankan kueri SQL dengan sebuah contoh. Kami akan membuat database, tabel dan kemudian memasukkan beberapa nilai ke dalamnya
Contoh. Buat database dan masukkan beberapa nilai ke dalamnya
PHP
<?php
$servername ="localhost";
Table has been created successfully1 =Table has been created successfully3;
Table has been created successfully6 =Table has been created successfully8;
New record created successfully_0
New record created successfully2 =New record created successfully4 New record created successfully5$servernameNew record created successfully7Table has been created successfully1New record created successfully7Table has been created successfully6id: 1 - Name: XYZ ABC1
id: 1 - Name: XYZ ABC_3 id: 1 - Name: XYZ ABC4New record created successfully2id: 1 - Name: XYZ ABC6
________12______7id: 1 - Name: XYZ ABC8id: 1 - Name: XYZ ABC4<?php0 ________171______1New record created successfully2<?php3
<?php5
New record created successfully_0
<?php8 = 0;
id: 1 - Name: XYZ ABC3 id: 1 - Name: XYZ ABC4New record created successfully2 6<?php8 8
________12______7$servername0 $servername1;
________171New record created successfully_173_______5 $servername6
________12______7$servername0 $servername9 <?php1New record created successfully2=2
<?php5
New record created successfully2=7
=_8
Keluaran
Database has been created successfullyMembuat tabel
PHP
<?php
$servername ="localhost";
Table has been created successfully1 =Table has been created successfully3;
Table has been created successfully6 =Table has been created successfully8;
;6 =;8;
New record created successfully_0
New record created successfully2 =New record created successfully4 New record created successfully5$servernameNew record created successfully7Table has been created successfully1New record created successfully7Table has been created successfully6New record created successfully7;6________12______1
Table has been created successfully14id: 1 - Name: XYZ ABC3 id: 1 - Name: XYZ ABC4New record created successfully2id: 1 - Name: XYZ ABC6
Table has been created successfully19id: 1 - Name: XYZ ABC8id: 1 - Name: XYZ ABC4<?php0 <?php1New record created successfully2<?php3
Table has been created successfully14<?php5
New record created successfully_0
<?php_8 Table has been created successfully31
Table has been created successfully14Table has been created successfully33
Table has been created successfully14Table has been created successfully35
Table has been created successfully14Table has been created successfully37
Table has been created successfully_39
New record created successfully_0
id: 1 - Name: XYZ ABC3 id: 1 - Name: XYZ ABC4New record created successfully2 6<?php8 8
________12______7$servername0 Table has been created successfully50;
________171New record created successfully_173_______5 $servername6
________12______7$servername0 Table has been created successfully58 <?php1New record created successfully2=2
<?php5
New record created successfully_0
New record created successfully2=7
=_8
Keluaran
Table has been created successfullyMemasukkan beberapa nilai ke dalam tabel “Emp”
PHP
<?php
$servername ="localhost";
Table has been created successfully1 =Table has been created successfully3;
Table has been created successfully6 =Table has been created successfully8;
;6 =;8;
New record created successfully_0
New record created successfully2 =New record created successfully4 New record created successfully5$servernameNew record created successfully7Table has been created successfully1New record created successfully7Table has been created successfully6New record created successfully7;6________12______1
id: 1 - Name: XYZ ABC_3 id: 1 - Name: XYZ ABC4New record created successfully2New record created successfully08
________12______7id: 1 - Name: XYZ ABC8id: 1 - Name: XYZ ABC4<?php0 ________171______1New record created successfully2<?php3
<?php5
<?php_8 New record created successfully20
New record created successfully21New record created successfully22New record created successfully23New record created successfully7New record created successfully25New record created successfully26
New record created successfully_0
id: 1 - Name: XYZ ABC3 id: 1 - Name: XYZ ABC4New record created successfully2 6<?php8 8
________12______7$servername0 New record created successfully37;
________171New record created successfully_173_______5$servername6
________12______7$servername0 New record created successfully45 <?php1<?php8 <?php1New record created successfully49 <?php1New record created successfully2=2
<?php5
New record created successfully2=7
=_8
Keluaran
New record created successfully_Catatan. Karena kita telah menggunakan AUTO_INCREMENT, ini akan secara otomatis menyisipkan record dengan “id=1” dan untuk setiap record yang baru disisipkan, “id” akan bertambah satu
Mengambil hasil dari database
PHP
<?php
$servername ="localhost";
Table has been created successfully1 =Table has been created successfully3;
Table has been created successfully6 =Table has been created successfully8;
;6 =;8;
New record created successfully_0
New record created successfully2 =New record created successfully4 New record created successfully5$servernameNew record created successfully7Table has been created successfully1New record created successfully7Table has been created successfully6New record created successfully7;6________12______1
id: 1 - Name: XYZ ABC_3 id: 1 - Name: XYZ ABC4New record created successfully2id: 1 - Name: XYZ ABC6
________12______7id: 1 - Name: XYZ ABC8id: 1 - Name: XYZ ABC4<?php0 ________171______1New record created successfully2<?php3
<?php5
New record created successfully_0
<?php8 =id: 1 - Name: XYZ ABC12;
id: 1 - Name: XYZ ABC_15 =New record created successfully2 6<?php8id: 1 - Name: XYZ ABC1
id: 1 - Name: XYZ ABC_3 id: 1 - Name: XYZ ABC4id: 1 - Name: XYZ ABC15id: 1 - Name: XYZ ABC25
________12______7id: 1 - Name: XYZ ABC27id: 1 - Name: XYZ ABC4id: 1 - Name: XYZ ABC29 =id: 1 - Name: XYZ ABC15id: 1 - Name: XYZ ABC32
New record created successfully21$servername0 id: 1 - Name: XYZ ABC35 <?php1id: 1 - Name: XYZ ABC29id: 1 - Name: XYZ ABC38id: 1 - Name: XYZ ABC39id: 1 - Name: XYZ ABC40id: 1 - Name: XYZ ABC41
id: 1 - Name: XYZ ABC42<?php1id: 1 - Name: XYZ ABC29id: 1 - Name: XYZ ABC38id: 1 - Name: XYZ ABC46id: 1 - Name: XYZ ABC40id: 1 - Name: XYZ ABC48 ________________________2121212__________________________________________________________________________________________________________________________________________________________________________.