php - How can I get mysql to print rows from a database table -

i trying learn php w3schools includes mysql section.so far have completed every other part of tutorial on w3school except part prints content database table. weird reason , nothing displays when run code. please how can working , problem come fact using mariadb xampp instead of mysql although said practically same syntax. here code

<?php $servername = "localhost"; $username = "uhexos"; $password = "strongpassword"; $database = "fruitdb";  // create connection $conn = new mysqli($servername, $username, $password); // check connection if ($conn->connect_error) {     die("connection failed: " . $conn->connect_error); }   // create database $sql = "create database fruitdb"; if ($conn->query($sql) === true) {     echo "database created successfully"; } else {     echo "error creating database: " . $conn->error; }  $conn->close(); // create connection $conn = mysqli_connect($servername, $username, $password,$database);  // sql create table $complexquery = "create table myfruits ( id int(6) unsigned auto_increment primary key,  fruittype varchar(30) not null, fruittaste varchar(30) not null, fruitquantity int not null, datepurchased timestamp )";  if ($conn->query($complexquery) === true) {     echo "table fruits created successfully<br> "; } else {     echo "error creating table:  " . $conn->error; } $entry = "insert myfruits (fruittype,fruittaste,fruitquantity) values ('orange','sweet','50'),('lemon','sour','10'),('banana','sweet','15')";  if ($conn->query($entry) === true) {     echo "new records created successfully"; } else {     echo "error: " . $conn->error; }    $sql = 'select id, fruitname, fruittaste myfruits';     $retval = mysql_query( $sql, $conn );     if(! $retval ) {       die('could not data: ' . mysql_error());    }     while($row = mysql_fetch_array($retval, mysql_assoc)) {       echo "emp id :{$row['id']}  <br> ".          "emp name : {$row['fruitname']} <br> ".          "emp salary : {$row['fruittaste']} <br> ".          "--------------------------------<br>";    }     echo "fetched data successfully\n";     mysql_close($conn); ?> 

this output echos.

error creating database: can't create database 'fruitdb'; database existserror creating table: table 'myfruits' existsnew records created 

or

database created successfullytable fruits created new records created 

based on error message, managed create database , tables once , each time run code fails because can't reuse names.

you don't want have code trying erase & start fresh on database every time. in fact, find don't create database inside regular code use phpmyadmin or other admin page that. creating tables inside code normal enough. 2 options:

1 - create table if not exist. extremely safe. however, if want start table on again new structure, or start empty, won't work. that, change create table create table if not exists

2 - delete table before creating it. before each create table command, add command delete table if exists myfruits