MacLochlainns Weblog

Michael McLaughlin's Technical Blog

Site Admin

Zend Core for Oracle

with one comment

Zend Core for Oracle is deprecated! You should really install Zend Core Server. You can find instructions to install the Zend Server Community Edition here.

This page shows you how to install Zend Core for Oracle, verify the installation of PHP, your connection to an Oracle XE database with PHP, and your connection to a MySQL database with PHP. Screen shots are provided for the installation. You can download the software from Zend Corporation.

Zend Core for Oracle Installation ↓

This section provides you with screen shots and instructions for installing a local copy of the Zend Core for Oracle. By the way, it also comes configured to support MySQL.

1. Launch the zendicon icon.

2. After you launch the icon, Windows prompts you with a security warning, like that below. Click the Run to install Zend Core for Oracle.

zendcore_install1

3. The first real screen appears and click Next to continue the installation.

zendcore_install2

4. On this page, you click the radio button to Accept the License or stop the whole process. After you select the correct radio button, click the Next button to continue.

zendcore_install3

5. Here you leave the Complete radio button checked, then click the Next button to continue.

zendcore_install4

6. This screen allows you to change where you install Zend Core for Oracle. My advice is don’t make any changes. If you do, please note that all my instructions use the default and you’ll have to adjust for that through the rest of the blog page. Click the Next button to continue.

zendcore_install5

7. Click the Install Zend Core’s bundled apache 2.2.4 because it’s the default, and the instructions follow that course. However, if you’re an experienced Apache administrator you can install Apache separately. Click the Next button to continue.

zendcore_install6

8. The default Apache port is 80 but you may already have something running on that port. If you do, you’ll need to choose an alternative port number. I’d suggest 81 as an alternative. Unfortunately, the documentation assumes a default port 80 throughout the notes. Click the Next button to continue.

zendcore_install7

9. You choose which file extensions to associate to PHP on this screen. I’d recommend .php and .inc. Click the Next button to continue.

zendcore_install8

10. This is a VERY important screen. You enter your Zend Core for Oracle password here. The Zend Core for Oracle provides you with a console to change your php.ini settings, it’s a nice interface. So, please make sure you enter a password that you won’t forget.

zendcore_install9

11. This screen lets you sign up for hot fixes and such. If you’ve a subscription relationship with Zend, choose the Yes radio button. If this is for a class or experiment, you may wish to choose the No radio button. Click the Next button to continue.

zendcore_install10

12. If you need to configure a proxy server for the downloads, here’s the place. If not, then click the No radio button before clicking the Next button.

zendcore_install11

13. This is the screen you’ve been working toward. This is where you confirm you want to install the product. Click the Next button to continue.

zendcore_install12

14. You can watch this for about 2 minutes or get up and stretch your legs.

zendcore_install13

15. If you’ve got a firewall and you chose to install the bundle, the Apache installation will prompt you to allow a firewall exception. Click the Unblock button unless you want to do this manually.

zendcore_install14

16. The next screen shouldn’t take but a minute or so. It is a progress screen to let you know that Zend is downloading its framework.

zendcore_install15

17. This next screen asks you if you want to keep Zend’s temporary download file. My advise is to dump it but if your planning to reinstall again in a short amount of time, keep it. Click Yes to reclaim your hard disk space.

zendcore_install16

18. The next screen just tells you where you can find the Zend console when you need to make changes. Click the OK button to dismiss the dialog.

zendcore_install17

19. The next screen tells you that you’ve completed the installation. Click the Finish button to begin verifying if everything worked.

zendcore_install18

Verify Installation of PHP ↓

This section shows you how to verify that PHP works inside your local Apache server.

  1. You confirm that your Apache server is working on your local machine by typing in the following URL, which will display the image below the URL.

configureoraclephp2

configureoraclephp3

  1. After you’ve installed Zend Core for Oracle and confirmed the Apache HTTP server is running, you need to know how to use it. One of the most important things to know for a novice, is where do I put the files so that the Apache web server can find them. You put them in the Apache document root, which is defined in the httpd.conf file. The default location is:

configureoraclephp1

  1. Write a PHP test program. The traditional test program consist of the following:
1
2
3
4
5
6
7
8

<html>
<head>
<title>My Installation Confirmation Page</title>
</head>
<body>
<?php phpInfo(); ?>
</body>
</html>
  1. Save the file in your document root, or htdocs folder as the phpInfo.php file.
  1. You can test whether program works by using the following URL in your browser. The full image represented by the cutout will appear in your browser. This confirms PHP is installed and configured in your Apache server.

configureoraclephp4

configureoraclephp5

Verify Oracle Connection with PHP ↓

This section shows you how to verify that you can connect to an Oracle database by using PHP.

  1. If you skipped the prior section, you need to know where to put your files so that the Apache web server can find them. You put them in the Apache document root, which is defined in the httpd.conf file. The default location is:

configureoraclephp1

  1. You write the following PHP file to confirm that you can connect to an Oracle database.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

<html>
<head>
<title>My Oracle Connection Confirmation Page</title>
</head>
<body>
<?php
  // Attempt to connect to your database.
  $c = @oci_connect("student", "student", "xe");
  if (!$c) {
    print "Sorry! The connection to the database failed. Please try again later.";
    die();
  }
  else {
    print "Congrats! You've connected to an Oracle database!";
    oci_close($c);
  }
?>
</body>
</html>
  1. Save the file in your document root, or htdocs folder as the OracleConnection.php file.
  1. You can test whether program works by using the following URL in your browser. You should see a success message if everything works in the rendered browser page.

configureoraclephp6

Verify MySQL Connection with PHP ↓

This section shows you how to verify that you can connect to an MySQL database by using PHP.

  1. If you skipped the prior section, you need to know where to put your files so that the Apache web server can find them. You put them in the Apache document root, which is defined in the httpd.conf file. The default location is:

configureoraclephp1

  1. You write the following PHP file to confirm that you can connect to an Oracle database.
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

<html>
<head>
<title>My MySQL Connection Confirmation Page</title>
</head>
<body>
<?php
  // Attempt to connect to your database.
  $c = @mysqli_connect("localhost", "student", "student", "sampledb");
  if (!$c) {
    print "Sorry! The connection to the database failed. Please try again later.";
    die();
  }
  else {
    // Initialize a statement in the scope of the connection.
    print "Congrats! You've connected to a MySQL database!";
  }
?>
</body>
</html>
  1. Save the file in your document root, or htdocs folder as the MySQLConnect.php file.
  1. You can test whether program works by using the following URL in your browser. You should see a success message if everything works in the rendered browser page.

configureoraclephp7

Written by maclochlainn

June 27th, 2009 at 2:37 pm

Posted in Uncategorized

One Response to 'Zend Core for Oracle'

Subscribe to comments with RSS or TrackBack to 'Zend Core for Oracle'.

  1. How can we see a zend written transcript converted to real text as we can see something written in html tags converted to real text

    Rekha Goel

    14 Aug 09 at 5:54 am

Leave a Reply