如何使用require_once()倍数并连接到同一页中的不同数据库？

Question

我试图连接到同一页中的不同数据库，并选择两次。但它似乎不工作，我只得到一个数据库，并选择工作！这是我的密码

<?php 
require_once ('../connect_upevent.php');
require_once ('../connect_events.php');


$select_upevent="SELECT * FROM upevent";
$result_upevent=mysqli_query($con,$select_upevent);

$select_events="SELECT img_name , title , LEFT(`content` , 540)  as `content`,date, id FROM events";
$result_events=mysqli_query($con,$select_events);

mysqli_close($con);
?>

我的时间()

                        <?php while ($row_upevent = mysqli_fetch_array($result_upevent)) {   ?>                     
                    <li> 
                        <h4><?php echo $row_upevent['title'] ?></h4> 
                        <div class="dt-sc-two-third column first event-index-float">
                            <img src="images/event/<?php echo $row_upevent['img_name'] ?>" alt="" title="">
                            <p><?php echo $row_upevent['content'] ?></p>
                        </div>
                        <div class="dt-sc-one-third column event-index-float">
                            <div class="venue">
                                <h5>location</h5>
                                <p><?php echo $row_upevent['place'] ?></p>
                            </div>
                            <div class="details">
                                <h5>time</h5>
                                <p><?php echo $row_upevent['date'] ?></p>
                            </div>
                        </div>
                    </li>
                    <?php } ?>

我的时间()2

                        <?php while ($row_events = mysqli_fetch_array($result_events)) {   ?>                     
                    <!--blog starts-->
                    <div class="dt-sc-one-half column first animate" data-animation="fadeInLeft" data-delay="300">
                        <article class="blog-entry">
                            <div class="entry-thumb">
                                <a href="event-detail.php?post=<?php echo $row_events['id'] ?>"><img src="images/event/<?php echo $row_events['img_name'] ?>" alt="" title=""></a>
                            </div>
                            <div class="entry-details">
                                <div class="entry-title">
                                    <h2><a href="event-detail.php?post=<?php echo $row_events['id'] ?>"><?php echo $row_events['title'] ?></a></h2>
                                </div>
                                <div class="entry-body">
                                    <p><?php echo $row_events['content'].'&nbsp;[ ... ]' ?></p>
                                </div>
                                <div class="entry-footer">
                                    <a href="event-detail.php?post=<?php echo $row_events['id'] ?>" class="read-more">read more<span class="fa fa-caret-left"></span> </a>
                                </div>
                            </div>
                        </article>
                    </div>
                    <!--blog ends-->
                    <?php } ?>

那我怎么才能让它工作呢？

Answer 1

用不同的对象创建两个连接

connect_upevent.php

$servername = "localhost";
$username = "username";
$password = "password";

// Create connection 1
$con1 = new mysqli($servername, $username, $password);

connect_events.php

$servername = "localhost";
$username = "username";
$password = "password";

// Create connection 2
$con2 = new mysqli($servername, $username, $password);

然后像这样使用这些连接

<?php 
require_once ('../connect_upevent.php');
require_once ('../connect_events.php');


$select_upevent="SELECT * FROM upevent";
$result_upevent=mysqli_query($con1,$select_upevent);

$select_events="SELECT img_name , title , LEFT(`content` , 540)  as `content`,date, id FROM events";
$result_events=mysqli_query($con2,$select_events);

mysqli_close($con1);
mysqli_close($con2);
?>

Answer 2

您正在连续地连接，并对两个数据库实例具有相同的名称。您应该创建不同的连接对象。换个名字就行了。

<?php 
require_once ('../connect_upevent.php'); // $con_upevent
require_once ('../connect_events.php'); // $con_events


$select_upevent="SELECT * FROM upevent";
$result_upevent=mysqli_query($con_upevent, $select_upevent);

$select_events="SELECT img_name , title , LEFT(`content` , 540)  as `content`,date, id FROM events";
$result_events=mysqli_query($con_events, $select_events);

mysqli_close($con_upevent);
mysqli_close($con_events);
?>

或者连接到一个，进行查询，连接到第二个，然后进行查询。

<?php 
require_once ('../connect_upevent.php');
require_once ('../connect_events.php');


$select_upevent="SELECT * FROM upevent";
$result_upevent=mysqli_query($con_upevent, $select_upevent);

$select_events="SELECT img_name , title , LEFT(`content` , 540)  as `content`,date, id FROM events";
$result_events=mysqli_query($con_events, $select_events);

mysqli_close($con_upevent);
mysqli_close($con_events);
?>
<?php 
// Connect to first DB
require_once ('../connect_upevent.php');

$select_upevent="SELECT * FROM upevent";
$result_upevent=mysqli_query($con,$select_upevent);

mysqli_close($con);

// Connect to second DB
require_once ('../connect_events.php');

$select_events="SELECT img_name , title , LEFT(`content` , 540)  as `content`,date, id FROM events";
$result_events=mysqli_query($con,$select_events);

mysqli_close($con);
?>

Answer 3

我需要查看所包含的文件的内容：

• connect_upevent.php
• connect_events.php

但我想，问题是:您使用同一个实例$con。

因此，当您第一次在文件"connect_upevent.php“中声明connect_upevent.php，然后在"connect_events.php”文件中覆盖它时，

您应该在包含的文件中创建两个实例。比如：

$con_upevent和$con_events.

否则，$con变量将被"connect_events.php“文件覆盖。