php7.0创建数据表 php怎么建立数据库mysql( 四 )


3.如上图,当点击"Outlook Express 信箱"菜单后,出现如下图示.
4.如上图,选择"是(Y)"按钮.找到备份的收件箱.DBX文件或者OUTLOOK EXPRESS 的原存储目录.选中:收件箱.dbx文件.
5.如上图,点击"打开"按钮.你能看到导入邮件的进度条.如下图所示:
6.全部导入成功以后,你能看到foxmail的收件箱下面多了一个文件夹:收件箱.Outlook ,这样原来在收件箱中因为容量超过2GB而看不到的邮件在FOXMAIL的这个文件夹中就都可以看到并打开了.但是由于foxmail本身的数据库限制.邮件将不能完全导入,会丢失20%的最新邮件.因此建议与我们联系,采用第一套方案.
恢复方案三.将outlook express 的目录备份了.存储起来.等待微软公司开发下一代操作系统,即XP的后一代版本.或者OUTLOOK EXPRESS 升级到7.0时.也许可以支持DBX最大数据库允许达到4GB或20GB.哪时就可以用OUTLOOK EXPRESS 的新版本来读取目前的收件箱中的邮件了.
看参考资料里,比较详细~~
php表单写入mysql数据库的代码!--表单文件,拷入index.php--
!DOCTYPE html
html
head
style
label{display:inline-block;width:100px;margin-bottom:10px;}
/style

titleAdd students/title
/head
body
!-- 数据库用mysqli 面向过程调用方法--
form method="post" action="write2db.php"
!--数据库用mysqli 面向过程调用方法
form method="post" action="write2db_sqlio.php"
--
!--数据库用PDO调用方法
form method="post" action="write2db_pdo.php"
--
labelFirst Name/label
input type="text" name="first_name" /
br /
labelLast Name/label
input type="text" name="last_name" /
br /
labeldepartment/label
input type="text" name="department" /
br /
labelEmail/label
input type="text" name="email" /
br /
input type="submit" value="https://www.04ip.com/post/Add students"
/form
/body
/html
------------------------------
?php
//拷贝命名为write2db.php,数据库用mysqli 面向过程调用方法
//print_r($_POST);
// create a variable
$first_name=$_POST['first_name'];
$last_name=$_POST['last_name'];
$department=$_POST['department'];
$email=$_POST['email'];
//调试用
echo "Your input: ";
echo $first_name;
echo 'br /';
echo $last_name;
echo 'br /';
echo $department;
echo 'br /';
echo $email;
echo 'br /';
$servername = "localhost";
//Your database username and password
//$username = "username";
//$password = "password";
$username = "tester";
$password = "testerPassword";
//your database name
$dbname = "test";
$tablename ="student";
// Create connection
$connect = mysqli_connect($servername, $username, $password, $dbname);
if (!$connect) {
die("Connection failed: " . mysqli_connect_error());
}
//Execute the query
$sql="INSERT INTO $tablename (first_name,last_name,department,email)
VALUES('$first_name','$last_name','$department','$email')";
if (mysqli_query($connect, $sql)) {
echo "Hooray! New record is inserted to database successfully. Please check database.";
} else {
echo "Error: " . $sql . "br /" . mysqli_error($connect);
}
mysqli_close($connect);
?
?php
//拷贝命名为write2db_sqlio.php,数据库用mysqli 面向对象调用方法
//print_r($_POST);
// create a variable
$first_name=$_POST['first_name'];
$last_name=$_POST['last_name'];
$department=$_POST['department'];
$email=$_POST['email'];
//调试用
echo "Your input: ";
echo $first_name;
echo 'br /';
echo $last_name;
echo 'br /';
echo $department;

推荐阅读