Table Editor
Fullscreen
Table Generator

How to Convert MySQL Query Output to PHP Array Online ?

1. Upload or paste your MySQL Query Output

If you are querying data in the MySQL command, just paste your MySQL Query Output result into the textarea of Data Source, and it will perform the magical conversion immediately. The Example button is a good practice.

2. Edit your MySQL Query Output online, if needed

You can edit your data online like Excel through Table Editor, and the changes will be converted into PHP Array in real-time.

3. Copy the converted PHP Array

Just copy the generated php array code in Table Generator, and paste it into your php file for testing.

Note: Your data is secure, the converts is done completely in your web browser and we will not store any of your data.

What is MySQL?

.txt

MySQL is a relational database management system (RDBMS) developed by Oracle that is based on structured query language (SQL). A database is a structured collection of data.

What is PHP?

.php

PHP (recursive acronym for PHP Hypertext Preprocessor ) is a widely-used open source general-purpose scripting language that is especially suited for web development and can be embedded into HTML.

Would you recommend this online tool to your friends?