Php Script Solution

Question

I have a little problem with my script. When I try to run it I receive "Parse error: syntax error, unexpected T_STRING" as long as I have ' sign in my code. When I change all ' into " then I have the same error. So I have to change all " into '.

Here is my code:

<?php
      PutEnv(TNS_ADMIN='C:\Programy\OracleDeveloper10g\NETWORK\ADMIN\');
      $conn = oci_connect("user", "pass", "dbstring");
      if (!$conn)
      {
        $e = oci_error();
        print $e;
        exit;
      }
      else
      {
        $stmt = OCIParse($conn, "SELECT password FROM USERS WHERE username=szymon");
        OCIExecute($stmt, OCI_DEFAULT);
      while ($row = oci_fetch_array($stmt, OCI_ASSOC+OCI_RETURN_NULLS)) {
      foreach ($row as $item) {
       $password = $item;
      }
        if ($password != $_POST[password]){
          $stmt = OCIParse($conn, "EXECUTE drop_tables");
          $message = "Tabele zostały usunięte";
        }
        else {
          $message = "Podane hasło jest niepoprawne";
        }
      }
   }
?>

as far as i can see, the code you posted is bug-free ...

miku
– miku

2009-11-19 18:04:18 +00:00
Commented Nov 19, 2009 at 18:04 — miku
– miku, Commented Nov 19, 2009 at 18:04

Community · Accepted Answer · 2023-11-17 20:42:18Z

5

Try

putenv("TNS_ADMIN='C:\Programy\OracleDeveloper10g\NETWORK\ADMIN\'");

If you look at the docs for putenv() it shows everything in quotes.

edited Nov 17, 2023 at 20:42

CommunityBot

11 silver badge

answered Nov 19, 2009 at 18:10

Chris Kloberdanz

4,5764 gold badges33 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Pekka · Accepted Answer · 2009-11-19 18:10:00Z

2

The problem is the backslashes in the TNS_ADMIN path. The last backslash escapes the closing '.

Try doubling all backslashes:

C:\\Programy\\OracleDeveloper10g\\NETWORK\\ADMIN\\

answered Nov 19, 2009 at 18:10

Pekka

451k150 gold badges989 silver badges1.1k bronze badges

Comments

Marek Karbarz · Accepted Answer · 2009-11-19 18:09:58Z

2

make sure you escape your \

answered Nov 19, 2009 at 18:09

Marek Karbarz

29.4k6 gold badges55 silver badges73 bronze badges

Comments

Eric Petroelje · Accepted Answer · 2009-11-19 18:10:31Z

2

On this line:

PutEnv(TNS_ADMIN='C:\Programy\OracleDeveloper10g\NETWORK\ADMIN\');

The slashes cause the ending quote to be escaped. Try it like this:

PutEnv(TNS_ADMIN='C:\\Programy\\OracleDeveloper10g\\NETWORK\\ADMIN\\');

answered Nov 19, 2009 at 18:10

Eric Petroelje

60.7k9 gold badges133 silver badges178 bronze badges

Collectives™ on Stack Overflow

Php Script Solution

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related