php read data from sql database

Question

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>

mysqli($server, $user_name, $password,$database);

ɹɐqʞɐ zoɹǝɟ
– ɹɐqʞɐ zoɹǝɟ

2015-09-27 02:11:58 +00:00
Commented Sep 27, 2015 at 2:11 — ɹɐqʞɐ zoɹǝɟ
– ɹɐqʞɐ zoɹǝɟ, Commented Sep 27, 2015 at 2:11
You didn't select your db.

aldrin27
– aldrin27

2015-09-27 02:13:03 +00:00
Commented Sep 27, 2015 at 2:13 — aldrin27
– aldrin27, Commented Sep 27, 2015 at 2:13

Adam Joseph Looze · Accepted Answer · 2015-09-27 02:17:30Z

3

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);

edited Sep 27, 2015 at 2:17

answered Sep 27, 2015 at 2:14

Adam Joseph Looze

1,04110 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

James Over a year ago

You sir are a GENIUS!!!! Thank you so much!!! Its always the simple things that get us(me)!!!!

Adam Joseph Looze Over a year ago

You are welcome. PHP is a lot of fun once you get the hang of it. Keep at it! And if you are happy with this answer, please select it as correct :)

Adam Joseph Looze Over a year ago

Also, I noticed your code, you have "SELECT firstName, middleName, lastName FROM base" and your database name is also "base" is this correct? For your select query, it should be the name of the table you want to retrieve from, not the database name. For example "SELECT firstName, middleName, lastName FROM users";

James Over a year ago

Yep yep I was just making a sample database and table to try to read data from and just coincidentally gave them the same name.

Collectives™ on Stack Overflow

php read data from sql database

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related