How to create table after create database using shell_script in PHP?

Question

After solve the issue to create a database using shell_script in php, see this post link, I was trying to create tables inside the same shell_exec command.

I have these lines:

$sql="CREATE DATABASE IF NOT EXISTS dbtest; use dbtest; CREATE TABLE MyGuests (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
firstname VARCHAR(30) NOT NULL,
lastname VARCHAR(30) NOT NULL,
email VARCHAR(50),
reg_date TIMESTAMP
) ";

shell_exec("mysql -uroot -pmypasswrd  -e  \"$sql\" ");

This code only creates the database, but not creates the table. My question is how accomplish this task using shell_exec()? Is it possible to run a sql satatment that comes from a mysqldump using shell_exec()?

I couldn't find anything on this really, but see if this helps gotoanswer.com/… — Funk Forty Niner
– Funk Forty Niner, Commented Jun 28, 2015 at 19:46
I though I saw somewhere that after -e we could use sql statements separeted by ; — IgorAlves
– IgorAlves, Commented Jun 28, 2015 at 19:51
I've never used that method before, so I thought I'd Google around for you to see if I could find anything related. Did the info on that page help you? — Funk Forty Niner
– Funk Forty Niner, Commented Jun 28, 2015 at 19:52
Hi Fred, you link gave new information, but didnt solve the problem. Thkns — IgorAlves
– IgorAlves, Commented Jun 29, 2015 at 9:49

RhinoLarva · Accepted Answer · 2015-06-28 20:19:49Z

1

This code only creates the database, but not creates the table. My question is how accomplish this task using shell_exec()?

The only one solution I can find for your problem is to write your whole SQL query in one line (without breaking it into several lines). It will affect the readability of your code, but your table will be created.

answered Jun 28, 2015 at 20:19

RhinoLarva

8552 gold badges11 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

IgorAlves Over a year ago

Yes, you are wright. I just run a script to delete "\n" to the end of the line (that is invisible) and it worked. I still have some issues because my sql script is 10k lines. But the main issue was "\n" that is not a sql command and stopped the shell_exec -e.

Collectives™ on Stack Overflow

How to create table after create database using shell_script in PHP?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related