How to parse sql queries in php

Question

what i need

   select column1,column2,column3 from table where  condition

output should be

select column1 from table where condition

i try to use explode

     print_r (explode(",",$str));

Output i need

Array

[0] => SELECT column1
[1] => from 
[2] => table

and so on .

but it will split into array and sql is dyanmic .

any suggestion is most welcome.

So your explode() ignores the first space, seems to work on commas as well and converts part of you string to upper-case. Curious. — jeroen
– jeroen, Commented Mar 21, 2018 at 13:02
This will take more than just using explode(). Have you tried anything else? — John Conde
– John Conde, Commented Mar 21, 2018 at 13:08
can php gives input select column1,column2,column3 from table where condition — afeef
– afeef, Commented Mar 21, 2018 at 13:13

Gourgandine · Accepted Answer · 2018-03-21 13:15:59Z

1

Very ugly solution :

$string = "select column1,column2,column3 from table where  condition";

$data1 = explode(" ",$string);
$data2 = explode(",",$data1[1]);
$data1[1] = $data2[0];
$string2 = implode($data1, " ");

print $string2;

answered Mar 21, 2018 at 13:15

Gourgandine

1996 bronze badges

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

2 Comments

afeef Over a year ago

sql column is dynamic it may increase/decrease

Gourgandine Over a year ago

well it dont care of the number of the column here, it just takes the first element (in you example : column1)

Sergi · Accepted Answer · 2018-03-21 13:13:47Z

1

If the performance is not a problem you could try something like:

<?php
$query = 'select column1,column2,column3 from table where  condition';

preg_match('/select (.*) from/i', $query, $matches);
$columns = explode(',', $matches[1]);
var_dump($columns);

http://sandbox.onlinephpfunctions.com/code/4a3ea6230b8efd49f0d99288756cef4fc378975f

answered Mar 21, 2018 at 13:13

Sergi

1406 bronze badges

2 Comments

afeef Over a year ago

i need output sql query select column1 from table where condition

Sergi Over a year ago

@afeef I didn't undertand you. If you can try to put the expected result :)

Collectives™ on Stack Overflow

How to parse sql queries in php

2 Answers 2

2 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related