且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

Ajax数据库选择值返回"0"而不是字符串

更新时间:2023-02-06 13:07:30

我已修复它.因此,当php设置$ q时,它使用的是intval()函数,该函数将字符串替换为0.删除该函数将允许字符串通过并正确加载页面!

I fixed it. So when the php was setting the $q it was using intval() function which was overriding the string with 0. Removing that function allowed the string through and loaded the page correctly!

我更正后的php代码是:

My corrected php code is:

<?php
    include_once ('inc.dbh.php');
    $q = $_GET['q'];
    $inventorysql = "SELECT * FROM inventory WHERE make = '".$q."'";
    $result = mysqli_query($conn, $inventorysql);
        while ($row = $result->fetch_assoc()) {
            echo '<div id="inventory" class="inventory margin-bottom-20 clearfix scroll_effect fadeIn"><a class="inventory" href="inventory-listing.php?vin=' . $row['vin'] . '"><div class="title">'.$row['year'].' '.$row['make'].' '.$row['model'].'</div><img src="images/inventory/'.$row['vin'].'-main.jpg" class="preview" alt="preview"><table class="options-primary"><tr><td class="option primary">Body Style:</td><td class="spec">'.$row['body'].'</td></tr><tr><td class="option primary">Drivetrain:</td><td class="spec">'.$row['drivetrain'].'</td></tr><tr><td class="option primary">Transmission:</td><td class="spec">'.$row['transmission'].'</td></tr><tr><td class="option primary">Mileage:</td><td class="spec">'.ltrim ($row['mileage'], '0').'</td></tr></table><table class="options-secondary"><tr><td class="option secondary">Exterior Color:</td><td class="spec">'.$row['exteriorcolor'].'</td></tr><tr><td class="option secondary">Interior Color:</td><td class="spec">'.$row['interiorcolor'].'</td></tr><tr><td class="option secondary">VIN Number:</td><td class="spec">'.$row['vin'].'</td></tr></table><div class="price"><b>Price:</b><br><div class="figure">$'.ltrim ($row['price'], '0').'<br></div><div class="tax">Plus Tax, Tag, and Title</div></div><div class="view-details gradient_button"><i class="fa fa-plus-circle"></i> View Details </div><div class="clearfix"></div></a></div>';     
        }
    echo $q;
?>