Connect PHP with Oracle database October 18, 2008
Posted by me2blog in PHP and Oracle database.Tags: apache server, Connect Oracle 10g with PHP, how to connect Oracle database using PHP, PHP connected to Oracle
7 comments
I spent the last four days looking for the correct way to Connect Apache server (PHP) with Oracle database, unfortunatly I didn’t find any complete article.So in this blog, I’m giving my expernce to connect ‘em 2geth
1. Install Apache server:
I make this step in a seprated blog page, plz check it from this link:Install Apache HTTP server
2. Extract the PHP zip folder:
1. Unzip the PHP file into c:\php
2. Copy all the files with the .dll extension to C:\WINDOS\system
3. Copy php5apache2.dll to C:\Apache\Apache2\modules
3. Copy the file php.ini-recommended and then edit it:
1. Open C:\php then copy the file php.ini-recommended to C:\WINDOWS
2. Rename it to be php.ini then open it with text editor
3. Set the doc_root to be: doc_root = c:\apache\apache2\htdocs
4. Set the extension_dir to: extension_dir = “C:\php\ext”
5. Uncomment (Remove the semicolon “;” from the beginning of the line) this line:
session.save_path = “c:/temp”
6. Uncomment the line: extension=php_oci8.dll
4.Edit the http.conf file:
1. Open the httpd file using any text editor, which exist on the path
C:\Apache\Apache2\conf
2. Find the line AllowOverride None and change the None value to be All
3. Look for the line DirectoryIndex index.html index.html.var and replace it with this line: DirectoryIndex index.html index.html.var index.php
4. Search for a section that has a lot of AddType commands, then added this line: AddType application/x-httpd-php .php so u have a total of 3 AddType command.
5. Search for a section has many Loads and add this line to it:
LoadModule php5_module modules/php5apache2.dll
5.Restart the Apache and the oracle database:
1. Restart the apache server using the cmd command (U can do it from the services but using the cmd has the advantage of showing errors while restarting the apache if there is any)
- Open start -> run -> cmd -> cd c:\apache\apache2\bin (press enter)
- The write apache –k restart (Press enter)
2. Restart the Oracle database
Open control panerl -> administrative tools -> services -> the restart all the services starting with Oracle
6. Test the connection:
1. To make the basic connection you need some information from the tnsnames.ora file, so follow the link C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN Then open it
2. Open textpad page or use any text editor you want the past this code:
<?php
$db = “(DESCRIPTION=(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.34)(PORT = 1521)))(CONNECT_DATA=(SID=orcl)))” ;
if ($c=OCILogon(“system”, “your database password“, $db)) {
echo “Successfully connected to Oracle.\n”;
OCILogoff($c);
} else {
$err = OCIError();
echo “Connection failed.” . $err[text];
}
?>
Where the HOST is taken from your tnsnames.ora file and SID value is equal to your database name Then save the file with the name test.php
3. Open web browser page and type on the title: http://localhost/test.php
If it all worked well you will get white page with the result:
Successfully connected to Oracle.
NOTE: Recommended links to download the software’s:
|
Software |
Version |
URL |
|
Oracle Database 10g Express Edition |
10.2 |
|
|
Apache HTTP Server |
2.0.58 |
|
|
PHP Hypertext Processor |
5.1.3 |
Install Apache HTTP server: October 18, 2008
Posted by me2blog in PHP and Oracle database.Tags: Apache, apache server, install apache
3 comments
Receiving the information from HTML forms October 1, 2008
Posted by me2blog in Common PHP Applications, php.Tags: check box, difference between GET and POST, GET, php, POST, receive the information from check box, Receive the information from HTML forms
add a comment
The forms data r available at PHP built in array. As said earlier there two methods to send the data: POST and GET, so information from any form uses the method POST is available in the built-in array $_POST with the key for each field with it’s name! and information from any form uses the method GET is found in the array $_GET, and the key for each field is it’s name …
The information that user select from drop down menu or radio buttons r similarly available for use, but the situation is a lil different while using check boxes bcz the user can check more than one box, the information is in multidimentional array ,,,, but i think there is an easier wayL when u create check box bottons, name each buton a unique name, and get it from 1D array, it will be faster and easier to code … remember no one can c ur code ,,, every one will c the effect of ur code, so write it in the easiest way 4 u :p
What is the difference between POST and GET:
- Get method: The form data is passed by adding it to the URL. The advantages for this method: it’s simple and fast but the disadvantages r less data to be passed and less secure (since the information r displayed in the browser).
- Post method: The form data is passed as a package in a separate communication with the processing script. The advantages: unlimited information to be passed and more secure and the disadvantage is the overhead which slows the speed.
Example:
<br><center><h2> Customer information </h2></center>
<br><br>
<center>
<table border=”0″>
<form action=”customer_info.php” method=”POST”>
<tr> <td> First name:</td> <td> <input type=”text” name=”first_name” value=”enter ur first name plz”></td></tr>
<tr> <td>Second name: </td> <td> <input type=”text” name=”second_name” value=”enter ur second name plz”> </td></tr>
<tr><td>Last name: </td> <td> <input type=”text” name=”last_name” value=”enter ur last name plz”></td> </tr>
<tr><td> Street Address:</td><td> <input type=”text” name=”st_address” value=”enter ur st address plz”></td> </tr>
<tr><td> City:</td><td>
<select name=”city”
<option> Amman </option>
<option> Aqaba </option>
<option> Irbd </option>
<option> Zarqa </option>
</td> </tr>
<tr><td>Sex: </td><td>
<input type =”radio” name=”Radio1″ value= “M” > Male
<input type =”radio” name=”Radio1″ value= “F”> Female
</td></tr>
<tr><td>Your Operating system: </td><td>
<input type= “checkbox” name=”os0″ value=”W”> Windows
<input type= “checkbox” name=”os1″ value=”L”> Linux
<input type= “checkbox” name=”os2″ value=”M”> Mac
</td></tr>
</table><br>
<input type=”submit” value=”submit name”>
</form>
and now …. the customer_info.php code:
<?php
if ($_POST[Radio1]==”M”) {
$sex= “Male”;
}
else
{
$sex= “Female”;}
echo “Welcome “,$_POST['first_name'],”!<br>”;
echo “Your second name is: “,$_POST['second_name'];
echo “<br>Your last name is: “,$_POST['last_name'];
echo “<br>”;
echo “you are “, $sex;
echo ” living in: “, $_POST[city];
echo “ in the “, $_POST[st_address],” Street”;
echo “<br>and your operating systems are: <br>”;
if (isset($_POST['os0'])) {
echo “Windows<br>”;
}
if (isset($_POST['os1'])) {
echo “Linux<br>”;
}
if (isset($_POST['os2'])) {
echo “Mac<br>”;
}
?>
The output:
and after clicking the submit name button u will c the following page:
Welcome Noor!
Your second name is: A
Your last name is: Adiga
you are Female living in: Aqaba in the Abc ST Street
and your operating systems are:
Windows














