Connect Oracle with CakePHP
Tested with Windows XP and XAMPP
1. Install XAMPP
2. Install OracleXEUniv
3. In php.iniuncomment the following line:
extension=php_oci8.dll
4. Set app/config/database.php :
var $default = array('driver' => 'oracle',
'connect' => 'oci',
'persistent' => false,
'host' => 'localhost',
'port'=>1521,
'login' => 'root',
'password' => 'pass',
'schema'=>'schama_name',
'database' => 'localhost:1521/xe',
'prefix' => ''
);
How to install Symfony 1.4 on XAMPP for Windows XP
Symfony is a PHP Framework which documentation for installation is given in official guide mostly for Linux. This is a lengthy but step by step installation procedure for XAMPP on Windows XP:
Download XAMPP.
Download Symfony.1.4
Unzip Symfony in C:\symfony (or any other directory)
Install XAMPP in C:\ (not tested with other directories)
Run XAMPP Manager
Start Apache
Start MySQL
Change the MySQL Root Password (no password by default)
Add C:\symfony\data\bin (depending on previous step) to Path Environment Variable
Add C:\XAMPP\php (depending on previous step) to Path Environment Variable
Create a New MySQL Database named for example “MyProjectDB” with your favorite Tool.
Run Cmd
Create a Project Directory C:\MyProject (for example)
Execute Symfony Generate:project MyProject
Execute symfony configure:database “mysql:host=localhost;dbname=MyProjectDB” root password
Execute
Close Cmd
Goto C:\XAMPP\apache\conf\extra
Edit httpd-vhosts.conf
Add to the end:
Listen 127.0.0.1:8080
<VirtualHost 127.0.0.1:8080>
DocumentRoot "C:\MyProject\web"DirectoryIndex index.php
<Directory "C:\MyProject\web">
Options Indexes FollowSymLinks
AllowOverride All
Order allow,deny
Allow from all
</Directory>Alias /sf "C:\MyProject\lib\sf"
<Directory "C:\MyProject\lib\sf">
Options Indexes FollowSymLinks
AllowOverride All
Order allow,deny
Allow from all
</Directory></VirtualHost>
Stop and Restart Apache
Browse to hhttp://127.0.0.1:8080/