PHP how to query MySQL database

#PHP #course #tutorial

PHP how to query MySQL database

[BroCodez]

<?php
include("database.php");

$sql = "SELECT * FROM users WHERE user = 'Spongebob'";
$result = mysqli_query($conn, $sql);

if(mysqli_num_rows($result) > 0){
$row = mysqli_fetch_assoc($result);
echo $row["id"] . "<br>";
echo $row["user"] . "<br>";
echo $row["reg_date"] . "<br>";
}
else{
echo"No user found";
}

mysqli_close($conn);
?>

<?php

$db_server = "localhost";
$db_user = "root";
$db_pass = "";
$db_name = "businessdb";
$conn = "";

try{
$conn = mysqli_connect($db_server,
$db_user,
$db_pass,
$db_name);
}
catch(mysqli_sql_exception){
echo"Could not connect! <br>";
}
?>

[amirarsalanb]

We don't deserve you bro😢 Thank you! 🙂

[paulhetherington]

/4''px paav~tmp kuiry tubx low < vk''2- inch pn~thrm mrk orb lyr < i.e. molz/
/i.e. 2'' inch tk xolmn pn < kom cnt-tubsz fch''td(8''px frch mrk lyr < molz mrch)/
/orb arund paav~tmp floch P' buoy namz < mch + H', SH', D' vk'' 2inch tk fstpn/