PHP 和 MySQL 搜索从数据库中获取完整数据

debugcn 发表于 Dev

用户9740150

我正在尝试搜索并从数据库中获取数据，但作为这个 php 和 MySQL 的新手，我无法完成这项任务。

<?php
$connection = mysql_connect("localhost", "root", ""); // Establishing Connection with Server
$db = mysql_select_db("vdl", $connection); // Selecting Database
//MySQL Query to read data
$query = mysql_query("select * from digital_library", $connection);
while ($row = mysql_fetch_array($query)) {
echo '<ul>';
echo "<li><b><a href=\"read.php?id={$row['company_id']}\">{$row['company_name']}</a></b></li>";
echo "<br />";
echo '</ul>';
}
?>

这些是我将从数据库中获取的字段。尝试进行简单搜索，但无法获取完整数据。

<?php
if (isset($_GET['id'])) {
$id = $_GET['id'];
$query1 = mysql_query("select * from digital_library where company_id=$id", $connection);
while ($row1 = mysql_fetch_array($query1)) {
?>

    <span>Company Name: </span> <?php echo $row1['company_name']; ?><br><br>
    <span>Since: </span> <?php echo $row1['since']; ?><br><br>
    <span>Strength: </span> <?php echo $row1['strength']; ?><br><br>
    <span>Head Quarters: </span> <?php echo $row1['head_quarter']; ?><br><br>
    <span>Location (City): </span> <?php echo $row1['locations']; ?><br><br>
    <span>Develpment Centers: </span> <?php echo $row1['development_centers']; ?><br><br>
    <span>Customers: </span> <?php echo $row1['customers']; ?><br><br>
    <span>MNC: </span> <?php echo $row1['mnc']; ?><br><br>
    <span>CMMI: </span> <?php echo $row1['cmmi']; ?><br><br>
    <span>Domains: </span> <?php echo $row1['domains']; ?><br><br>
    <span>Industries: </span> <?php echo $row1['industries']; ?><br><br>
    <span>Domain Competitors: </span> <?php echo $row1['domain_competitor']; ?><br><br>
    <span>Products: </span> <?php echo $row1['products']; ?><br><br>
    <span>Services: </span> <?php echo $row1['services']; ?><br><br>
    <span>Uniqueness: </span> <?php echo $row1['uniqueness']; ?><br><br>
    <span>Company URL: </span> 
    <a target='_blank' href="<?php echo $row1['url']; ?>"> 
        <?php echo $row1['url']; ?>
    </a><br><br>
    <!--<span>Comapny Logo:</span> <?php echo $row1['logo']; ?><br><br>-->
    <span>Onsight: </span> <?php echo $row1['onsight']; ?><br><br>
    <span>Benefits: </span> <?php echo $row1['benefits']; ?><br><br>
    <span>Awards: </span> <?php echo $row1['awards']; ?><br><br>
<?php } ?>

用户9740150

最后谷歌帮我解决了我的问题。

<?php
mysql_connect ("localhost", "root","")  or die (mysql_error());
mysql_select_db ("vdl");

$term = $_POST['term'];

$sql = mysql_query("select * from digital_library where company_name like '%$term%'");

while ($row = mysql_fetch_array($sql)){
    echo 'ID: '.$row['company_id'];
    echo '<br/> First Name: '.$row['company_name'];
    echo '<br/> Since: '.$row['since'];
    echo '<br/> Strength: '.$row['strength'];
    echo '<br/> Head Quarters: '.$row['head_quarter'];
    echo '<br/> Location (City): '.$row['locations'];
    echo '<br/> Development Centers: '.$row['development_centers'];
    echo '<br/> Customers: '.$row['customers'];
    echo '<br/> MNC: '.$row['mnc'];
    echo '<br/> CMMI: '.$row['cmmi'];
    echo '<br/> Domains: '.$row['domains'];
    echo '<br/> Industries: '.$row['industries'];
    echo '<br/> Domain Competitors: '.$row['domain_competitor'];
    echo '<br/> Products: '.$row['products'];
    echo '<br/> Services: '.$row['services'];
    echo '<br/> Uniqueness: '.$row['uniqueness'];
    echo '<br/> URL: '.$row['url'];
    echo '<br/> Onsights: '.$row['onsight'];
    echo '<br/> Benefits: '.$row['benefits'];
    echo '<br/> Awards: '.$row['awards'];
    echo '<br/><br/>';
    }

?>

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。