How do I create page to display data I entered

[PhPots]

Hello guy , how do I write PHP page that have table to list all the data I entered to my system.

 

 

[Frank_b]

Hi,

 

That is a very global question. Can you explain what you system is? are you talking about a database, a textfile or what?

[PhPots]

@frank_b

Its a php system with sql database. I entered student information into the system. I can view the student info by knowing their ID. But I want to create page that list student that I registered. Now I can only view student list through PHPmyadmin.

[ginerjm]

Basically you want to write some code like this:

 

if $_POST['id'] is not set, output a form that has one text field for the id and one submit that calls back to this script using POST, not GET when it is submitted and exit and wait for the input.

 

if $_POST['id'] is set, then grab it, validate it, and use it in a prepared query to get the data you want to display.  Using those query results ($pdo->fetch(PDO::FETCH_ASSOC) ) build some html to display these fields in whatever order you want.  You can use an html table, or some div tags to arrange it on screen.  Be sure to place some submit buttons on it to handle what ever you want to do next.  Then exit and wait.

 

This is a very simple solution.  You need to be safe and secure in handling the user input and writing the query.

[Frank_b]

take a look here: http://webdevelopingcat.com/php-mysql-tutorial-for-beginners-connecting-to-the-database-with-pdo/

[PhPots]

Nicely done. Thank you guys !