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

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
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
How to make PHP applications fasterHow to make PHP applications fasterMay 12, 2025 am 12:12 AM

TomakePHPapplicationsfaster,followthesesteps:1)UseOpcodeCachinglikeOPcachetostoreprecompiledscriptbytecode.2)MinimizeDatabaseQueriesbyusingquerycachingandefficientindexing.3)LeveragePHP7 Featuresforbettercodeefficiency.4)ImplementCachingStrategiessuc

PHP Performance Optimization Checklist: Improve Speed NowPHP Performance Optimization Checklist: Improve Speed NowMay 12, 2025 am 12:07 AM

ToimprovePHPapplicationspeed,followthesesteps:1)EnableopcodecachingwithAPCutoreducescriptexecutiontime.2)ImplementdatabasequerycachingusingPDOtominimizedatabasehits.3)UseHTTP/2tomultiplexrequestsandreduceconnectionoverhead.4)Limitsessionusagebyclosin

PHP Dependency Injection: Improve Code TestabilityPHP Dependency Injection: Improve Code TestabilityMay 12, 2025 am 12:03 AM

Dependency injection (DI) significantly improves the testability of PHP code by explicitly transitive dependencies. 1) DI decoupling classes and specific implementations make testing and maintenance more flexible. 2) Among the three types, the constructor injects explicit expression dependencies to keep the state consistent. 3) Use DI containers to manage complex dependencies to improve code quality and development efficiency.

PHP Performance Optimization: Database Query OptimizationPHP Performance Optimization: Database Query OptimizationMay 12, 2025 am 12:02 AM

DatabasequeryoptimizationinPHPinvolvesseveralstrategiestoenhanceperformance.1)Selectonlynecessarycolumnstoreducedatatransfer.2)Useindexingtospeedupdataretrieval.3)Implementquerycachingtostoreresultsoffrequentqueries.4)Utilizepreparedstatementsforeffi

Simple Guide: Sending Email with PHP ScriptSimple Guide: Sending Email with PHP ScriptMay 12, 2025 am 12:02 AM

PHPisusedforsendingemailsduetoitsbuilt-inmail()functionandsupportivelibrarieslikePHPMailerandSwiftMailer.1)Usethemail()functionforbasicemails,butithaslimitations.2)EmployPHPMailerforadvancedfeatureslikeHTMLemailsandattachments.3)Improvedeliverability

PHP Performance: Identifying and Fixing BottlenecksPHP Performance: Identifying and Fixing BottlenecksMay 11, 2025 am 12:13 AM

PHP performance bottlenecks can be solved through the following steps: 1) Use Xdebug or Blackfire for performance analysis to find out the problem; 2) Optimize database queries and use caches, such as APCu; 3) Use efficient functions such as array_filter to optimize array operations; 4) Configure OPcache for bytecode cache; 5) Optimize the front-end, such as reducing HTTP requests and optimizing pictures; 6) Continuously monitor and optimize performance. Through these methods, the performance of PHP applications can be significantly improved.

Dependency Injection for PHP: a quick summaryDependency Injection for PHP: a quick summaryMay 11, 2025 am 12:09 AM

DependencyInjection(DI)inPHPisadesignpatternthatmanagesandreducesclassdependencies,enhancingcodemodularity,testability,andmaintainability.Itallowspassingdependencieslikedatabaseconnectionstoclassesasparameters,facilitatingeasiertestingandscalability.

Increase PHP Performance: Caching Strategies & TechniquesIncrease PHP Performance: Caching Strategies & TechniquesMay 11, 2025 am 12:08 AM

CachingimprovesPHPperformancebystoringresultsofcomputationsorqueriesforquickretrieval,reducingserverloadandenhancingresponsetimes.Effectivestrategiesinclude:1)Opcodecaching,whichstorescompiledPHPscriptsinmemorytoskipcompilation;2)DatacachingusingMemc

See all articles

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

Hot Tools

SublimeText3 English version

SublimeText3 English version

Recommended: Win version, supports code prompts!

Safe Exam Browser

Safe Exam Browser

Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.

SecLists

SecLists

SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

PhpStorm Mac version

PhpStorm Mac version

The latest (2018.2.1) professional PHP integrated development tool