T_constant_encapsed_string

[Yew12]

I'm hoping some one will know where I've gone wrong with the following.

[PHP]<?php

putenv("TNS_ADM IN=/u1/oracle/Produdcts/shu10g/network/admin");

$con = OCIlogon("Usern ame","Password" ,"shu10g");

$query "Begin p_room_content( 1,1,:var_room_i d, :var_fixture_id , :var_fixture_de scription); End; ";

$stmt = OCIParse($con, $query) or die ('Can not parse query');

OCIBindByName($ stmt,":var_room _id", &$room_id,4) or die ('Cannot bind variable');

OCIBindByName($ stmt,":var_fixt ure_id", &$fixture_id ,4) or die ('Can not bind variable');

OCIBindByName($ stmt,":var_fixt ure_description ", &$fixture_descr iption,25) or die ('Can not bind variable');

OCIExecute($stm t) or die ('Cannot Execute statement');

OCIFreeStatemen t($stmt);

OCILogoff($con) ;

Echo "$room_id $fixture_id $fixture_descri ption ";

?>[/PHP]

[Markus]

I'm hoping some one will know where I've gone wrong with the following.

[PHP]<?php

putenv("TNS_ADM IN=/u1/oracle/Produdcts/shu10g/network/admin");

$con = OCIlogon("Usern ame","Password" ,"shu10g");

$query "Begin p_room_content( 1,1,:var_room_i d, :var_fixture_id , :var_fixture_de scription); End; ";

$stmt = OCIParse($con, $query) or die ('Can not parse query');

OCIBindByName($ stmt,":var_room _id", &$room_id,4) or die ('Cannot bind variable');

OCIBindByName($ stmt,":var_fixt ure_id", &$fixture_id ,4) or die ('Can not bind variable');

OCIBindByName($ stmt,":var_fixt ure_description ", &$fixture_descr iption,25) or die ('Can not bind variable');

OCIExecute($stm t) or die ('Cannot Execute statement');

OCIFreeStatemen t($stmt);

OCILogoff($con) ;

Echo "$room_id $fixture_id $fixture_descri ption ";

?>[/PHP]

When you receive an error you are given the line number on which the error occured; it's helpful to know which line.

Regards

[TheServant]

When you receive an error you are given the line number on which the error occured; it's helpful to know which line.

Regards

And what error it says it has.

[Markus]

And what error it says it has.

Says it in the title i believe :P

[TheServant]

Says it in the title i believe :P

Oh. Didn't realize that was the error... Please continue with no notice of my ramblings [/ramble]

[ronverdonk]

What is the purpose of [php]$query "Begin p_room_content( 1,1,:var_room_i d, :var_fixture_id , :var_fixture_de scription); End; ";[/php]I think you want an assignment to a variable here.

Ronald

[Markus]

What is the purpose of [php]$query "Begin p_room_content( 1,1,:var_room_i d, :var_fixture_id , :var_fixture_de scription); End; ";[/php]I think you want an assignment to a variable here.

Ronald

Nice catch!

I looked right past that.

[ronverdonk]

All you need is an IDE that catches it for you!

Ronald

[TheServant]

All you need is an IDE that catches it for you!

Ronald

...IDE? [/n00b reveal]

[ronverdonk]

...IDE? [/n00b reveal]

An integrated development environment (IDE) is a software application that provides comprehensive facilities to computer programmers for software development. An IDE normally consists of a source code editor, a compiler and/or interpreter, build automation tools, and (usually) a debugger.

The one I use is phpDesigner 2008 V6.0.2. Works for me.

Ronald

[TheServant]

An integrated development environment (IDE) is a software application that provides comprehensive facilities to computer programmers for software development. An IDE normally consists of a source code editor, a compiler and/or interpreter, build automation tools, and (usually) a debugger.

The one I use is phpDesigner 2008 V6.0.2. Works for me.

Ronald

So more professional DreamWeaver?

[ronverdonk]

So more professional DreamWeaver?

Certainly not! I like to write my own code, not by some s.... assembly application.

Ronald

[TheServant]

Certainly not! I like to write my own code, not by some s.... assembly application.

Ronald

Hmmm, I should look into this phpDesigner as I only use dreamweaver for the coloured code and I don't use any of it's other features... Thanks for that Ron.

[Markus]

I believe Ronalds is a version that costs you mooooneeeeeeeey .

My version of PHP Designer, however, doesn't.; Hooray for freeware!

PHP Designer 2007 - Personal.

:D

[TheServant]

I believe Ronalds is a version that costs you mooooneeeeeeeey .

My version of PHP Designer, however, doesn't.; Hooray for freeware!

PHP Designer 2007 - Personal.

:D

Yeah been looking at that. I found the 07 Personal version just wanted to make sure it's legal (so thanks for letting me know). Well seeing you two use it it will be worth checking out!