PHP Database Connectivity: Working with MySQL

To work with MySQL database in PHP, you need to establish a connection, execute queries, and fetch results. Here’s a step-by-step guide on how to achieve this:

1. Establish a Connection:
– Use the `mysqli_connect()` function to connect to the MySQL database. It takes four parameters: hostname, username, password, and database name.
– Example: `$conn = mysqli_connect("localhost", "username", "password", "database_name");`

2. Execute Queries:
– Use the `mysqli_query()` function to execute SQL queries. It takes two parameters: the connection variable and the SQL query.
– Example: `$result = mysqli_query($conn, "SELECT * FROM table_name");`

3. Fetch Results:
– Use the `mysqli_fetch_assoc()` function to fetch the result set as an associative array. It takes the result variable as a parameter.
– Example: `while ($row = mysqli_fetch_assoc($result)) { echo $row[‘column_name’]; }`

4. Close the Connection:
– Use the `mysqli_close()` function to close the database connection when you’re done.
– Example: `mysqli_close($conn);`

Here’s a complete example that demonstrates the above steps:

// Step 1: Establish a Connection
$conn = mysqli_connect("localhost", "username", "password", "database_name");

// Step 2: Execute Queries
$result = mysqli_query($conn, "SELECT * FROM table_name");

// Step 3: Fetch Results
while ($row = mysqli_fetch_assoc($result)) {
echo $row[‘column_name’];

// Step 4: Close the Connection

Note: Replace "localhost", "username", "password", "database_name", and "table_name" with your actual values.

Let's talk

If you want to get a free consultation without any obligations, fill in the form below and we'll get in touch with you.