indenting SQL in php_mode

indenting SQL in php_mode

[Frank Thieme]

Hi!

After years I'm back on Emacs. At the moment I'm writing a PHP/Mysql
project and wonder how I can get some indentation on the SQL statements
within PHP code.

When I write function calls like

foo($bar,
    $foobar);

I can indent pressing <Tab> key. But when I do same for SQL just nothing
happens:

$query = "SELECT foo
FROM bar
WHERE foobar"

I have to manually indent...

any hints?

Bye...Frank

Re: indenting SQL in php_mode

[Ian Eure]

On Dec 7, 2008, at 11:45 AM, Frank Thieme wrote:

> Hi!
>
> After years I'm back on Emacs. At the moment I'm writing a PHP/Mysql
> project and wonder how I can get some indentation on the SQL  
> statements
> within PHP code.
>
> When I write function calls like
>
> foo($bar,
>    $foobar);
>
> I can indent pressing <Tab> key. But when I do same for SQL just  
> nothing
> happens:
>
> $query = "SELECT foo
> FROM bar
> WHERE foobar"
>
> I have to manually indent...
>
> any hints?
>
There's no easy solution, unfortunately. I think the only thing you  
can do is et up MMM or MuMaMo so those regions are sql-mode instead of  
php-mode, and use sql-indent.el.

I've never had the patience to get either of those working, so I just  
align it by hand in the source, or edit the query in a *SQL* buffer,  
then dump it into the source in a here document.

  - Ian

Re: indenting SQL in php_mode

[Frank Thieme]

On Mo 08 Dez 2008 06:57, Ian Eure <ian@digg.com> writes:

> There's no easy solution, unfortunately. I think the only thing you
> can do is et up MMM or MuMaMo so those regions are sql-mode instead of
> php-mode, and use sql-indent.el.
>
> I've never had the patience to get either of those working, so I just
> align it by hand in the source, or edit the query in a *SQL* buffer,
> then dump it into the source in a here document.

Mmh, I know what you mean. I think it would be sufficient if indentation
is like in text-mode, but somehow this seems to be disabled.

Bye...Frank

Re: indenting SQL in php_mode

[Lennart Borgman]

On Mon, Dec 8, 2008 at 12:08 PM, Frank Thieme <fthieme@gmx.net> wrote:
> On Mo 08 Dez 2008 06:57, Ian Eure <ian@digg.com> writes:
>
>> There's no easy solution, unfortunately. I think the only thing you
>> can do is et up MMM or MuMaMo so those regions are sql-mode instead of
>> php-mode, and use sql-indent.el.
>>
>> I've never had the patience to get either of those working, so I just
>> align it by hand in the source, or edit the query in a *SQL* buffer,
>> then dump it into the source in a here document.

Could you please show me some examples of how sql in php look? (Delimiters etc.)

Re: indenting SQL in php_mode

[Frank Thieme]

On Mo 08 Dez 2008 14:32, "Lennart Borgman" <lennart.borgman@gmail.com> writes:

> Could you please show me some examples of how sql in php look? (Delimiters etc.)

I don't know whether there is a standard, but I do it like this:

$query = "SELECT field1,
                 field2,
                 field3
          FROM table1 t1,
               table2 t2
          WHERE t1.foo = t2.bar
            AND field1 = 'foobar'";

Bye...Frank

Re: indenting SQL in php_mode

[Lennart Borgman]

On Mon, Dec 8, 2008 at 3:01 PM, Frank Thieme <fthieme@gmx.net> wrote:
> On Mo 08 Dez 2008 14:32, "Lennart Borgman" <lennart.borgman@gmail.com> writes:
>
>> Could you please show me some examples of how sql in php look? (Delimiters etc.)
>
> I don't know whether there is a standard, but I do it like this:
>
> $query = "SELECT field1,
>                 field2,
>                 field3
>          FROM table1 t1,
>               table2 t2
>          WHERE t1.foo = t2.bar
>            AND field1 = 'foobar'";

Thanks, Frank, but I thoiught you meant a file with mixed php and sql
code, or? How does the delimiters from the php code look?

Re: indenting SQL in php_mode

[Ian Eure]

On Dec 8, 2008, at 8:27 AM, Lennart Borgman wrote:

> On Mon, Dec 8, 2008 at 3:01 PM, Frank Thieme <fthieme@gmx.net> wrote:
>> On Mo 08 Dez 2008 14:32, "Lennart Borgman"  
>> <lennart.borgman@gmail.com> writes:
>>
>>> Could you please show me some examples of how sql in php look?  
>>> (Delimiters etc.)
>>
>> I don't know whether there is a standard, but I do it like this:
>>
>> $query = "SELECT field1,
>>                field2,
>>                field3
>>         FROM table1 t1,
>>              table2 t2
>>         WHERE t1.foo = t2.bar
>>           AND field1 = 'foobar'";
>
> Thanks, Frank, but I thoiught you meant a file with mixed php and sql
> code, or? How does the delimiters from the php code look?
>
It's not like PHP-in-HTML, where there are explicit delimiters. It's  
just stored in a variable as a long string.

You'd have to use the variable declaration as the delimiter and force  
people to use $sql (or whatever).

  - Ian

Re: indenting SQL in php_mode

[Lennart Borgman]

On Mon, Dec 8, 2008 at 6:38 PM, Ian Eure <ian@digg.com> wrote:
> On Dec 8, 2008, at 8:27 AM, Lennart Borgman wrote:
>
>> On Mon, Dec 8, 2008 at 3:01 PM, Frank Thieme <fthieme@gmx.net> wrote:
>>>
>>> On Mo 08 Dez 2008 14:32, "Lennart Borgman" <lennart.borgman@gmail.com>
>>> writes:
>>>
>>>> Could you please show me some examples of how sql in php look?
>>>> (Delimiters etc.)
>>>
>>> I don't know whether there is a standard, but I do it like this:
>>>
>>> $query = "SELECT field1,
>>>               field2,
>>>               field3
>>>        FROM table1 t1,
>>>             table2 t2
>>>        WHERE t1.foo = t2.bar
>>>          AND field1 = 'foobar'";
>>
>> Thanks, Frank, but I thoiught you meant a file with mixed php and sql
>> code, or? How does the delimiters from the php code look?
>>
> It's not like PHP-in-HTML, where there are explicit delimiters. It's just
> stored in a variable as a long string.
>
> You'd have to use the variable declaration as the delimiter and force people
> to use $sql (or whatever).

Ah, thanks, I see. This is of course possible to do, something similar
is done for style="..." in for example nxhtml-mumamo-mode. However
here it looks like something more flexible would be good. I will put
it on my todo-list.

Re: indenting SQL in php_mode

[Frank Thieme]

On Mo 08 Dez 2008 17:27, "Lennart Borgman" <lennart.borgman@gmail.com> writes:

> Thanks, Frank, but I thoiught you meant a file with mixed php and sql
> code, or? How does the delimiters from the php code look?

This is mixed code - it is a PHP string containing a SQL query. I'm
sorry, I don't really know what information do you need...

For more examples you could look at the PHP manual of the Mysql
interface:

e.g.: http://de.php.net/manual/en/function.mysql-query.php

Bye...Frank