A. 由網頁提交的表單提交寫入資料庫 php源代碼該怎麼寫
把下面的代碼保存為post.php
<?
$conn = mysql_connect("localhost","11111","22222");
$action = $_POST['action'];
if($action == 'send'){
$username = $_POST['username'];
$password = $_POST['password'];
mysql_select_db("333333",$conn);
$sql = "INSERT INTO player (username,password) VALUES ('$username','$password')";
$result = mysql_query($sql,$conn);
}
?>
<html>
<body>
<form method="post" action="post.php">
<input type="text" name="username">
<input type="text" name="password">
<input type="hidden" name="action" value="send">
<input type="submit" name="Submit" value="提交">
</form>
</body>
</html>
B. PHP怎麼把表單提交到本頁
PHP把表單提交到本頁,這個的話,我們是通過<form action="提交的文件名">來實現的,還有一個傳值的方式,post或者是get可以通過METHOD來實現的,這里我寫一段代碼:
<html>
<head></head>
<body>
<form action='文件名' method="post">
姓名<input type='text' value="">
密碼<input type='text' value="">
email<input type='text' value="">
</form>
</body>
</html>
C. PHP 表單 提交數據到mysql
PHP 提交表單,然後保存資料庫示例:
1.sql腳本:
createdatabasecompany;
usecompany;
createtableemployee(
idint(11)notnullprimarykeyauto_increment,
emp_namevarchar(20)notnull,
emp_novarchar(30)notnull,
emp_jobvarchar(50)
);
2.index.php代碼:
<?php
header("Content-type:text/html;charset=utf-8;");
//判斷是否提交表單
if(isset($_POST['btn'])){
//連接資料庫
$conn=mysql_connect("localhost","root","root");
if(!$conn){
die("資料庫連接錯誤!".mysql_error());
}
mysql_select_db("company");
mysql_query("setnamesutf8");
//獲取表單提交元素
$emp_name=$_POST['emp_name'];
$emp_no=$_POST['emp_no'];
$emp_job=$_POST['emp_job'];
//驗證表單元素,然後入庫操作
if($emp_name&&$emp_no&&$emp_job){
$sql="insertintoemployee
(emp_name,emp_no,emp_job)
values
('{$emp_name}','{$emp_no}','{$emp_job}')
";
$int=mysql_query($sql);
$suc_msg="<fontcolor='green'>數據插入成功!</font><ahref='javascript:history.go(-1);'>返回</a>";
$err_msg="數據插入失敗";
exit($int?$suc_msg:$err_msg);
}else{
exit("提交數據全部為必填項!");
}
}
?>
<html>
<head>
<title>PHP表單提交示例</title>
<metahttp-equiv="content-type"content="text/html;charset=utf-8"/>
</head>
<body>
<formid="myform"action="<?phpecho$_SERVER['PHP_SELF']?>"method="post">
員工姓名:<inputname="emp_name"type="text"/><br/>
工號:<inputname="emp_no"type="text"/><br/>
工作職責:<inputname="emp_job"type="text"/><br/>
<inputname="btn"type="submit"value="提交表單"/><br/>
</form>
</body>
</html>
3.運行效果:
D. php表單提交到資料庫。請問如何寫r_save.php的代碼
<?php
$username = xxx; //資料庫用戶名
$password = xxx; //資料庫密碼
$con = mysql_connect("localhost",$username,$username);
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("my_db", $con);
mysql_query("INSERT INTO person (id, name, sex, phone, room_id, seat, date1, opinion)
VALUES ('$_POST[id]', '$_POST[name]', '$_POST[sex]', '$_POST[phone]', '$_POST[room_id]', '$_POST[seat]', ''$_POST[date1]', '$_POST[option]')");
mysql_close($con);
?>
E. PHP寫一個代碼 怎麼做一個提交表單
樓上的Javascript方法可行,但如果用戶關閉Javascript支持就不起作用了。補充PHP代碼
<?php
if(!empty($_POST['str'])) {
header("Location: http://www.abc.com/qq/".$_POST['str']."/sina");
}
?>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<input type="text" size="16" name="str" value="" /> <input type="submit" value="Submit" />
</form>
F. 用php語言編寫提交表單的代碼 急求 求高手解答
加密的方法是md5()加密
密碼+常量方式
define(ALL_PS,"php");
例如echo md5('admin'.ALL_PS);
然後把列印出來的密碼串插入資料庫
資料庫和表的結構就自己創建吧,很簡單的
下面是方法是讀取資料庫中的密碼,然後開始登陸的密碼再加密和資料庫中讀取的比較,如果比較結果相同,則登錄成功
public function Get_user_login($username, $password) {
$username= str_replace(" ","", $_POST[username]);
$sql="select * from register where `username` = '$username'";
$query=$this->query($sql);
$us=is_array($row=$this->fetch_array($query));
$ps = $us ? md5($password.ALL_PS) == $row[password] : FALSE;
if($ps) {
$_SESSION[uid]=$row[uid];
$_SESSION[user_shell]=md5($row[username].$row[password].ALL_PS);
echo"<script>alert('登錄成功 ');location.href='admin.php'</script>";
}else{
echo"<script>alert('密碼或用戶名錯誤');location.href='admin_index.php'</script>";
session_destroy();
}
}
G. PHP提交表單發送郵件的代碼!50分求!
載入這個類就好了
<?
set_time_limit(120);
class smtp
{
/* Public Variables */
var $smtp_port;
var $time_out;
var $host_name;
var $log_file;
var $relay_host;
var $debug;
var $auth;
var $user;
var $pass;
var $sender;
/* Private Variables */
var $sock;
/* Constractor */
function smtp($relay_host = "", $smtp_port = 25,$auth = false,$user,$pass,$sender)
{
$this->debug = FALSE;
$this->smtp_port = $smtp_port;
$this->relay_host = $relay_host;
$this->time_out = 30; //is used in fsockopen()
$this->auth = $auth;//auth
$this->user = $user;
$this->pass = $pass;
$this->sender = $sender;
$this->host_name = "localhost"; //is used in HELO command
$this->log_file = "";
$this->logs = ""; //記錄跟伺服器的交互過程
$this->sock = FALSE;
}
/* Main Function */
function sendmail($to, $from, $subject = "", $body = "", $mailtype, $cc = "", $bcc = "", $additional_headers = "")
{
$sent = TRUE;
$mail_from = $this->get_address($this->strip_comment($from));
$body = ereg_replace("(^|(\r\n))(\.)", "\1.\3", $body);
$header .= "MIME-Version:1.0\r\n";
if($mailtype=="HTML"){
$header .= "Content-Type:text/html\r\n";
}
$header .= "To: ".$to."\r\n";
if ($cc != "") {
$header .= "Cc: ".$cc."\r\n";
}
//$header .= "From: $from<".$from.">\r\n";
$header .= "From: ".$from."\r\n";
$header .= "Subject: ".$subject."\r\n";
$header .= $additional_headers;
$header .= "Date: ".date("r")."\r\n";
$header .= "X-Mailer: 72e.net (PHP/".phpversion().")\r\n";
list($msec, $sec) = explode(" ", microtime());
$header .= "Message-ID: <".date("YmdHis", $sec).".".($msec*1000000).".".$mail_from.">\r\n";
$TO = explode(",", $this->strip_comment($to));
if ($cc != "") {
$TO = array_merge($TO, explode(",", $this->strip_comment($cc)));
}
if ($bcc != "") {
$TO = array_merge($TO, explode(",", $this->strip_comment($bcc)));
}
foreach ($TO as $rcpt_to) {
$rcpt_to = $this->get_address($rcpt_to);
if (!$this->smtp_sockopen($rcpt_to)) {
$this->log_write("Error: Cannot send email to ".$rcpt_to."\n");
$sent = FALSE;
continue;
}
if ($this->smtp_send($this->host_name, $mail_from, $rcpt_to, $header, $body)) {
$this->log_write("E-mail has been sent to <".$rcpt_to.">\n");
} else {
$this->log_write("Error: Cannot send email to <".$rcpt_to.">\n");
$sent = FALSE;
}
fclose($this->sock);
$this->log_write("Disconnected from remote host\n");
}
return $sent;
}
/* Private Functions */
function smtp_send($helo, $from, $to, $header, $body = "")
{
if (!$this->smtp_putcmd("HELO", $helo)) {
return $this->smtp_error("sending HELO command");
}
#auth
if($this->auth){
if (!$this->smtp_putcmd("AUTH LOGIN", base64_encode($this->user))) {
return $this->smtp_error("sending AUTH command");
}
if (!$this->smtp_putcmd("", base64_encode($this->pass))) {
return $this->smtp_error("sending AUTH command");
}
}
#
//if (!$this->smtp_putcmd("MAIL", "FROM:".$from."")) {
if (!$this->smtp_putcmd("MAIL", "FROM:<".$this->sender.">")) {
return $this->smtp_error("sending MAIL FROM command");
}
if (!$this->smtp_putcmd("RCPT", "TO:<".$to.">")) {
return $this->smtp_error("sending RCPT TO command");
}
if (!$this->smtp_putcmd("DATA")) {
return $this->smtp_error("sending DATA command");
}
if (!$this->smtp_message($header, $body)) {
return $this->smtp_error("sending message");
}
if (!$this->smtp_eom()) {
return $this->smtp_error("sending <CR><LF>.<CR><LF> [EOM]");
}
if (!$this->smtp_putcmd("QUIT")) {
return $this->smtp_error("sending QUIT command");
}
return TRUE;
}
function smtp_sockopen($address)
{
if ($this->relay_host == "") {
return $this->smtp_sockopen_mx($address);
} else {
return $this->smtp_sockopen_relay();
}
}
function smtp_sockopen_relay()
{
$this->log_write("Trying to ".$this->relay_host.":".$this->smtp_port."\n");
$this->sock = @fsockopen($this->relay_host, $this->smtp_port, $errno, $errstr, $this->time_out);
if (!($this->sock && $this->smtp_ok())) {
$this->log_write("Error: Cannot connenct to relay host ".$this->relay_host."\n");
$this->log_write("Error: ".$errstr." (".$errno.")\n");
return FALSE;
}
$this->log_write("Connected to relay host ".$this->relay_host."\n");
return TRUE;
}
function smtp_sockopen_mx($address)
{
$domain = ereg_replace("^.+@([^@]+)$", "\1", $address);
if (!@getmxrr($domain, $MXHOSTS)) {
$this->log_write("Error: Cannot resolve MX \"".$domain."\"\n");
return FALSE;
}
foreach ($MXHOSTS as $host) {
$this->log_write("Trying to ".$host.":".$this->smtp_port."\n");
$this->sock = @fsockopen($host, $this->smtp_port, $errno, $errstr, $this->time_out);
if (!($this->sock && $this->smtp_ok())) {
$this->log_write("Warning: Cannot connect to mx host ".$host."\n");
$this->log_write("Error: ".$errstr." (".$errno.")\n");
continue;
}
$this->log_write("Connected to mx host ".$host."\n");
return TRUE;
}
$this->log_write("Error: Cannot connect to any mx hosts (".implode(", ", $MXHOSTS).")\n");
return FALSE;
}
function smtp_message($header, $body)
{
fputs($this->sock, $header."\r\n".$body);
$this->smtp_debug("> ".str_replace("\r\n", "\n"."> ", $header."\n> ".$body."\n> "));
return TRUE;
}
function smtp_eom()
{
fputs($this->sock, "\r\n.\r\n");
$this->smtp_debug(". [EOM]\n");
return $this->smtp_ok();
}
function smtp_ok()
{
$response = str_replace("\r\n", "", fgets($this->sock, 512));
//echo "response=".$response."\r\n";
$this->smtp_debug($response."\n");
//echo "ereg 23 ==".ereg("^[23]", $response)."\n";
if (!ereg("^[23]", $response)) {
//echo "@@@@@";
fputs($this->sock, "QUIT\r\n");
fgets($this->sock, 512);
$this->log_write("Error: Remote host returned \"".$response."\"\n");
return FALSE;
}
return TRUE;
}
function smtp_putcmd($cmd, $arg = "")
{
if ($arg != "") {
if($cmd=="") $cmd = $arg;
else $cmd = $cmd." ".$arg;
}
fputs($this->sock, $cmd."\r\n");
$this->smtp_debug("> ".$cmd."\n");
//echo "cmd=".$cmd."\r\n";
return $this->smtp_ok();
}
function smtp_error($string)
{
$this->log_write("Error: Error occurred while ".$string.".\n");
return FALSE;
}
function log_write($message)
{
$this->logs .= $message;
$this->smtp_debug($message);
if ($this->log_file == "") {
return TRUE;
}
$message = date("M d H:i:s ").get_current_user()."[".getmypid()."]: ".$message;
if (!@file_exists($this->log_file) || !($fp = @fopen($this->log_file, "a"))) {
$this->smtp_debug("Warning: Cannot open log file \"".$this->log_file."\"\n");
return FALSE;
}
flock($fp, LOCK_EX);
fputs($fp, $message);
fclose($fp);
return TRUE;
}
function strip_comment($address)
{
$comment = "\([^()]*\)";
while (ereg($comment, $address)) {
$address = ereg_replace($comment, "", $address);
}
return $address;
}
function get_address($address)
{
$address = ereg_replace("([ \t\r\n])+", "", $address);
$address = ereg_replace("^.*<(.+)>.*$", "\1", $address);
return $address;
}
function smtp_debug($message)
{
if ($this->debug) {
echo $message;
}
}
} // end class
?>
<?
$smtpserver = "smtp.126.com"; //smpt伺服器,網路可以搜索到
$prot=25; //埠一般都是25,除極個別的除外
$smtpuser = "您的郵箱地址"; //您登錄smtp伺服器的用戶名
$smtppwd = "您的密碼"; //您登錄smtp伺服器的密碼
$mailtype = "HTML"; //郵件的類型,可選值是 TXT 或 HTML ,TXT 表示是純文本的郵件,HTML 表示是 html格式的郵件
$sender = "發件人地址"; //發件人,一般要與您登錄smtp伺服器的用戶名($smtpuser)相同,否則可能會因為smtp伺服器的設置導致發送失敗
$smtp = new smtp($smtpserver,$prot,true,$smtpuser,$smtppwd,$sender);
//$smtp->debug = true; //是否開啟調試,只在測試程序時使用,正式使用時請將此行注釋
$to = "[email protected]";//收件人
$subject = "你好";
$body = "<h1>這是一個用 <font color='red'><b> php socket </b></font> 發郵件的測試。
支持SMTP認證!</h1>
";
$send=$smtp->sendmail($to,$sender,$subject,$body,$mailtype);
if($send==1){
echo "郵件發送成功";
}else{
echo "郵件發送失敗<br>";
echo "原因:".$this->smtp->logs;
}
?>
H. 如何用PHP實現表單提交
創建go.php,代碼如下
<?php
@$username = $_POST['name'];
@$usermessage = $_POST['message'];
if(!empty($username) || !empty($usermessage)){
echo "您的姓名:".$username.",您的留言內容:".$usermessage;
}else{
echo '<form action="go.php" method="post">
您的姓名:<input type="text" name="name"><br><br>
留言內容:<input type="text" name="message">
<button>提交</button>
</form>';
案例截圖:
I. PHP表單提交後出現的是自己的PHP代碼
像你表單應該是HTML的吧,提交給PHP做處理,像顯示代碼的話,好像APA沒處理啊?你應該在「瀏覽器」中打開表單,就應該可以了,還有,你可以加入,if語句,如果登陸成功,顯示登陸成功,否則,顯示失敗。我能答的就這么多了!答對的話,給分吧!!
J. php表單怎樣提交到當前頁面,並用$_POST獲取其值
<?php
$username=$_POST['username'];
?>
<form action="" ><input type="text" name="username"><input type="submit" name="submit" value="提交"></form>
form的action屬性留空的話就直接提交到當前頁面了 後台直接$_POST獲取前台傳過來的表單域啊