Code Newbie
News     Forums     Search     Members     Sign Up    

My Code Newbie
Username

Password

Articles/Snippets
ASP Classic
ASP.NET
C
C#
C++
HTML / CSS
Java
Javascript
Linux / BSD
Perl
PHP
Python
Ruby
SQL
VB 6
VB.NET

C.N. Friends
  Planet Rome

Link to Us!
Code Newbie
  Code Newbie
    forums
Old 09-08-2004, 05:04 AM   #1 (permalink)
viruz
Registered User
 
Join Date: Sep 2004
Posts: 1
viruz is on a distinguished road
Send a message via ICQ to viruz
php & oracle..

hello friends,
is there anybody who uses oracle for database.. with php.. how can i use it..? how must i set up oracle for web database server and how ll i create tables? is there anyprogram like phpmyadmin for oracle?.. i know oci functions of php but i couldnt design database from oracle.. and i dont know settings of it. i cant connect it from php..
ok.. waiting for answers..
thank.
viruz is offline   Reply With Quote
Old 09-08-2004, 06:44 AM   #2 (permalink)
Admin
$_['Your_Mom'];
 
Admin's Avatar
 
Join Date: May 2002
Location: Santee
Posts: 627
Admin is on a distinguished road
http://us2.php.net/manual/en/ref.oracle.php

??
__________________


Urban Clothing
Admin is offline   Reply With Quote
Old 09-08-2004, 07:05 AM   #3 (permalink)
technobard
Centurion Nova Prime
 
technobard's Avatar
 
Join Date: May 2002
Location: Oak Park, IL (USA)
Posts: 285
technobard is on a distinguished road
First, I haven't used PHP with Oracle although I use Oracle extensively. There are a few articles out there on the subject. Check out: Configuring PHP with Oracle 8i Support 9i should work more or less the same way. I'm not sure about Oracle 10G support. You can google for more.

As for how to create tables with Oracle, etc., the database comes with SQL*Plus, iSQL*Plus, and optionally Oracle Enterprise Manager (OEM). SQL*Plus is a commandline interface for running queries, creating tables, adding users, etc. iSQL*Plus is the web version of that and requires Apache (which comes with a standard Oracle install these days.) OEM is a standalone java app that presents a gui interface for most of the admin functions like creating tables.

There are also third party applications you can use like TOAD, for example, that will give you a nice gui, if you prefer that over the commandline or OEM.

I wasn't sure from your post if you were installing Oracle from scratch, building a new database, or if an existing database already existed that you were building a schema in. If you have a database administrator to rely on, definitely go that route. Oracle is a lot more involved (sometimes unnecessarily so) than MySQL or many others. You can find complete documentation, etc. at http://otn.oracle.com (you'll have to sign up for a free account to get to the documentation). One more thing: Oracle's architecture is different from MySQL, Postgresql, DB2, SQL Server, etc. In all of the other databases mentioned, you can have multiple databases within a single instance or set of server processes. Oracle has at most one database per instance. You can create multiple schemas/users within a database, each with their own set of tables, indexes, stored procs, etc.

Oracle offers a development license for free, but does expect fees for actual production use.
technobard is offline   Reply With Quote
Old 09-08-2004, 11:07 AM   #4 (permalink)
technobard
Centurion Nova Prime
 
technobard's Avatar
 
Join Date: May 2002
Location: Oak Park, IL (USA)
Posts: 285
technobard is on a distinguished road
Alright. An even better link to PHP & Oracle info from Oracle's technet site: Hitchhiker's Guide to PHP

There are a number of articles here with useful PHP code including installation.
technobard is offline   Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
PHP Comes of Age sde Code Newbie News 0 04-14-2004 11:41 AM
new to php jhoop2002 PHP 12 08-06-2003 02:45 PM
I need to learn PHP Nitro PHP 9 06-28-2003 11:24 AM
PHP as CGI?? bdl PHP 8 05-08-2003 08:29 AM


All times are GMT -8. The time now is 11:33 PM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.0.0 RC8





Copyright © 2000-2008, Milano Interactive
Web Hosting provided by Portal 360 Web Hosting