$_POST
抓取網頁上輸入的資料,不同於 $_GET
抓取網址問號後的變數。
[root@kvm3 ~]# vim /var/www/html/insertentry.php [root@kvm3 ~]# cat /var/www/html/insertentry.php <html> <head> <title>Add New Record in MariaDB Database</title> </head> <body> <?php if(isset($_POST['add'])) { $dbhost = 'localhost:3306'; $dbuser = 'root'; $dbpass = '123qwe'; $conn = mysqli_connect($dbhost, $dbuser, $dbpass) or die(mysqli_connect_error().PHP_EOL); $title = $_POST['title']; $author = $_POST['author']; $submission_date = $_POST['submission_date']; mysqli_select_db( $conn, 'dywphp' ) or die('Error: '.mysqli_error($conn).PHP_EOL); $sql = "insert into tblphp (title,author,submission_date)". "values ('$title','$author','$submission_date')"; mysqli_query( $conn, $sql ) or die('Error: '.mysqli_error($conn).PHP_EOL); mysqli_close($conn); } else { ?> <form method="post" action="<?php $_PHP_SELF ?>"> <table width="600" border="0" cellspacing="1" cellpadding="2"> <tr> <td width="250">Dywphp Title</td> <td> <input name="title" type="text" id="title"> </td> </tr> <tr> <td width="250">Dywphp Author</td> <td> <input name="author" type="text" id="author"> </td> </tr> <tr> <td width="250">Submission Date [yyyy-mm-dd]</td> <td> <input name="submission_date" type="text" id="submission_date"> </td> </tr> <tr> <td width="250"> </td> <td> </td> </tr> <tr> <td width="250"> </td> <td> <input name="add" type="submit" id="add" value="Add Dywphp"> </td> </tr> </table> </form> <?php } ?> </body> </html>
http://kvm3.deyu.wang/insertentry.php
,輸入一筆紀錄。
tblphp
,並回傳寫入成功。