altervista001a.txt

Category : B12phpfw Written by jazeb On 2016-10-26 12:20:29

Edit post in op. system file altervista001a.txt ⟩⟩
We cre/edit .txt here and del .txt in op.system. TODO: del .txt here).

Edit post data in database table row ⟩⟩


Post summary :

1a. Install ZWAMP, Apache, PHP, MySQL, WordPress on Win 10 all 64bit, all portable (extract, setup files)

Image :

Image description :

$tmp_imgpath=/srv/disk16/3266814/www/phporacle.eu5.net/fwphp/glomodul/post/Uploads/unnamed.jpg
$tmp_imgurlrel=Uploads/unnamed.jpg

Post content :

Revised November 2019.

1a. Install ZWAMP, Apache, PHP, MySQL, WordPress on Win 10 all 64bit, all portable (extract, setup files)

HOME

22.oct.2016
from J:\zwamp64\z_apache_php_instalac_doc\z_doc\01_zwamp_instalac_moj.txt

I tried 4-5 WAMP server SW. WAMP and ZWAMP are ok but XAMPP unzip is simplest  Ealmost 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. Z-WAMP

is hosted by SourceForge:http://zwamp.sourceforge.net/
download:http://sourceforge.net/projects/zwamp/files/
latest is jan.2013 11_zwamp-x64-2.2.1-full.zip
to DIRECTORY J:\zwamp64\z_apache_php_instalac_doc\win64_x64bit
where is also coresponding MS VC++ which must be installed first (only this one installation) see below vc_redist.x64.

Latest ZWAMP for Win XP which I have as web site on USB stickthey work on all Windows 32/64 bit versions :
25 MB 11_for_winXP_32bit_zwamp-i386-1.1.2.zip
br>Last version I extracted php for 32 bit windows xp is 5.4.* :
11_for_wiXP_32bit_vcredist_x86_VS2008.exe
12_for_winXP_32bit_php-5.4.45-Win32-VC9-x86.zip
Last apache for 32 bit windows xp is 2.4.? or 2.2.? (see apachelounge site)

ZWAMP is Bing Cosca痴 project (also author of F3 Fat free php framework).
Latest ZWAMP 2013 year for win 10 64 bit contains web development tools:

  1. I use only : Apache, MySQL, PHP, Adminer, I added phpmyadmin and I extracted their latest versions to Z:\.sys (Z: is for me 笁E\zwamp64\vdrive
  2. I do not use : MiniPerl 5.14.2, MongoDB 2.2.3, (PHP 1.3.4 driver), APC 3.1.13, XCache 3.0.0, XDebug 2.2.1, AdminMongoDB, MemCached, SQLite, eAccelerator, and Alternative PHP Cache (APC)

ZWAMP Version 2.2.1, 2013 year (LATEST RELEASE)

23.oct.2016 I EXTRACTED NEWEST 64 BIT VERSIONS OF (ALL NO INSTALL, PORTABLE)

Apache 2.4.3

apachelounge
12_apache_httpd-2.4.20-win64-VC14.zip

PHP 5.4.12

12_php-7.0.12-Win32-VC14-x64.zip
MSVC14 (Visual C++ 2015)

MySQL 5.6.10

mysql-5.7.16-winx64.zip, mysql-5.7.9-winx64.zip
see below EXTRACT PORTABLE: MYSQL

tool
Adminer 3.5.1

Adminer 4.2.5
http://dev1:8083/adminer/adminer.php
see below EXTRACT PORTABLE: MYSQL

ZWAMP does not contain phpMyAdmin

phpMyAdmin 4.6.4
see below EXTRACT PORTABLE: MYSQL

ZWAMP does not contain WordPress

1_wordpress-4.6.1.zip 8.5 MB
see below EXTRACT PORTABLE: WORDPRESS

My DIRECTORY J:\zwamp64\z_apache_php_instalac_doc\win64_x64bit
contains :

***** 1. vc_redist (install this first, other SW is portable ): *****

23.oct.2016 15 MB 10_2015_vc_redist.x64.exe
for .php 7.0.12 64 bit(compiled with Visual Studio 2015)
http://www.microsoft.com/en-us/download/details.aspx?id=48145

2. Apache :

3.jul.2016. 14 MB 12_apache_httpd-2.4.20-win64-VC14.zip

do not forget comment/uncomment:
LoadModule php5_module/.sys/php/php5apache2_4.dll
LoadModule php7_module/.sys/php/php7apache2_4.dll
in J:\zwamp64\vdrive\.sys\Apache2\conf\httpd.conf and :

\# ZWAMP does:   (subst Z: "J:\\zwamp\\vdrive")
Listen 8083
dir J:\\zwamp64\\vdrive\\.sys\\php is :   PHPIniDir /.sys/php
dir J:\\zwamp64\\vdrive\\.sys\\php is
<IfModule alias\_module>
  \# dir. J:\\zwamp64\\vdrive\\.sys\\adminer is :
  \# [http://localhost:8083/adminer/](http://localhost:8083/adminer/)
 Alias /adminer /.sys/adminer
  <Directory /.sys/adminer>
    Options All
    AllowOverride AuthConfig
    Require all granted
  </Directory>

  \# [http://localhost:8083/phpmyadmin/](http://localhost:8083/phpmyadmin/)  
  \# WE NEED WAMP WAY for WAMP main menu group 3. Aliases & virt.hosts :
  \# J:\\zwamp64\\vdrive\\alias\\phpmyadmin.conf for me is all commented
  Alias /phpmyadmin /.sys/phpmyadmin
  <Directory /.sys/phpmyadmin>
    Options All
    AllowOverride AuthConfig
    Require all granted
  </Directory>
</IfModule>

3.1 PHP

http://windows.php.net/download
build date Oct 13 2016 24 MB 12_php-7.0.12-Win32-VC14-x64.zip
oct.2016 23 MB 12_php-5.6.27-Win32-VC11-x64.zip
oct.2015 21 MB 12_php-5.5.38-Win32-VC11-x64.zip
works, oci8 for php7 is supported !!
see trick with php_oci8_11g.dll below

          \*\*\*\*\* 3.2 memcache CURL : \*\*\*\*\*  

CURL is compiled with php7.0.12,
I do not use memcache (any cache) for now (not needed ?)

4. DB

          \*\*\*\*\* 4.1 DB sqlite : \*\*\*\*\*  

13.08.2015. 164 kB tema.sqlite
***** 4.2 sqlite develop. tools : *****
24.06.2015. 25 MB 14_sqlitestudio-3.0.6.zip
29.03.2015. 98 kB 14_SQLiteStudio_User Manual.htm
br>
***** 4.2 DB Oracle 11gXE 64 bit : *****

332 MB 1_OracleXE112_Win64.zip
see below OracleXE112 INSTALL
see below CONNECT PHP TO OracleXE112
***** Oracle develop. tools : *****
Orcle sqldeveloper
Orcle sqldeveloper data modeler
IDE Netbeans I do not use

\*\*\*\*\* 4.3 DB mysql (SEE BELOW MYSQL EXTRACT GUIDE) : \*\*\*\*\*  

23.oct.2016. 349 MB 14_mysql-5.7.16-winx64.zip

          \*\*\*\*\*  mysql develop. tools \*\*\*\*\*  

23.oct.2016. 6 MB 16_phpMyAdmin-4.6.4-all-languages.7z
compatible with PHP 5.5 to 7.0 and MySQL 5.5 and newer.
SHA256: 89ce2055402ea3052d380aebddf3c9c5bfc4ed686f49b98ee2e0f6ec6a3ded6c
old: 16_phpMyAdmin-4.5.0.2-all-languages.7z

23.oct.2016. 283 kB 16_adminer-4.2.5-en.phpI renamed to :
J:\zwamp64\vdrive\.sys\adminer\adminer.php
01.06.2016 413 kB adminer-4.2.4.php, 570 kB 16_adminer-master.zip

23.10.2015. 33 MB
15_mysql-workbench-community-6.3.5-winx64-noinstall.zip

EXTRACT PORTABLE: MYSQL, PHPMYADMIN, ADMINER

22.oct.2016
http://dev.mysql.com/downloads/mysql/
(phpinfo() shows: mysqli mysqlnd 5.0.12-dev 20150407 ?)
MD5: 1b23c0ddaa1ad59465fd1702b864e4a3
BEGIN PGP SIGNATURE I do not use this
Version: GnuPG v1

iD8DBQBX7U37jHGNO1By4fURAkIGAJ9vU5VfOLHqDnZvvrtq/B/n6jE3MQCgh4C1
9sR5bRIkjwpwJ5Adjekc7uA=
\=9Kxd
END PGP SIGNATURE

348 MB 14_mysql-5.7.16-winx64.zip
36 MB 14_mysql_refman-5.7.16-en.a4.pdf
http://dev.mysql.com/doc/refman/5.7/en/ http://dev.mysql.com/doc/

A bit more difficult for beginner user is to integrate newest
Apache. php, mysql, phpmyadmin, adminer in ZWAMP
(all portable = extract & setup & run).

Testing MySQL is best in console (command prompt) window best mysql msgs.
I did not use MSI mysql installer (is it better ?)

If using no install mysql zip, you need to:

1. ***EXTRACT MYSQL***
unzip J:\zwamp64\z_apache_php_instalac_doc\win64_x64bit\14_mysql-5.7.16-winx64.zip
to ZWAMP dir: J:\zwamp64\vdrive\.sys\mysql (rename old to mysql_5_7_9)

2. Create***OPTIONS*** file my.ini see my.ini below
or copy my.ini from mysql_5_7_9 dir to mysql dir
Optional I id not: extract the debug-test archive if you plan to execute the MySQL benchmark and test suite

???I DID NOT: Choose a MySQL ***SERVER TYPE***, it could be :
it is server-id = 1 ???
mysqld Optimized binary with named-pipe support
or mysqld-debug like mysqld, but compiled with
full debugging and automatic memory allocation checking

3. ***INITIALIZE MYSQL***
3.1 Freecommander in admin mode and click CLI icon
or (I did):
make icon C:\Windows\SysWOW64\cmd.exe -> right click -> run as admin
J:
cd J:\zwamp64\vdrive\.sys\mysql

3.2 .\bin\mysqld nitialize-insecure er=mysql

MySQL ee mysqld creates dir :
J:\zwamp\vdrive\.sys\mysql\data we can move it if needed

data dir we can delete to try nitialize-insecure again if
installation was unsuccesfull as my was first time I used
nitialize mysqld parameter
I did not know how resolve errors same as MANY PEOPLE ON WEB FORUMS :
access denied for user root@localhost or
ur password has expired

4. ***START*** MySQL server :
4.1 First this to be able to do 4.2 !! :
Establish ZWAMP try icon & start Apache and mysql
(or 2click on: J:\zwamp64\zwamp.exe)
Rightclick on ZWAMP try icon
standard ZWAMP, WAMP or XAMPP functions.

ZWAMP Services menu item should show apache and mysql started.

4.2 Execute mysql.exe to ***OPEN MYSQL CONNection***
to open mysql prompt:
J:
cd J:\zwamp\vdrive\.sys\mysql

.\bin\mysql -u root -p
Enter password: *****
press ENTER key if you not yet have root psw *****
then ***GIVE PASSWORD TO ROOT USER***
ALTER USER root@localhost IDENTIFIED BY root
exit
So we avoided error:
ERROR 1045 (28000): Access denied for user root@localhost(using password: YES)

Then again:
.\bin\mysql -u root -p

or .\bin\mysql -u root -h 127.0.0.1 穁Eip-password

If we try 4.2 without ZWAMP started (5.1) :
Enter password: ****
ERROR 2003 (HY000): Cant connect to MySQL server on 鼠ocalhost(10061)

Why we need password :
secure default user accounts
Portable phpMyAdmin says gin without psw is forbidden by configuration/p>

5. MYSQL TOOLS

http://dev1:8083/phpmyadminlogin into mysql with portable phpMyAdmin works after :
rename J:\zwamp64\vdrive\.sys\phpMyAdmin to phpMyAdmin_4_5_0_2
16_phpMyAdmin-4.6.4-all-languages.7z 6 MB ***phpMyAdmin EXTRACT*** to :
J:\zwamp64\vdrive\.sys\phpMyAdmin
copy J:\zwamp64\vdrive\.sys\phpMyAdmin_4_5_0_2\config.inc.php
to J:\zwamp64\vdrive\.sys\phpMyAdmin\config.inc.php
see below config.inc.php

http://dev1:8083/adminer/adminer.phplogin into mysql with portable adminer works
login into oracle 11gXE with portable adminer works
16_adminer-4.2.5-en.php 283 kB copyed to adminer dir
same as phpMyAdmin and renamed to adminer.php, no setup file changes required

http://dev1:8083/adminer/ed/editor.phpis only for mysql DB

http://dev1:8083/adminer/ed/oraed.php is only for Oracle DB

EEEEEEEEEEEEEEEEEEEEEEEEEEEEEE end mysql 64 bit installation

http://dev1:8083/phpmyadmindisplays:

Database server
Server: localhost via TCP/IP
Server type: MySQL
Server version: 5.7.16 MySQL Community Server (GPL)
Protocol version: 10
User:root@localhost
Server charset: UTF-8 Unicode (utf8)

Web server
Apache/2.4.20 (Win64)
Database client version: libmysql mysqlnd 5.0.12-dev 20150407 $Id: 241ae00989d1995ffcbbf63d579943635faf9972 $
PHP extension: mysqliDocumentation curlDocumentation mbstringDocumentation
PHP version: 7.0.12

phpMyAdmin
Version information: 4.6.4 (up to date)
Documentation
Official Homepage
Contribute
Get support
List of changes
License

Starting MySQL from the Windows Command Line
\=======================================
mysqld corresponds to Oracle DB server daemon(TSR) service name (XE)

Stop MySQL server by executing this command:
mysqladmin -u root -p shutdown

Start mysqld with the 穁Eandalone and 謀ebug options. In debug case, mysqld writes a log fileC:\mysqld.tracethat should contain the reason WHY MYSQLD DOESNT START. See Section 24.5.3, 典he DBUG Package
Usemysqld 没erbose 防elpto display all the options that mysqld supports.

2.3.5.6 Customizing the PATH for MySQL Tools
\============================================
To make it easier to invoke MySQL programs, you can add the path name of the MySQL bin directory to your Windows system PATH environment variable.
You should not add the MySQL bin directory to your Windows PATH if you are running multiple MySQL servers on the same machine.

https://www.adminer.org/#download
Adminer Database management in a single PHP file
Adminer Editor Data manipulation for end-users

https://www.adminer.org/
Supports: MySQL, PostgreSQL, SQLite, MS SQL, Oracle, SimpleDB, Elasticsearch
Requirements: PHP 5+
Apache License 2.0 or GPL 2

To see what databases (users in Oracle DB terminology) exist :

  • (in oracle DB user coresponds to mysql DB)
    goto J:\zwamp64\vdrive\.sys\mysql\bin

mysqld 防elp
mysqld Ver 5.7.16 for Win64 on x86_64 (MySQL Community Server (GPL))
Copyright (c) 2000, 2016, Oracle and/or its affiliates.
Starts the MySQL database server.

Usage: mysqld [OPTIONS]

For more help options (several pages), use
mysqld 没erbose 防elp

mysqlshow -u root -p

  • | Databases |

  • | information_schema |
    | blogwp |
    | mysql |
    | performance_schema |
    | sys |

  • Two DB ar minimum.

mysqlshow -u root mysql
Database: mysql

  • | Tables |

  • | columns_priv |
    | db |
    br>+

To select information from a table in the mysql database :
mysql -e 鉄ELECT User, Host, plugin FROM mysql.user-u root mysql
++++
| User | Host | plugin |
++++
| root | localhost | mysql_native_password |
| mysql.sys | localhost | mysql_native_password |
++++

mysqladmin -u root version status proc
mysqladmin Ver 8.42 Distrib 5.7.16, for Win64 on x86_64
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
Server version 5.7.16
Protocol version 10
Connection localhost via TCP/IP
TCP port 3306
Uptime: 41 min 55 sec

Threads: 1 Questions: 21 Slow queries: 0 Opens: 115 Flush tables: 1 Open tables: 0 Queries per second avg: 0.008
Uptime: 2515 Threads: 1 Questions: 22 Slow queries: 0 Opens: 115 Flush tables: 1 Open tables: 0 Queries per second avg: 0.008
++++++++
| Id | User | Host | db | Command | Time | State | Info |
++++++++
| 11 | root | localhost:50191 | | Query | 0 | starting | show processlist |
++++++++

To display all the options that mysqld supports:
.\bin\mysqld 没erbose 防elp

J:\zwamp\vdrive\.sys\mysql>.\bin\mysql -u root -p
Enter password:
mysql> SELECT User, Host, Password FROM mysql.user;
ERROR 1054 (42S22): Unknown column Esswordin 素ield listbr> mysql>SELECT User, Host FROM mysql.user;
+++
| User | Host |
+++
| mysql.sys | localhost |
| root | localhost |
+++
2 rows in set (0.00 sec)

# -

my.ini mysql 5.7.16 config file

# -
# J:\zwamp64\vdrive\.sys\mysql\my.ini
[client]
password = root
port = 3306
socket = /.tmp/mysql.sock

[mysqld]
basedir = J:/zwamp64/vdrive/.sys/mysql
datadir = J:/zwamp64/vdrive/.sys/mysql/data
# default IPv6 change to ipv4
bind-address = 0.0.0.0
skip-external-locking
key_buffer_size = 16K
max_allowed_packet = 1M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 128K
sync_binlog = 0
explicit_defaults_for_timestamp = TRUE
server-id = 1

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
safe-updates

[myisamchk]
key_buffer_size = 8M
sort_buffer_size = 8M

[mysqlhotcopy]
interactive-timeout

# -

config.inc.php phpMyAdmin 4.6.4 config file

# -
// J:\zwamp64\vdrive\.sys\phpMyAdmin\config.inc.php
$cfg[owfish_secret = /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
$i = 0;
$i++;
/* Authentication type */
//$cfg[ervers[$i][th_type = 祖ookie
// if you prefer to not be prompted every time you log in:
$cfg[ervers[$i][爽ser = root
$cfg[ervers[$i][assword = root // use here your password
//$cfg[ervers[$i][th_type = 祖onfig
/* Server parameters */
$cfg[ervers[$i][ost = 鼠ocalhost
$cfg[ervers[$i][祖onnect_type = 奏cp
$cfg[ervers[$i][祖ompress = false;
$cfg[ervers[$i][llowNoPassword = false;

$cfg[繕ploadDir =
$cfg[aveDir =

  1. EXTRACT PORTABLE: WORDPRESS

http://sspc1:8083/papl1/blogwp/wp-admin/ = Control panel (Ndzorna plo鐶)
http://sspc1:8083/papl1/blogwp/ = articles, posts, 鑞anci, objave

http://sspc1:8083/papl1/blogwp/primjer-stranice/\= page

http://sspc1:8083/papl1/blogwp/2016/10/22/dan-svijete/

http://sspc1:8083/papl1/blogwp/wp-admin/about.php

https://wordpress.org/download/
http://codex.wordpress.org/Installing_WordPress

1. extract 1_wordpress-4.6.1.zip, 8.5 MB
to
J:\zwamp64\vdrive\web\papl1\blogwp

2. 5-Minute Installation

11111 start apache & mysql

start ZWAMP
rightclick ZWAMP icon and check services apache and mysql are running

22222 create mysql DB and user for WordPress blog

z:
dir .sys
cd .sys\mysql\bin
mysqlshow -u root -p
mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.16 MySQL Community Server (GPL)
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
Type elp;or 曾hfor help. Type 曾cto clear the current input statement.

  1. mysql>DROP DATABASE blogwp;(possible repeat this)
  2. mysql>CREATE DATABASE blogwp;
    2.cre usr mysql>GRANT ALL PRIVILEGES ON blogwp.* TO 澱logwp如罵ocalhost/strong>
    ->
    IDENTIFIED BY 澱logwp
    3. mysql>
    FLUSH PRIVILEGES;
    4. mysql>
    EXIT****

**

or in GraphicUI which creates statements below :

http://dev1:8083/phpmyadmin/
create db blogwp collation utf8_,:
New link on left top

CREATE USER ogwp叩IDENTIFIED WITH mysql_native_password BY **
GRANT ALL PRIVILEGES ON *.* TO ogwp叩REQUIRE NONE WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;
GRANT ALL PRIVILEGES ON `blogwp`.* TO ogwp叩
REVOKE ALL PRIVILEGES ON `blogwp`.* FROM ogwp叩
GRANT ALL PRIVILEGES ON `blogwp`.* TO ogwp叩WITH GRANT OPTION;

33333 install WordPress blog tables to MySQL DB

http://sspc1:8083/papl1/blogwp/
or http://sspc1:8083/papl1/blogwp/wp-admin/install.php
Needed info about DB:
DB name blogwp
DB user name blogwp
DB psw blogwp
Host of DB localhost or PC name eg SSPC1 or domain name eg http://www.mysite.hr
tables Prefiks blogwp
(if we want more WordPress installations in one DB)

Above info is used to createwp-config.phpfile. Also you can edit
wp-config-sample.php. Seehttps://codex.wordpress.org/Editing_wp-config.php

psw= email=/p>

Akismet blog spam protection needs :
email, usr/psw, API key
https://akismet.com/account/

http://sspc1:8083/papl1/blogwp/ = articles, posts, 鑞anci, objave
http://sspc1:8083/papl1/blogwp/wp-admin/ = control panel

44444 WordPress Importer

will import the following content from a WordPress export file:
posts, pages, comments, categories, and other content.
<!褁E\zwamp64\vdrive\web\papl1\blogwp\1_phporacle.wordpress.2016-10-22.xml
This is a WordPress eXtended RSS file (WXR) generated by WordPress as an export of your site.
gt;
<!You may use this file to TRANSFER CONTENT FROM ONE SITE TO ANOTHER. gt;
<!This file is not complete backup of your site. gt;

<!TO IMPORT THIS INFORMATION INTO A WORDPRESS SITE : gt;
<!1. Log in to that site as an administrator. gt;
<!2. Go to TOOLS: IMPORT IN THE WORDPRESS ADMIN PANEL. gt;
<!3. Install the 展ordPressimporter from the list. gt;
<!4. Activate & Run Importer. gt;
<!5. Upload this file using the form provided on that page. gt;
<!6. You will first be asked to MAP THE AUTHORS IN THIS EXPORT FILE TO USERS gt;
<! on the site. For each author, you may choose to map to an gt;
<! existing user on the site or to create a new user. gt;
<!7. WORDPRESS WILL THEN IMPORT each of the posts, pages, comments, categories, etc. contained in this file into your site. gt;
<!generator=埜ordPress/4.6.1created=016-10-22 12:46gt;

If you would prefer to do things manually then follow these instructions:
Upload the wordpress-importer folder to the /wp-content/plugins/ directory
Activate the plugin through the Euginsmenu in WordPress
Go to the Tools -> Import screen, click on WordPress

Remember toupdate the passwords and roles of imported users.

Many web hosts now offer tools (e.g. Fantastico) to automatically install WordPress for you.
WordPress has Automatic upgrading.

Things to Know/todo Before You Begin Installing WordPress

Access to web server (via FTP or shell)
text editor
FTP Client
Web browser (K-meleon, Firefox, Google Chrome)

Minimum requirements to run WordPress:
PHP version 5.6 or greater
MySQL version 5.6 or greater OR . MariaDB version 10.0 or greater -http://dev1:8083/phpmyadmin/
WordPress also works with PHP 5.2.4+ and MySQL 5.0+, but these versions have reached official End Of Life and as such may expose your site to security vulnerabilities.

******************************************************
OracleXE112 INSTALL
******************************************************
see my other article or just install it as any Windows program.

4. CONNECT PHP 7.0.12 TO Oracle 11g r2 XE

Oracle instantclient is not needed if all is on home development PC :
OCI8 Extension WORKS FOR PHP 7.0.12 64 BIT build date Oct 13 2016

Use php 7.0.12 OCI8 extension to access Oracle Database 11g XE from PHP

I did for php 7.0.12, 64 bit:

download:https://pecl.php.net/package/oci8
https://pecl.php.net/package/oci8/2.1.2/windows
7.0 Thread Safe (TS) x64
TRICK: from J:\zwamp64\vdrive\.sys\php\ext\1_php_oci8-2.1.2-7.0-ts-vc14-x64.zip 20.sep.2016 734 kB
extractphp_oci8_11g.dllin J:\zwamp64\vdrive\.sys\php\ext

I also installed php 5.6.27, 64 bit:

I renamed php dir to php_7_0_12
I renamed php_5_6_27 dir to php
download:https://pecl.php.net/package/oci8/2.0.12/windows
5.6 Thread Safe (TS) x64
from J:\zwamp64\vdrive\.sys\php\ext\1_php_oci8-2.0.12-5.6-ts-vc11-x64.zip 20.sep.2016 581 kB
extractphp_oci8_11g.dllin J:\zwamp64\vdrive\.sys\php\ext

OCI8 php extension needs to be linked with Oracle 12, 11, or 10.2
client libraries. These libraries are found in your database installation,
or (I did not this) : in the free Oracle Instant Client from
http://www.oracle.com/technetwork/database/features/instant-client/
Install the 腺asicor 腺asic LiteInstant Client package. If
building from source, then also install the SDK package.
aug.2015. 55 MB 18_instantclient-basic-windows.x64-11.2.0.4.0.zip
nov.2014. 73 MB instantclient-basic-windows.x64-12.1.0.2.0.zip

Oracle standard cross-version connectivity applies. For example,
PHP OCI8 linked with Instant Client 11.2 can connect to Oracle
Database 9.2 onward. See Oracle note 徹racle Client / Server
Interoperability Support(ID 207303.1) for details.

see README of pecl oci8 dll-s zip above
see Documentation is athttp://php.net/oci8

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.

Comments

Share your thoughts about this post

/srv/disk16/3266814/www/phporacle.eu5.net/fwphp/glomodul/post/Posts.php


      

~~~$pp1->dbg=1~~~/srv/disk16/3266814/www/phporacle.eu5.net/vendor/b12phpfw/ftr.php() , line 119 SAYS:
Coding step c s 0 1. GLOBAL VARIABLES ~~~~~~~~~~~~~~~~~~~~~~~~~~~~

PHP_OS=Linux, php_uname()=Linux f21.runhosting.com 5.10.179kvmcap #1 SMP Fri Apr 28 12:30:51 UTC 2023 x86_64
$_SERVER['DOCUMENT_ROOT']=/home/www/phporacle.eu5.net
$_SERVER['REQUEST_URI']=/fwphp/glomodul/blog/?i/read_post/id/36
$_SERVER['QUERY_STRING']=i/read_post/id/36
$_SERVER['HTTP_HOST']=phporacle.eu5.net
OS doc root adress is $this->p p 1->wsroot_ path=/srv/disk16/3266814/www/phporacle.eu5.net
Same web server doc root adress is $this->p p 1->wsroot_ url=http://phporacle.eu5.net/

Module property pallete like in Oracle Forms :
$this->p p 1
=stdClass Object ( [module_version] => Blog Msg MySQL 10.0.3.0 Feb. 2023 [dbg] => 1 [dbicls] => Db_allsites [stack_trace] => Array ( [0] => Array ( [0] => /srv/disk16/3266814/www/phporacle.eu5.net/fwphp/glomodul/blog/index.php, lin=31 ) [1] => /srv/disk16/3266814/www/phporacle.eu5.net/vendor/b12phpfw/Autoload.php, lin=25 (B12phpfw\core\b12phpfw\Autoload::__construct) ) [dir_apl] => glomodul [wsroot_path] => /srv/disk16/3266814/www/phporacle.eu5.net [shares_path] => /srv/disk16/3266814/www/phporacle.eu5.net/vendor/b12phpfw [site_path] => /srv/disk16/3266814/www/phporacle.eu5.net/fwphp [module_path] => /srv/disk16/3266814/www/phporacle.eu5.net/fwphp/glomodul/blog [shared_dbadapter_obj] => B12phpfw\core\b12phpfw\Db_allsites Object ( [errmsg:B12phpfw\core\b12phpfw\Db_allsites:private] => ) [rblk] => 10 [Home_ctr_obj] => B12phpfw\module\blog\Home_ctr Object ( [pp1:B12phpfw\core\b12phpfw\Config_allsites:private] => stdClass Object *RECURSION* ) [uriq] => stdClass Object ( [i] => read_post [id] => 36 [HELP_ROUTING_AND_URL_QUERY] => ~~~~~~~~~~~~~~~~~ properties = key-keyvalue pairs : LINKALIAS => ?i/HOME_METHOD_TO_CALL/param1/param1value... (? is QS=Query Separator) 1. LINKALIAS 2. URLurlqrystring 3. Router (Config_allsites) extracts (from 2.) IN VIEW SCRIPT IN Home_ ctr CALLED METHOD IN Home_ ctr ,'cre_row_frm' => QS.'i/cc/' METHOD cc or cre_row_frm or... ,'home_url' => QS.'i/home/' METHOD home : key="i", value="home" ,'ldd_category' => QS.'i/del_category/id/' id value we assign in view script after $ p p 1->ldd_category ,'loginfrm' => QS.'i/loginfrm/' METHOD loginfrm (or include script) ,'login' => QS.'i/login/' METHOD login ) [HELP_STATES_ATTRIBUTES] => F O R $_S E S ARR. (D B S H E M A...) ~~~~~~~~~~~~~~~~~ [cncts] => stdClass Object ( ) [states] => stdClass Object ( ) [HELP_PATHS_IN_UTL_CLS] => cs02. R O U T I N G - A D R E S S E S in Config_ allsites.php ~~~~~~~~~~~~~~~~ [wsroot_url] => http://phporacle.eu5.net/ [shares_url] => http://phporacle.eu5.net/vendor/b12phpfw/ [img_url] => http://phporacle.eu5.net/vendor/b12phpfw/img/ [lang] => en [uri_qrystring] => i/read_post/id/36 [uri_qrystring_arr] => Array ( [0] => i [1] => read_post [2] => id [3] => 36 ) [uri_arr] => Array ( [0] => /fwphp/glomodul/blog/ [1] => i/read_post/id/36 ) [module_relpath] => fwphp/glomodul/blog [module_url] => http://phporacle.eu5.net/fwphp/glomodul/blog/ [site_url] => http://phporacle.eu5.net/fwphp/ [LINK_ALIASES] => $ p p 1->LINK_ALIAS => HOME METHOD TO CALL ~~~~~ eg1: in view script href="<?=$pp1->home_blog?>" calls home method in Home_ctr so : QS."i/home_blog/"~~~~~ where QS is question mark ("?") = urlQuerySeprator [home_blog] => ?i/home/ [home] => ?i/home/ [sitehome] => ?i/sitehome/ [ldd_category] => ?i/del_category/id/ [ldd_admins] => ?i/del_admins/id/ [ldd_posts] => ?i/del_posts/id/ [ldd_comments] => ?i/del_comments/id/ [filter_page] => p/ [admins] => ?i/admins/ [loginfrm] => ?i/loginfrm/ [login] => ?i/login/ [logout] => ?i/logout/r/i|loginfrm| [read_user] => ?i/read_user/id/ [upd_user_loggedin] => ?i/upd_user_loggedin/r/i|upd_user_loggedin|id| [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/36] => ) $_POST=Array ( ) $_SESSION=Array ( [SuccessMessage] => Array ( ) [ErrorMessage] => Array ( ) )

/srv/disk16/3266814/www/phporacle.eu5.net/vendor/b12phpfw/ftr.php() , line 150 SAYS:
Coding step c s 0 2. R O U T I N G ~~~~~~~~~~~~~~~~~~~~~~~~~~~~

$_SERVER['REQUEST_URI'] =/fwphp/glomodul/blog/?i/read_post/id/36

$p p1->uri_ arr is exploded string $_SERVER['REQUEST_URI'] (part1 before QS=? and part2 after QS)
part1 index 0 is $p p 1->module_ relpath=fwphp/glomodul/blog
part2 index 1 is $p p 1<>uri_ qrystring = key-value pairs ee = url parameters after QS = i/read_post/id/36
$this->p p1->uri_ arr=Array ( [0] => /fwphp/glomodul/blog/ [1] => i/read_post/id/36 )

EXPLODED $p p1->uri_ qrystring (on /) is $this->p p1->uri_ qrystring_ arr=Array ( [0] => i [1] => read_post [2] => id [3] => 36 )
method in Home_ ctr and method parameters : $p p 1->u r i q=stdClass Object ( [i] => read_post [id] => 36 [HELP_ROUTING_AND_URL_QUERY] => ~~~~~~~~~~~~~~~~~ properties = key-keyvalue pairs : LINKALIAS => ?i/HOME_METHOD_TO_CALL/param1/param1value... (? is QS=Query Separator) 1. LINKALIAS 2. URLurlqrystring 3. Router (Config_allsites) extracts (from 2.) IN VIEW SCRIPT IN Home_ ctr CALLED METHOD IN Home_ ctr ,'cre_row_frm' => QS.'i/cc/' METHOD cc or cre_row_frm or... ,'home_url' => QS.'i/home/' METHOD home : key="i", value="home" ,'ldd_category' => QS.'i/del_category/id/' id value we assign in view script after $ p p 1->ldd_category ,'loginfrm' => QS.'i/loginfrm/' METHOD loginfrm (or include script) ,'login' => QS.'i/login/' METHOD login )