[請益] 用PHP創造資料庫的帳戶
不知道這個問題可不可以在這裡發問
其實是要用PHP做一個的介面
它可以用來創造資料庫的帳號(以phpMyAdmin來說)
SQL的語法是:
CREATE USER '$username'@'%' IDENTIFIED BY '$password';
GRANT SELECT ,
INSERT ,
UPDATE ,
DELETE ,
DROP ,
RELOAD ,
SHUTDOWN ,
PROCESS ,
FILE ,
REFERENCES ,
INDEX ,
ALTER ,
SHOW DATABASES ,
SUPER ,
CREATE TEMPORARY TABLES ,
LOCK TABLES ,
REPLICATION SLAVE ,
REPLICATION CLIENT,
CREATE VIEW ,
SHOW VIEW ,
CREATE ROUTINE,
ALTER ROUTINE,
CREATE USER,
EXECUTE ON * . * TO '$username'@'%' IDENTIFIED BY '$password' WITH
GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0
MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0
已知道直接放到SQL語法執行攔
可以成功創出擁有該權限之帳號
$username 為使用者名稱
$password 為密碼(用資料庫既定的新增使用者介面創造的話,會是一串星號******.....)
可是PHP就不知道要用什麼函式去執行該SQL的語法
以下是我未完成的程式:
<?php
$link = mysql_connect("localhost",123,"456");
mysql_query("SET NAMES 'utf8'");
if( !$link )echo "資料庫連結失敗<br>";
else echo "連結成功了<p>";
mysql_query("SET NAMES 'utf8'");
$username = $_POST["username"];//在html的型態為TEXT
$password = $_POST["password"];//在html的型態為password
$create_user"(SQL語法) ";
$mysql = mysql_query($create_user,$link);//不確定是不是可以這樣用
//當時翻書找不到執行這種SQL的函式= ="
if($data == 1)
echo"success!";
else
echo"fail!";
mysql_free_result($mysql);
mysql_close($link);
?>
願PTT 的PHP神解惑 感恩<(_ _)>
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 122.125.82.99
→
09/22 22:40, , 1F
09/22 22:40, 1F
→
09/23 09:24, , 2F
09/23 09:24, 2F
※ 編輯: skywillnosky 來自: 203.64.183.230 (09/23 09:45)
→
09/23 09:58, , 3F
09/23 09:58, 3F
→
09/23 09:58, , 4F
09/23 09:58, 4F
→
09/23 10:04, , 5F
09/23 10:04, 5F
→
09/23 10:11, , 6F
09/23 10:11, 6F
→
09/23 10:13, , 7F
09/23 10:13, 7F
→
09/23 10:14, , 8F
09/23 10:14, 8F
→
09/23 10:14, , 9F
09/23 10:14, 9F
→
09/23 10:14, , 10F
09/23 10:14, 10F
→
09/23 10:19, , 11F
09/23 10:19, 11F
→
09/23 10:20, , 12F
09/23 10:20, 12F
→
09/23 10:22, , 13F
09/23 10:22, 13F
→
09/23 10:23, , 14F
09/23 10:23, 14F
→
09/23 10:25, , 15F
09/23 10:25, 15F
→
09/23 10:28, , 16F
09/23 10:28, 16F
→
09/23 10:29, , 17F
09/23 10:29, 17F
→
09/23 10:31, , 18F
09/23 10:31, 18F