PHP代码没有更新MySQL表 [英] PHP code not updating MySQL table

问题描述

我无法更新表格。逻辑似乎很简单，但我无法让它发挥作用。该表名为test。列名是密码，姓名，地址，城市，州，邮编和电子邮件。


首先，您必须登录我的网站（名称和密码）。这是一个密码保护页面。下一个php页面包含将该数据插入名为test的mysql表的指令。这时我还插入了？假数据？通过电子邮件列进入地址（只是为了给我稍后更新的内容）。


[PHP] $ passcode = $ _POST [密码];

$ name = $ _POST [''name''];


mysql_query（" INSERT INTO test

（密码，姓名，地址，城市，州， zip，email）VALUES（''$ passcode''，''name''，''''，''b''，''c''，'d''，''e''） ）或死（mysql_error（））;


这个页面还有另一个表格来填写变量$ address，$ city，$ state，$ zip，$ email。[/ PHP]

下一页包含了谢谢。以下是将第2页的数据插入与第1页（测试）相同的表中的说明。我试图通过使用以下代码让它进入同一行。


[PHP]

$ address = $ _POST [''地址''];

$ city = $ _POST [''city''];

$ state = $ _POST [''state''];

$ zip = $ _POST [''zip''];

$ email = $ _POST [''email''];


mysql_query（" UPDATE test SET address =''$ address''，city =''$ city''，state =''$ state''，zip =''$ zip''，email =''$ email ''WHERE passcode =''$ passcode''"）;

或die（mysql_error（））; [/ PHP]

这一切都适用于更新WHERE代码。我无法让变量起作用。


我是一个新手，并使用在线教程自学。感谢您给我的任何帮助。

I am having trouble updating a table. The logic seems so simple but I just can?t get it to work. The table is named test. The column names are passcode, name, address, city, state, zip and email.

First you have to sign into my site (name and passcode). This is a password protection page. The next php page holds the instructions to insert that data into the mysql table named test. At this time I am also inserting ?fake data? into the address through email columns (just to give me something to update later).

[PHP]$passcode = $_POST[passcode];
$name = $_POST[''name''];

mysql_query("INSERT INTO test
(passcode, name, address, city, state, zip, email) VALUES(''$passcode'',''$name'',''a'',''b'',''c'',''d'',''e'') ") or die(mysql_error());

This page also has another form to fill out with the variables $address, $city, $state, $zip, $email.[/PHP]
The next page contains a thank you. Here are the instructions to insert the data from page 2 into the same table as page 1 (test). I?m trying to get it to go into the same row by using the following code.

[PHP]
$address = $_POST[''address''];
$city = $_POST[''city''];
$state = $_POST[''state''];
$zip = $_POST[''zip''];
$email = $_POST[''email''];

mysql_query("UPDATE test SET address=''$address'', city=''$city'', state=''$state'', zip=''$zip'', email=''$email'' WHERE passcode=''$passcode'' ");
or die(mysql_error()); [/PHP]
It all works up to the update WHERE code. I can''t get the variable to work.

I?m a newbie and taught myself using online tutorials. Thanks for any help you can give me.

推荐答案

passcode =

passcode =

_POST [密码];

_POST[passcode];

name =

这篇关于PHP代码没有更新MySQL表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！