T_constant_encapsed_string

[Yew12]

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

[PHP]<?php

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

$con = OCIlogon("Username","Password","shu10g");

$query "Begin p_room_content(1,1,:var_room_id, :var_fixture_id, :var_fixture_description); 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_fixture_id", &$fixture_id,4) or die ('Can not bind variable');

OCIBindByName($stmt,":var_fixture_description", &$fixture_description,25) or die ('Can not bind variable');

OCIExecute($stmt) or die ('Cannot Execute statement');

OCIFreeStatement($stmt);

OCILogoff($con);

Echo "$room_id $fixture_id $fixture_description ";

?>[/PHP]

[Markus]

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

[PHP]<?php

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

$con = OCIlogon("Username","Password","shu10g");

$query "Begin p_room_content(1,1,:var_room_id, :var_fixture_id, :var_fixture_description); 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_fixture_id", &$fixture_id,4) or die ('Can not bind variable');

OCIBindByName($stmt,":var_fixture_description", &$fixture_description,25) or die ('Can not bind variable');

OCIExecute($stmt) or die ('Cannot Execute statement');

OCIFreeStatement($stmt);

OCILogoff($con);

Echo "$room_id $fixture_id $fixture_description ";

?>[/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_id, :var_fixture_id, :var_fixture_description); 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_id, :var_fixture_id, :var_fixture_description); 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!

[ronverdonk]

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, but I think (not sure) that you miss support for working with OOP and frameworks in PHP, real and advanced debugging using Xdebug, remote ftp-editing and some more features. And only for Euro 39.

Ronald

[TheServant]

Yeah, but I think (not sure) that you miss support for working with OOP and frameworks in PHP, real and advanced debugging using Xdebug, remote ftp-editing and some more features. And only for Euro 39.

Ronald

lol, do you work for them or what?! Nah, it sounds good, but I will try the Personal Edition for starters. But you are right it is not expensive, so if I like it, I buy it. Thanks for your help guys.

[ronverdonk]

lol, do you work for them or what?! Nah, it sounds good, but I will try the Personal Edition for starters. But you are right it is not expensive, so if I like it, I buy it. Thanks for your help guys.

I don't work for anyone! But I like to design and write all code myself, in whatever language and I absolutely hate (assembly or construction) applications like Dreamweaver or FrontPage and the likes. They are not about programming, they are forcing you to use prefabricated building blocks.

Ronald