.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

<< < … 156 157 158 159 160 161 162 163 164 165 166 … > >>   Sort: Rank

What Is a Session ID
What Is a Session ID? - PHP Script Tips - Understanding and Using Sessions A session ID is an identification string of a session. Since there might be multiple visitors coming to your Web site at the same time, the PHP engine needs to maintain multiple sessions concurrently. Session IDs are created ... 2007-04-18, 5193👍, 0💬

How To Connect to MySQL from a PHP Script
How To Connect to MySQL from a PHP Script? - PHP Script Tips - Working with MySQL Database If you want access the MySQL server, you must create a connection object first by calling the mysql_connect() function in the following format: $con = mysql_connect($server, $username, $password); If you are c... 2007-04-18, 5288👍, 0💬

What Do You Need to Connect PHP to MySQL
What Do You Need to Connect PHP to MySQL? - PHP Script Tips - Working with MySQL Database If you want to access MySQL database server in your PHP script, you need to make sure that MySQL module is installed and turned on in your PHP engine. Check the PHP configuration file, php.ini, to make sure the... 2007-04-18, 5194👍, 0💬

How To Retrieve the Session ID of the Current Session
How To Retrieve the Session ID of the Current Session? - PHP Script Tips - Understanding and Using Sessions Normally, you don't need to know the session ID of the current session. But if you are interested to know the session ID created by the PHP engine, there are two ways to get it: Calling sessio... 2007-04-18, 5192👍, 0💬

How To Commit the Current Transaction
How To Commit the Current Transaction? - Oracle DBA FAQ - Understanding SQL Transaction Management If you have used some DML statements updated some data objects, and you want to have the updates to be permanently recorded in the database, you can use the COMMIT statement. It will make all the datab... 2007-04-18, 5075👍, 0💬

How To Create a Testing Table
How To Create a Testing Table? - Oracle DBA FAQ - Understanding SQL Transaction Management If you want to practice DML statements, you should create a testing table as shown in the script below: >cd (OracleXE home directory) >.\bin\sqlplus /nolog SQL> connect HR/fyicenter Connected. SQL> CREATE TABL... 2007-04-18, 5581👍, 0💬

How To Install MySQL
How To Install MySQL? - PHP Script Tips - Working with MySQL Database MySQL is an open source database management system developed by MySQL AB, http://www.mysql.com. You can download a copy and install it on your local computer. Here is how you can do this: Go to http://dev.mysql.com/downloads /mysql... 2007-04-18, 5209👍, 0💬

What Are the Options to Transfer Session IDs
What Are the Options to Transfer Session IDs? - PHP Script Tips - Understanding and Using Sessions Once a new session is created, its session ID must be transferred to the client browser and included in the next client request, so that the PHP engine can find the same session created by the same vis... 2007-04-18, 5294👍, 0💬

How To Use MySQL Command Line Interface
How To Use MySQL Command Line Interface? - PHP Script Tips - Working with MySQL Database MySQL server comes with a command line interface, which will allow you to operate with the server with SQL statements and other commands. To start the command line interface, you can run the \mysql\bin\mysql pro... 2007-04-18, 5803👍, 0💬

How Session IDs Are Transferred on Your Web Server
How Session IDs Are Transferred on Your Web Server? - PHP Script Tips - Understanding and Using Sessions As you know there are two options the PHP engine can use to transfer session IDs to the client browsers. But how to do know which option is your PHP engine is using? The PHP sample script will he... 2007-04-18, 5368👍, 0💬

What Happens to the Current Transaction If a DDL Statement Is Executed
What Happens to the Current Transaction If a DDL Statement Is Executed? - Oracle DBA FAQ - Understanding SQL Transaction Management If a DDL statement is executed, the current transaction will be committed and ended. All the database changes made in the current transaction will become permanent. Thi... 2007-04-18, 5085👍, 0💬

How To Rollback the Current Transaction
How To Rollback the Current Transaction? - Oracle DBA FAQ - Understanding SQL Transaction Management If you have used some DML statements updated some data objects, you find a problem with those updates, and you don't want those updates to be permanently recorded in the database, you can use the ROL... 2007-04-18, 5157👍, 0💬

How To Force the PHP Engine to Use Cookies to Transfer Session IDs
How To Force the PHP Engine to Use Cookies to Transfer Session IDs? - PHP Script Tips - Understanding and Using Sessions If you want to force your PHP engine to use cookies to transfer session IDs instead of URL parameters, you can open the PHP configuration file, php.ini, and make the following cha... 2007-04-18, 5514👍, 0💬

What Happens to the Current Transaction If the Session Is Ended
What Happens to the Current Transaction If the Session Is Ended? - Oracle DBA FAQ - Understanding SQL Transaction Management If a session is ended, the current transaction in that session will be committed and ended. All the database changes made in the current transaction will become permanent. Thi... 2007-04-18, 5182👍, 0💬

What Happens to the Current Transaction If the Session Is Killed
What Happens to the Current Transaction If the Session Is Killed? - Oracle DBA FAQ - Understanding SQL Transaction Management If a session is killed by the DBA, the current transaction in that session will be rolled back and ended. All the database changes made in the current transaction will be rem... 2007-04-18, 5282👍, 0💬

Where Are the Session Values Stored
Where Are the Session Values Stored? - PHP Script Tips - Understanding and Using Sessions When a value is saved into the current session by one PHP page, the PHP engine must stored this value somewhere on Web server, so that the PHP engine can retrieve it back when same visitor comes back to request... 2007-04-18, 5374👍, 0💬

How Does Oracle Handle Read Consistency
How Does Oracle Handle Read Consistency? - Oracle DBA FAQ - Understanding SQL Transaction Management Oracle supports two options for you on how to maintain read consistency: READ WRITE (the default option), also called statement-level read consistency. READ ONLY, also called transaction-level read c... 2007-04-18, 5304👍, 0💬

What Is the Timeout Period on Session Values
What Is the Timeout Period on Session Values? - PHP Script Tips - Understanding and Using Sessions The PHP engine has no direct settings on session timeout period. But it has a session garbage collection mechanism that you can set to remove those special files containing session values. There are 3 ... 2007-04-18, 5578👍, 0💬

What Is a READ WRITE Transaction
What Is a READ WRITE Transaction? - Oracle DBA FAQ - Understanding SQL Transaction Management A READ WRITE transaction is a transaction in which the read consistency is set at the statement level. In a READ WRITE transaction, a logical snapshot of the database is created at the beginning of the exec... 2007-04-18, 5080👍, 0💬

How To Test the Session Garbage Collection Process
How To Test the Session Garbage Collection Process? - PHP Script Tips - Understanding and Using Sessions In order to test the session garbage collection process, you need to change the settings to expire session variables in 10 seconds and run the process on every request: session.gc_probability = 1... 2007-04-18, 5459👍, 0💬

How To Set session.gc_divisor Properly
How To Set session.gc_divisor Properly? - PHP Script Tips - Understanding and Using Sessions As you know that session.gc_divisor is the frequency of when the session garbage collection process will be executed. You should set this value based on the income request traffic. Here are some suggestions:... 2007-04-18, 8101👍, 0💬

How To Set session.gc_maxlifetime Properly
How To Set session.gc_maxlifetime Properly? - PHP Script Tips - Understanding and Using Sessions As you know that session.gc_maxlifetime is the session value timeout period. You should set this value based on the usage pattern of your visitors. Here are some suggestions: # Set it to 20 minutes for a... 2007-04-18, 7297👍, 0💬

How To Set a Transaction To Be READ ONLY
How To Set a Transaction To Be READ ONLY? - Oracle DBA FAQ - Understanding SQL Transaction Management If you want a transaction to be set as READ ONLY, you need to the transaction with the SET TRANSACTION READ ONLY statement. Note that a DML statement will start the transaction automatically. So you... 2007-04-17, 5516👍, 0💬

What Is a READ ONLY Transaction
What Is a READ ONLY Transaction? - Oracle DBA FAQ - Understanding SQL Transaction Management A READ ONLY transaction is a transaction in which the read consistency is set at the transaction level. In a READ ONLY transaction, a logical snapshot of the database is created at the beginning of the trans... 2007-04-17, 5181👍, 0💬

<< < … 156 157 158 159 160 161 162 163 164 165 166 … > >>   Sort: Rank

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML