PHP mysql 连接数据库Demo

//php 连接数据库demo,用一个表字段更新另一个表
//读取app_date某个数据（txtMeals） 更新到PCR_FORM_DATA 里面的Meals字段
/*
*
* Grace
*
*/

try{
$mysql_server_name='127.0.0.1:3306';
//改成自己的mysql数据库服务器
$mysql_username='root';
//改成自己的mysql数据库用户名
$mysql_password='';
//改成自己的mysql数据库密码
$mysql_database='Test';
//改成自己的mysql数据库名
$conn=mysql_connect($mysql_server_name, $mysql_username,$mysql_password,$mysql_database);
mysql_select_db($mysql_database,$conn);
$sql='select Id,PCR_FORM_DATA.AppUid AS AppUid,APPLICATION.APP_UID AS APP_UID, Meals,APPLICATION.APP_DATA as APP_DATA from PCR_FORM_DATA
INNER JOIN APPLICATION ON APPLICATION.APP_UID = PCR_FORM_DATA.AppUid
;';
$result = mysql_query($sql);
$aRr = array();
while(is_array($row = mysql_fetch_array($result))){
$AppData = $row['APP_DATA'];
$fAppData = unserialize($AppData);
if(is_array($fAppData)){
$row ['ORGMeals'] = $fAppData['txtMeals'];
}
$aRr[] = $row;
}
//create temp table
$createTable ="CREATE TABLE `TEST_MEAL` (
`Id` varchar(32) NOT NULL DEFAULT '',
`ORGMeals` double(20,2) DEFAULT NULL,
`Meals` double(20,2) DEFAULT NULL,
`AppUid` varchar(32) DEFAULT NULL,
PRIMARY KEY (`Id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;";
$result = mysql_query($createTable);
$in ='';
$sql2='INSERT INTO TEST_MEAL (`Id`,`ORGMeals`,`Meals`,`AppUid`) VALUES';
foreach ($aRr as $item){
if(!$in){
$in = "('".$item['Id']."','".$item['ORGMeals']."','".$item['Meals']."','".$item['AppUid']."')";
}else{
$in .= ","."('".$item['Id']."','".$item['ORGMeals']."','".$item['Meals']."','".$item['AppUid']."')";
}
}
$sql2 .=$in;
$sql2 = $sql2.';';
//用一个表字段，更新另一个表
$result = mysql_query($sql2);
$update = 'update PCR_FORM_DATA b , TEST_MEAL n
set b.Meals = n.ORGMeals
where n.AppUid = b.AppUid;';
$result = mysql_query($update);
mysql_query('DROP TABLE TEST_MEAL;');
// print_r('<pre>');
// print_r($aRr) ;
// die;
//echo $sql;
mysql_close($conn);
echo "Hello!操作成功!";
}catch (Exception $e){
print ($e->getMessage());die;
}