CODEWITHSUNDEEP
phpmysql
James
James

Reputation: 77

php read data from sql database

I'm trying to learn php and I can't read any data from my database!. I know the connection to the server is live and working but this line seem to be giving me problems.

$result = $conn->query($sql);

Where $sql = "SELECT firstName, middleName, lastName FROM Base"; I'm not sure what the problem is but any hints or answer are appreciated .

<!DOCTYPE html>
<html>
<head>
</head>
<body>
<h1>My first PHP page</h1>
<?php
// connect to database
$user_name = "superUser";
$password = "";
$database = "Base"$server = "127.0.0.5";
// open connection to the server
$conn = new mysqli($server, $user_name, $password);
// echo "Connection to the server is open";
// check connetion
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
else {
    print "Connection to the server is open";
}
// load the data from the table
$sql = "SELECT firstName, middleName, lastName FROM Base";
// echo $conn->server_info;
$result = $conn->query($sql);
if ($result) {
    echo "Table was found";
}
else echo "no";
/*while($row = $result->fetch_assoc()) {
echo "id: " . $row["id"]. " - Name: " . $row["firstname"]. " " . $row["lastname"]. "<br />";
}
print $result["firstName"];// ": Number of Rows!" ;*/
// if ($result->num_rows > 0) {
// output data of each row
// close server connection
$conn->close();
?>
</body>
</html>

Upvotes: 0

Views: 2778

Answers (1)

Adam Joseph Looze
Adam Joseph Looze

Reputation: 1021

The following is a mysqli connect example.

<?php
$con = mysqli_connect("localhost","my_user","my_password","my_db");

// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }
?>

You forgot to add your database name. Change this,

$conn = new mysqli($server, $user_name, $password);

to this

$conn = new mysqli($server, $user_name, $password, $database);

Upvotes: 3

Related Questions