一、簡API完成的，沒有對數據庫進行操作。在接下來的高MySQL數據庫的操作做一下二、思路分MySQL數據庫進行操作演示，實現與數據庫的交互。在BAEdbname。可使用標準的PHPMysql或PHPMysqli擴展數據庫，BAE的PHP中已提供這兩個 三、創建BAEMySQL數據登陸開發者中心->->選擇應用->云環境->服務管理->MySQL(云數據庫)->創建數據庫注意每個應用有且只有一個數據庫享受1G免費其余數據庫均不享受免費。只有將已使用免費的數據庫刪除，才能再次使用此項。點擊“phpMyadmin”數據庫。“執行”AUTO_INCREMENT（UNIQUECREATETABLEIFNOTEXISTS`test_mysql`CREATETABLEIFNOTEXISTS`test_mysql``id`int(11)NOTNULL`from_user`varchar(40)DEFAULT`account`varchar(40)DEFAULT`password`varchar(40)DEFAULT`update_time`datetimeDEFAULTNULL,PRIMARYKEY(`id`),UNIQUEKEY`from_user`phpMyAdmin四、示例（PHP*MySQLBAEMySQL/*替換為你自己的數據庫名（可 查看到*MySQLBAEMySQL/*替換為你自己的數據庫名（可 查看到$dbname=/*從環境變量里取出數據庫連接需要的參數$host=$port=$user=$pwd=/*mysql_connect()連接服務器$link=@mysql_connect("{$host}:{$port}",$user,$pwd,true);if(!$link){die("ConnectServerFailed:".}/*mysql_select_db()選中需要連接的數據庫*/if(!mysql_select_db($dbname,$link)){die("SelectDatabaseFailed:".}/*至此連接已完全建立，就可對當前數據庫進行相應的操作了/*需要再連接其它數據庫，請再使用mysql_connect+mysql_select_db啟 *phpmysql$sql="createtableifnotexiststest_mysql(idintprimarykeyauto_increment,nonamevarchar(1024),keyidx_no(no))";$ret=mysql_query($sql,$link);if($ret===false){die("CreateTableFailed:".}elseecho"CreateTableSucceed<br} $sql="insertintotest_mysql(no,name)values(2007,'thisisatest(2008,'thisisanothertestmessage'),$ret=mysql_query($sql,$link);if($ret===false){die("InsertFailed:".}elseecho"InsertSucceed<br}$sql="deletefromtest_mysqlwhereno=$ret=mysql_query($sql,$link);if($ret===false){die("DeleteFailed:".}else}elseecho Succeed<br}$sql="updatetest_mysqlsetname='yyyyyy'whereno=$ret=mysql_query($sql,$link);if($ret===false){die("UpdateFailed:".}elseecho"UpdateSucceed<br}$sql="selectid,no,namefrom$ret=mysql_query($sql,$link);if($ret===false){die("SelectFailed:".}elseecho"SelectSucceed<brwhile($row=mysql_fetch_assoc($ret))echo"{$row['id']}{$row['no']}{$row['name']}<br}}$sql="droptableifexists$ret=mysql_query($sql,$link);if($ret===false){die("DropTableFailed:".}elseecho"DropTableSucceed<br}configure.php/***配置數據庫名稱define("MYSQLNAME",五、修改成可調用的函數形式（PHP5.1functionmysql_query($sql)ordie('創建表失敗，錯誤信息：'.mysql_error());return"創建表成功";}5.2數functionreturnreturnreturn}}}function_delete_data($sql){return returnreturn}}}function_update_data($sql){return returnreturn}}}function$ret=mysql_query($sql)ordie('SQLreturn$ret;}functionmysql_query($sql)ordie('刪除表失敗，錯誤信息：'.mysql_error());return"刪除表成功";}}六、測試MySQL函數使新建文件dev_mysql.php在同 下并引入mysql_bae.func.php文require_oncerequire_oncephpMyAdmintest_mysql$create_sql="CREATETABLEIFNOTEXISTS`test_mysql``id`int(11)NOTNULL`from_user`varchar(40)DEFAULT`account`varchar(40)DEFAULT`password`varchar(40)DEFAULT`update_time`datetimeDEFAULTNULL,PRIMARYKEY(`id`),UNIQUEKEY`from_user`echo$insert_sql="insertintotest_mysql(from_user,account,update_time)$insert_sql="insertintotest_mysql(from_user,account,update_time)values('David','860510','abcabc','2013-09-29$res=_insert_data($insert_sql);if($res==1){echoechoecho}：$update_sql$update_sql="updatetest_mysqlsetaccount=860512whereaccount=$res=_update_data($update_sql);if($res==1){echo}elseif($res==0){echo}elseif($res==echo}：$delete_sql$delete_sql="deletefromtest_mysqlwhereaccount=$res=_delete_data($delete_sql);if($res==1){echo}elseif($res==0){echo}elseif($res==echo}： $select_sql="select*from$result=while($rows=echo"<br}：$drop_sql$drop_sql="droptableifexistsecho：MySQL七、實現 的交互（Mysql擴展如：綁 3.保證數據庫中存在test_msyql表，這里測試 對MySQL數據庫的增刪改查操作，不考如：綁 3.如：修改如：修改4.刪除mysql_bae.func.phprequire_once$keywords=$keywords=$nowtime=date("Y-m-d$select_sql="SELECTidfromtest_mysqlWHERE$rows=mysql_fetch_array($res,MYSQL_ASSOC);if($rows[id]<>''){}if(trim($keywords[0]if($user_flag<>'y'){$insert_sql="INSERTINTOtest_mysql(from_user,account,password,update_time)$resif(trim($keywords[0]if($user_flag<>'y'){$insert_sql="INSERTINTOtest_mysql(from_user,account,password,update_time)$res=_insert_data($insert_sql);if($res==1){$contentStr}elseif($res==$contentStr$contentStr}$contentStr}}：if(trim($keywords[0]if(trim($keywords[0]$select_sql="SELECT*FROMtest_mysqlWHEREif($rows[id]<>''){$contentStr="賬戶 $rows[password]\n"."From_user：$rows[from_user]\n"."$contentStr="}}：if(trim($keywords[0]if(trim($keywords[0]$select_password_sql="SELECT*FROMtest_mysqlWHEREif($old_password==$update_sql="UPDATEtest_mysqlSETpassword='$new_password'WHEREfrom_user='$fromUsername'";$res=_update_data($update_sql);if($res==1){$contentStr}elseif($res==$contentStr}$contentStr=" 有誤，請確認后重試}}：if(trim($keywords[0]if(trim($keywords[0]$delete_sql="DELETEFROMtest_mysqlWHERE$res=_delete_data($delete_sql);if($res==1){$contentStr}elseif($res==$contentStr}}： 八、PHPMysqli擴展，封裝成Mysqlirequire_once'includes/configure.php';classMySQLi_BAE{private$mysqli;private$host;private$user;private$password;private$port;privatefunction}}functionset($property_name,$this-}function/*從平臺獲取查詢要連接的數據庫名稱$this->database=/*從環境變量里取出數據庫連接需要的參數$this->host=$this->user=$this->password=$this->port=$this->mysqli=newmysqli($this->host,$this-$this->password,$this->database,$this-if($this->mysqli-die("ConnectServerdie("ConnectServerFailed:".$this->mysqli-}$this->mysqli->query("setnames}//dqlfunction$res$this->mysqli->query($query)ordie("操作失敗return//$this->mysqli-}//dmlfunction$res$this->mysqli->query($query)ordie("操作失敗return0;//if($this->mysqli->affected_rows0){return1;//執行成功return2;//}}//$this->mysqli-}}九、測試類的使require_onceDMLrequire_once$mysqli_BAE=new$mysqli_BAE=new$sql="insertintotest_mysql(from_user,account,password,update_time)values('David','860510','abcabc','2013-09-2717:14:28')";//$sql="updatetest_mysqlsetaccount=860512whereaccount=//$sql="deletefromtest_mysqlwhereaccount=echoechoecho}：require_once$mysqli_BAE=newrequire_once$mysqli_BAE=new$sql="select*fromforeach($rowforeach($rowas$key=>$val){echo"$val--";}echo}$res-：十、實現 的交互（Mysqli