MySQL - PHP Print Records to HTML (mysqli) скачать в хорошем качестве

MySQL - PHP Print Records to HTML (mysqli)

Find code and diagrams at: https://www.EliTheComputerGuy.com You can use PHP to access records in a MySQL database and then print them out in HTML. phpSelect.php ?php $servername = "localhost"; $username = "bob"; $password = "123456"; $db = "classDB"; $conn = new mysqli($servername, $username, $password, $db); if($conn-connect_error){ die("Connection failed ".$conn-connect_error); } $sql = "select * from parts"; $result = $conn-query($sql); if ($result-num_rows 0){ while($row = $result-fetch_assoc() ){ echo $row["part_name"] ." " .$row["part_price"]. "br"; } } else { echo "0 records"; } $conn-close(); ? phpSelectTable.php ?php $servername = "localhost"; $username = "bob"; $password = "123456"; $db = "classDB"; $conn = new mysqli($servername, $username, $password, $db); if($conn-connect_error){ die("Connection failed ".$conn-connect_error); } $sql = "select * from parts"; $result = $conn-query($sql); echo "table tr th . Name /th th Price /th /tr "; if ($result-num_rows 0){ while($row = $result-fetch_assoc() ){ echo "tr td". $row["part_name"] . "/td td".$row["part_price"]. "/td /tr"; } } else { echo "0 records"; } echo "/table"; $conn-close(); ?