╧εΣΣσ≡µΩα Postgres95

Postgres95 - ∞ε∙φα  ßατα Σαφφ√⌡  Γδ ■∙α ±  ∩αßδΦΩ Σε∞σφ, Ωε≥ε≡α  ≡σαδΦτ≤σ≥ τφα≈Φ≥σδⁿφεσ ∩εΣ∞φεµσ±≥Γε  τ√Ωα SQL . ╬φα ∩εΣΣσ≡µΦΓασ≥ ∞φεµσ±≥Γε ≥Φ∩εΓ Σαφφ√⌡ Φ Ωε∞αφΣ√, Ωε≥ε≡√σ φσ Σε±≥≤∩φ√ Γ mSQL. ╧εΣ≡εßφα  Φφ⌠ε≡∞α÷Φ  ε≥φε±Φ≥σδⁿφε Postgres95 Φ φσ∩ε±≡σΣ±≥Γσφφε ∩≡επ≡α∞∞φεπε εßσ±∩σ≈σφΦ  ∞εµσ≥ ß√≥ⁿ φαΘΣσφα ∩ε URL: http://epoch.cs.berkeley.edu: 8000/postgres95/.

╤δσΣ≤■∙Φσ ⌠≤φΩ÷ΦΦ PHP Σε±≥≤∩φ√ Σδ  Postgres95:

pg_Connect()

pg_Close()

pg_Host()

pg_Port()

pg_Options()

pg_tty()

pg_DBname()

pg_Exec()

pg_Result()

pg_FreeResult()

pg_GetLastOid()

pg_NumRows()

pg_NumFields()

pg_FieldNum()

pg_FieldName()

pg_FieldType()

pg_FieldSize()

pg_FieldPrtLen()

pg_errorMessage()

╬ß≡α≥Φ≥σ ΓφΦ∞αφΦσ: ─ΓεΦ≈φ√σ ≤Ωατα≥σδΦ φσ ∩εΣΣσ≡µΦΓα■≥± .

┬ Σε∩εδφσφΦσ Ω ²≥Φ∞ ⌠≤φΩ÷Φ ∞, PHP/FI ∞εµσ≥ ß√≥ⁿ ±Ωε∞∩ΦδΦ≡εΓαφ, ≈≥εß√ ∩≡ε∩≤±Ωα≥ⁿ δ■ß√σ ∩≡ ∞√σ εΣΦφε≈φ√σ ±Φ∞Γεδ√ ( ' ) ΩαΓ√≈ΩΦ, φαΘΣσφφ√σ Γ Σαφφ√⌡ ∞σ≥εΣεΓ GET ΦδΦ POST . ┼±δΦ Γ ⌠αΘδσ php.h ε∩≡σΣσδσφα ∩σ≡σ∞σφφα  MAGIC_QUOTES, ≥ε ²≥Φ ΩαΓ√≈ΩΦ αΓ≥ε∞α≥Φ≈σ±ΩΦ ß≤Σ≤≥ ∩≡ε∩≤±Ωα≥ⁿ± , ≤∩≡ε∙α , ∩σ≡σΣα≈≤ Σαφφ√⌡ Φτ ⌠ε≡∞ φσ∩ε±≡σΣ±≥Γσφφε Ω τα∩≡ε±α∞ Postgres95.

┬ε≥ ∩≡ε±≥εΘ ±Ω≡Φ∩≥ , Ωε≥ε≡√Θ ±εσΣΦφ σ≥±  ± ßατεΘ Σαφφ√⌡ Postgres95 φα δεΩαδⁿφε∞ ±σ≡Γσ≡σ, φατ√Γα■∙σΘ±  'mydb' Φ ΦτΓδσασ≥ Φ∞σφα Φ Γετ≡α±≥√ δ■ΣσΘ Φτ ≥αßδΦ÷√:

<?
   $conn = pg_Connect("localhost", "5432", "", "", "mydb"); 
   if (!$conn) { 
       echo "An error occured.\n"; 
       exit;
   }
   $result = pg_Exec($conn, "select * from table1"); 
   if (!$result) { 
       echo "An error occured.\n"; 
       exit;
   }
   $num = pg_NumRows($result);
   $i = 0;
   while ($i < $num) { 
      echo "name: "; 
      echo pg_Result($result, $i, "name"); 
      echo "  age: "; 
      echo pg_Result($result, $i, "age"); 
      echo "<BR>";
      $i++;
   }
   pg_FreeResult($result);
   pg_Close($conn);
>

[═αταΣ] [╤εΣσ≡µαφΦσ] [┬∩σ≡σΣ]