PHP實例代碼如下:
- $uid = $_request['uid'];
- checkusername($uid);
- function checkusername()
- {
- $title = $uid;
- if( emptyempty( $title ) )
- {
- return false;
- }
- else
- {
- mysql教程_connect('localhost','root','root');
- mysql_select_db('test');
- mysql_query("set names 'gb2312'");
- $sql = "select * from cn_user where username ='$title'";
- $row = mysql_query($sql);
- if( mysql_num_rows( $row ) )
- {
- echo '用戶名己經存';
- }
- else
- {
- return '可以注冊';
- }
- }
- }
SQL數據庫代碼如下:
- /*
- create table `test`.`cn_user` (
- `id` int not null auto_increment ,
- `username` varchar( 20 ) not null ,
- `times` date null ,
- primary key ( `id` )
- ) engine = myisam
- 插入數據
- insert into `test`.`cn_user` (
- `id` ,
- `username` ,
- `times`
- )
- values (
- null , 'jimmy', null
- ), (
- null , 'm.survivalescaperooms.com', null
- );
- */
新聞熱點
疑難解答