[請益] Xajax即時檢查帳號已經註冊遇到的問題?

看板PHP作者 (我的生命因你而發光)時間16年前 (2009/10/08 07:44), 編輯推噓1(103)
留言4則, 2人參與, 最新討論串1/1
目前我想要使用Xajax去做即時賬號檢查功能 但問題出在$stokData = mysql_query($query_stokData, $lozenzo_conn) or die(mysql_error()); 我找google是好像說要連到server,而不是DATABASE 這不曉得是什麼意思呢? 程式碼部分該怎樣修改呢? ======= $lozenzo_conn======== $hostname_lozenzo_conn = "localhost"; $database_lozenzo_conn = "test"; $username_lozenzo_conn = "root"; $password_lozenzo_conn = "root"; $lozenzo_conn = mysql_pconnect($hostname_lozenzo_conn, $username_lozenzo_conn, $password_lozenzo_conn) or trigger_error(mysql_error(),E_USER_ERROR); ============= 檢查的xajax =========== <?php include_once ("../xajax/xajax.inc.php"); $xajax = new xajax(); $xajax->registerFunction("processform"); function processform($form){ $res = new xajaxResponse(); $username = $form['pno']; $username=trim($username); if(!empty($username)){ $query_stokData = "SELECT pno FROM lorenzo_newstok WHERE pno ='" . $username . "'"; $stokData = mysql_query($query_stokData, $lozenzo_conn) or die(mysql_error()); $row_stokData = mysql_fetch_assoc($stokData); $totalRows_stokData = mysql_num_rows($stokData); if($totalRows_stokData==1){ $res->assign('showmsg','innerHTML', "該名稱已經註冊過"); }else{ $res->assign('showmsg','innerHTML', ""); } return $res; } } $xajax->processRequest(); ?> -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 123.193.218.254

10/08 09:48, , 1F
有沒有可能是沒有選擇DB的關係呢?加個mysql_select_db看看?
10/08 09:48, 1F

10/08 11:47, , 2F
OK,我試試看,謝謝~
10/08 11:47, 2F

10/08 12:14, , 3F
我發現問題點了,分享一下,一個的確是向poewar說的沒加
10/08 12:14, 3F

10/08 12:15, , 4F
另一個是要加global $database, $lozenzo_conn
10/08 12:15, 4F
文章代碼(AID): #1ApIVh_K (PHP)
文章代碼(AID): #1ApIVh_K (PHP)