// Set DB access as constants define ('DB_USER2', 'canesfan_wowadmi'); define ('DB_PASSWORD2', 'capj20las'); define ('DB_HOST2', 'localhost'); define ('DB_NAME2', 'canesfan_insite'); // Connect to the database $db_link2 = @mysql_connect (DB_HOST2, DB_USER2, DB_PASSWORD2); // MySql connection string if ($db_link2) { // If connected, select the DB $db_selected = @mysql_select_db(DB_NAME2, $db_link2); // Database to connect to if (!$db_selected) { // If DB could not be selected echo "Could not select the database"; } } else { // If could not connect to DB echo "Could not connect to the database"; } // ======================================= \\ // Database Query Function \\ // ======================================= \\ function DBQuery ($query) { $result = mysql_query($query); $my_rows = array(); $total = mysql_num_rows($result); if ($total > 0) { mysql_data_seek($result, 0); while ($row = mysql_fetch_array($result)) { array_push($my_rows, $row); } } return $my_rows; } // ======================================= \\ // Database Insert Query Function \\ // ======================================= \\ function DBInsert ($query) { $result = mysql_query($query); $my_rows = mysql_insert_id(); return $my_rows; } // ======================================= \\ // Database Number of Rows Function \\ // ======================================= \\ function DBNumRows ($query) { $result = mysql_query($query); $my_rows = mysql_num_rows($result); return $my_rows; } // ======================================= \\ // Database Update Function \\ // ======================================= \\ function DBUpdate ($query) { $result = mysql_query($query); $my_rows = mysql_affected_rows(); return $my_rows; } // ======================================= \\ // Database Delete Query Function \\ // ======================================= \\ function DBDelete ($query) { $result = mysql_query($query); $my_rows = mysql_affected_rows(); return $my_rows; } ?> Sample CMS

A Content Managment System (CMS) allows you to control the content of your site on your own from a password protected area. Controlable content can be anything from client lists, product catalog, site texts and images. From your CMS you can also track orders on ecommerce sites, send clients and members emails and newsletters.

Try some of the sample tools for examples of what can be done from your Content Managment System.

Text Editor
InSite Designs' Text Editor is ideal for creating custom formatted newsletters, adding news articles, updating member and client information or updating your site's content.

Re-Order Photos
Quickly and easily re-order the photos on your site. This tool can be used to re-order videos, news articles, client testimonials or other text blocks on your site

Client Listing
View all of your members or clients and their information. Conntacts are easily added, editted and removed. This feature can also be applied to product listings and stock, or customer orders.

Voting System
Poll your visitors. Votes can be limited to registered users, logged in members or 1 vote per person. Can also be used to rate products and services.

Try the Demo Try the Demo Try the Demo Try the Demo