使用php过滤表 [英] filter table using php

问题描述

大家好，



i需要一些帮助，我试图用PHP过滤我的表但是它给了我这个错误你的错误在你的SQL语法;检查与MySQL服务器版本对应的手册，以便在第1行='hes''附近使用正确的语法下面是我的代码。

 <  表格    name   =  search_form    方法  =  POST    action   =  index.php >  
 
 
  <  选择   名称  =  search_pad >  
 <  选项    value   =  hes >  HES <   / option  >  
 <  选项    value   =  WFBS  >  WFBS <   / option  >  
 <   / select  >  
 
 <  输入    type   = 提交   名称  = 搜索    value   =  test < span class =code-keyword> /  >  
 <   / form  >  

<前郎=PHP> <？php
include（ 包括/ db_connection.php）;

$ sql = SELECT * FROM tbl_masterlist;

if（isset（$ _ POST [' search']））{

$ search_term = mysql_real_escape_string（$ _ POST [' search_pad']）;

$ sql 。= 其中p0_product ='{$ search_term}';

}

$ query = mysql_query（$ sql）或 die（mysql_error（））;
？>

提前致谢

Makubex

解决方案

sql = SELECT * FROM tbl_masterlist;

if（isset（

_POST [' search']））{

search_term = mysql_real_escape_string（

hello guys,

i need some help, im trying to filter my table using php but it gives me this error "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 'hes'' at line 1" below is my code.

<form name="search_form" method="POST" action="index.php">
				
								
<select name="search_pad">
<option value="hes">HES</option>
<option value="WFBS">WFBS</option>
</select>
								
<input type="submit" name="search" value="test"/>
</form>

<?php
include ("include/db_connection.php");
										
$sql = "SELECT * FROM tbl_masterlist";
										
										if(isset($_POST['search'])){
										
$search_term = mysql_real_escape_string($_POST['search_pad']);
										
$sql .= "where p0_product = '{$search_term}' ";
										
}
										
$query = mysql_query($sql) or die(mysql_error());
?>	

Thanks in advance
Makubex

解决方案

sql = "SELECT * FROM tbl_masterlist"; if(isset(

_POST['search'])){

search_term = mysql_real_escape_string(

这篇关于使用php过滤表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！