iam成功编辑时数据库没有改变[PHP MySQL] [英] Database not changed when iam success edit [PHP MySQL]
问题描述
Hello codeproject成员，我开始使用PHP开始动态Web编程。
在这种情况下我正在使用PHP MySQL学习CRUD但是我在编辑数据库时遇到了一些问题。需要一些帮助和建议。谢谢
这是我的php代码，名为adminedit.php
，当我在数据库中看到，数据没有改变..
<？php 包括 base.php;
？>
< ！DOCTYPE HTML >
< html >
< head >
< title > 表单编辑数据< / title >
< / head >
< body >
< table border = 1 >
< tr >
< td align = center > 表单编辑数据< / td >
< / tr >
<跨度 class =code-keyword>< tr > < td >
< 表格 >
< 表格 方法 = 发布 action = admineditprocess。 php >
<？ php
$ id = ereg_replace（' [^ 0 -9]'，' '，$ _GET [' id']）;
$ result = mysql_query（ SELECT *来自UserID = $ id）的用户;
while（$ row = mysql_fetch_array（$ result））
{
$ nama = $ row [' 用户名'];
$ pass = $ row [' 密码];
$ email = $ row [' EmailAddress ];
$ privilege = $ row [' 特权];
}
？>
< 输入 type = hidden 名称 = id 值 = <？echo $ id;？ > >
< tr >
< td > 用户名< / td >
< td >
< 输入 type = text name = 用户名 size = 80 value = < ;？php echo $ nama;？> >
< / td >
< / tr >
< tr >
< ; td > 密码< / td >
< ; td >
< 输入 type = text name = password size = 80 value = <？php echo $ pass;？> >
< / td >
< / tr >
< tr >
< td > 电子邮件地址< / td >
< td >
< input 类型 = text 名称 = email size = 80 value = <？php echo $ email;？> >
< / td >
< / tr >
< tr >
< td > 特权< / td >
< td >
< 输入 type = text name = privilege size = 80 value = <？php echo $ privilege？> >
< / td >
< / tr >
< tr >
< td align = left >
< 输入 类型 = 提交 名称 = 提交值 value < span class =code-keyword> = 修改 >
< / td >
< / tr >
< / form >
< / table > ;
< / td > < / tr > ;
< / table >
< / body >
< / html < span class =code-keyword>> Hello codeproject member, iam beginning starting dynamic web programming using PHP. 这篇关于iam成功编辑时数据库没有改变[PHP MySQL]的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
这是admineditprocess.php
<前lang =PHP> <？php
包括 base.php;
$ id = $ _POST [ id ];
$ name = $ _POST [ username ];
$ password = $ _POST [ password ];
$ emailaddress = $ _POST [ email ];
$ privilege = $ _POST [ 特权];
$ order = UPDATE users
SET Username ='$ name'，
Password ='$ password'，
EmailAddress ='$ emailaddress'，
privilege ='$ privilege'
WHERE
UserID ='$ id';
mysql_query（$ order）;
header（ location：adminpanel.php）;
？> id
= ereg_replace（' [^ 0-9]'， ' '，
_GET [' < span class =code-string> id'
]）;
result
= mysql_query（ SELECT * FROM UserID =
in this case i am learning CRUD using PHP MySQL but iam get some problem on editing database. Need some help and suggestion. thank you
this is my php code named as adminedit.php
when i saw in the database, data not changed..
<?php include "base.php";
?>
<!DOCTYPE HTML>
<html>
<head>
<title>Form Edit Data</title>
</head>
<body>
<table border=1>
<tr>
<td align=center>Form Edit Data</td>
</tr>
<tr><td>
<table>
<form method="post" action="admineditprocess.php">
<?php
$id = ereg_replace('[^0-9]', '', $_GET['id']);
$result = mysql_query("SELECT * FROM users where UserID=$id");
while($row = mysql_fetch_array($result))
{
$nama = $row['Username'];
$pass = $row['Password'];
$email = $row['EmailAddress'];
$privilege = $row['privilege'];
}
?>
<input type="hidden" name="id" value="<? echo $id;?>">
<tr>
<td>Username</td>
<td>
<input type="text" name="username" size="80" value="<?php echo $nama;?>">
</td>
</tr>
<tr>
<td>Password</td>
<td>
<input type="text" name="password" size="80" value="<?php echo $pass;?>">
</td>
</tr>
<tr>
<td>Email Address</td>
<td>
<input type="text" name="email" size="80" value="<?php echo $email;?>">
</td>
</tr>
<tr>
<td>Privilege</td>
<td>
<input type="text" name="privilege" size="80" value="<?php echo $privilege?>">
</td>
</tr>
<tr>
<td align="left">
<input type="submit" name="submit value" value="Edit">
</td>
</tr>
</form>
</table>
</td></tr>
</table>
</body>
</html>
this is admineditprocess.php
<?php
include "base.php";
$id = $_POST["id"];
$name = $_POST["username"];
$password = $_POST["password"];
$emailaddress = $_POST["email"];
$privilege = $_POST["privilege"];
$order = "UPDATE users
SET Username='$name',
Password='$password',
EmailAddress='$emailaddress',
privilege='$privilege'
WHERE
UserID='$id'";
mysql_query($order);
header("location:adminpanel.php");
?>
id
= ereg_replace('[^0-9]', '',_GET['id']);
result
= mysql_query("SELECT * FROM users where UserID=
