How to echo database fields with PHP?

[Nemanja]

So, I'm learning basics of PHP and Mysql and I am trying to print my database data to a PHP page. I have a table username, email and URL fields. I'm trying to select this table and echo field values but the result returned is a blank page. What does this mean?
Could you please post some sample of showing data from a database by echo them using PHP?

Thanks in advance.

 

[Ruesnam]

If I got your point, then let me give you an example.
Let's say you have a table called 'user', and you want to print a field called 'username'

<?php
     try{
        $database = new PDO($host, $user, $password);//database credentials
    }
   catch(Exception $e){
        die('Failure : '.$e->getMessage());
   }
   $request = $database->prepare('SELECT * FROM user ');
   $request->execute();
   $result = $request->fetch();
   if($result){
     echo $result['username']; 
  }
  
?>

Hope it helped

 

[Rob Whisonant]

Post the current code you are using.

 

[Mike001]

Ruesnam,

I know that you mean well but if Nemanja does not understand the structural layout of PHP, there is very little chance that he will understand what you have displayed in classes.

My guess is, he is trying to fill a variable with multiple fields. That happens a lot to new programmers that do not have a good understanding of variables vs. arrays.

Nemanja if you add your code I can help you displaying the data. Or if you are really motivated you can watch a bunch of free videos on my website, under the PHP section that will explain exactly what you are trying to do.

Just a thought.