Papa Kuhikuhi ʻatikala
Pehea e hana ai i kahi waihona ʻikepili ma MySQL ? Nā kauoha/nā ʻōlelo/syntax no ka hana ʻana i kahi waihona ʻikepili MySQL.
Hana ʻo MySQL i ka waihona
E hana i kahi waihona me ka mysqladmin
Me kahi mea hoʻohana maʻamau, pono paha ʻoe i nā pono kikoʻī e hana a holoi paha i nā waihona MySQL.
No laila, hoʻohana mākou i ka mea hoʻohana kumu e komo ai ma ʻaneʻi. ʻO ka mea hoʻohana kumu ka mana kiʻekiʻe loa a hiki ke hoʻohana i ke kauoha mysql mysqladmin e hana i kahi waihona.
laʻana
Hōʻike wale kēia kauoha i ke kaʻina o ka hana ʻana i kahi waihona i kapa ʻia ʻo chenweiliang:
[root@host]# mysqladmin -u root -p create chenweiliang Enter password:******
Ma hope o ka hoʻokō pono ʻia ʻana o ke kauoha i luna, e hana ʻia ka MySQL database chenweiliang.
E hana i ka waihona me ka PHP script
Hoʻohana ʻo PHP i ka hana mysqli_query e hana a holoi paha i nā waihona MySQL.
Loaʻa i ka hana ʻelua mau ʻāpana a hoʻihoʻi i ka TRUE inā kūleʻa ka hoʻokō ʻana, inā ʻaʻole e hoʻi mai FALSE.
ʻōlelo ʻōlelo
mysqli_query(connection,query,resultmode);
| hāmeʻa | ho'ākāka |
|---|---|
| pili ana | Pono.Hōʻike i ka pilina MySQL e hoʻohana. |
| nīnau hulina | Pono, kuhikuhi i ke kaula nīnau. |
| ʻano hopena | Koho.he mau.Hiki ke loaʻa kekahi o kēia mau waiwai:
|
laʻana
Hōʻike kēia hiʻohiʻona i ka hoʻohana ʻana iā PHP e hana i kahi waihona:
hana waihona
<?
php
$dbhost = 'localhost:3306'; // mysql服务器主机地址
$dbuser = 'root'; // mysql用户名
$dbpass = '123456'; // mysql用户名密码
$conn = mysqli_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
die('连接错误: ' . mysqli_error($conn));
}
echo '连接成功
';
$sql = 'CREATE DATABASE chenweiliang';
$retval = mysqli_query($conn,$sql );
if(! $retval )
{
die('创建数据库失败: ' . mysqli_error($conn));
}
echo "数据库 chenweiliang 创建成功\n";
mysqli_close($conn);
?>
Ma hope o ka hoʻokō pono ʻana, e hoʻihoʻi ʻia nā hopena aʻe:
ua holomua ka pilina
Ua hana maikaʻi ʻia ka waihona chenweiliang
Me ka manaʻolana, e kōkua ka ʻatikala "Pehea e hana ai i kahi waihona ʻikepili ma MySQL? Nā Kauoha/Nā ʻŌlelo/Syntax no ka hana ʻana i kahi waihona ʻikepili MySQL" i kaʻana like ʻia ma ka blog a Chen Weiliang ( https://www.chenweiliang.com/ ) iā ʻoe.
E ʻoluʻolu e kaʻana like i ka loulou o kēia ʻatikala: https://www.chenweiliang.com/cwl-459.html
