**我有这个文件
if(isset($_POST['action']) && $_POST['action']=="add")
{
$CompanyName=$_POST['add_CompanyName'];
$SupplierAddress=$_POST['add_SupplierAddress'];
$SupplierFax1=$_POST['add_SupplierFax1']; $pattern="/^[A-Z]{2}'d{4}'b/";
if(($CompanyName=="")||($SupplierAddress == "")||($SupplierFax1 == "")){
echo '{"status":"1"}';
exit;
}
else if( !preg_match($pattern,$SupplierFax1)){
echo '{"status":"2"}';
exit;
}else{
$test=mysqli_query($con,"INSERT INTO suppliers(CompanyName,SupplierAddress,SupplierFax1,AttachTitle) VALUES('$CompanyName','$SupplierAddress','$SupplierFax1')") or die ("data error!");
echo '{"status":"3"}';
exit;
}
}
elseif(isset($_POST['action'])&& $_POST['action']=="update")
{
$id=$_POST['edit_id'];
$CompanyName=$_POST['edit_CompanyName'];
$SupplierAddress=$_POST['edit_SupplierAddress'];
$SupplierFax1=$_POST['edit_SupplierFax1'];
$test = mysqli_query($con,"UPDATE suppliers SET CompanyName='$CompanyName',SupplierAddress='$SupplierAddress',SupplierFax1='$SupplierFax1', WHERE id='$id'") or die ("data error!");
echo '{"status":"3"}';
exit;
}
elseif(isset($_POST['action']) && $_POST['action']=="delete")
{
$id = $_POST['delete_id'];
$test = mysqli_query($con,"delete from suppliers where id='$id'");
if(mysqli_affected_rows($con) == 1){
echo '{"status":"1"}';
}else{
echo '{"status":"0"}';
}
exit;
}
我有这个形式
<form id="form1" method="post" enctype=”multipart/form-data>
<p><label>CompanyName</label><input type="text" id="add_CompanyName" name="add_CompanyName" /></p>
<p><label>SupplierAddress</label><input type="text" id="add_SupplierAddress" name="add_SupplierAddress" /> </p>
<p><label>SupplierFax1</label><input type="text" id="add_SupplierFax1" name="add_SupplierFax1" /></p>
<p><input type="submit" value="Add" /></p>
<input type="hidden" id="action" name="action" value="add" />
</form>
现在我想添加新的两个字段来上传文档,并显示它们在mysql中的路径与路径描述
我如何将它们添加到上面的代码中?我也使用ajax
$('#suppliers tr:even:not(#nav):not(#total)').addClass('even');
$('#suppliers tr:odd:not(#nav):not(#total)').addClass('odd')
$("form#form1").submit(function(){
var vId = $("input#edit_id").val();
var vCompanyName = $("input#edit_CompanyName").val();
var vSupplierAddress = $("input#edit_SupplierAddress").val();
var vSupplierFax1 = $("input#edit_SupplierFax1").val();
var myRegExp=/^[A-Z]{2}'d{4}'b/;
});
首先要做的是用所需的新数据字段修改表。例如:
ALTER TABLE supplies ADD COLUMN field2 varchar(32) NOT NULL;
要填充这一列,您必须将此添加到您的HTML:
<p><label>Field2</label><input type="text" id="add_field2" name="add_field2" /></p>
在PHP中捕获如下:
$field2 = $_POST['add_field2'];
并将插入查询更改为如下内容:
$test=mysqli_query($con,"INSERT INTO suppliers(CompanyName,SupplierAddress,SupplierFax1,AttachTitle, field2) VALUES('$CompanyName','$SupplierAddress','$SupplierFax1', '$field2')") or die ("data error!");
和你的更新查询:
$test = mysqli_query($con,"UPDATE suppliers SET CompanyName='$CompanyName',SupplierAddress='$SupplierAddress',SupplierFax1='$SupplierFax1',field2='$field2' WHERE id='$id'") or die ("data error!");
我还想指出你到以下网站:SQL注入
仔细阅读,以防止您的数据库被泄露,如果您的应用程序是开放给世界