Browse a Listing
Top > PHP > Tips and Tutorials > Database-Related
Popular Tags
Free Script links
This article is primarily for PHP programmers. Nevertheless, the basic idea is not unique to PHP and guided by basic understanding of OO ideas and SQL, anybody should be able to grab it.
Category:
Write a Review
Add Favorite
Refer it to Friend
Report Broken Link
Date Added: Oct 15, 2006 Hits: 5 Rating: 0.00 Votes: 0
Member Reviews
Visitor Ratings
Google PR
PHP4 is packed with good features. One of the most popular is session variables. These are variables that persist throughout a session, as the user moves from page to page. Session variables are great holders of state information and other useful stuff.
To use session variables, call session_start() at the beginning of your web page, before your HTTP headers are sent. Then for every variable you want to keep alive for the duration of the session, store it in $_SESSION[$variable_name]. By default, the session handler will keep track of the session by using a cookie. You can save objects or arrays in session variables also (but be warned that this is buggy in some versions of PHP4).
Category:
Write a Review
Add Favorite
Refer it to Friend
Report Broken Link
Date Added: Oct 15, 2006 Hits: 3 Rating: 0.00 Votes: 0
Member Reviews
Visitor Ratings
Google PR
Member Reviews
Visitor Ratings
Google PR
Most interactive websites nowadays require data to be presented dynamically and interactively based on input from the user. For example, a customer may need to log into a retail website to check his purchasing history. In this instance, the website would have stored two types of data in order for the customer to perform the check ? the customer?s personal login details; and the customer?s purchased items. This data can be stored in two types of storage ? flat files or databases.
Category:
Write a Review
Add Favorite
Refer it to Friend
Report Broken Link
Date Added: Oct 15, 2006 Hits: 8 Rating: 0.00 Votes: 0
Member Reviews
Visitor Ratings
Google PR
SQLite is a C library that implements an embeddable SQL database engine. Scripts which link with the SQLite library can have SQL access without running an additional database server.
Category:
Write a Review
Add Favorite
Refer it to Friend
Report Broken Link
Date Added: Oct 15, 2006 Hits: 0 Rating: 0.00 Votes: 0
Member Reviews
Visitor Ratings
Google PR
Member Reviews
Visitor Ratings
Google PR
Member Reviews
Visitor Ratings
Google PR
Member Reviews
Visitor Ratings
Google PR
Open DataBase Connectivity is an Application Programming Interface (API) that allows a programmer to abstract a program from a database. When writing code to interact with a database, you have to add code that talks to a particular database using a proprietary API. If you want your program to talk to an Access, FoxPro and Oracle databases you have to code your program with three different database API's. This can be quite the daunting task causing much grief. Now, enter ODBC...
When programming to interact with ODBC you only need to use the ODBC API (a combination of ODBC extension function calls and the SQL language) to talk to different database products. The ODBC Manager will figure out how to contend with the type of database you are targeting. Regardless of the database type you are using, all of your calls will be to the ODBC API. All that you need to do is have installed an ODBC driver that is specific to the type of database you will be using.
Category:
Write a Review
Add Favorite
Refer it to Friend
Report Broken Link
Date Added: Oct 15, 2006 Hits: 2 Rating: 0.00 Votes: 0
Member Reviews
Visitor Ratings
Google PR
Member Reviews
Visitor Ratings
Google PR