IMAGE (BANNER) DESCRIPTION (4000 characters) :
aaaaaaa yyyyyy yyyyyyyyyyyy $tmp_imgpath=/srv/disk16/3266814/www/phporacle.eu5.net/fwphp/glomodul/post/Uploads/twitter.jpg
$tmp_imgurlrel=Uploads/twitter.jpg

Post content :

Revised November 2019.

1. Install Apache, PHP, Oracle DB 11g XE & 11g, Oracle Forms 6i and 12c & Reports on Win 10 (all 64bit)

HOME Downloads are now: https://github.com/slavkoss/fwphp

26.oct.2019 I use 64 bit XAMPP: PHP 7.3.7 AND APACHE 2.4.38. on Windows 10 64 bit.PDO: mysql, oci, sqlite ARE WORKING.Oracle db 11gXE (no more E. Rangel pdooci – pdo sintax on oci8 program layer).

I tried 4-5 WAMP server SW. WAMP and ZWAMP are ok but XAMPP unzip is simplest – almost 1 click . WAMP has problem with composer installations from Windows command line. Next shows more details about ZWAMP (I do not use ZWAMP recently) :

1. Unzip zwamp-x64-2.2.1-full.zip to J:\zwamp64
2. Rename old J:\zwamp64\vdrive\.sys\Apache2 dir to Apache2_2_4_16
3. Download Apache : http://www.apachelounge.com
   Create dir J:\zwamp64\vdrive\.sys\Apache2.
   Unzip httpd-2.4.20-win64-VC14.zip– it’s Apache24 folder content to :
   ServerRoot J:/zwamp64/vdrive/.sys/Apache2 (or c:/Apache24 = ServerRoot) in httpd.conf
   Default folder for your your webpages is DocumentRoot
   DocumentRoot J:/zwamp64/vdrive/.sys/Apache2/htdocs
   Directories
   ScriptAlias – also when you use extra folder config file(s) change to your location there
4. No changes in J:\zwamp64\vdrive\.sys\Apache2_2_4_16\conf\extra
5. changes in J:\zwamp64\vdrive\.sys\Apache2\conf :
   copy here own httpd.conf ver 2.4.16 to conf dir (rename original before copying)
   copy here own vhosts.conf ver 2.4.16 to conf dir
6. J:\zwamp64\vdrive\.sys\Apache2\conf\httpd.conf :
   LoadModule php7_module /.sys/php/php7apache2_4.dll
   AddType application/x-httpd-php .php# without this OCI8 and PDO MySQL and PDO sqlite are not visible in inet browser
   are visible in php CLI
   PHPIniDir /.sys/php
7. Download PHP: http://windows.php.net/download/
   php-7.0.8-Win32-VC14-x64.zip same unzip as apache zip above.
8. Downloadnewest oci8-2.1.1 Extension for php 7.0.8 64 bit on Windows 10 64 bit – april 2016 (older does not work) :
   OCI8 is also for E.Rangels PDOOCI.
   https://pecl.php.net/package/oci8/2.1.1/windows – Windows dll-s
   https://pecl.php.net/package/oci8 – for Linux
   released by christopher.jones@oracle.com
   https://blogs.oracle.com/opal/entry/php_7_oci8_2_1
   php_oci8-2.1.1-7.0-ts-vc14-x64_Jones_pecl.php.net.zip
   Unzip it’s dll-s to: J:\zwamp64\vdrive\.sys\php\ext
   Christopher Jones’s oci8-2.1.1 for php 7 :
   dir J:\zwamp64\vdrive\.sys\php\ext\php_oci*.*
   18.04.2016. 05:20 155.136 php_oci8.dll
   18.04.2016. 05:20 790.528 php_oci8.pdb – WHAT IS THIS ?
   18.04.2016. 05:20 157.184 php_oci8_11g.dll
   18.04.2016. 05:20 790.528 php_oci8_11g.pdb
   18.04.2016. 05:20 158.208 php_oci8_12c.dll
   18.04.2016. 05:20 790.528 php_oci8_12c.pdb
   7 File(s) 2.997.248 bytes
9. J:\zwamp64\vdrive\.sys\php\php.ini
10. 2click J:\zwamp64\zwamp.exe -> right click house icon -> restart
    -> started Apache and MySQL. If not both started very useful is :
    J:\zwamp64\vdrive\.sys\Apache2\bin>httpd.exe
    – this report errors, same as :
    php -v
    PHP 7.0.8 (cli) (built: Jun 21 2016 15:15:15) ( ZTS )
    Copyright (c) 1997-2016 The PHP Group
    Zend Engine v3.0.0, Copyright (c) 1998-2016 Zend Technologies
    or
    php -r “var_dump(function_exists(‘oci_connect’));”
    or
    C:\WINDOWS\system32>php -r “if (! $dbc = oci_pconnect(‘hr’, ‘hr’, ‘ora7’, ‘UTF8’)) echo ‘***** 1. UNSUCCESSFULL db connect *****’; else {echo \”\n\”; echo ‘~~~ PARSE-BIND-EXECUTE-FETCH ~~’; echo \”\n\”; echo ‘SUCCESSFULL db connect’; echo \”\n\”; $dml=’SELECT first_name, phone_number FROM (SELECT first_name, phone_number FROM employees ORDER BY first_name) where rownum < 3′; echo $dml; echo \”\n\”; $parse_stid = oci_parse($dbc, $dml); if (!$parse_stid) { $m = oci_error($conn); echo ‘skripta: ‘ . __FILE__ ; echo’ says neuspio oci_parse : ‘ ; echo $m[‘message’]; } $exec_ret = oci_execute($parse_stid); echo ‘oci_execute returned: ‘; print_r($exec_ret); echo \”\n\”; echo ‘oci_fetch_array returned: ‘; $row = oci_fetch_array($parse_stid, OCI_ASSOC + OCI_RETURN_NULLS); print_r($row); }”WHICH DISPLAYS:~~~ PARSE-BIND-EXECUTE-FETCH ~~
    SUCCESSFULL db connect
    SELECT first_name, phone_number FROM (SELECT first_name, phone_number FROM employees ORDER BY first_name) where rownum < 3
    oci_execute returned: 1
    oci_fetch_array returned: Array
    (
    [FIRST_NAME] => Adam
    [PHONE_NUMBER] => 650.123.2234
    )
11. Not needed if we use ZWAMP :
    Install Apache as a service:
    httpd.exe -k install httpd.exe -k restart, or stop
    ApacheMonitor: (not needed if we use ZWAMP):
    Double click ApacheMonitor.exe, or put it in your Startup folder.

28.11.2015 INSTALLATION APACHE 2.4.16 (Win64) & PHP 7.0.0 RC5 MSVC14 (Visual C++ 2015) x64 ON J:\zwamp\vdrive\.sys\Apache2 (& …\php) OR ON C DISK

Install as a service (not needed if using XAMPP or ZWAMP or WAMP):
httpd.exe -k install
httpd.exe -k restart
httpd.exe -k stop
ApacheMonitor: Double click ApacheMonitor.exe, or put it in your Startup folder.

Use PGP Signature and/or the SHA Checksums to verify the integrity.
C:\gnuwin32\bin\sha1sum.exe -help
sha1sum.exe -b J:\0downl\1_instalirano\Apache_httpd-2.4.16-win64-VC14.zip :
d917094cf13ecea83938aa58058ea7c5c6ef2756
Checksums created with GPGHash by SmartJuwel
Creation date: 22.07.2015 with GnuPG Version: 1.4.18
SHA1-Checksum for: httpd-2.4.16-win64-VC14.zip:
D917094CF13ECEA83938AA58058EA7C5C6EF2756
or SHA224-Checksum or SHA256-Checksum or SHA384-Checksum

phphttp://windows.php.net/qa/For Apache on Windows: Thread Safe

I did not used Instant Client :
Oracle Database drivers for popular languages and environments including Node.js, Python and PHP can use Instant Client to connect to local or remote DBs.
https://community.oracle.com/thread/1051752 :
1. Download 64 or 32-bit Oracle Instant Client – there is no MSVC14 build 6.8.2015
2. put it somewhere useful (I put it under my php directory)
3. Add it to your system’s PATH. (A quick & dirty fix on Windows is to copy
all of the *.dll files from the 11g InstantClient package* into same dir
as your webserver’s executable (e.g. httpd.exe).)
http://www.oracle.com/technetwork/database/features/instant-client/index-100365.html
4. Edit your php.ini and uncomment extension=php_oci8_11g.dll

I did not 1. to 4. above !

Stories on WEB that excellent (but never finished and abandoned) old 32 bit F6i, R6i SW and new Windows do not work together are not true. See also – they managed same as I (good site, could give more details):
Installing Oracle Developer (forms & reports 6i) on Windows 7 64bit
and
Oracle Developer 6i & Oracle database 11g R2 (11.2.0.1.0)
Great question to Oracle who says “we do not leave our customers who still use F6i & R6i” – but F6i & R6i can not even be downloaded from Oracle:
Why 32 bit F6i & R6i can not be patched to be certificated on 64 bit 11g and 64 bit Windows ? Oracle Power Objects (SW simmilar to F6i & R6i ) is also abandoned SW.
Today is modern to make new SW, worse than old (nobody begins new project with F11 & R11 – they are rather applications than development SW) and forget poor bastards who bought abandoned SW. So they cut their expenses (and our lifes). Simmilar stories are Microsoft ASP-VS2008-Silverlight, Google AngularJS 1.x – 2.x, over 100 development SW around…
Incompetent managers and trade departments cut our lifes, but they should know that life is not child joke.

APACHE – USE THREAD SAFE (TS) VERSIONS OF PHP BINARIES FOR WINDOWS

MULTITHREAD CAPABLE BINARIES BUILDS – INTERACTION WITH A MULTITHREADED SAPI AND PHP LOADED AS A MODULE INTO A WEB SERVER.

Use Apache builds provided by Apache Lounge– PHP official site use their binaries to build Apache SAPIs.

VC9 builds require you to have the Visual C++ Redistributable for Visual Studio 2008 SP1 x86 or x64 installed.
VC11 builds require to have the Visual C++ Redistributable for Visual Studio 2012 x86 or x64 installed. and so on

PECL FOR WINDOWS:PECL extensions for Windows is being worked on. Windows DLL can be downloaded right from thePECL website.
PECL extension release and snapshot build directories are browsable directly.

Not needed for 64 bit Apache, PHP, 11XE all three on home PC..
Download from http://www.oracle.com/technetwork/topics/winx64soft-089540.html
instantclient-basic-windows.x64-12.1.0.1.0.zip (64,939,911 bytes) (cksum – 3658834848)
extract to: C:\Windows\SysWOW64\instantclient_12_1
and set it on Win PATH variable + H:\Apache24\bin,
(NO: THERE ARE MORE PHP INSTALLATIONS (only 1 Apache): + H:\php)

C:\Apache24\bin>echo %SystemRoot%
outputs: C:\Windows

C:\Apache24\bin>path

extension=php_oci8_11g.dll (remove the “;” from the start of the line)

Restart Apache (XAMPP or WAMP server)

Open file to see database name as
C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN\tnsnames.ora
// D:\app\Farhan\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora

LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.168.1.2)
)
)

Service name is “orcl.168.1.2”, my is: XE :

XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = sspc)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) ) ora7 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = sspc)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) )

ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) )

See https://github.com/slavkoss/fwphp/blob/master/fwphp/glomodul/z_examples/index.php
for httpd.conf, vhosts.conf, C:\Windows\System32\drivers\etc\hosts, php.ini

kod edit phpinfo EOKOD; /* call it so: kod_edit_run( $idx // script_dir_path , $idxscript // script_name , MDURL); // web_docroot_url = (Apache) web server URL */ }

TXT AFTER EACH POST : I have odd cosmic thoughts every day

Science is an enterprise that should be cherished as an activity of the free human mind...

Venus has a runaway greenhouse effect. ... we're twiddling knobs here on Earth without knowing the consequences of it. Mars once had running water. Something bad happened there as well.