//connecting to a databasefunction Conn ($dbhost, $dbuser, $dbpwd, $dbname) {$link= @mysql_connect ($dbhost, $dbuser, $dbpwd) or Die ("Connection Database Error!". Mysql_error ()); mysql_select_db ($dbname, $link); mysql_query ("Set names UTF8");}//Execute SQL statementfunction Query ($sql) {returnmysql_query ($sql);}//returns the number of recordsfunction NumRows ($sql) {$result=mysql_query ($sql); returnmysql_num_rows ($result);}//gets a piece of information that returns a one-dimensional arrayfunction GetOne ($sql) {$result=mysql_query ($sql); returnMysql_fetch_assoc ($result);}//gets more than one message, returns a multidimensional arrayfunction GetAll ($sql) {$result=mysql_query ($sql); $rows=Array (); while($rs =Mysql_fetch_assoc ($result)) {$rows []=$rs; } return$rows;}//Close the databasefunction Close () {mysql_close ();}
<?Php$config=Array ('Dbhost'='localhost', 'Dbuser'='Root', 'dbpwd'="', 'dbname'='MyBlog');
PHP basic------Operation MySQL function