StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POPHP Session in Class
primarykey
Id
16398392
data
AcceptedAnswerId
0
AnswerCount
2
ClosedDate
CommentCount
3
CommunityOwnedDate
CreationDate
2013-05-06T12:05:48.960
FavoriteCount
0
LastActivityDate
2013-05-06T13:09:48.423
LastEditDate
2013-05-06T13:09:48.423
LastEditorUserId
1729551
OwnerUserId
1729551
ParentId
0
PostTypeId
1
Score
0
ViewCount
2090
LastEditorDisplayName
text
Body
<pre><code><? session_start(); class DB_MSSQL { protected $Host; protected $Database; protected $User; protected $Password; protected $Link_ID = 0; protected $Query_ID = 0; protected $Record = array(); protected $Row = 0; protected $Errno = 0; protected $Error = ""; protected $Halt_On_Error = "yes"; protected $Auto_Free = 1; protected $PConnect = 0; function _construct(){ $this->Host = $_SESSION['SQLIP']; $this->Database = $_SESSION['SQLDB']; $this->User = $_SESSION['SQLUSER']; $this->Password = $_SESSION['SQLPASS']; } function DB_MSSQL($query = "") { if($query) { $this->query($query); } } function connect() { if ( 0 == $this->Link_ID ) { if(!$this->PConnect) { $this->Link_ID = mssql_connect($this->Host, $this->User, $this->Password); } else { $this->Link_ID = mssql_pconnect($this->Host, $this->User, $this->Password); } if (!$this->Link_ID) $this->connect_failed("connect ($this->Host, $this->User, \$Password) failed"); else if (!mssql_select_db($this->Database, $this->Link_ID)) { $this->connect_failed("cannot use database ".$this->Database); } } } function connect_failed($message) { $this->Halt_On_Error = "yes"; $this->halt($message); } function free_result(){ mssql_free_result($this->Query_ID); $this->Query_ID = 0; } function query($Query_String) { /* No empty queries, please, since PHP4 chokes on them. */ if ($Query_String == "") /* The empty query string is passed on from the constructor, * when calling the class without a query, e.g. in situations * like these: '$db = new DB_Sql_Subclass;' */ return 0; if (!$this->Link_ID) $this->connect(); // printf(" Debug: query = %s \n", $Query_String); $this->Query_ID = mssql_query($Query_String, $this->Link_ID); $this->Row = 0; if (!$this->Query_ID) { $this->Errno = 1; $this->Error = "General Error (The MSSQL interface cannot return detailed error messages)."; $this->halt("Invalid SQL: "); } return $this->Query_ID; } function next_record() { if ($this->Record = mssql_fetch_row($this->Query_ID)) { // add to Record[<key>] $count = mssql_num_fields($this->Query_ID); for ($i=0; $i<$count; $i++){ $fieldinfo = mssql_fetch_field($this->Query_ID,$i); $this->Record[strtolower($fieldinfo->name)] = $this->Record[$i]; } $this->Row += 1; $stat = 1; } else { if ($this->Auto_Free) { $this->free_result(); } $stat = 0; } return $stat; } function seek($pos) { mssql_data_seek($this->Query_ID,$pos); $this->Row = $pos; } function metadata($table) { $count = 0; $id = 0; $res = array(); $this->connect(); $id = mssql_query("select * from $table", $this->Link_ID); if (!$id) { $this->Errno = 1; $this->Error = "General Error (The MSSQL interface cannot return detailed error messages)."; $this->halt("Metadata query failed."); } $count = mssql_num_fields($id); for ($i=0; $i<$count; $i++) { $info = mssql_fetch_field($id, $i); $res[$i]["table"] = $table; $res[$i]["name"] = $info->name; $res[$i]["len"] = $info->max_length; $res[$i]["flags"] = $info->numeric; } $this->free_result(); return $res; } function affected_rows() { // Not a supported function in PHP3/4. Chris Johnson, 16May2001. // return mssql_affected_rows($this->Query_ID); $rsRows = mssql_query("Select @@rowcount as rows", $this->Link_ID); if ($rsRows) { return mssql_result($rsRows, 0, "rows"); } } function num_rows() { return mssql_num_rows($this->Query_ID); } function num_fields() { return mssql_num_fields($this->Query_ID); } function nf() { return $this->num_rows(); } function np() { print $this->num_rows(); } function f($Field_Name) { return $this->Record[strtolower($Field_Name)]; } function p($Field_Name) { print $this->f($Field_Name); } function halt($msg) { if ("no" == $this->Halt_On_Error) return; $this->haltmsg($msg); if ("report" != $this->Halt_On_Error) die("Session halted."); } function haltmsg($msg) { printf("Server have a critical error! We are very sorry for any inconvenience! \n", $msg); printf("MSSQL Error: %s (%s)\n", $this->Errno, $this->Error); } } ?> </code></pre> Faild to connect.. if i put $Host;$Database;$User;$Password; manually is work fine. but with constructor can't connect. ($_SESSION have correct value) But i don't know how to echo $obj->Host,Password,user,etc.
Tags
<php><html><css><class><session-variables>
Title
PHP Session in Class
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USMihai Oprea
UserOwnerUserId
1. USMihai Oprea
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
2. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.