dongpengqin3898 2015-12-02 09:01
浏览 44
已采纳

使用slug url从mysql db中获取文章

Im developing my own PHP Mysql site.

I used to fetch data by id like this : mysite.com/articles.php?id=12

now i want to change the url with slug:

mysite.com/articles/google-search

or

mysite.com/articles.php?article=google-search

I dont want to use id and numbers.

My table:

+----+---------------+---------+------------------------------------+
| id | title         | article |   urlslug                          |
+----+---------------+---------+------------------------------------+
| 12 | google search | xxxxxxx |   google-search                    |
| 13 | bing yahoo    | xxxxxxx |   bing-yahoo                       |
| 14 | friendly seo  | xxxxxxx |   friendly-seo                     |
+-------------------------------------------------------------------+

I used the below code to get data by id:

$id = $_GET['id'];
$id = mysqli_real_escape_string($conn,$id);
$query = "SELECT * FROM `table` WHERE `id`='" . $id . "'";
$result = mysqli_query($conn,$query);

while($row = mysqli_fetch_array($result)) {
echo ($row['title']);
echo ($row['article']);    }

I tried the above code by substituting urlslug it says Invalid ID specified. I googled and even searched in stack questions i didnt get any help. Please assist me. Thanks in advance.

  • 写回答

2条回答 默认 最新

  • dongpu3792 2015-12-02 09:05
    关注

    If url is like this mysite.com/articles.php?article=google-search then instead of id get the article from url and change the condition to urlslug instead of id.

    $slug = $_GET['article'];
    $slug = mysqli_real_escape_string($conn,$slug);
    $query = "SELECT * FROM `table` WHERE `urlslug`='" . $slug. "'";
    $result = mysqli_query($conn,$query);
    
     //Since  slug is unique you will get only 1 result so no need to loop
    
     $row = mysqli_fetch_array($result);
     echo $row['title'];
     echo $row['article'];    
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 求差集那个函数有问题,有无佬可以解决
  • ¥15 【提问】基于Invest的水源涵养
  • ¥20 微信网友居然可以通过vx号找到我绑的手机号
  • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
  • ¥15 解riccati方程组
  • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥65 汇编语言除法溢出问题