Viewing file:  FunctionDB2.php (2.37 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
$ServerName = "localhost";
$UserName2 = "root";
$UserPassword2 = "";
$DataBaseName2 = "personal_developdb";
function ConnectDB2()
{
global $con;
global $ServerName;
global $UserName2;
global $UserPassword2;
global $DataBaseName2;
$con = mysql_connect($ServerName,$UserName2,$UserPassword2);
if (!$con)
die("Can't Connect DataBase".mysql_error());
mysql_select_db($DataBaseName2) or die ("Can't Select Personal_developdb ".mysql_error());
}
/////////////////////// Uses Close DB ////////////////////////////
function CloseDB2()
{
global $con;
mysql_close($con);
}
/////////////////////////////////////////////////////
function InsertCommit($Teacher_code,$Title,$Year_com,$Edu,$Edu_job,$Tsis,$Check_tool,$Scp10,$Club_bcnlp,$North_network,$Else_commit)
{
global $conn;
$sql = "INSERT INTO committee_tb (Teacher_code,Title,Year_com,Edu,Edu_job,Tsis,Check_tool,Scp10,Club_bcnlp,North_network,Else_commit)";
$sql = $sql."VALUES ('$Teacher_code','$Title','$Year_com','$Edu','$Edu_job','$Tsis','$Check_tool','$Scp10','$Club_bcnlp','$North_network','$Else_commit')" ;
mysql_query($sql) or die("$sql Insert has incorrect".mysql_error());
}
/////////////////////////////////////////////////////
function InsertEdu_Service($Project_name,$Period,$Date_start,$Term,$Year_budget,$Budget,$Budget_use,$Target_group,$Objective,$Fund_support ,$Fee,$Response,$Total_time_project ,$Total_time_insi ,$Total_time_inso)
{
global $conn;
$sql = "INSERT INTO edu_service_tb (Project_name,Period,Date_start,Term,Year_budget,Budget,Budget_use,Target_group,Objective,Fund_support ,Fee,Response,Total_time_project ,Total_time_insi ,Total_time_inso)";
$sql = $sql."VALUES ('$Project_name','$Period','$Date_start','$Term','$Year_budget','$Budget','$Budget_use','$Target_group','$Objective','$Fund_support' ,'$Fee','$Response','$Total_time_project','$Total_time_insi' ,'$Total_time_inso')" ;
mysql_query($sql) or die("$sql Insert has incorrect".mysql_error());
}
///////////////////////////////////////////////////
function Insert_Res_project($Teacher_code,$Project_name,$Year_res,$Duty,$Duty_else,$Apply)
{
global $conn;
$sql = "INSERT INTO res_project_tb (Teacher_code,Project_name,Year_res,Duty,Duty_else,Apply)";
$sql = $sql."VALUES ('$Teacher_code','$Project_name','$Year_res','$Duty','$Duty_else','$Apply')" ;
mysql_query($sql) or die("$sql Insert has incorrect".mysql_error());
}
?>
|