How to do interactive with the prompt this way in PHP?

Question

C:\>mysql -uroot -padmin
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.0.37-community-nt-log MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases
    -> ;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| attendance         |
| fusionchartsdb     |
| mysql              |
| sugarcrm           |
| test               |
+--------------------+
6 rows in set (0.09 sec)

mysql> use mysql;
Database changed
mysql>

So I want to start a process by mysql -uroot -padmin,and in that process I want to run these statements:

 show databases
 use mysql
 insert xxx (..) values (..)

How to do it in PHP?

Answer 1

You can write your own console or use ready-made one called PHPMyAdmin. If your intention is just to interact with mysql server using web-frontend.

Although writing your own could be tricky. Unfortunately, HTTP servers are not interactive. HTTP is stateless protocol. So, you have to find a way to save a state between requests. One of solutions is to use persistent connection. But with goal being unclear it's hard to advise anything certain.

Answer 2

I don't think I follow your question completely...

If you're trying to execute statements in MySQL in PHP, you can use the mysql_* functions.

If you just want to execute a series of commands via the command line, you can use

`mysql -u root -p admin --execute "show databases; use mysql; insert ...."`

If you want to write your own interactive replacement for the MySQL command line tools in PHP, you're going to need a hell of a lot of time and perseverance. Start by reading about PHP's CLI: http://php.net/manual/en/features.commandline.php

Answer 3

The MySQL client uses the readline() library, which is available to PHP as well.

PHP's PEAR commandline app (invoked when you run pear install <package> processes interactive command line input in a similar manner, but without using the full readline library. There's some of the input-reading source here. The key line being $line = fgets(STDIN, 2048);

Answer 4

You can do so via proc_open.

$bin = 'path/to/mysql.exe';
$cmd = $bin . ' -ulocalonly';
$descriptors = array(
  0 => array('pipe', 'r'), 
  1 => array('pipe', 'w'),
  2 => array('pipe', 'r')
);

$process=proc_open($cmd, $descriptors, $pipes, dirname($bin));
if (is_resource($process)) {
  // ....

}

The tricky part is to parse the output of the other process (from $pipes[0] and $pipes[2]) and react on all possible situations (including error handling). You might want to look into the expect pecl extension for that.