PHP 連結 MySQL 資料庫功能表

(1)

PHP 連結 MySQL 資料庫　功能表

登入處理登入登出顯示紀錄新增紀錄儲存新增紀錄查看鍵值 - 設定取得鍵值顯示鍵值紀錄修改紀錄刪除紀錄選資料庫取得資料庫選資料表取得資料表 PHP 範例檔

(2)

功能表 menu.php

<html>

<head>

</head>

</body>

</html>

(3)

登入

dblogon.html

<html>

<head>

<title>PHP連結MySQL登錄表單</title>

</head>

<body>

<div align="center"><center><table border="0" width="80%"

cellspacing="1">

<tr>

<td width="89%"><input type="text" name="username"

size="10"></td>

</tr>

<tr>

<td width="89%"><input type="password" name="password"

size="10"></td>

</tr>

<tr>

<td width="89%"><input type="text" name="host" value="localhost"

size="60"></td>

</tr>

<tr>

<td width="11%" bgcolor="#C0C0C0"><strong>資料庫

</strong></td>

<td width="89%"><input type="text" name="dbname"

size="20"></td>

</tr>

<tr>

<td width="89%"><input type="submit" value="送出"

name="send">

(4)

</tr>

</table>

</center></div>

</form>

</body>

</html>

(5)

處理登入

<?php

session_start();

$username = $_POST['username'];

$password = $_POST['password'];

$host = $_POST['host'];

$dbname = $_POST['dbname'];

$_SESSION['username'] = $username;

$_SESSION['password'] = $password;

$_SESSION['host'] = $host;

$_SESSION['dbname'] = $dbname;

$link = mysql_pconnect($host,$username,$password) or die(mysql_error());

mysql_select_db($dbname) or die(mysql_error());

mysql_query("SET CHARSET big5");

if (mysql_errno()) {

header("HTTP/1.1 500 Internal Server Error");

echo $query.'\n';

echo mysql_error();

} else {

echo "Connect successfully...\n";

$url='http://localhost/menu.php';

echo '<META HTTP-EQUIV=REFRESH CONTENT="1; '.$url.'">';

}

?>

(6)

登出

logout.php

<?php

session_start();

session_destroy();

echo "Disconnected successfully...\n";

die();

?>

(7)

顯示紀錄

showrecord.php

<?php

session_start();

?>

<html>

<head>

<title>PHP連結MySQL 首頁</title>

</head>

<body>

客戶資料表<br>

<tr>

<td width="20%"> Email</td>

</tr>

<?php

//session_start();

$username = $_SESSION['username'];

$password = $_SESSION['password'];

$host = $_SESSION['host'];

$dbname =$_SESSION['dbname'];

$link = mysql_pconnect($host,$username,$password) or

(8)

die(mysql_error());

//mysql_query("use mysal",$link);

$result = mysql_query("SELECT * FROM cuinfo order by cu_no;");

if (!$result ) {

die("Could not open cuinfo: " . mysql_error());

}

$row = mysql_fetch_row($result);

while ($row != NULL) {

list($cu_no, $cu_na, $cu_tel, $cu_mtel, $cu_email,$cu_staf,$cu_adrs,

$cu_txno,$ml_type) = $row;

echo <<<EOD <tr>

<td width="20%"> $cu_emaill</td>

</tr>

EOD;

}

mysql_free_result($result);

?>

</table>

</center></div>

</body>

</html>

(9)

新增紀錄 addrecord.php

<html>

<head>

<title>PHP連結MySQL 新增紀錄</title>

</head>

<body>

客戶資料表<br>

cellspacing="1">

<tr>

<td width="85%"><input type="text" name="cu_no"

size="10"></td>

</tr><tr>

<td width="85%"><input type="text" name="cu_na"

size="20"></td>

</tr><tr>

<td width="85%"><input type="text" name="cu_tel"

size="12"></td>

</tr><tr>

<td width="85%"><input type="text" name="cu_mtel"

size="12"></td>

</tr><tr>

(10)

<td width="85%"><input type="text" name="cu_email"

size="40"></td>

</tr><tr>

<td width="85%"><input type="text" name="cu_staf"

size="12"></td>

</tr><tr>

<td width="85%"><input type="text" name="cu_adrs"

size="40"></td>

</tr><tr>

<td width="85%"><input type="text" name="cu_txno"

size="10"></td>

</tr><tr>

<td width="85%"><input type="text" name="ml_type"

size="4"></td>

</tr>

<tr>

</td>

</tr>

</table>

</center></div>

</form>

</body>

</html>

(11)

儲存新增紀錄 insertrec.php

<?php

session_start();

$keyvalue=$_SESSION['keyvalue'] ;

$no = $_POST['cu_no'];

$na = $_POST['cu_na'];

$tel = $_POST['cu_tel'];

$mtel = $_POST['cu_mtel'];

$ml = $_POST['cu_email'];

$st = $_POST['cu_staf'];

$ad = $_POST['cu_adrs'];

$tx = $_POST['cu_txno'];

$tp = $_POST['ml_type'];

$sql="Insert Into cuinfo Values ('" . $no . "','" . $na . "','" . $tel . "','" .

$mtel . "','" . $ml . "','" . $st . "','" . $ad . "','" . $tx . "','" . $tp . "')";

mysql_query($sql);

//echo $sql;

echo "Failed...";

} else

(12)

{

echo "Insert Successfully...";

}

?>

<form>

<input class="MyButton" type="button" value="回首頁"

onclick="window.location.href='http://localhost/menu.php'" />

<input class="MyButton" type="button" value="新增紀錄"

onclick="window.location.href='http://localhost/addrecord.php'" />

</form>

(13)

查看鍵值 - 設定 setkeyvalue.php

<?php

session_start();

$result = mysql_query("SELECT Distinct cu_no FROM cuinfo order by cu_no;");

if (!$result ) {

}

?>

<html>

<head>

<title>PHP連結MySQL 選取鍵值</title>

</head>

<body>

<tr>

(14)

<?php

list($cu_no) = $row;

// echo <<<EOD

echo "<Option Value='" . $cu_no . "'>" . $cu_no . "</Option>";

// EOD;

}

?>

</Select>

</td></tr>

<tr>

</td>

</tr>

</table>

</center></div>

</form>

</center></div>

</body>

</html>

(15)

取得鍵值

getkeyvalue.php

<?php

session_start();

$keyvalue = $_POST['selValue'];

$_SESSION['keyvalue'] = $keyvalue;

echo "選取鍵值 =". $keyvalue . "\n";

$url='http://localhost/showkeyrec.php';

?>

(16)

顯示鍵值紀錄 showkeyrec.php

<?php

session_start();

//session_start();

$sql ="SELECT * FROM cuinfo where cu_no='" . $keyvalue . "'";

$result = mysql_query($sql);

if (!$result ) {

}

if ($row != NULL) {

} else {

echo $sql . "\n";

echo "無對應紀錄...";

} ?>

<html>

<head>

(17)

<title>PHP連結MySQL 顯示鍵值紀錄</title>

</head>

<body>

客戶資料表<br>

<?php

list($cu_no, $cu_na, $cu_tel, $cu_mtel, $cu_email,$cu_staf,$cu_adrs,

$cu_txno,$ml_type) = $row;

?>

cellspacing="1">

<tr>

<td width="85%"><input type="text" name="cu_no" Value="<?

=$cu_no?>" size="10"></td>

</tr><tr>

<td width="85%"><input type="text" name="cu_na" Value="<?

=$cu_na?>" size="20"></td>

</tr><tr>

<td width="85%"><input type="text" name="cu_tel" Value="<?

=$cu_tel?>" size="12"></td>

</tr><tr>

<td width="85%"><input type="text" name="cu_mtel" Value="<?

=$cu_mtel?>" size="12"></td>

</tr><tr>

<td width="85%"><input type="text" name="cu_email" Value="<?

=$cu_email?>" size="40"></td>

</tr><tr>

(18)

<td width="85%"><input type="text" name="cu_staf" Value="<?

=$cu_staf?>" size="12"></td>

</tr><tr>

<td width="85%"><input type="text" name="cu_adrs" Value="<?

=$cu_adrs?>" size="40"></td>

</tr><tr>

<td width="85%"><input type="text" name="cu_txno" Value="<?

=$cu_txno?>" size="10"></td>

</tr><tr>

<td width="85%"><input type="text" name="ml_type" Value="<?

=$ml_type?>" size="4"></td>

</tr>

<tr>

</td>

<input class="MyButton" type="button" value="刪除"

onclick="window.location.href='http://localhost/deleterec.php'"

/>     

<input class="MyButton" type="button" value="重選鍵值"

onclick="window.location.href='http://localhost/setkeyvalue.php'" />

</td>

</tr>

</table>

</center></div>

</form>

(19)

</body>

</html>

(20)

修改紀錄 updaterec.php

<?php

session_start();

$no = $_POST['cu_no'];

$na = $_POST['cu_na'];

$tel = $_POST['cu_tel'];

$mtel = $_POST['cu_mtel'];

$ml = $_POST['cu_email'];

$st = $_POST['cu_staf'];

$ad = $_POST['cu_adrs'];

$tx = $_POST['cu_txno'];

$tp = $_POST['ml_type'];

$sql="Update cuinfo set cu_no='" . $no . "'";

$sql=$sql . ", cu_name='" . $na . "'";

$sql=$sql . ", cu_tel='" . $tel . "'";

$sql=$sql . ", cu_mtel='" . $mtel . "'";

$sql=$sql . ", cu_email='" . $ml . "'";

$sql=$sql . ", cu_staf='" . $st . "'";

$sql=$sql . ", cu_adrs='" . $ad . "'";

$sql=$sql . ", cu_txno='" . $tx . "'";

$sql=$sql . ", ml_type='" . $tp . "' where cu_no='" .

(21)

$_SESSION['keyvalue'] . "';";

mysql_query($sql);

//echo $sql;

echo "Failed...";

} else {

echo "Update Successfully...";

}

?>

<form>

</form>

(22)

刪除紀錄 deleterec.php

<?php

session_start();

//session_start();

$sql="Delete from cuinfo where cu_no='" . $_SESSION['keyvalue'] . "';";

mysql_query($sql);

echo "Delete Record Failed...";

} else {

echo "Delete Record Successfully...";

}

?>

<form>

</form>

(23)

選資料庫 selectdb.php

<?php

session_start();

$result = mysql_query("show databases;");

if (!$result ) {

die("Could not open Database: " . mysql_error());

}

?>

<html>

<head>

<title>PHP連結MySQL 選取資料庫</title>

</head>

<body>

<tr>

<td width="15%" bgcolor="#C0C0C0"><strong>資料庫

</strong></td>

(24)

<?php

list($db) = $row;

echo "<Option Value='" . $db . "'>" . $db . "</Option>";

}

?>

</Select>

</td></tr>

<tr>

</td>

</tr>

</table>

</center></div>

</form>

</center></div>

</body>

</html>

(25)

取得資料庫 getselectdb.php

<?php

session_start();

$_SESSION['dbname'] = $keyvalue;

echo "選取資料庫 = ". $keyvalue . "\n";

?>

<form>

</form>

(26)

選資料表 selecttbl.php

<?php

session_start();

$result = mysql_query("show tables;");

if (!$result ) {

die("Could not open Database: " . mysql_error());

}

?>

<html>

<head>

<title>PHP連結MySQL 選取資料表</title>

</head>

<body>

<tr>

<td width="15%" bgcolor="#C0C0C0"><strong>資料表

</strong></td>

(27)

<?php

list($tbl) = $row;

echo "<Option Value='" . $tbl . "'>" . $tbl . "</Option>";

}

?>

</Select>

</td></tr>

<tr>

</td>

</tr>

</table>

</center></div>

</form>

</center></div>

</body>

</html>

(28)

取得資料表 getselecttbl.php

<?php

session_start();

$_SESSION['tblname'] = $keyvalue;

echo "選取資料表 = ". $keyvalue . "\n";

?>

<form>

</form>

(29)

dblogon.php

<?php

session_start();

$username = $_POST['username'];

$password = $_POST['password'];

$host = $_POST['host'];

$dbname = $_POST['dbname'];

$_SESSION['username'] = $username;

$_SESSION['password'] = $password;

$_SESSION['host'] = $host;

$_SESSION['dbname'] = $dbname;

header("HTTP/1.1 500 Internal Server Error");

echo $query.'\n';

echo mysql_error();

} else {

echo "Connect successfully...\n";

$url='http://localhost/menu.php';

}

?>

PHP 連結 MySQL 資料庫 功能表

PHP 連結 MySQL 資料庫功能表