PHP scripts using CL

[heroine]

Hi All,

I have this scenario, hopefully it can be possible to implement it in php scripting using command line.

I have a datatbase (MySQL) to connect.

By using command prompt:
- So i would like to have a php script to connect to my mysql, and it says it's connected successfully...(i have this code done) additionally, I want this script to allow the end user to enter his/her own database name...be able to create a name which will automatically be generated into mysql. Another script to drop the database ?????? and also give options to user....do you really want to delete or drop ...????
Can both php (connect & create name) be in the same script? how?

Once that's done, the user must be able also to connect through command prompt to a URL, in order to retrieve data and store them into mysql.

Can I find some sample working codes to illustrate all?

Hope to get your comments soooooonnnnn...
thanks a lot for reading....

[benneke]

i'm not sure if it's possible to run php script on a command line. I dont even want to know why you'd want to do this.

i think you need another programming language to achieve what you want.
Perhaps you should use Perl or java (my best bet will be java, because i think its more accessable for people who want to start programming)

what you say, is very much possible to implement in java using JDBC (java database connection).

To create/drop/alter a database is possible to execute in java/perl/php if you use a DDL (Data Definition Language) syntax query that is in the mysql-dialect

[jester22c]

Here is an example of a simple Perl script to connect and query a database. Google has plenty more where that came from.