Web Entwicklung

apache

Installation

apt-get install mysql-server mysql-client apache2 php5 php5-mysql libapache2-mod-php5 phpmyadmin
/usr/bin/mysqladmin -u root password 'enter-your-good-new-password-here'
/etc/init.d/apache2 restart

Konfiguration für die Entwicklung

/etc/php5/apache2/php.ini

error_reporting = E_ALL & ~E_DEPRECATED
display_errors = On

php

pear

apt-get install php5-dev make php-pear

• http://blog.jerrevds.be/article/install-apc-or-pecl-debian
• wp:PEAR - PHP Extension and Application Repository
  • wp:PEAR#PECL - PHP Extension Community Library

cairo

Installation

pecl install cairo
pecl install cairo channel://pecl.php.net/cairo-0.3.2
echo "extension=cairo.so" >>  /etc/php5/apache2/php.ini
/etc/init.d/apache2 restart

• http://cairographics.org/cairo-php/

Beispiel

$s = new CairoImageSurface(CairoFormat::ARGB32, 400, 400);
$c = new CairoContext($s);
$c->fill();
$c->setSourceRGB(1, 0, 0);
$c->setLineWidth(50);
$c->arc(200, 200, 100, 0, 2 * M_PI);
$c->stroke();
$c->setSourceRGB(0, 0, 0.6);
$c->rectangle(0, 160, 400, 75);
$c->fill();
 
$s->writeToPng(dirname(__FILE__)  . '/test.png');

• Getting started with PHP Cairo graphics extension on XP

Probleme

falls das php nicht interpretiert wird, sondern stumpf ausgegeben wird

/etc/php5/apache2/php.ini da nicht "<?php" verwendet wird, muss der short_open_tag aktiviert werden!!!!

short_open_tag = On

• LaMp

mysql

Datenbank&Benutzer anlegen

mysql -u root -p

create database DATABASE;
create user 'USERNAME'@'localhost' identified by 'PASSWORD';
grant all on DATABASE.* to 'USERNAME'@'localhost';

export import

# export
mysqldump --single-transaction --default-character-set=utf8 -u _username_ -p _databasename_ > mysql.yyyymmdd.sql
# import
mysql -u _username_ -p _databasename_ < mysql.yyyymmdd.sql