標籤：
<?php /******************************** *** 功能：選擇指定的MySQL資料庫 *********************************/?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>選擇資料庫</title></head><body background="image/bg.JPG"><table align="center"><tr><td><img src="image/banner.jpg"></td></tr><tr><td background="image/head.JPG" align="center"><form action="" method="post"> <select name="select"> <option value="1" selected="selected">請選擇資料庫</option> <!--串連資料庫--> <?php $conn = mysql_connect("localhost","root",""); $rs = mysql_query("show databases");//查詢操作 //將資料庫名稱以下拉式清單的方式顯示 while($rst = mysql_fetch_array($rs)){ $i = 0; echo "<option value = ".$rst[$i].">".$rst[$i]."</option>"; $i ++; }?> </select> <input type="submit" name="sub" value="確定" /></form></td></tr><tr><td background="image/head.JPG"> <?php if(!empty($_POST["sub"])){ if($_POST["select"] == "1"){ echo "<script>alert(‘請選擇資料庫‘);</script>"; }else{ if(mysql_select_db($_POST["select"],$conn)){ echo "<script>alert(‘已經串連到指定的資料庫‘);</script>"; mysql_close(); }else{ echo "<script>alert(‘出錯了‘);</script>"; } } } ?></td></tr></table></body></html>
選擇指定的MySQL資料庫
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
