我是一个新的,只是学习,我有一个困惑的数据表从表到url id,我想从表中获取数据时,我写url,例如localhost/index.php?=user='username',表将根据url username
显示这里的表样本
<<p> 内容表/strong>code_content | judul_content | deskripsi | nama_lengkap
2 abc tes1 john
3 efg tes2 gerald
4 hij tes3 john
用户表username | password | nama_lengkap
user1 123 john
user2 234 gerald
当我写这个url localhost/index.php?=user=user2,我希望这个输出显示
* *judul_content = "efg"
nama_lengkap = "gerald"
* * <?php
$koneksi = mysql_connect("localhost","root","1234");
mysql_select_db("my_db");
$hal = 0;
if(isset($_GET['page'])){
$page = $_GET['page'];
}else{
$page = 1;
}
$limit = 2;
$offset = ($page - 1)*$limit;
$hasil = mysql_query("select * from content order by code_content desc limit $offset,$limit;");
$get_total = mysql_query("select count(*) as total from content");
$total_artikel = 0;
while($h_total = mysql_fetch_array($get_total)){
$total_artikel = $h_total['total'];
}
$total_page = ceil($total_artikel/$limit);
?>
<?php while($data = mysql_fetch_array($hasil)){ ?>
<h2><a href="index.php?page=full&kode=<?php echo $data["code_content"]; ?>" style="text-decoration:none;">
<?php echo $data["judul_content"]; ?></a></h2>
<?php echo $data["tanggal"]; ?> by <a href="#" target="_blank"><?php echo $data["nama_lengkap"]; ?></a>
<div id="posts-list" class="cf">
<div class="right" style="float:left; text-align:justify; width:100%;">
<?php
echo implode(array_slice(explode(" ",$data["content"]),0,75)," ").".....";
?><br /><br />
<a href="index.php?page=full&kode=<?php echo $data["code_content"]; ?>">Continue reading...</a> <!--| <a href="#">Comments (60)</a>-->
</div>
<div class="cleaner"></div>
</div>
<?php } ?>
<div>
<?php if($page > 1){ ?>
如何在没有登录的情况下显示基于url用户的表由于
既然你想从2个表中检索数据,那么你必须在两个表之间建立关系(在内容中传递user_id作为外键),然后你可以通过URL轻松地检索数据。
用户表id | username | password | nama_lengkap
1 user1 123 john
2 user2 234 gerald
内容表user_id | kode_content | judul_content | deskripsi | nama_lengkap
1 2 abc tes1 john
2 3 efg tes2 gerald
localhost/index . php ?=用户="用户名"
if(isset($_GET['user'])) {
$user_name = $_GET['user'];
$check_user = "SELECT username FROM user WHERE username = '$user_name' LIMIT 1";
if(!empty($check_user))
{
$user_data = "SELECT contents.judul_content, users.nama_lengkap
FROM users
INNER JOIN contents
ON users.id=contents.user_id
WHERE users.username = '$check_user'";
print_r ($user_data);
}else{
echo "No User Found."
}
}