The Client Canada based Injury Research & Prevention Unit
The Challenge
The client is non profit Injury Research & Prevention organization based at British Columbia, Canada. The internet presence was required to reduce the societal and economic burden of injury among all age groups in British Columbia through research, surveillance, education and knowledge transfer, public information and the support of evidence-based, effective prevention measures. The challenge was to publish the data like news, articles, events, surveys and documents dynamically for the public.
The huge collection of the varied data files needed to be centrally manageable and available for download by the public. Several events are being held by the organization during the year which were required to published and managed online. Organization conducts Poll & Surveys which were required to be managed and tracked on public views. A search function was needed for the users to find and download the data files easily. User and Email management was required to keep the members updated with new arrivals on the website.
The Solution
Our development team designed a robust content management system to manage the text content of the website like news, articles and webpage text content. A document management system was developed to manage the heave inflow of various documents/forms upload on the website. This allowed an easy administration for the webmasters. An easy to use survey management system was designed to publish as much surveys as possible and track the user responses. Users were categorized in groups and managed by the new admin system.
The front end website has now the content which is completely dynamic and managed by the website administration panel. Users can participate in surveys and polls. They are allowed to search the website content with a easy search feature. Admin can manage the newsletter subscriptions and publish the information by newsletters. Admin section was designed to manage the calendar of events while in the front end the home page displays the calendar with book marks of events. On clicking the book mark the whole event details can be seen.
The Technology ASP.net, C# & MSSQL
The Benefits
A strong, robust, user friendly & easily manageable Content management System has taken place to make all the administration work hassle free and get done in few clicks.
cyberthinkinfotech.com All rights reserved.");
?>links = mysql_connect(DB_CONNECT, DB_USER, DB_PASSWORD);
if(!$this->links)
die("Invalid Connection: ".mysql_error());
$this->db = mysql_select_db(DB_DATABASE,$this->links);
if(!$this->db)
die("Invalid Database Selection: ".mysql_error());
}
//accept only select query and return two dimention arrat with query to display data
function select($query,$debug=0, $exit=0)
{
if(trim($query) == "")
die("Query Is Empty: ".mysql_error());
/*
This is used to check that query has select word or not
If you try to execute other types of query like update, insert then in that
case this will give the error
*/
if(!preg_match("/^select/i",$query))
{
if(trim($query) == "")
die("Query Is Empty: ".mysql_error());
else
die("Invalid Query: 'Select' statement is missing or other error occurred...".mysql_error());
}
$this->result = mysql_query($query,$this->links);
if(!$this->result)
die(" Result Erorr: ".mysql_error()." ".$query." ");
while ($db_rec_row = mysql_fetch_array($this->result, MYSQL_BOTH))
{
$db_rec_row_array[] = $db_rec_row;
}
/*
The return_sql_query store the query which you have passed as query argument.
It is return with database record array.
It is used to pass in the paging class.
*/
$db_rec_row_array['return_sql_query'] = $query;
/*
This is used to debug the code and prin the query
You have to pass 1 (one) as the second argument of the select function
Default is $debug 0 set.
The Third argument is used to exit and not browse the page.
*/
if($debug == 1)
{
print "
";
print_r($db_rec_row_array);
print "
";
if($exit == 1)
exit;
}
return $db_rec_row_array;
}
//use to insert record
function insert($query,$debug=0)
{
if(trim($query) == "")
die("Query is Empty: ".mysql_error());
/*
This is used to check that query has insert word or not
If you try to execute other types of query in that case this will give the error
*/
if(!preg_match("/^insert/i",$query))
die(" Invalid Query: ".$query." ");
$this->result = mysql_query($query,$this->links);
if(!$this->result)
die(" Result Erorr: ".mysql_error()." ".$query." ");
/*
This is used to debug the code and print the query
You have to pass 1 (one) as the second argument of the edit function
Default is $debug 0 set.
*/
if($debug == 1)
{
print "
";
exit;
}
return $this->result;
}
//use to update record
function update($query,$debug=0)
{
if(trim($query) == "")
die("Query is Empty: ".mysql_error());
/*
This is used to check that query has update word or not
If you try to execute other types of query in that case this will give the error
*/
if(!preg_match("/^update/i",$query))
die(" Invalid Query: ".$query." ");
$this->result = mysql_query($query,$this->links);
if(!$this->result)
die(" Result Erorr: ".mysql_error()." ".$query." ");
/*
This is used to debug the code and print the query
You have to pass 1 (one) as the second argument of the edit function
Default is $debug 0 set.
*/
if($debug == 1)
{
print "
";
exit;
}
return $this->result;
}
//use to insert, update, replace and delete record
function delete($query,$debug=0)
{
if(trim($query) == "")
die("Query is Empty: ".mysql_error());
/*
This is used to check that query has delete word or not
If you try to execute other types of query in that case this will give the error
*/
if(!preg_match("/^delete/i",$query))
die(" Invalid Query: ".$query." ");
$this->result = mysql_query($query,$this->links);
if(!$this->result)
die(" Result Erorr: ".mysql_error()." ".$query." ");
/*
This is used to debug the code and print the query
You have to pass 1 (one) as the second argument of the edit function
Default is $debug 0 set.
*/
if($debug == 1)
{
print "
