Ec (2); db. func: & lt ;? FunctionGetRows ($ Database, $ Query) {mysql_connect (& quot; ftp & quot;, & quot; root & quot;, & quot ;); $ dbmysql_select_db ($ Database); if (! $ Db) {echo & quot; unable to link data script ec (2); script
Db. func:
Function GetRows ($ Database, $ Query ){
Mysql_connect ("ftp", "root ","");
$ Db = mysql_select_db ($ Database );
If (! $ Db ){
Echo "cannot connect to the database! ";
Exit;
}
$ Rows = mysql_query ($ Query );
If (! $ Rows ){
Echo "SQL command error! ";
Exit;
}
Return $ rows;
}
Function ConnectDatabase ($ Database ){
Mysql_connect ("ftp", "root ","");
$ Db = mysql_select_db ($ Database );
If (! $ Db ){
Echo "cannot connect to the database! ";
Exit;
}
}
?>
Cratetable. php:
Function CreateTable (){
$ Link = mysql_connect ("ftp", "root ","");
$ Db = mysql_select_db ("pcadmin ");
If (! $ Db ){
Echo "failed to connect to database! ";
Exit;
}
$ Rows = mysql_query ("select * from Profile ");
If (! $ Rows ){
$ SQL = "Create Table Profile (ID integer auto_increment primary key, Name char (255), Produce char (255), Lianluo char (255), Tel integer (15 ), email char (255 ))";
Mysql_query ($ SQL );
}
$ Rows = mysql_query ("select * from Aplication ");
If (! $ Rows ){
$ SQL = "Create Table Aplication (Name char (255) primary key, IP char (255), Ap char (255), Directory char (255 ))";
Mysql_query ($ SQL );
}
Mysql_close ($ link );
}
CreateTable ();
?>
Input.htm: