Adlogix is hiring a Senior PHP Developer

Easy SSH tunneling with Putty

Need to access a MySQL server, a RabbitMQ management server or any other (web) server configured on a dedicated/virtual server which is not (or you don’t want to) open to the outside world?

A simple SSH connection and Putty makes this possible:

1. Requirements

Putty SSH client (download)
SSH access to a server

2. Configure Putty

Open the Putty Configuration client, and fill in the field ‘Host Name (or IP address)‘ with the IP or host name of your remote server. In the Connection type section you should select SSH which will set the port automatically to 22.

Once this is done, open the Tunnels section in the menu Connection -> SSH. In this section we are going to configure the port forwarding. Assume we want to access the RabbitMQ management web server which runs on the port 55672. We need to tell Putty to listen on a Source port (=local), and to forward it to the Destination (=remote).

For this example we will configure putty to forward port 1234 to the remote port 55672.

Fill in the ports as displayed in following screen and then click on Add:

If everything is correctly configured click Open. This will open a SSH connection with your remote server and at the same time the configured port forwarding. The major drawback is that you cannot see the port forwarding from that screen. If you also use putty to manage your remote server, you will not see the difference. Of course you can always configure the putty screen to be a different color (if you know alternative tricks, please share )

While the putty connection screens remains open you should be able to access the RabbitMQ management web server by calling http://localhost:1234 in your favorite browser.

As you can see the procedure is really simple and opens a lot of possibilities without having to open different ports on your remote server.

Enjoy

How to use a symfony 1 layout from a different directory

3 Replies

In symfony 1 it is possible to have different layouts for an application. But they all have to be put into the directory ‘myproject/apps/frontend/templates/’. But what if you want to use a layout from another location?

Assume you make a plugin with a specific layout, it would be nice to load the layout from the plugin directory, and not to have to copy the file to the global directory.

Here is how you can achieve this:

$template = $this->getContext()->getConfiguration()->getTemplateDir('MODULE', 'LAYOUT_FILE.php');
$this->setLayout($template . '/LAYOUT_FILE');

Let’s say you have the following:

my_project/
  plugins/
    my_plugin/
      modules/
        MyUser/
          actions/
            actions.php
          templates/
            indexSuccess.php
            MyUserLayout.php

The actions.php class could be something like this:

class MyUserAction extends sfActions {

  public function preExecute() {
    $template = $this->getContext()->getConfiguration()->getTemplateDir('MyUser', 'MyUserLayout.php');

    $this->setLayout($template . '/MyUserLayout');
  }

  public function executeIndex() {

  }
}

Have fun!

Symfony Live 2010 – day 1 #sflive2010

2 Replies

So far everything went great, well not great but ok, the periferique in paris was hell this morning, and we had a 5 hour drive from brussels to paris, thx to a train accident. But… most important… we got here.

We mist the first session on i18n but the second one on admin generator gave me som gr8 ideas on layout. After that, the Microsoft crew came on to stage, and pffff.. shitty presentation… just a promotion and selling of their Azure product. And I wasn’t impressed at all!!!

now lunch, simple but ok. and we’ll see what the next hours bring…

sessions are about to start…

well well well, that was an interesting session by Mr Bachelet. I regret it that he didn’t do the session in french, it would have been better!!! a bit of an overview of all handlers and helper, just isn’t enough I guess…

Questions are answered quite good…. He knows his stuff real good! take your time to present next time.

doctrine migrations was nice. interesting and in particular the question session with a very kind host, answering all questions asked. And believe me, there were a lot of questions

Symfony Live 2010 #sflive2010

2 Replies

On the 16-17th of February the Symfony Live 2010 conference will be held in Paris. A lot promising developers and evangelists will be speakers on this conference like:

Fabien Potencier
Jonathan Wage
Dustin Whittle
Stefan Koopmanschap
…

My colleague and I will attend this conference and, if everything goes well, we will try to update our DevExp blog with live feedback or summarized posts on some of the most interesting sessions.

Read from Excel in ASP

4 Replies

I always had a hard time finding correct documentation on the old ASP (active server pages) language and I needed it one more time in the last few days to create a script that read from an excel file.

As I believe that it might be handy for a handful of people around the world (is there actually anybody else still developing in ASP these days?), I hereby share my little piece of code with you guys.

Any suggestions or comments are always welcome.

In my example we read from an excel file that has 1 small table that has 1000 lines and columns from A until G.
The first row contains all the column names.

'initialize variables
Dim objConn, strSQL
Dim x

Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "DRIVER={Microsoft Excel Driver (*.xls)}; IMEX=1; HDR=NO; "&_
 "Excel 8.0; DBQ=" & Server.MapPath("filename.xls") & "; "
strSQL = "SELECT * FROM A1:G1000"

Response.Write("<table border=""1"">")
Response.Write("<tr>")
'write all columnNames
For x=0 To objRS.Fields.Count-1
 Response.Write("<th>" & objRS.Fields(x).Name & "</th>")
Next
Response.Write("</tr>")

Do Until objRS.EOF

' write as much columns as there are in your excel file
Response.Write("<td>" & objRS.Fields(0).Value & "</td>")
Response.Write("<td>" & objRS.Fields(1).Value & "</td>")
Response.Write("<td>" & objRS.Fields(2).Value & "</td>")
Response.Write("<td>" & objRS.Fields(3).Value & "</td>")
Response.Write("<td>" & objRS.Fields(4).Value & "</td>")
Response.Write("<td>" & objRS.Fields(5).Value & "</td>")
Response.Write("<td>" & objRS.Fields(6).Value & "</td>")

objRS.Close

Response.Write("</table>")

Set objRS=Nothing

Interview: Jean-Baptiste Jung

Interview: Jacob Gube

3 Replies

blogthumb4 Well, well, well after our first interview I guess our ball got rollin’ and we are proud to present our second interview.

This time we got in contact with Jacob Gube who is the founder and maintainer of the Six Revisions weblog having over 35K RSS readers. Let’s hope we reach the same amount one day!!!

Jacob Gube, a web developer and designer who works with PHP, .NET, Flash/ActionScript, XHTML, JavaScript/jQuery/MooTools and MySQL, is the creator and primary author of Six Revisions – a weblog the provides practical, useful information for the modern, standards-compliant web designer and web developer.

What projects are you currently working on?

I’m working on a PHP/MySQL social news site start-up that’s self-funded. No release dates yet and there’s still a lot of work to be done! Also, I’m trying to finish up a JavaScript book.

Continue reading →

How to force symfony colors on windows with PuttyCyg?

13 Replies

Those of you who’re developing with symfony under windows will have noticed that, when running tasks in the command prompt, no colors are used. This is because the windows command prompt isn’t compatible with the color notation.
Most of you also have cygwin installed (shame on you if you didn’t :p). But even if you run the tasks through “PuttyCyg”, which is fully compatible with the color notation, you will not benefit from the colors.

Why?

Continue reading →

Interview: Stefan Koopmanschap

1 Reply

3317597132_6be12c93c7

A few weeks ago I thought it might be cool to get some interesting guys, which are occupied with projects in PHP, interviewed. And guess what, we got on contact with Mr. Stefan Koopmanschap and he was kind enough to answer all our questions.

Stefan Koopmanschap (‘left’) is a PHP developer, consultant and trainer with an eye for best practices. He works at Unet as (symfony) developer and development team leader. He is a community person and is active in the european PHP community as secretary of the phpBenelux Usergroup as well as in the Symfony community by advocating symfony and as the Community Manager.

Stefan has a wide history in Open Source, having been Support Team Leader for phpBB, documentation translator for Zend Framework and community manager, plugin developer and maintainer plus various other things for symfony.

Stefan is also a best practices advocate. He prefers easy and useful explanations of best practices over the academic and theoretical stuff found in most literature.

Hope you enjoy this interview!

Hello Stefan, first of all, thx for taking the time to answer all our questions.

Can you tell us what projects you are currently working on?

At work I am involved in a big project to build an application that will handle all the administration, provisioning and handling of user accounts etc. for the whole VOiP and connectivity of the services we offer. Aside from that, my main projects are being the Community Manager for symfony and also preparing some new talks for the upcoming conferences.

Continue reading →

devexp

DEVelopment EXPerience, shared with the world!

Adlogix is hiring a Senior PHP Developer

Easy SSH tunneling with Putty

How to use a symfony 1 layout from a different directory

Symfony Live 2010 – day 1 #sflive2010

Symfony Live 2010 #sflive2010

Read from Excel in ASP

Interview: Jean-Baptiste Jung

Interview: Jacob Gube

How to force symfony colors on windows with PuttyCyg?

Interview: Stefan Koopmanschap