Table of Contents
回复讨论(解决方案)
Home Backend Development PHP Tutorial php前台与后台数据库交互时,获取不到值

php前台与后台数据库交互时,获取不到值

Jun 23, 2016 pm 02:26 PM


 
 
代码如下:  
  index.php  
 
 
ob_start();
session_start();
require_once("config.php");
?>  
 
 
 
 
简单投票系统  
 
 
 

if($_POST["submit"]){

if($_SESSION["vote"]==session_id())
{
?>  
 
exit();
}
$id=$_POST["itm"];
$sql="update vote set count=count+1 where id=$id";
if(mysql_query($sql))
{
$_SESSION["vote"]=session_id();
?>  
 
}
else
{
?>  
 
}
}
?>  
 
 
 

 

bgcolor="pink">  
 
 
 
$sql="select * from vote";
$rs=mysql_query($sql);
while($rows=mysql_fetch_assoc($rs))
{
?>  
 
    
 
}
?>  
 
 
 
 
$sql="select * from votetitle";
$rs=mysql_query($sql);
$row=mysql_fetch_assoc($rs);
echo $row["votetitle"];
?>
" />
 

/>
 
 
 
 
$sql="select sum(count) as 'total' from vote";
$rs=mysql_query($sql);
$rows=mysql_fetch_assoc($rs);
$sum=$rows["total"]; //得出总票数
$sql="select * from vote";
$rs=mysql_query($sql);
?>  

bgcolor="#C2C2C2">  
 
 
 
 
 
while($rows=mysql_fetch_assoc($rs))
{
?>  
 
 
 
 
 
}
?>  
  
项目 票数 百分比
 
$per=$rows["count"]/$sum;
$per=number_format($per,4);
?>  
 
%
 
  
 
  隐藏结果  
  
 
   
   
    
 
admin.php  
 
require_once("config.php");
?>  
 
 
 
 
 
简单投票系统  
 
 
 
 
if($_POST["Submit"])
{
$title=$_POST["title"];
$sql="update votetitle set votetitle='$title'";
mysql_query($sql);
?>  
 
}
if($_POST["Submit2"])
{
$newitem=$_POST["newitem"];
$sql="insert into vote (titleid,item,count) values (1,'$newitem',1)";
mysql_query($sql);

}
?>  
 
    
      
        
        
      
      
        
        
        
        
        
      
     $sql="select * from vote order by count desc";
$rs=mysql_query($sql);
while($rows=mysql_fetch_assoc($rs))
{
?>  
 
        
        
        
        
        
      
}
?>  
      
        
      
      
        
        
      
  
编号项目票数修改删除
" />'" />'"  />
 
    
 
     
 
 
 

if($_GET["type"]=="modify"){

$id=$_GET["id"];
if($_POST["Submit3"])
{
$item=$_POST["itm"];
$count=$_POST["count"];
$sql="update vote set item='$item',count=$count where id=$id";
mysql_query($sql);
echo "";  
}  
$sql="select * from vote where id=$id";  
$rs=mysql_query($sql);  
$rows=mysql_fetch_assoc($rs);  
?>  
 
    
      
        
      
      
        
        
      
      
        
        
      
      
        
      
  
修改投票项目
名称:
票数:
 
 
 
}
?>  
if($_GET["type"]=="del"){
$id=$_GET["id"];
$sql="delete from vote where id in ($id)";
mysql_query($sql);
echo "";  
}  
?>  
 
 
 
 
config.php  
 
$conn=@mysql_connect("localhost","root","");
if($conn==null)
die("数据库连接失败");
mysql_query("set names 'gb2312'");
if(!mysql_select_db("vote"))
{
die("数据库连接失败");
}
?>  


回复讨论(解决方案)

代码太乱,大致扫了一眼没看明白...  
 
我看没人回复 楼主我给你说个思路你自己研究下吧:   
 
使用firebug观察当你点击时是否正确触发ajax.(看看是否js出错)  
 
如果正确触发ajax,看看ajax都传了什么参数 看看参数是否出错  
 
看看返回什么值,是否正确返回值. 如果正确返回 那就检查返回后的js  
 
如果没有正确返回,逐行查看提交到的php页面,用ajax传过去的参数一行行试.

代码纠结了,看了三分之一看不下去了

哪位大侠看得下去就是真心喜欢你了

代码我就不看了,太乱了,获取不到值的话,你检查一下变量名有没写错?或者get和post方法不一致?

太长了,你应该把css,js 都拆分开写,link 引入,最基本的规范啊~

浏览器F12吧  

line 58  
$id=$_POST["itm"]; 这里拿不到$id吗?

不忍  直视

代码太长了,没看完。没取得,看参数名对了没,post的路径对不对吧

你就直接说哪里获取数据失败?你要是女程序员,我就看完了。

你还真是女的哟,$id=$_POST["itm"];是这里取值不到?

这个怎么看???我的天呢

我去~~第一次见这么问问题的!

成功源于失败,菜鸟测试一下!

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 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)

Explain the concept of late static binding in PHP. Explain the concept of late static binding in PHP. Mar 21, 2025 pm 01:33 PM

Article discusses late static binding (LSB) in PHP, introduced in PHP 5.3, allowing runtime resolution of static method calls for more flexible inheritance.Main issue: LSB vs. traditional polymorphism; LSB's practical applications and potential perfo

Explain JSON Web Tokens (JWT) and their use case in PHP APIs. Explain JSON Web Tokens (JWT) and their use case in PHP APIs. Apr 05, 2025 am 12:04 AM

JWT is an open standard based on JSON, used to securely transmit information between parties, mainly for identity authentication and information exchange. 1. JWT consists of three parts: Header, Payload and Signature. 2. The working principle of JWT includes three steps: generating JWT, verifying JWT and parsing Payload. 3. When using JWT for authentication in PHP, JWT can be generated and verified, and user role and permission information can be included in advanced usage. 4. Common errors include signature verification failure, token expiration, and payload oversized. Debugging skills include using debugging tools and logging. 5. Performance optimization and best practices include using appropriate signature algorithms, setting validity periods reasonably,

How does session hijacking work and how can you mitigate it in PHP? How does session hijacking work and how can you mitigate it in PHP? Apr 06, 2025 am 12:02 AM

Session hijacking can be achieved through the following steps: 1. Obtain the session ID, 2. Use the session ID, 3. Keep the session active. The methods to prevent session hijacking in PHP include: 1. Use the session_regenerate_id() function to regenerate the session ID, 2. Store session data through the database, 3. Ensure that all session data is transmitted through HTTPS.

Describe the SOLID principles and how they apply to PHP development. Describe the SOLID principles and how they apply to PHP development. Apr 03, 2025 am 12:04 AM

The application of SOLID principle in PHP development includes: 1. Single responsibility principle (SRP): Each class is responsible for only one function. 2. Open and close principle (OCP): Changes are achieved through extension rather than modification. 3. Lisch's Substitution Principle (LSP): Subclasses can replace base classes without affecting program accuracy. 4. Interface isolation principle (ISP): Use fine-grained interfaces to avoid dependencies and unused methods. 5. Dependency inversion principle (DIP): High and low-level modules rely on abstraction and are implemented through dependency injection.

How to automatically set permissions of unixsocket after system restart? How to automatically set permissions of unixsocket after system restart? Mar 31, 2025 pm 11:54 PM

How to automatically set the permissions of unixsocket after the system restarts. Every time the system restarts, we need to execute the following command to modify the permissions of unixsocket: sudo...

How to debug CLI mode in PHPStorm? How to debug CLI mode in PHPStorm? Apr 01, 2025 pm 02:57 PM

How to debug CLI mode in PHPStorm? When developing with PHPStorm, sometimes we need to debug PHP in command line interface (CLI) mode...

Explain late static binding in PHP (static::). Explain late static binding in PHP (static::). Apr 03, 2025 am 12:04 AM

Static binding (static::) implements late static binding (LSB) in PHP, allowing calling classes to be referenced in static contexts rather than defining classes. 1) The parsing process is performed at runtime, 2) Look up the call class in the inheritance relationship, 3) It may bring performance overhead.

See all articles