Code: Select all
<?php
$text='
<?
/////////////////////////////////////////////////////////////////////////////////////////
//function to get data
function getData($request_page, $table_view, $filter, $order, $purpose)
{
global $mysql_errno, $mysql_error, $no_db_connection, $no_result;
//build sql statement based on the table -
//for complex data sets test for and include $filter and $order
switch($table_view)
{
case $table_view :
{ //list of all tables from the passed in databasse
if($purpose == "SHOW ALL TABLES") //keep the format and spacing for $purpose EXACT
{
$sql_statement = "SHOW TABLES FROM $table_view";
$script_error = " retrieving a list of all tables in the database";
}
elseif($purpose == "SHOW COLUMNS") //keep the format and spacing for $purpose EXACT
{
$sql_statement = "SHOW COLUMNS FROM $table_view";
$script_error = " retrieving a list of columns for the table or view $table_view";
}
break;
}
case "sys_element_attribute_spec" :
{
if($purpose == "SHOW ALL FORM ELEMENTS and ATTRIBUTES") //keep the format and spacing
{
$sql_statement = "SELECT seas.* FROM `sys_element_attribute_spec` seas $filter $order";
$script_error = " retrieving a list of elements and their attribute specifications";
//reportError($request_page, $script_error , $purpose , $sql_statement);
}
else if ($purpose == "MAX ORDER NUMBER")//keep the format and spacing for $purpose EXACT
{
$sql_statement = "SELECT MAX(link_order) FROM LINKS $filter";
$script_error = " Retrieving hyper link order or arrangement on page";
}
//reportError($request_page, $script_error , $purpose , $sql_statement);
break;
}
case "sys_form_specification" :
{
if($purpose == "SHOW ALL FORM SPECIFICATIONS")//keep the format and spacing for $purpose
{
$sql_statement = "SELECT fp.*, FROM `sys_form_specification` $filter $order";
$script_error = " retrieving list of form specifications";
//reportError($request_page, $script_error , $purpose , $sql_statement);
}
else if ($purpose == "MAX ORDER NUMBER")//keep the format and spacing for $purpose EXACT
{
$sql_statement = "SELECT MAX(link_order) FROM LINKS $filter";
$script_error = " Retrieving hyper link order or arrangement on page";
}
//reportError($request_page, $script_error , $purpose , $sql_statement);
break;
}
case "party": //keep the format and spacing for $purpose EXACT
{
if($purpose == "PARTY AND IMAGES REGARDLESS of ROLE")
{
$sql_statement = "SELECT p.party_id, p.party_type, p.person_fnm, p.person_mnm, p.person_lnm, p.org_nm, p.tagline, p.address_ln1, p.address_ln2, p.address_city, p.address_state, p.address_zip, p.phone1, p.phone1_type, p.phone2, p.phone2_type, p.email, p.website, i.image_file_nm, p.img_file_nm, p.map_img_file_nm, p.login_id, p.login_pwd, p.login_reminder, p.login_last_updated, p.created_user_id, p.created_date_ts, p.last_updated_user_id, p.last_updated_date_ts, p.party_desc FROM be_party p, be_image i $filter $order";
$script_error = " retrieving party and images regardless of role";
//reportError($request_page, $script_error , $purpose , $sql_statement);
}
break;
}
case "content" :
{
if($purpose == "GENERAL DISPLAY") //keep the format and spacing for $purpose EXACT
{
$sql_statement = "SELECT c.*, p.person_fnm, p.person_lnm FROM `content` c, `party_content` pc, `party` p $filter $order";
$script_error = " Retrieving General Display Content/Article and Author(s)";
//reportError($request_page, $script_error , $purpose , $sql_statement);
}
else if ($purpose == "MAX ORDER NUMBER")//keep the format and spacing for $purpose EXACT
{
$sql_statement = "SELECT MAX(link_order) FROM LINKS $filter";
$script_error = " Retrieving hyper link order or arrangement on page";
}
//reportError($request_page, $script_error , $purpose , $sql_statement);
break;
}
} //end of switch
/////////////////////////////////////////////////////////////////////////////////////////
//connect to the db and get the results
$db_link = db_connect();
if(!$db_link)
{
//error handling
reportError($request_page, $script_error, $no_db_connection, $sql_statement);
$result = -1;
}
else
{
// SQL Query - should select each column by name
$result = mysql_query($sql_statement, $db_link);
if(!$result)
{
//error handling
reportError($request_page, $script_error, $no_result, $sql_statement);
$result = -2;
}
return $result;
}
} //end function getData
/////////////////////////////////////////////////////////////////////////////////////////
//function to set or update data
function setData($request_page, $table_view, $update_string, $filter, $uid){
global $db_host, $db_user, $db_pwd, $db_name, $db_default_name, $mysql_errno, $mysql_error, $no_db_connection, $no_result;
//build sql statement based on the table -
//for complex data sets test for and include $filter and $order
switch($table_view){
case "links" : {
$current_date = date("Y-m-d, H:i:s");
$sql_statement = "UPDATE LINKS SET ";
$sql_statement .= $update_string;
$sql_statement .= ", last_update_dt = \'" . $current_date . "\' " . $filter;
$script_error = "Updating hyper links.";
//here to see what the SQL statement is
//reportError($request_page, $script_error ,"No SQL result - testing only " , $sql_statement);
break;
}
} //end of switch
/////////////////////////////////////////////////////////////////////////////////////////
//connect to the db and get the results
$db_link = db_connect();
if(!$db_link){
//error handling
reportError($request_page, $script_error, $no_db_connection, $sql_statement);
$result = -1;
}
else{
//reportError($request_page, $script_error, $no_result, $sql_statement);
// SQL Query - should select each column by name
$result=mysql_query($sql_statement, $db_link);
if(!$result){
//error handling
reportError($request_page, $script_error, $no_result, $sql_statement);
$result = -2;
}
return $result;
}
} //end function
/////////////////////////////////////////////////////////////////////////////////////////
//function to add or insert data
function addData($request_page, $table_view, $insert_string, $purpose, $uid){
global $db_host, $db_user, $db_pwd, $db_name, $db_default_name, $mysql_errno, $mysql_error, $no_db_connection, $no_result;
//this may be used with all inserts
$current_date = date("Y-m-d H:i:s");
//build sql statement based on the table -
switch($table_view){
case "web_issue" : {
$sql_statement = "INSERT INTO web_issue VALUES(\'\', ";
$sql_statement .= $insert_string;
$sql_statement .= " )";
//here to see what the SQL statement is
$script_error = "Inserting a new web issue";
//reportError($request_page, $script_error ,"No SQL result - testing only " , $sql_statement);
break;
}
} //end of switch
/////////////////////////////////////////////////////////////////////////////////////////
//connect to the db and get the results
$db_link = db_connect();
if(!$db_link){
//error handling
reportError($request_page, $script_error, $no_db_connection, $sql_statement);
$result = -1;
}
else{
// SQL Query - should insert a row into a table or view
$result=mysql_query($sql_statement, $db_link);
if(!$result){
//error handling
reportError($request_page, $script_error, $no_result, $sql_statement);
$result = -2;
}
return $result;
}
} //end function
/////////////////////////////////////////////////////////////////////////////////////////
//function to delete data
function removeData($request_page, $purpose, $table_view, $filter, $uid ){
global $db_host, $db_user, $db_pwd, $db_name, $db_default_name, $mysql_errno, $mysql_error, $no_db_connection, $no_result;
//build sql statement based on the table -
//for complex data sets test for and include $filter and $order
switch($table_view){
case "event" : {
if($purpose == "DELETE EVENT"){
$sql_statement = "DELETE FROM event $filter";
$script_error = "Deleting event from admin area per user request. User ID: " . $uid;
}
break;
}
} //end of switch
/////////////////////////////////////////////////////////////////////////////////////////
//connect to the db and get the results
$db_link = db_connect();
if(!$db_link){
//error handling
reportError($request_page, $script_error, $no_db_connection, $sql_statement);
$result = -1;
}
else{
// SQL Query - should select each column by name
$result=mysql_query($sql_statement, $db_link);
if(!$result){
//error handling
reportError($request_page, $script_error, $no_result, $sql_statement);
$result = -2;
}
return $result;
}
} //end function
?>';
preg_match_all('#"(SELECT.+?)"#si',$text,$matches);
var_export($matches);
?>
Code: Select all
array (
0 =>
array (
0 => '"SELECT seas.* FROM `sys_element_attribute_spec` seas $filter $order"',
1 => '"SELECT MAX(link_order) FROM LINKS $filter"',
2 => '"SELECT fp.*, FROM `sys_form_specification` $filter $order"',
3 => '"SELECT MAX(link_order) FROM LINKS $filter"',
4 => '"SELECT p.party_id, p.party_type, p.person_fnm, p.person_mnm, p.person_lnm, p.org_nm, p.tagline, p.address_ln1, p.address_ln2, p.address_city, p.address_state, p.address_zip, p.phone1, p.phone1_type, p.phone2, p.phone2_type, p.email, p.website, i.image_file_nm, p.img_file_nm, p.map_img_file_nm, p.login_id, p.login_pwd, p.login_reminder, p.login_last_updated, p.created_user_id, p.created_date_ts, p.last_updated_user_id, p.last_updated_date_ts, p.party_desc FROM be_party p, be_image i $filter $order"',
5 => '"SELECT c.*, p.person_fnm, p.person_lnm FROM `content` c, `party_content` pc, `party` p $filter $order"',
6 => '"SELECT MAX(link_order) FROM LINKS $filter"',
),
1 =>
array (
0 => 'SELECT seas.* FROM `sys_element_attribute_spec` seas $filter $order',
1 => 'SELECT MAX(link_order) FROM LINKS $filter',
2 => 'SELECT fp.*, FROM `sys_form_specification` $filter $order',
3 => 'SELECT MAX(link_order) FROM LINKS $filter',
4 => 'SELECT p.party_id, p.party_type, p.person_fnm, p.person_mnm, p.person_lnm, p.org_nm, p.tagline, p.address_ln1, p.address_ln2, p.address_city, p.address_state, p.address_zip, p.phone1, p.phone1_type, p.phone2, p.phone2_type, p.email, p.website, i.image_file_nm, p.img_file_nm, p.map_img_file_nm, p.login_id, p.login_pwd, p.login_reminder, p.login_last_updated, p.created_user_id, p.created_date_ts, p.last_updated_user_id, p.last_updated_date_ts, p.party_desc FROM be_party p, be_image i $filter $order',
5 => 'SELECT c.*, p.person_fnm, p.person_lnm FROM `content` c, `party_content` pc, `party` p $filter $order',
6 => 'SELECT MAX(link_order) FROM LINKS $filter',
),
)