mits

i guess clob is the one for long text then

I'm a little confused here. I have 3 fields in my table which require long text to be entered so the standard varchar2 isn't enough. I tried the "LONG" data type but it errored saying a table can only have 1 LONG data type used. Which data type do i use to cater for text for more than one column? thanks

thanks a lot.... the below worked; ociexecute($result); ocifetchstatement($result,$tab_result); // the result will be fetched in the table $tab_result echo ocirowcount($result);

i am completely lost now and can not work out why no data is being retrieved when i run a query. I have set up oracle and php on my localhost using; xamp oci8 library oracle 10g express (universal) oracle instant client I am establishing a connection without any problem, but when i run a query and return results, it returns 0 :S. here's the code; $connect = oci_connect('myusername', 'mypassword', '127.0.0.1'); $query = 'SELECT * FROM EMPLOYEES'; $result = OCIParse($connect, $query); OCIExecute($result); echo OCI_Num_Rows($result); it returns 0 when in fact there are 5 records...i run the same query directly using oracle's interface and it works fine, it's just not working when i try it using PHP. any advice?

Problem Solved: Solution: http://www.learnphponline.com/errors/url-file-access-is-disabled-in-the-server-configuration i used DOCUMENT_ROOT server variable within the require and it works fine.

hi, thanks for that....i added the full path to the file and i get the following error; Warning: require() [function.require]: URL file-access is disabled in the server configuration in /var/www/sites/stage.demomedia.co.uk/html/quote_generator/pdf.php on line 2 Warning: require(http://www.demomedia.co.uk/quote_builder/fpdf16/fpdf.php) [function.require]: failed to open stream: no suitable wrapper could be found in /var/www/sites/stage.demomedia.co.uk/html/quote_generator/pdf.php on line 2 i think it's progress. any ideas?

hi, i'm using the fpdf library to generate PDF's from form input. It all worked well on my local host, but now that i have transferred to a web server it displays the following error when trying to generate a PDF. Warning: require(/fpdf16/fpdf.php) [function.require]: failed to open stream: No such file or directory in /home/ddgq0o2n/public_html/quote_builder/pdf.php on line 2 Fatal error: require() [function.require]: Failed opening required '/fpdf16/fpdf.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/ddgq0o2n/public_html/quote_builder/pdf.php on line 2 i have searched for "include_path", but can't find it anywhere. i'm thinking it's a server problem, where the library may not be compatible or something needs to be switched on, as it worked fine on my local host. any help and suggestions welcome thanks.

Hi, I kow this is probably something simple, but i have 2 links to a RSS feed which i need to put up on a web page. Not just a link, but the actual feed rendered with a number of news headlines. One is a ".rss2.XML" link and the ither is a html link. the HTML i suppose is static, so probably not any good. thanks in advance

hi, i have an article with several paragraphs. However i would like the first paragraph to be converted into a header. string replacement will not work as it will replace all the p tags. i just want the 1st set of p tags to be replaced. can anyone help? thanks

update To make things a lil more clear. The URL should be http://127.0.0.1/projects/project_name/svn/index.php?id=schedule?PHPSESSID=1234567890 instead i get the following url when i click on the schedule link. http://127.0.0.1/projects/project_name/svn/%3Cbr?PHPSESSID=if9kjk52uv979k9duf8v9hrfs1%20/%3E%3Cb%3EDeprecated%3C/b%3E:%20%20Function%20split()%20is%20deprecated%20in%20%3Cb%3EC:\wamp\www\projects\project_name\svn\extensions\makeUrl.inc%3C/b%3E%20on%20line%20%3Cb%3E11%3C/b%3E%3Cbr%20/%3Eindex.php?id=schedule we do have a makeurl function which does the obvious. however, if i copy in the url from index.php onwards from development to local it works fine. i think the make url function is working fine on development but not on my local.

Hi, I'm trying to view files on my localhost and i'm getting the error Forbidden: You don't have permission to access /dir/... on this server It works fine on our development server. Upuntil now i was working on development, but i want to work from localhost. We do use session id's for all our urls, e.g. index.php?id='page'?PHPSESSID=1234567890. I'm not sure whether thats the problem. I'm guessing it's some setting in the php.ini file. I'm using WAMP, but the same issue arises with XAMPP, so it's not the server itself. Thanks in advance.

well i got oracle working with php using the above instructions. install oracle on your local machine if needed download instant client add the instant client directory to windows path enable oci8 in the php.ini file ...and you should be good to go

Your problem can be solved by "output buffering" you can do 2 things to control this; 1) at the beginning of your php script add the function "ob_start();" OR 2) Switch on output buffering in your php.ini file. Search for "output_buffering" current;y your one is probably set to "off" Make the change and restart your server. That should do the trick regarding "headers already sent"

My next project will involve using an Oracle DB with PHP instead of the usual MySQL. I've read a little about PHP and Oracle and so far I have done the following. 1) Installed Oracle 10g express 2) Downloaded Oracle Instant Client As far as i'm aware, i need to do the following; 1) Add the path of the Instant Client to the windows PATH 2) uncomment the OCI8 library in the php.ini file under extensions. and hopefully all should be fine! is there anything else I will need to do to configure PHP with Oracle? I'm going to go via http://www.oracle.com/technology/pub/notes/technote_php_instant.html ...and hope for the best!

oops! i have tried it now and it works fine. I used the follwing code. <?php $file = "line_break.txt"; $handle = fopen($file, "r"); $string = fread($handle, filesize($file)); echo nl2br($string); ?> .. and it works exactly how i want. thanks