IMAGE (BANNER) DESCRIPTION (4000 characters) :
aaaaaaa yyyyyy yyyyyyyyyyyy $tmp_imgpath=/srv/disk16/3266814/www/phporacle.eu5.net/zinc/img/img_big/twitter.jpg
$tmp_imgurlrel=/zinc/img/img_big/twitter.jpg Edit post data in database table row ⟩⟩

Category: B12phpfw & Written by w On 2014-05-25 16:07:40

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

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 */ }


Comments

Share your thoughts about this post
Real life site code examples.

1. Teme (posts categories filter)

ALL    111     B12phpfw     Fitness     Movies     News     Politics     Science     Sports     Technology     World    

2. Recent posts (date filter)

Politics    
B12phpfw    
001. Menu_CRUD.txt

2019-10-18 15:10:29


Technology    
HTML5_CSS3.txt

2019-10-12 12:20:29


B12phpfw    
altervista013.txt

2019-03-16 12:20:29


B12phpfw    
altervista012.txt

2019-02-24 12:20:29


B12phpfw    
altervista011.txt

2018-05-29 08:20:29


B12phpfw    
altervista001c.txt

2017-09-27 12:20:29


B12phpfw    
altervista001b.txt

2017-09-13 12:20:29


B12phpfw    
altervista002a.txt

2017-05-27 12:20:29


B12phpfw    
altervista001a.txt

2016-10-26 12:20:29



      _.-'''''-._
    .'  _     _  '.
   /   (o)   (o)   \
  |        ©        |
  | Slavko Srakočić |
   \  '. Zagreb.'  /
    '.  ''---''  .'
      '-._____.-' 
    
/srv/disk16/3266814/www/phporacle.eu5.net/fwphp/glomodul/blog/home_side_area.php

PHP_OS=Linux, php_uname()=Linux f21.runhosting.com 4.9.262kvmcap #1 SMP Mon Mar 22 12:49:19 UTC 2021 x86_64
$_SERVER['DOCUMENT_ROOT']=/home/www/phporacle.eu5.net
$_SERVER['REQUEST_URI']=/fwphp/glomodul/blog/?i/read_post/id/69
$_SERVER['QUERY_STRING']=i/read_post/id/69
$_SERVER['HTTP_HOST']=phporacle.eu5.net
~~~~~~~~~/srv/disk16/3266814/www/phporacle.eu5.net/zinc/ftr.php() , line 78 SAYS:
OS web server doc root $this->p p 1->wsroot_path=/srv/disk16/3266814/www/phporacle.eu5.net/
Same web server doc root as URL $this->p p1->wsroot_url=http://phporacle.eu5.net/
Module property pallete like in Oracle Forms :
$this->p p 1
=stdClass Object ( [dbg] => 1 [stack_trace] => Array ( [0] => Array ( [0] => /srv/disk16/3266814/www/phporacle.eu5.net/fwphp/glomodul/blog/index.php, lin=18 ) ) [module_towsroot] => ../../../ [module_version] => 6.0.4.0 Msg [vendor_namesp_prefix] => B12phpfw [module_path_arr] => Array ( [0] => /srv/disk16/3266814/www/phporacle.eu5.net/fwphp/glomodul/blog/ [1] => /srv/disk16/3266814/www/phporacle.eu5.net/zinc/ [2] => /srv/disk16/3266814/www/phporacle.eu5.net/fwphp/glomodul/user/ [3] => /srv/disk16/3266814/www/phporacle.eu5.net/fwphp/glomodul/post_category/ [4] => /srv/disk16/3266814/www/phporacle.eu5.net/fwphp/glomodul/post/ [5] => /srv/disk16/3266814/www/phporacle.eu5.net/fwphp/glomodul/post_comment/ ) [uriq] => stdClass Object ( [i] => read_post [id] => 69 ) [F O R $_S E S ARR. (D B S H E M A...)] => ~~~~~~~~~~~~~~~~~ [cncts] => stdClass Object ( ) [states] => stdClass Object ( ) [A D R E S S E S in Config_allsites.php] => ~~~~~~~~~~~~~~~~ [wsroot_path] => /srv/disk16/3266814/www/phporacle.eu5.net/ [wsroot_url] => http://phporacle.eu5.net/ [imgrel_path] => zinc/img/ [module_path] => /srv/disk16/3266814/www/phporacle.eu5.net/fwphp/glomodul/blog/ [uri_arr] => Array ( [0] => /fwphp/glomodul/blog/ [1] => i/read_post/id/69 ) [module_relpath] => fwphp/glomodul/blog [module_url] => http://phporacle.eu5.net/fwphp/glomodul/blog/ [uri_qrystring_arr] => Array ( [0] => i [1] => read_post [2] => id [3] => 69 ) [ROUTES (LINKS) IN M O D U L E CTR Home_ctr.php] => ~~~~~~~~~~~~~~~~~ [PP1_ MODULE] => ~~~~~in view script eg href = $pp1->login~~~~~ [loginfrm] => ?i/loginfrm/ [login] => ?i/login/ [logout] => ?i/logout/r/i|loginfrm| [del_row] => ?i/del_row_do/ [filter_page] => ?p/ [dashboard] => ?i/dashboard/ [admins] => ?i/admins/ [read_user] => ?i/read_user/ [upd_user_loggedin] => ?i/upd_user_loggedin/ [categories] => ?i/categories/ [posts] => ?i/posts/ [filter_postcateg] => ?i/filter_postcateg/c/ [addnewpost] => ?i/addnewpost/ [read_post] => ?i/read_post/ [editpost] => ?i/editpost/ [edmkdpost] => ?i/edmkdpost/ [readmkdpost] => ?i/readmkdpost/ [comments] => ?i/comments/ [upd_comment_stat] => ?i/upd_comment_stat/ [kalendar] => ?i/kalendar/ [about_us] => ?i/about/ [contact_us] => ?i/contact/ [features] => ?i/features/ ) $_ GET=Array ( [i/read_post/id/69] => ) $_POST=Array ( ) $_SESSION=Array ( )