D-talk (Entries tagged as planetphp)

Connecting from PHP on a non Microsoft OS to MSSQL with a domain account

nospam@example.com (Mark van der Velden) — Fri, 04 Jun 2010 07:24:00 +0200

I was asked to create a web interface front-end with Microsoft Dynamics CRM as back-end. But I had some troubles setting up the connection, since it has to be done using a domain logon. This doesn't have to be a problem at all, unless your configuration is wrong! In this article I'll explain a few things and point you in the right direction when you have login problems.

As stated earlier, the server running the PHP installation is not Microsoft. In this case a AS400 installation, but it could've been a Linux installation also. I'm using PDO for this article and PHP version 5.2.11. Even if you don't want to use PDO, I recommend using it only for debugging (if possible) since that will give you *most likely* more debug information then the mssql_* family.

When using PDO with a MS-SQL database, you'll need to supply "dblib" as driver and DBLib uses FreeTDS as underlaying library. FreeTDS can be a source of troubles when you're trying to connect, if not configured properly. So I'll kick-off with a little information about it. Don't skip it if you have login problems!

Continue reading "Connecting from PHP on a non Microsoft OS to MSSQL with a domain account"

Multiple PHP versions on one webserver

nospam@example.com (Mark van der Velden) — Tue, 03 Nov 2009 08:39:00 +0100

Introduction

This is a blog about running two PHP versions on one webserver and using multiple php.ini files, this combination can be a tricky one to tackle. But luckily one we can tackle quite easily as long as one of the PHP versions is >= 5.2.7. For this example I'll be using Apache, but the webserver flavor doesn't really matter. The most important part is the "PHP_INI_SCAN_DIR" environment variable.

The why

There could be a number of reasons to want what I'm about to talk about. In my case I have a project where I have a legacy code-base, running on a specific PHP version, and a new code-base which will be run on 5.3. Because the new code-base will be a ongoing progress of replacing the old, it first has to run side by side with the legacy code-base. So I wanted my development image to run two PHP versions.

The old code-base used php.ini settings such as a include-path, error reporting, etc. Which will be different from the new code-bas, and those can no-longer be set with the 'php_value' feature of Apaches since the PHP version we'll be using for that runs as (f)CGI rather then as module.

Continue reading "Multiple PHP versions on one webserver"

PHP Quiz part 3

nospam@example.com (Mark van der Velden) — Mon, 21 Sep 2009 17:35:00 +0200

Welcome to another part of the PHP Quiz series, again some interesting questions to crack your brain about. If you have some nice additions or questions, be sure to leave a comment. Enjoy part three!

As always, think of the answer before you execute the code or look it up. You can find round two here.

Unset cast

What is the type of $a and what is the type of $b

$a = "A";
$b = (unset) $a;
var_dump($a, $b);

Form fun

What will the output be?

Fun with strings

Strings in PHP are versatile, but how versatile are they... What will the output be?

$juggling = "Itffkhmf";
$rox = "Spy";
$b = $c = "";
for ($i=0; $i<strlen($juggling); $i++) {
$b .= $juggling[ $i ];
$b++;
}
for ($i=0; $i<strlen($rox); $i++) {
$c .= $rox[ $i ];
$c--;
}

var_dump( $b, $c );

Continue reading "PHP Quiz part 3"

Did you know... part two

nospam@example.com (Mark van der Velden) — Thu, 25 Jun 2009 19:14:00 +0200

In these blog series I'd like to talk a bit about some "Did you knows". These series contain information I came across along the way and I mention them here to give you insight or just to make you aware of it's existence. The information is by no means in chronological order and mostly not even covering "state of the art" or "brand new" items for that matter. Some are directly code related, others are just brief descriptions. Basically it's just a pile of PHP and web related information. You can find part one here.

Continue reading "Did you know... part two"

PHP Quiz part 2

nospam@example.com (Mark van der Velden) — Thu, 14 May 2009 10:41:00 +0200

A short quiz this time, but that doesn't make it less fun. Do you know the answer to all of them? Get a cup of coffee and kill 10 minutes with round two...

As always, think of the answer before you execute the code or look it up. You can find round one here.

Array pointer

What will the output be ?

$array = range(0,5);
next($array);
foreach($array as $v) {
echo $v;
}

ArrayAccess and isset fun

isset or not isset, thats the question.

$a = new ArrayObject;
$a['fubar'] = NULL;
$null = NULL;

if (isset($null)) {
echo 1;
} else {
echo 2;
}

if (isset($a['fubar'])) {
echo 1;
} else {
echo 2;
}

if (array_key_exists('fubar', $a)) {
echo 1;
} else {
echo 2;
}

Typo?

The output might be confusing..

array(4>'a')

References

How many notices will be thrown?

error_reporting(E_ALL);
function a( & $array) {}
function b($array) {}
a($array);
b($array);

Continue reading "PHP Quiz part 2"

Did you know... part one

nospam@example.com (Mark van der Velden) — Tue, 11 Nov 2008 21:59:00 +0100

In this blog post I'd like to talk a bit about some "Did you know's". With these "Did you know" blog posts I want to tell you a few things that I came across along the way and hopefully you know some I don't know yet! Some DYK's are directly code related, others are just here to give you insight and some are just to let you know of it's existence (Afteral you don't search for what you don't know about.)

So here they come in random/chaotic order:

Writable directories

Not so PHP specific, but often miss-used is checking for writable directories/paths. Directories don't have to be readable to be used for writing, but they do have to be writable and executable.

So a check like this, is simply incomplete:

$dir = '/tmp/cache/';
if (is_writable($dir)) {
touch($dir . 'cache.txt');
}

And will simply fail if the directory is writable but has no execute attributes (mode 0666). This is especially trouble, and can keep you occupied for a long time when using the shutup (@) parameter...

Form name attribute character conversions

Due to legacy PHP versions and to my understanding mostly due the register_globals feature, some HTML form name attribute characters are translated. The idea behind it makes sense, however it's applied in a strange way.

For example <input type="text" name="fu.bar" value="" > in a form with post method, get's translated (even in the current PHP 6 roadmap) into: $_POST['fu_bar']. This happens with the "." and " " characters. But not with '-' which seems weird, because $fu-bar isn't a valid variable, but '-' is a valid HTML input name attribute character. You probably never need it, but I had situation recently where I was flabbergasted of why array key's where different from their HTML counterparts and I completely forgot about this behavior.

Continue reading "Did you know... part one"

Best practices, part one

nospam@example.com (Mark van der Velden) — Fri, 24 Oct 2008 17:11:00 +0200

Best practices are ways of solving problems in a good way, these practices change over time and can depend on versions. A lot of people who have their roots in PHP4 have habits that are no longer best practices. But not just them, a lot of developers don't apply best-practices rules. In this blog post I'd like to point out a few reminders or refreshing points for you to take in. Most you will probably know but some you might not know or didn't look for. If you know some nice additions, make a comment and I'll add it.

Enjoy!

Continue reading "Best practices, part one"

Be careful with double extensions

nospam@example.com (Mark van der Velden) — Fri, 24 Oct 2008 13:43:00 +0200

Since I'm on a 'finish blog drafts' spree, I might as well publish this one also. I actually had it in draft for about 5 months now anyway.

In most upload tools files are checked on extensions only, while it might seem pretty solid it's actually not as safe as you might think. Especially in combination with Apache and mod_mime.

When you do:
rename image.jpg image.txt and you request it: domain.com/image.txt you get garbled text.

However when you try something like this:
rename file.php file.php.bogus and you request it: domain.com/file.php.bogus PHP code within the file is handled by the handler set for that extension.

Before you get all excited, the scenario when this happens is not likely to happen, because it only works for unknown file extensions. So basically, this can only happen when you work with black-listing rather then white-listing. And when checking files, you shouldn't be black-listing in the first place. Let's go into detail about the why.

Continue reading "Be careful with double extensions"

PHP Quiz part 1

nospam@example.com (Mark van der Velden) — Thu, 24 Apr 2008 21:50:30 +0200

Simple things of PHP can be just as fun as the advanced things in PHP!
To prove that I wanted to make a small quiz, and here it is.

Below you'll see 10 pieces of PHP5 code, the goal is to figure out the code and know the output before you actually run it.
Have fun!

Comment and closing tag

<?php // Without cheating.. What will you see when you run this single line of ?\?> php code

Echo print and get what

<?php
// What do you expect from this ?
echo print( 1 ); ?>

What wil eval to true

<?php
// How many times will we get 'true' ?

$boolean = false;
echo ($boolean) ? 'true' : 'false';

$boolean = '0';
echo ($boolean) ? 'true' : 'false';

$boolean = '00';
echo ($boolean) ? 'true' : 'false';

Continue reading "PHP Quiz part 1"