在PHP中创建搜索表单以搜索数据库？_随笔

在PHP中创建搜索表单以搜索数据库？

试试看让我知道会发生什么。

形成：

<form action="form.php" method="post"> Search: <input type="text" name="term" /><br /> <input type="submit" value="Submit" /> </form>

Form.php：

$term = mysql_real_escape_string($_REQUEST['term']);$sql = "SELECt * FROM liam WHERe Description LIKE '%".$term."%'";$r_query = mysql_query($sql);while ($row = mysql_fetch_array($r_query)){ echo 'Primary key: ' .$row['PRIMARYKEY']; echo '<br /> Code: ' .$row['Code']; echo '<br /> Description: '.$row['Description']; echo '<br /> Category: '.$row['Category']; echo '<br /> Cut Size: '.$row['CutSize'];  }

编辑：清理多一点。

Final Cut（我的测试文件）：

<?php$db_hostname = 'localhost';$db_username = 'demo';$db_password = 'demo';$db_database = 'demo';// Database Connection String$con = mysql_connect($db_hostname,$db_username,$db_password);if (!$con)  {  die('Could not connect: ' . mysql_error());  }mysql_select_db($db_database, $con);?><!DOCTYPE html><html lang="en">    <head>        <meta charset="utf-8" />        <title></title>    </head>    <body><form action="" method="post">  Search: <input type="text" name="term" /><br />  <input type="submit" value="Submit" />  </form>  <?phpif (!empty($_REQUEST['term'])) {$term = mysql_real_escape_string($_REQUEST['term']);$sql = "SELECT * FROM liam WHERe Description LIKE '%".$term."%'"; $r_query = mysql_query($sql);while ($row = mysql_fetch_array($r_query)){  echo 'Primary key: ' .$row['PRIMARYKEY'];  echo '<br /> Code: ' .$row['Code'];  echo '<br /> Description: '.$row['Description'];  echo '<br /> Category: '.$row['Category'];  echo '<br /> Cut Size: '.$row['CutSize'];   }}?>    </body></html>

欢迎分享，转载请注明来源：内存溢出

原文地址: http://outofmemory.cn/zaji/5044805.html

在PHP中创建搜索表单以搜索数据库？

发表评论

评论列表（0条）