PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE Hotel (Id INT NOT NULL PRIMARY KEY, Name varCHAR(60) NOT NULL, Class INT NOT NULL); INSERT INTO Hotel VALUES (1, "Rosa Resort Hotel", 4), (2, "Joy World Palace", 5), (3, "My Dream Beach", 3), (4, "Golden Beach Hotel ", 4), (5, "Joy Kirish Resort", 5); SELECT * FROM Hotel;
Copy Clear
Copy Format Clear
<?php use Carbon\Carbon; $result = mysqli_query($mysqli, "SELECT * FROM Hotel WHERE Id=2") or die ("Невозможно выполнить запрос!"); while (list($Id, $Name, $Class) = mysqli_fetch_array($result)) { echo "$Id, $Name, $Class"; } ?>
Show:  
Copy Clear