Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $host = "Hname-Db01-0002";
- $name = "root";
- $pass = "root";
- $db = "main";
- $mysqli = new mysqli($host, $name, $pass, $db);
- if($mysqli->connect_error) { die("Oops, no database " . $mysqli->connect_error); } else {
- $search = "SELECT Name, CountryCode FROM city";
- $result = $mysqli->query($search);
- if($result->num_rows > 0){
- while($row = $result->fetch_assoc()){
- echo "Name: ".$row['Name']." - Lastname: ".$row['CountryCode']."<br>";
- }
- }
- $mysqli->close();
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement