小编典典

sql查询的第一次迭代未正​​确包装

sql

所以,我有这个php文件,但是第一个结果没有被包装在’result’div中,因此样式也不正确。所有后续结果均已正确包装。帮助?

编辑:根据评论,我试图拉出html。我承认我是菜鸟,但这是我想出的。似乎无法解决原始问题:

scripts_post.php:

$connection = mysqli_connect("server", "user", "password", "dbname");
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$result = mysqli_query($connection, $sqlQuery);
mysqli_close($connection);
if (empty($result)) { 
    echo 'No results found'; 
    return;
}
while($row = mysqli_fetch_array($result))
    {
        echo include 'single_result.php';
    }
echo "<div class='results_end'><p>End of list</p></div>";

single_result.php:

    <div class='result'>
        <div class='result_left'>
            <div class='result_photo'><img src=<?php echo "'" . $row['PhotoLink'] . "'" ?> height='200' width='200' class='script_photo'></div>
        </div>
        <div class='results_right'>
            <div class='result_title'><?php echo $row['Title'] ?></div>
            <div class='result_summary'><?php echo $row['Summary'] ?></div>
            <div class='result_description'><?php echo $row['Description'] ?></div>
            <div class='result_preview'><a href =<?php echo "'" . $row['PreviewLink'] . "'" ?> target='_blank'>view preview</a></div>         
            <div class='result_detail'>Type: <?php echo $row['Type'] ?></div>   
            <div class='result_detail'>Biblical Characters Portrayed: <?php echo $row['BiblicalCharacters'] ?></div>
            <div class='result_detail'>Topics: <?php echo $row['Topics'] ?></div>
            <div class='result_price'>Cost: $<?php echo $row['Price'] ?></div>
            <div class='result_purchase'><a href =<?php echo "'" . $row['DownloadLink'] . "'" ?> target='_blank'><img src='http://image.payloadz.com/images/btn-addtocart-b.png' border='0'></a></div>
        </div>
    </div>

编辑#2:这就是上面所说的。也许这里有些东西缠着东西?

    <script src="http://ajax.googleapis.com/ajax/libs/jquery/2.1.0/jquery.min.js">
    </script>
    <script language ="javascript">
        $(function() {
            $('form').submit(function(event) {
                var form = $(this);
                $.ajax({
                    type: form.attr('method'),
                    url: form.attr('action'),
                    data: form.serialize()
                }).done(function(returned_data) {
                    document.getElementById('scriptsearch_results_div').innerHTML = returned_data;
                }).fail(function() {
                    alert("The search has failed.  Please alert the webmaster.");
                });
                event.preventDefault();
            });
        });
    </script>
    ...
    <div id="formcontainer">
        <form id="scriptsearch_form" action="scripts_post.php" method="post">
            // form fields
            <p> <input type="submit" value="Search" class="submitbutton" id="mainsubmitbutton"> </p>
        </form>
    </div>
    <div id="scriptsearch_results_div">
        <p>Search for scripts using the options at left.</p>
    </div>

阅读 143

收藏
2021-04-14

共1个答案

小编典典

找到了问题。真的很傻 <body>实际上是scripts_post.php中的标签,<body因此第一个操作>是关闭标签,然后将其间的内容转储。

2021-04-14