The PDO (PHP Data Objects) defines the lightweight, consistent interface for accessing databases in PHP.
Follow the steps to fetch data from Database in PHP pdo:
1. Create Database: Create a database using XAMPP, the database is named “fetch” here. You can give any name to your database.
2. Create Table: Create table “studentRecord”, inside “fetch” database.
3. Create Table Structure: Table “studentRecord” containing 2 fields.
- id – primary key – auto increment
- studentname – varchar(100)
The datatype for studentname is varchar. The size can be altered as per the requirement. However, 100 is sufficient, and the datatype for “id” is int and it is a primary key. Set the primary key to auto-increment, so that the value of id increase automatically.
A primary key, also called a primary keyword, is a key in a relational database that is unique for each record. It is a unique identifier, such as a driver’s license number, telephone number (including area code), or vehicle identification number (VIN).
The structure of table will look like this
4. Insert student record: Here I have only taken the name and id of students. You can add more fields, according to your requirements.
Or you can write sql query to insert the values.
After inserting the information, the table will look like this.
5. Create a folder “fetch”, that includes these two following files: The folder should be in “D:\xampp\htdocs\” (or where your XAMPP is installed).
5.1. index.php: Here foreach construct provides an easy way to iterate over arrays. foreach works only on arrays and objects and will issue an error when you try to use it on a variable with a different data type or an uninitialized variable. There are two syntaxes:
foreach (array_expression as $value) statement foreach (array_expression as $key => $value) statement
The following SQL query is used to fetch all data from the table.
SELECT * FROM studentrecord;
6. After completing all these steps, now do the following steps:
- Run XAMPP
- Start Apache server and MySQL
- Type http://localhost/fetchData/dashboard.php in your browser.
The table will look like this and that’s how you fetch the information from Database in PHP PDO.
- PHP program to fetch data from localhost server database using XAMPP
- How to fetch data from localserver database and display on HTML table using PHP ?
- What is the difference between MySQL, MySQLi and PDO?
- AngularJS | fetch data from API using HttpClient
- How to fetch data from JSON file and display in HTML table using jQuery ?
- Create a database on Relational Database Service (RDS) of Amazon Web Services(AWS)
- Get and Post method using Fetch API
- How to fetch the details using ng-repeat in AngularJS?
- Simple POST request using the fetch API
- Simple GET and POST request using Fetch API method by making custom HTTP library
- How to make simple PUT request using fetch API by making custom HTTP library ?
- Simple DELETE request using fetch API by making custom HTTP library
- How to fetch single and multiple documents from MongoDb using Node.js ?
- Fetch API
- Difference between Fetch and Axios.js for making http requests
- D3.js d3-Fetch API
- How to fetch images from node server ?
- Spring Boot | How to access database using Spring Data JPA
- How to Upload Image into Database and Display it using PHP ?
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to email@example.com. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.