File: fwphp/glomodul/blog/msgmkd/altervista001a.txt

Recommend this page to a friend!
  Classes of Slavko Srakocic  >  B12 PHP FW  >  fwphp/glomodul/blog/msgmkd/altervista001a.txt  >  Download  
File: fwphp/glomodul/blog/msgmkd/altervista001a.txt
Role: Documentation
Content type: text/plain
Description: Documentation
Class: B12 PHP FW
Manage database records with a PDO CRUD interface
Author: By
Last change: ver 7.0.1 mnu, msg, mkd FUNCTIONAL namespaces, CRUD PDO trait, pretty URL-s
Date: 2 months ago
Size: 24,938 bytes
 

Contents

Class file image Download
Revised November 2019.      

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

**[HOME](http://phporacle.altervista.org/php-oracle-main-menu/ "Main menu")**

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/](http://zwamp.sourceforge.net/)  
download:[http://sourceforge.net/projects/zwamp/files/](https://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 stick**they 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](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](https://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](https://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.php**I 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/](https://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/phpmyadmin](http://dev1:8083/phpmyadmin)login 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.php](http://dev1:8083/adminer)login 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.php](http://dev1:8083/adminer/ed/editor.php)is only for mysql DB

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

?E??E??E??E??E??E??E??E??E??E??E??E??E??E??E??E??E??E??E??E??E??E??E??E??E??E??E??E??E??E? end mysql 64 bit installation

[http://dev1:8083/phpmyadmin](http://dev1:8083/phpmyadmin)displays:

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 file**C:\\mysqld.trace**that should contain the reason WHY MYSQLD DOESNT START. See Section 24.5.3, ?he DBUG Package  
Use**mysqld ?erbose ?elp**to 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](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 = 

3.  EXTRACT PORTABLE: WORDPRESS
-------------------------------

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

[http://sspc1:8083/papl1/blogwp/primjer-stranice/](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/](https://wordpress.org/download/)  
[http://codex.wordpress.org/Installing\_WordPress](https://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)  
1.        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/](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 create**wp-config.php**file. Also you can edit  
wp-config-sample.php. See[https://codex.wordpress.org/Editing\_wp-config.php](https://codex.wordpress.org/Editing_wp-config.php)

psw= email=/p>

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

[http://sspc1:8083/papl1/blogwp/](http://sspc1:8083/papl1/blogwp/)  = articles, posts, ?anci, objave  
[http://sspc1:8083/papl1/blogwp/wp-admin/](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 to**update 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)  
[https://pecl.php.net/package/oci8/2.1.2/windows](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  
extract**php\_oci8\_11g.dll**in 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](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  
extract**php\_oci8\_11g.dll**in 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 at[http://php.net/oci8](https://php.net/oci8)

 kod[ edit](?$web_docroot_url/inc/utl/edservertxt.php)[ phpinfo](?$web_docroot_url/phpinfo_inc.php) EOKOD; /\* call it so: kod\_edit\_run( $idx // script\_dir\_path , $idxscript // script\_name , MDURL); // web\_docroot\_url = (Apache) web server URL \*/ }**
For more information send a message to info at phpclasses dot org.