如何从我的搜索按钮输出数据库中的数据？ [英] How to output the data from the database for my search button?

问题描述

我是一个新手在PHP，我需要别人的帮助这个代码。代码没有输出我喜欢输出..输出没有..谢谢提前

Im a newby in php and i need someone's help for this code.The code did not output what i like to output..it outputs nothing..thanks in advance

<?php

  $con=mysql_connect("127.0.0.1","root","") or die('Could not reach the database'.mysql_error());

  mysql_select_db("ojt",$con);

  $search=isset($_GET['search']) ? $_GET['search'] : '';

  $search=stripslashes($search);

  $search=mysql_real_escape_string($search);



  $sql = " SELECT * FROM `ojt`.`troubleticket` WHERE (`technicalname` LIKE '%".$search."%') OR (`services` LIKE  '%".$search."%')OR (`problem` LIKE  '%".$search."%') OR (`companyname` LIKE  '%".$search."%') OR (`remarks` LIKE  '%".$search."%')";

  $query1=mysql_query($sql);

  if($query1)

  { echo '<table>
          <tr>
          <td width="80" bgcolor="#000000"><div align="center" class="fontstyle"><font color="#FFFFFF"><b>TICKET NO</b></font></div></td>
          <td width="230" bgcolor="#000000"><div align="center" class="fontstyle"><font color="#FFFFFF"><b>DATE</b></font></div></td>
          <td width="50" bgcolor="#000000"><div align="center" class="fontstyle"><font color="#FFFFFF"><b>PRIORITY</b></font></div></td>
          <td width="130" bgcolor="#000000"><div align="center" class="fontstyle"><font color="#FFFFFF"><b>TECHNICAL NAME</b></font></div></td>
          <td width="125" bgcolor="#000000" ><div align="center" class="fontstyle"><font color="#FFFFFF"><b>SERVICES</b></font></div></td>
          <td width="153" bgcolor="#000000"><div align="center" class="fontstyle"><font color="#FFFFFF"><b>COMPANY NAME</b></font></div></td>
          <td width="189" bgcolor="#000000"><div align="center" class="fontstyle"><font color="#FFFFFF"><b>PROBLEM</b></font></div></td>
          <td width="140" bgcolor="#000000"><div align="center" class="fontstyle"><font color="#FFFFFF"><b>REMARKS</b></font></div></td>
        </tr>';
    while($query = mysql_fetch_array($query1))
    {
      echo "<tr><td bgcolor='#A9A9A9'><div align='center'>" . $query['ticketno'] . "</td><td bgcolor='#A9A9A9'><div align='center'>" . $query['DATE'] . "</td><td bgcolor='#A9A9A9'><div align='center'>" . $query['priority'] . "</td><td bgcolor='#A9A9A9'>" . $query['technicalname'] . "</td><td bgcolor='#A9A9A9'>" . $query['services'] . "</td><td bgcolor='#A9A9A9'>" . $query['companyname'] . "</td><td bgcolor='#A9A9A9'>" . $query['problem'] . "</td><td bgcolor='#A9A9A9'><div align='center'>" . $query['remarks'] . "</td></tr>";
    }
    echo '</table>';
  }
  else
  {
    echo "Unsuccessful";
  }
?>

推荐答案

con = mysql_connect（ 127.0.0.1，root，） < span class =code-summarycomment> 或 die（'可能 不 达到 database'.mysql_error（））;

mysql_se lect_db（ojt，

con=mysql_connect("127.0.0.1","root","") or die('Could not reach the database'.mysql_error()); mysql_select_db("ojt",

con）;

con);

search = isset（

search=isset(

这篇关于如何从我的搜索按钮输出数据库中的数据？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！