Home Backend Development PHP Tutorial PHP本地修改测试OK,到服务器上就不行了,哪位高手能帮帮小弟我

PHP本地修改测试OK,到服务器上就不行了,哪位高手能帮帮小弟我

Jun 13, 2016 am 10:25 AM
net post quot user

PHP本地修改测试OK,到服务器上就不行了,谁能帮帮我?
本地测试都是可以的,就是到服务器上就不行了,接收值和连接都没有问题。以下是写入数据库的代码,感觉是它出错,但是找不到错误原因,请大家帮忙看看,谢谢了
----------分割线----------------

require_once("../conn.inc.php"); //包含数据库连接文件
//接收表单值
$netsId=$_GET['id'];
//if($netsId == NULL){
//$netsId=$_GET['id'];
//}else
if($_GET['id'] == NULL){
echo '没有修改信息!';
}
//echo $netsId;
$user_name=$_POST["user_name"];
$user_psw=$_POST["user_psw"];
$user_ip=$_POST["user_ip"];
$net_name=$_POST["net_name"];
echo $net_name;
$net_url=$_POST["net_url"];
$net_type=$_POST["net_type"];
$Province=$_POST["Province"];
$City=$_POST['City'];
$net_content=$_POST["net_content"];
//预定义变量
$net_num=$_POST["net_num"];
$net_in=$_POST["net_in"];
$net_out=$_POST["net_out"];
$net_ok=$_POST["net_ok"];
$net_recom=$_POST["net_recom"];

//系统时间差8小时问题
date_default_timezone_set('Asia/Chongqing'); 
$now = getdate(time()); 
$cur_wday=$now['wday'];
$date = date("Y-m-d H:i:s $cweekday[$cur_wday]"); 
$net_submit_time = date("Y-m-d H:i:s"); 
$last_time = $_POST["last_time"]; 
if($City == NULL)
{
$City = $_POST['citydefault'];

}

//输入操作语句
$sql = "UPDATE nets SET user_name = '$user_name',user_psw = '$user_psw',user_ip = '$user_ip',net_name = '$net_name',net_url = '$net_url',net_type = '$net_type',Province = '$Province',City = '$City',net_content = '$net_content',net_num = $net_num,net_in = $net_in,net_out = $net_out,net_ok = $net_ok,net_recom = $net_recom,net_submit_time = '$net_submit_time',last_time = '$last_time' where id = $netsId"; 

mysql_query($sql); //传递操作语句至mysql数据库
echo "网站修改成功!


";
echo '您还可以返回首页 或者 ';
echo '点击返回';
//echo '修改的ID号为:'.$netsId.'';

?>

------解决方案--------------------
不检查函数返回值?
------解决方案--------------------
把错误信息发上来啊。
------解决方案--------------------
探讨

把错误信息发上来啊。

------解决方案--------------------
探讨

引用:
引用:

把错误信息发上来啊。


是的,把错误提示发上来.简单快捷


显示这句,不知道什么意思……
信息没有成功写入数据库!You have an error in your SQL syntax; check the manual that corresponds to your MySQL server ve……

------解决方案--------------------
将SQL 语句修改成这个样子 试看看
id={$netsId}";

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Roblox: Bubble Gum Simulator Infinity - How To Get And Use Royal Keys
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Nordhold: Fusion System, Explained
3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Hot Topics

Java Tutorial
1664
14
PHP Tutorial
1269
29
C# Tutorial
1249
24
How to use python requests post How to use python requests post Apr 29, 2023 pm 04:52 PM

Python simulates the browser sending post requests importrequests format request.postrequest.post(url,data,json,kwargs)#post request format request.get(url,params,kwargs)#Compared with get request, sending post request parameters are divided into forms ( x-www-form-urlencoded) json (application/json) data parameter supports dictionary format and string format. The dictionary format uses the json.dumps() method to convert the data into a legal json format string. This method requires

How does java initiate an http request and call the post and get interfaces? How does java initiate an http request and call the post and get interfaces? May 16, 2023 pm 07:53 PM

1. Java calls post interface 1. Use URLConnection or HttpURLConnection that comes with java. There is no need to download other jar packages. Call URLConnection. If the interface response code is modified by the server, the return message cannot be received. It can only be received when the response code is correct. to return publicstaticStringsendPost(Stringurl,Stringparam){OutputStreamWriterout=null;BufferedReaderin=null;StringBuilderresult=newSt

A brief analysis of the POST method in PHP with parameters to jump to the page A brief analysis of the POST method in PHP with parameters to jump to the page Mar 23, 2023 am 09:15 AM

For PHP developers, using POST to jump to pages with parameters is a basic skill. POST is a method of sending data in HTTP. It can submit data to the server through HTTP requests. The jump page processes and jumps the page on the server side. In actual development, we often need to use POST with parameters to jump to pages to achieve certain functional purposes.

How to solve the problem that NGINX reverse proxy returns 405 for POST request of HTML page How to solve the problem that NGINX reverse proxy returns 405 for POST request of HTML page May 22, 2023 pm 07:49 PM

实现如下:server{listen80;listen443ssl;server_namenirvana.test-a.gogen;ssl_certificate/etc/nginx/ssl/nirvana.test-a.gogen.crt;ssl_certificate_key/etc/nginx/ssl/nirvana.test-a.gogen.key;proxy_connect_timeout600;proxy_read_timeout600;proxy_send_timeout600;c

How to determine whether a post has been submitted in PHP How to determine whether a post has been submitted in PHP Mar 21, 2023 pm 07:12 PM

PHP is a widely used server-side scripting language that can be used to create interactive and dynamic web applications. When developing PHP applications, we usually need to submit user input data to the server for processing through forms. However, sometimes we need to determine whether form data has been submitted in PHP. This article will introduce how to make such a determination.

How to implement PHP to jump to the page and carry POST data How to implement PHP to jump to the page and carry POST data Mar 22, 2024 am 10:42 AM

PHP is a programming language widely used in website development, and page jumps and carrying POST data are common requirements in website development. This article will introduce how to implement PHP page jump and carry POST data, including specific code examples. In PHP, page jumps are generally implemented through the header function. If you need to carry POST data during the jump process, you can do it through the following steps: First, create a page containing a form, where the user fills in the information and clicks the submit button. Acti in the form

PHP code example: How to use POST to pass parameters and implement page jumps PHP code example: How to use POST to pass parameters and implement page jumps Mar 07, 2024 pm 01:45 PM

Title: PHP code example: How to use POST to pass parameters and implement page jumps In web development, it often involves the need to pass parameters through POST and process them on the server side to implement page jumps. PHP, as a popular server-side scripting language, provides a wealth of functions and syntax to achieve this purpose. The following will introduce how to use PHP to implement this function through a practical example. First, we need to prepare two pages, one to receive POST requests and process parameters

Fix 0x800713ec.NET Framework error code Fix 0x800713ec.NET Framework error code Mar 07, 2024 am 10:07 AM

If you encounter the .NET Framework error 0x800713ec when installing a program in Windows 11/10, there are some methods you can take to solve the problem. This error is usually caused by not having the correct .NET Framework version, but there can be other causes. Here, we explore some common root causes to help you identify your issue and resolve it as quickly as possible. The entire error message looks like this: One or more issues caused the installation to fail. Please resolve the issue and try the installation again. See the log file for details. 0x800713ec Fix 0x800713ec.NET Framework Error Code To fix 0x800713ec.NET Framework error code, follow the solutions below

See all articles