Hi

As homework for my study I have to do some kind of browser GUI to send commands to mysql command line tool and to show the output in the browser.

I already set up sudo to have the right permissions for the www-data user.

In the php documentation I found that one of the following four commands are probably for tasks like mine.

exec
passthru
shell exec
system

Can anyone tell me which one is the best for my requirements?

The idea is to use php from the browser to connect to mysql like on the command line with:
"mysql –user=username –password"
And then give back the output of the command line to the browser.

If the above is working then the next step would be to put a link in order to execute the command “show database;” again through php by clicking that link.
After clicking this link it would give back to the browser what the command line would display.

Thanks
Markus

If you simply have to connect to mysql, why not use mysql_connect(host, user, password) and then mysql_select_db("name of db") and so on? Then you can use the mysql_error() command to generate the error you need from the connection. However, if you need to see actual command line output, I prefer exec, but that's me.

phpdba: Please read my whole posting. I'm study information technology and i have to do a homework for learning purpose.

Does anyone else have a recommendation on which php command i shall use for interaction of php with the mysql on the sell?
I was even think about to hack a little bit in the phpmyadmin scripts but my php knowhow is just not enough yet.

Thanks
Markus

Hi,

The documentation of PHP is freely available from the web (http://www.php.net).
That said, the best way to connect to a MySQL database from PHP is what has been suggested to you by phpdba.

So now, you have a homework.
So do it your self!
Don't ask or expect others to do it for you.

Regards,

Tshimanga.

I was just expecting kind of an advice from a more advanced linux user to guide me in the right direction. My homework I will do myself, don’t worry about that;-)

To be honest, I don’t see the sense of your posting tshikose, or do you just want to increase your posting count?

bye
Markus