如何连接数据库并从数据库中获取结果 [英] How do I connect database and get result from the database

问题描述

我创建了两个表作为类别和子类别。当我选择一个类别如何通过使用PHP按类别加载子类别？



我尝试过：

I created two tables as category and sub category. when i choose a category how do i load sub category according to category by using php?

What I have tried:

	<?php

                                        
                                            $servername = "localhost";
                                            $username = "root";
                                            $password = "";
                                            $dbname = "omcqs";

$conn = new mysqli($servername, $username, $password, $dbname);

$sql = "SELECT sub_category.sc_name,category.c_id
		FROM category
		INNER JOIN sub_category ON category.c_id = sub_category.c_id";
		


/*$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // output data of each row
   while($row = $result->fetch_assoc()){

     echo '<option >'.$row["sc_name"] .'</option> <br />';  

   }

}*/

推荐答案

servername =localhost;

servername = "localhost";

username =root;

username = "root";

password =;

password = "";

这篇关于如何连接数据库并从数据库中获取结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！