Php mysqli with mariadb

Developer Quickstart: PHP and MariaDB

The PHP programming language has long been considered a fairly light and simple solution for developers to use to create robust and creative web applications. In fact, that’s as true now as it has ever been as past few versions of PHP have made the language more appealing than ever. Like many other languages, PHP has the ability to take advantage of the power of MariaDB, and it’s actually a pretty simple and straightforward process. But talk, text in this case, is cheap. So to demonstrate this I’ve created a simple PHP web application called Rolodex to manage contacts. In this article I’m going to highlight, from a high level, some of the fundamental details of using PHP to connect to and communicate with a MariaDB database. Everything I’ll be exploring is based on the code for the Rolodex application, and if you’d like to dive into the code you can check it out here.

Preparing the database

Before jumping into the PHP code for the application it’s important to note that it uses a single database called rolodex.

CREATE TABLE `rolodex`.`contacts` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `name` VARCHAR(100) NOT NULL, `age` INT(3) NOT NULL, `email` VARCHAR(100) NOT NULL, PRIMARY KEY (`id`) ); 

The SQL necessary to run the Rolodex application can be found in the schema.sql file. Tip: If you don’t have an instance of MariaDB up and running yet you can find more information on how to get started in this MariaDB Quickstart Guide.

Configuring the application

To facilitate the use of a MariaDB database within the Rolodex PHP application I’ve created a new file called config.php that contains the configuration settings and database connection object that can be reused across PHP pages. Connecting to and communicating with an underlying MariaDB database is facilitated by the mysqli PHP extension.

 // Basic connection settings $databaseHost = ''; $databaseUsername = ''; $databasePassword = '******'; $databaseName = 'rolodex'; // Connect to the database $mysqli = mysqli_connect($databaseHost, $databaseUsername, $databasePassword, $databaseName); 

Within the config.php file I’ve started by defining variables that hold the host address, username, password and default database that are used to create a new mysqli connection object, which contains a variety of configuration options that you can use to tailor to your environment.

Executing SQL

Using, and reusing, the mysqli connection within config.php is as easy as including it within a PHP code block on another PHP page.

 // Include the database connection file include_once("config.php"); . ?> 

Then, with an established connection, you have the ability to use a plethora of capabilities from the mysqli extension, including executing queries using mysqli_query. Selecting data

 // Include the database connection file include_once("config.php"); // Fetch contacts (in descending order) $result = mysqli_query($mysqli, "SELECT * FROM contacts ORDER BY id DESC"); ?> 

Selecting contacts with mysqli_query Or, in the case that you need to handle dynamically inserted parameter values, you can use mysqli_prepare. Inserting data

$stmt = $mysqli->prepare("INSERT INTO contacts (name,age,email) VALUES(?, ?, ?)"); 

$stmt = $mysqli->prepare("UPDATE contacts SET name=?, age=?, email=? WHERE >); $stmt->bind_param("sisi", $name, $age, $email, $id); $stmt->execute(); 

$stmt = $mysqli->prepare("DELETE FROM contacts WHERE >); $stmt->bind_param("i", $id); $stmt->execute(); 

Deleting contacts using mysqli_prepare As you can see, getting started with PHP and MariaDB is easy, but we’ve only scratched the surface of what’s possible. If you’d like to see for yourself what else is possible with PHP and MariaDB, start by checking out the full source code for the Rolodex application in the new PHP Quickstart GitHub repository.

Learn more

And if you’d like to learn even more about what’s possible with MariaDB be sure to check out the Developer Hub and the new MariaDB Developer Code Central GitHub organization. There you can find much more completely open-source content just like this spanning a variety of other technologies, use cases and even programming languages. You can also dive even deeper into MariaDB capabilities in the official MariaDB documentation. And, as always, MariaDB is deeply rooted in open-source and would be nothing without their awesome community! If you’d like to help contribute directly to MariaDB you can find them on GitHub, send feedback directly to their Developer Relations team at developers@mariadb.com, or join the conversation in the new MariaDB Community Slack! Happy coding!

Источник

Developer Quickstart: PHP mysqli and MariaDB

The PHP programming language has long been considered a fairly light and simple solution for developers to use to create robust and creative web applications. In fact, that’s as true now as it has ever been as the past few versions of PHP have made the language more appealing than ever.

Like many other languages, PHP has the ability to take advantage of the power of MariaDB, and it’s actually a pretty simple and straightforward process.

But talk (or text in this case) is cheap. So to demonstrate this, I’ve created a simple PHP web application called Rolodex to manage contacts.

In this article I’m going to highlight, from a high level, some of the fundamental details of using PHP to connect to and communicate with a MariaDB database. Everything I’ll be exploring is based on the code for the Rolodex application, and if you’d like to dive into the code you can check it out here.

Preparing the database

Before jumping into the PHP code for the application it’s important to note that it uses a single database called rolodex .

The rolodex database contains a single table, contacts , that is used to store basic information.

CREATE TABLE `rolodex`.`contacts` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `name` VARCHAR(100) NOT NULL, `age` INT(3) NOT NULL, `email` VARCHAR(100) NOT NULL, PRIMARY KEY (`id`) );

The SQL necessary to run the Rolodex application can be found in the schema.sql file.

Configuring the application

To facilitate the use of a MariaDB database within the Rolodex PHP application I’ve created a new file called config.php that contains the configuration settings and database connection object that can be reused across PHP pages. Connecting to and communicating with an underlying MariaDB database is facilitated by the mysqli PHP extension.

'; $databaseUsername = ''; $databasePassword = '******'; $databaseName = 'rolodex'; // Connect to the database $mysqli = mysqli_connect($databaseHost, $databaseUsername, $databasePassword, $databaseName); ?>

Within the config.php file I’ve started by defining variables that hold the host address, username, password and default database that are used to create a new mysqli connection object, which contains a variety of configuration options that you can use to tailor to your environment.

Executing SQL

Using, and reusing, the mysqli connection within config.php is as easy as including it within a PHP code block on another PHP page.

Then, with an established connection, you have the ability to use a plethora of capabilities from the mysqli extension, including executing queries using mysqli_query.

Selecting contacts using mysqli_query

Or, in the case that you need to handle dynamically inserted parameter values, you can use mysqli_prepare.

Inserting data

$stmt = $mysqli->prepare("INSERT INTO contacts (name,age,email) VALUES(?, ?, ?)"); $stmt->bind_param("sis", $name, $age, $email); $stmt->execute();

Inserting contacts using mysqli_prepare

Updating data

$stmt = $mysqli->prepare("UPDATE contacts SET name=?, age=?, email=? WHERE $name, $age, $email, $id); $stmt->execute();

Updating contacts using mysqli_prepare

Deleting data

$stmt = $mysqli->prepare("DELETE FROM contacts WHERE $id); $stmt->execute();

Deleting contacts using mysqli_prepare

As you can see, getting started with PHP and MariaDB is easy, but we’ve only scratched the surface of what’s possible. If you’d like to see for yourself what else is possible with PHP and MariaDB, start by checking out the full source code for the Rolodex application in the new PHP Quickstart GitHub repository.

Learn more

And if you’d like to learn even more about what’s possible with MariaDB, be sure to check out the Developer Hub and our new Developer Code Central GitHub organization. There you can find much more content just like this spanning a variety of other technologies, use cases and even programming languages.

You can also dive even deeper into MariaDB capabilities in the official documentation.

And, as always, we’d be nothing without our awesome community! If you’d like to help contribute you can find us on GitHub, send feedback directly to us at developers@mariadb.com or join the conversation in the new MariaDB Community Slack!

Источник

Saved searches

Use saved searches to filter your results more quickly

You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session.

This repository contains a simple web application that demonstrates how to quickly connect to and communicate with a MariaDB database using PHP (via mysqli).

License

mariadb-developers/php-quickstart

This commit does not belong to any branch on this repository, and may belong to a fork outside of the repository.

Name already in use

A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?

Sign In Required

Please sign in to use Codespaces.

Launching GitHub Desktop

If nothing happens, download GitHub Desktop and try again.

Launching GitHub Desktop

If nothing happens, download GitHub Desktop and try again.

Launching Xcode

If nothing happens, download Xcode and try again.

Launching Visual Studio Code

Your codespace will open once ready.

There was a problem preparing your codespace, please try again.

Latest commit

Git stats

Files

Failed to load latest commit information.

README.md

This repository contains a simple web application that demonstrates how to quickly connect to and communicate with a MariaDB database using PHP (via mysqli).

⚠️ Interested in using MariaDB and PHP with PDO (PHP Data Objects)? Check out the quickstart here!

The application in this repository demonstrates how to:

• Connect to a MariaDB database using mysqli
• Execute queries ( SELECT , UPDATE , INSERT and DELETE ) to manage contact data (like a digital rolodex)
• Use prepared statements

The application relies on a single database ( rolodex ) that contains a single table ( contacts ). You can find the necessary SQL for setting up the environment in schema.sql.

After you’ve pulled down this repository, follow these steps to get the app up and running:

Update the database configuration settings in config.php (which is used across the app) to point to your MariaDB database. Example configuration:

$databaseHost = '127.0.0.1'; $databaseUsername = 'user_name'; $databasePassword = '********'; $databaseName = 'rolodex';

Please feel free to submit PR’s, issues or requests to this project directly.

If you have any other questions, comments, or looking for more information on MariaDB please check out:

Or reach out to us directly via:

About

This repository contains a simple web application that demonstrates how to quickly connect to and communicate with a MariaDB database using PHP (via mysqli).

Источник