name; $value = $row["$name"]; $mirage_resultValue[$name] = $value; } } } return $mirage_resultValue; } function mirage_dbdo($sql_query, $sql_command_type, $alert="0"){ if ($alert==1) { print $sql_query."
"; } global $db_connection; global $db_type; global $arrSQLCache; global $mysqli; if ($sql_command_type == "SELECT"){ if (!$arrSQLCache[$sql_query]) { $k=0; $mirage_resultValue=null; $result = mysqli_query($mysqli,"$sql_query");//or die("
Query failed:
dbdo
$sql_query

"); while ($row = mysqli_fetch_array($result)) { $num_of_fields = mysqli_num_fields($result); for($k==0;$k<$num_of_fields;$k++){ $field_name = mysqli_fetch_field_direct($result, $k); $name=$field_name->name; $value = $row["$name"]; $mirage_resultValue[$name] = $value; } } $arrSQLCache[$sql_query]=$mirage_resultValue; } else { $mirage_resultValue = $arrSQLCache[$sql_query]; } return $mirage_resultValue; } if ($sql_command_type == "INSERT"){ } if ($sql_command_type == "DELETE"){ } $query = "$sql_query"; mysqli_query($mysqli,$query); return true; } function mirage_multi($sql_query, $indexValue=1, $alert="0"){ if ($alert==1) { print $sql_query."
"; } global $db_type; global $arrSQLCache; global $mysqli; if (!$arrSQLCache[$sql_query]) { $result = mysqli_query($mysqli,"$sql_query")or die("
Query failed:
multi
$sql_query

"); $a = 0; $requestedValue = $indexValue - 1; while ($row = mysqli_fetch_array($result)) { $getFieldName = mysqli_fetch_field_direct($result, $requestedValue); $name=$getFieldName->name; $value = $row["$name"]; $requestedArray[$value] = $row; $a++; } $arrSQLCache[$sql_query]=$requestedArray; } else { $requestedArray = $arrSQLCache[$sql_query]; } return $requestedArray; } /** fixes bug that over-writes non-unique data **/ function mirage_multi_unique($sql_query, $indexValue=1, $alert="0"){ if ($alert==1) { print $sql_query."
"; } global $db_type; global $arrSQLCache; global $mysqli; if (!$arrSQLCache[$sql_query]) { $result = mysqli_query($mysqli,"$sql_query")or die("
Query failed:
multi
$sql_query

"); $a = 0; $requestedValue = $indexValue - 1; while ($row = mysqli_fetch_array($result)) { $requestedArray[$a] = $row; $a++; } $arrSQLCache[$sql_query]=$requestedArray; } else { $requestedArray = $arrSQLCache[$sql_query]; } return $requestedArray; } ?> Society of Christian Schools in BC Network - Login
'.$_GET["message"].'
'; } ?>
Email
Pass
Registered Email:
*/ ?>